CA InterTest

 View Only

Tuesday Tip: How to turn off the DB2 Last SQL capture feature of CA InterTest for CICS 

Dec 23, 2014 04:08 PM

In order to support the CORE=LASTSQL command for CA InterTest for CICS, the global exit XRMIOUT is started (by default) when you start the product.  This exit then collects DB2-related call information for every DB2 call done in the system. This can have significant performance implications in some DB2 SITES. If your site is not licensed for DB2 you will also want to turn this option off.

 

The CA InterTest for CICS IN25OPTS parameter XRMIO=YES/NO controls the use of this exit. The default is XRMIO=YES. We recommend that you carefully review this prior to using the default settings. To see what CA InterTest for CICS options are currently active in your CICS region you can display the options online in your CICS region by entering the VRPT transaction at a clear screen in CICS and pressing enter. Then select option 2

 

2  Global Options        - Display Installation Options

 

The current options is effect will be displayed. For example in the print screen below notice XRMIO=YES

 

                           CURRENT IN25OPTS VALUES                    A11IC4S6

  AUDIT   =YES        FILET   =FILE       OSGETM  =YES        SYMDWILD=

  AUTMON  =YES        FILSEC  =YES        PROMD   =00000020   TRCFDCLS=

  BKPTERM =           FSYMP   =PROTFILE   READBUF =YES        TRCFFMID=SYMDTRCF

  BREAK   =YES        GLOG    =CSSL       IPINIT  =YES        TRCFMCLS=

  CICSPLEX=NO         HELPFIL =PROTHLF    RECNTMU =NO         TRCFMEGM=120

  CKPTFIL =PROTCPF    HELPT   =HELP       RECNTNW =YES        TRCFMEGT=15

  CNTLSEC =YES        ICMDBUF =1024       SDISPLAY=DATA       TRCFSCLS=

  CNTLT   =CNTL       ICMDEXE =50         SLB     =YES        TRCFTHRD=8

  CNTOSEC =YES        ICMDMAX =50         SLBAKEEP=YES        TRCFTOUT=240

  CNTSQLG =YES        IGLUT   =IGLU       SLBMARG =01         TRCFUNIT=

  CORET   =CORE       IPLXT   =IPLX       SLBSCRL =PAGE       TRCFVOL =

  CORSEC  =YES        IRCTT   =VIRC       SLBTIT  =YES        UCONLY  =NO

  CPF11   =7B         ISERT   =ISER       STBTRN  =STB4       USERHELP=PROTUHF

  CPLXCKPI=0020       ITSTT   =ITST       STMTTRCE=500        VERCOR  =NO

  CPLXFMID=INTERTST   LETSVC  =YES        STUAR   =NO         VRPTT   =VRPT

  DFLTUSER=SPECIFIC   LISTT   =LIST       SYMDFIL =PROTDMP    VTATT   =VTAT

  DL1SIZE =8192       MONOM   =MENU       SYMDINT =YES        XRMIO   =YES

  EXTSEC  =NO         MONOMSEC=NO         SYMDSVCD=YES

  FDISP   =FC         NDVRASML=NO         SYMDT   =SYMD

  FFORM   =D          NDVRPROC=INTNDVR    SYMDL   =SYMD

 

PF1            2            3 End        4 Return     5            6

PF7            8            9           10           11           12

 

 

 

The instructions for changing the options can be found in the Installation Guide chapter Options.

Below are the IN25OPTS SYSIN cards needed to turn off the DB2 capture exit by setting parameter XRMIO=NO

 

//SYSIN    DD  *

          IN25OPTS TYPE=CSECT,                                          X

                XRMIO=NO

          IN25OPTS TYPE=FINAL

          END

/*

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.