CICS

Expand all | Collapse all

Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

  • 1.  Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Fri January 14, 2022 10:38 PM

    I have a small VSAM file created with 118 char records and keylength 6.  The file was created and loaded with three data records, and was successfully unloaded to a flat file with IDCAMS utility.  After setup in CICS using 
    CEDA DEFINE FILE(CMFFD8) GROUP(DUR5202)
    and setting these parameters below
    DSNAME=KC03FD8.A1.CICS.CMFFD8
    RECORDSIZE=118
    KEYLENGTH=6
    READ UPDATE ADD BROWSE DELETE to YES
    set STATUS to ENABLED
    and letting all other parameters default.

    Using CEMT SET FILE(CMFFD8) OPEN to manually open VSAM file in CICS takes about 90 secs.
    Using CEMT SET FILE(CMFFD8) CLOSED to manually close VSAM file in CICS takes about 2 secs. 

    Open/Close timings are the same when done with a COBOL program setup in CICS to open/close the VSAM file to display records for an inquiry. 

    Are there settings in CICS, or for the VSAM file that might be causing this delay on the OPEN?
    About a year ago, the OPEN and CLOSE were taking only a few seconds each, but as far as I know nothing has changed on the system since then.  I know something must be different, but I am looking for a clue about where to look since I have checked everything I can think of.  I can provide more information if needed. 

    View of file setup options in CICS:
    =========================
    CEDA View File( CMFFD8 )
    File : CMFFD8
    Group : DUR5202
    DEScription :
    VSAM PARAMETERS
    DSNAme : KC03FD8.A1.CICS.CMFFD8
    Password : PASSWORD NOT SPECIFIED
    RLsaccess : No Yes | No
    LSRPOOLId : 1 1-8 | None
    LSRPOOLNum : 001 1-255 | None
    READInteg : Uncommitted Uncommitted | Consistent | Repeatable
    DSNSharing : Allreqs Allreqs | Modifyreqs
    STRings : 001 1-255
    Nsrgroup :
    REMOTE ATTRIBUTES
    REMOTESystem :
    REMOTEName :

    REMOTE AND CFDATATABLE PARAMETERS
    RECORDSize : 00118 1-32767
    Keylength : 006 1-255 (1-16 For CF Datatable)

    INITIAL STATUS
    STAtus : Enabled Enabled | Disabled | Unenabled
    Opentime : Firstref Firstref | Startup
    DIsposition : Share Share | Old

    BUFFERS
    DAtabuffers : 00002 2-32767
    TABLE : No No | CIcs | User | CF
    Maxnumrecs : Nolimit Nolimit | 1-99999999

    CFDATATABLE PARAMETERS
    CFdtpool :
    TABLEName :
    UPDATEModel : Locking Contention | Locking
    LOad : No No | Yes

    DATA FORMAT
    RECORDFormat : V V | F

    OPERATIONS
    Add : Yes No | Yes
    BRowse : Yes No | Yes
    DELete : Yes No | Yes
    READ : Yes Yes | No
    UPDATE : Yes No | Yes

    AUTO JOURNALLING
    JOurnal : No No | 1-99
    JNLRead : None None | Updateonly | Readonly | All
    JNLSYNCRead : No No | Yes
    JNLUpdate : No No | Yes
    JNLAdd : None None | Before | AFter | ALl
    JNLSYNCWrite : Yes Yes | No

    RECOVERY PARAMETERS
    RECOVery : None None | Backoutonly | All
    Fwdrecovlog : No No | 1-99
    BAckuptype : Static Static | Dynamic

    SECURITY
    RESsecnum : 00 0-24 | Public

    DEFINITION SIGNATURE
    DEFinetime : 01/14/22 09:58:58
    CHANGETime : 01/14/22 10:00:19
    CHANGEUsrid : CICSUSER
    CHANGEAGEnt : CSDApi CSDApi | CSDBatch
    CHANGEAGRel : 0720




    ------------------------------
    Gregory Oakes
    ------------------------------


  • 2.  RE: Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Sun January 16, 2022 04:01 PM
    Update:

    I was doing some testing today, and the Open and Close are taking a few seconds each now. 

    I have not made any changes to program, or VSAM file, but the open delay seems to have gone away.  

    Any idea what might have helped with this?
    As far as I know, there were no changes on the system, but I am still checking on this.

    Greg



    ------------------------------
    Gregory Oakes
    ------------------------------



  • 3.  RE: Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Mon January 17, 2022 02:36 AM
    Hi Gregory,
    does this happen on the Dallas ISV system? Then it is really a bit strange.
    Otherwise I would have suggested to check for messages in CICS about building an LSR-Pool. This might take some time if any of the defined files are migrated. So an alternative might be to define the file with LSRPOOL None. This means that there is no dependency on any other file as it is with LSRPOOL defined.
    If the LSR-Pool is existent then any further open will not lead to building a new one. This might be the explanation why the delay is gone, but it will happen again after restart of CICS.
    Hope this gives a little help
    Helmut

    ------------------------------
    Helmut Roese
    COM Software GmbH
    Eschborn
    ------------------------------



  • 4.  RE: Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Mon January 17, 2022 04:53 AM
    The only thing I can think of is the dataset was migrated.  There will be a wait until it is recalled.  Is that a possibility?

    ------------------------------
    Ed Addison
    ------------------------------



  • 5.  RE: Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Mon January 17, 2022 04:53 AM
    The only thing I can think of is the dataset was migrated.  There will be a wait until it is recalled. Is that a possibility?

    ------------------------------
    Ed Addison
    ------------------------------



  • 6.  RE: Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Mon January 17, 2022 04:53 AM
    The only thing I can think of is the dataset was migrated.  There will be a wait until it is recalled. Is that a possibility?

    ------------------------------
    Ed Addison
    ------------------------------



  • 7.  RE: Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Mon January 17, 2022 02:39 PM
    System Admin looked through the logs and noticed that there was a message. 
    +DFHTS1311 CICSTS55 Temporary storage data set is full and cannot be extended
    CICS uses this temporary storage DFHTEMP when opening and closing files.

    System Admin recreated the file, and this seems to have cleared the OPEN delay problem. 
    DFH550.CNTL.CICS.DFHTEMP,NEW-



    ------------------------------
    Gregory Oakes
    ------------------------------



  • 8.  RE: Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Wed January 19, 2022 04:14 PM
    Well, I am surprised, but the VSAM Open in CICS is back to taking about 90 secs versus the CLOSED that is taking 1-2 secs.  Is it possible the problem is back for some reason?  Maybe the DFHTEMP fix was not the solution?

    ------------------------------
    Gregory Oakes
    ------------------------------



  • 9.  RE: Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Mon January 17, 2022 04:53 AM
    The only thing I can think of is the dataset has been migrated.  There will be a wait until it is recalled.

    ------------------------------
    Ed Addison
    ------------------------------



  • 10.  RE: Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Wed January 19, 2022 05:58 PM
    Dataset has not been migrated.  The VSAM datasets were just created and are visible, and can be accessed by a program as a test.  

    As far as I know, the LSRPOOL is not the problem. 
    Had not tried LSRPOOL NONE, but this is default that was used previously, and when DFHTEMP was rebuilt.  
    Current LSR settings
    LSRPOOLId : 1 1-8 | None
    LSRPOOLNum : 001 1-255 | None
    Does VSAM need to be recreated to change LSRPOOLId and LSRPOOLNum, since alter only allows change of LSRPOOLNum to None?


    ------------------------------
    Gregory Oakes
    ------------------------------



  • 11.  RE: Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Wed January 19, 2022 06:04 PM
    If you don't have a LSRPOOL defined CICS has to issue macros to VSAM for EVERY dataset you have using the same LSRPOOL.  If any of them are migrated there will be a wait. If you do have a LSRPOOL defined to CICS then the macros are not needed for every dataset. 

    If CICS does have to build the LSRPOOL you will see a DFHFC0208I message:

    https://www.ibm.com/docs/en/cics-ts/5.2?topic=messages-dfhfc0208i

    ------------------------------
    Ed Addison
    ------------------------------



  • 12.  RE: Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Thu January 20, 2022 08:36 AM

    I tried the VSAM OPEN/CLOSED this morning, and both are taking a few seconds. 

    I repeated the open close several times with the same results.

    CEMT SET FILE(CMFFD8) OPEN

    CEMT SET FILE(CMFFD8) CLOSED

    It seems like this problem is intermittent for some unknown reason. 



    ------------------------------
    Gregory Oakes
    ------------------------------



  • 13.  RE: Manual Open of small VSAM file in CICS takes about 90 secs versus Close that takes a few seconds

    Posted Thu January 20, 2022 10:57 AM

    And tried just now, and it is taking 90 secs again.

    Tried CEMT INQ TA command, and task 0000404 is the CEMT session that completed the OPEN in about 90 secs. 

    CEMT  INQ TA                                                           
      STATUS:  RESULTS - OVERTYPE TO MODIFY                            
       Tas(0000326) Tra(RP01) Fac(0063) Dis Ter Pri( 001 )             
          Sta(TP) Use(CICSUSER) Uow(DAF1562FCF7F3F0F)                  
       Tas(0000327) Tra(FL09)           Sus Tas Pri( 001 )             
          Sta(TP) Use(CICSUSER) Uow(DAF156339E2C730F) Hty(EDF     )    
       Tas(0000336) Tra(CEDF) Fac(0072) Sus Ter Pri( 001 )             
          Sta(U ) Use(CICSUSER) Uow(DAF1565A2E6D5A0F) Hty(ZCIOWAIT)    
       Tas(0000404) Tra(CEMT) Fac(0141) Sus Ter Pri( 255 )             
          Sta(TO) Use(CICSUSER) Uow(DAF15C4F7941EC0E) Hty(ZCIOWAIT)    
       Tas(0000409) Tra(CEMT) Fac(0145) Run Ter Pri( 255 )             
          Sta(TO) Use(CICSUSER) Uow(DAF15CB7D756590E)                  

    Close works fine in a few secs. 

    Did Open again, and still taking long time?

    Tried CEMT INQ TA command, and task 0000404 is the CEMT session

    CEMT INQ TA                                                          
    STATUS:  RESULTS - OVERTYPE TO MODIFY                           
     Tas(0000326) Tra(RP01) Fac(0063) Dis Ter Pri( 001 )            
        Sta(TP) Use(CICSUSER) Uow(DAF1562FCF7F3F0F)                 
     Tas(0000327) Tra(FL09)           Sus Tas Pri( 001 )            
        Sta(TP) Use(CICSUSER) Uow(DAF156339E2C730F) Hty(EDF     )   
     Tas(0000336) Tra(CEDF) Fac(0072) Sus Ter Pri( 001 )            
        Sta(U ) Use(CICSUSER) Uow(DAF1565A2E6D5A0F) Hty(ZCIOWAIT)   
     Tas(0000404) Tra(CEMT) Fac(0141) Run Ter Pri( 255 )            
        Sta(TO) Use(CICSUSER) Uow(DAF15C4F7941EC0E)                 
     Tas(0000409) Tra(CEMT) Fac(0145) Run Ter Pri( 255 )            
        Sta(TO) Use(CICSUSER) Uow(DAF15CB7D756590E)                 

    This behavior, on again and off again, is very strange.



    ------------------------------
    Gregory Oakes
    ------------------------------