Db2 for z/OS

Db2 for z/OS on IBM Z

Db2 for z/OS on IBM Z

Leading enterprise data server technology powering business critical transactions and analytics

 View Only
Back to discussions
Expand all | Collapse all

DB2 V13: DECLARE CURSOR results on SQLCODE -67913 / SQLSTATE 62023

  • 1.  DB2 V13: DECLARE CURSOR results on SQLCODE -67913 / SQLSTATE 62023

    Posted Fri November 22, 2024 10:11 AM

    Hi,

    In a COBOL program I'm getting sporadically SQLCODE -67913  / SQLSTATE 62023 when declaring a cursor. With the exact same query parameters fails more or less 1 on 5 runs.

    There is no SQLSTATE class 62 and the lowest SQLCODE is -30000 something.

    Google for either of them does not produce any good result.

    The program runs inside CICS 6.1. Worth mentioning that there is nothing in CICS logs related to this problem.

    Someone have an idea what is and/or where I can find information about this error?

    DSN7100I  -DBDG DSN7GCMD                                              
    *** BEGIN DISPLAY OF GROUP(........) CATALOG LEVEL(V13R1M504)         
                      CURRENT FUNCTION LEVEL(V13R1M504)                   
                      HIGHEST ACTIVATED FUNCTION LEVEL(V13R1M504)         
                      HIGHEST POSSIBLE FUNCTION LEVEL(V13R1M504)          
                      PROTOCOL LEVEL(2)                                   
                      GROUP ATTACH NAME(....)                             
    --------------------------------------------------------------------- 
    DB2          SUB                     DB2    SYSTEM    IRLM            
    MEMBER   ID  SYS  CMDPREF   STATUS   LVL    NAME      SUBSYS IRLMPROC 
    -------- --- ---- --------  -------- ------ --------  ----   -------- 
    ........   0 DBDG -DBDG     ACTIVE   131506 S0W1      DJDG   DBDGIRLM 
    --------------------------------------------------------------------- 
    SPT01 INLINE LENGTH:        32138                                     
    *** END DISPLAY OF GROUP(........)                                    
    DSN9022I  -DBDG DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION           



    ------------------------------
    Sergio Samayoa
    ------------------------------


  • 2.  RE: DB2 V13: DECLARE CURSOR results on SQLCODE -67913 / SQLSTATE 62023

    Posted Tue December 17, 2024 09:09 AM

    Hello Sergio, 

    can you paste the whole Db2 error code at your cobol program?

    Do you have a tool for monitoring the locks? If 4 in 5 of the times it works, I am thinking about some deadlock or timeout (sqlcode -913).

    Thanks,



    ------------------------------
    Soledad Martinez
    Volkswagen Group Services
    Salinas - Asturias
    ------------------------------

    Original Message


Related Content