IBM Support

IT18654: -901 SQLERRMC: PROBE 020 IN SQLKTOPN(), MSG=TQ ALREADY OPEN

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • On DB2 DPF a Stored procedure execution can fail with the
    following on a remote node for a fetch request
    
    db2diag.log will have entries of this nature:
    
    
    FUNCTION: DB2 UDB, table Q services, sqlktopn, probe:20
    MESSAGE : DIA0001E An internal error occurred. Report the
    following error code
              : "Line=00536, rc1=0x82170001, rc2=0x00000004,
    rc3=0x7fff4cd127a0,
              msg=TQ already open".
    
    
    EDUID   : 317146               EDUNAME: db2agntp (FTDW) 61
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
    probe:300
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 44
    sqlerrmc: probe 020 in sqlktopn(), msg=TQ already open
    sqlerrp : SQLRI50E
    sqlerrd : (1) 0x82170001      (2) 0x00000001      (3) 0x00000000
               (4) 0x00000000      (5) 0xFFFFEA92      (6)
    0x0000003D
    sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
    sqlstate:
    
    
    Stacks will include:
    
    sqlriReceiveDss
    sqlrr_dss_router
    sqlrr_subagent_router
    sqleSubRequestRoute
    sqleProcessSubRequest
    
    example:
    
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    0x00007FFFF1D6157F ossDumpStackTraceEx + 0x01ef
    
    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2osse.so.1)
    0x00007FFFF1D5C33E _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x00cc
    
    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2osse.so.1)
    0x00007FFFF4AFBB63 sqlo_trce + 0x03fb
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF4B44912 sqloDumpDiagInfoHandler + 0x00e0
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF79CD7E0 address: 0x00007FFFF79CD7E0 ; dladdress:
    0x00007FFFF79BE000 ;
     offset in lib: 0x000000000000F7E0 ;
                    (/lib64/libpthread.so.0)
    0x00007FFFF79CA97C pthread_kill + 0x002c
                    (/lib64/libpthread.so.0)
    0x00007FFFF4B43D11 sqloDumpEDU + 0x0045
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF3D75FEB _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi +
    0x068f
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF3593B02 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x0572
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF37B7B50 _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x0020
    
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF37B7237
    _Z11sqlzeMapZrcP8sqeAgentjmjP5sqlcaiPK12sqlzeContextb + 0x046
    3
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF35C0018 _Z11sqlrrMapZrcP8sqlrr_cbjmi + 0x0038
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF4EE37A6
    _Z15sqlriReceiveDssP8sqlrr_cbP16sqlkdRqstRplyFmtPl + 0x0530
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF4D20627 _Z16sqlrr_dss_routerP8sqlrr_cb + 0x027f
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF4D22A9D
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0e53
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF3EB5B59 _Z20sqleSubRequestRouterP8sqeAgentPjS1_ +
    0x0679
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF3EB65C8 _Z21sqleProcessSubRequestP8sqeAgent + 0x00a6
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF30B2ECB _ZN8sqeAgent6RunEDUEv + 0x0641
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF37B7F00 _ZN9sqzEDUObj9EDUDriverEv + 0x00a6
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF37B7E57 _Z10sqlzRunEDUPcj + 0x0009
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF35164DC sqloEDUEntry + 0x02f4
                    (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF79C5AA1 address: 0x00007FFFF79C5AA1 ; dladdress:
    0x00007FFFF79BE000 ;
     offset in lib: 0x0000000000007AA1 ;
                    (/lib64/libpthread.so.0)
    0x00007FFFF1113AAD clone + 0x006d
                    (/lib64/libc.so.6)
    
    
    or traps with
    
    
    Stack:
    ======================
    
    0x00007FFFF1DD4CFB ossDumpStackTraceEx + 0x01ef
      0x00007FFFF1DCFABA _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x00cc
      0x00007FFFF4B29B2F sqlo_trce + 0x03fb
      0x00007FFFF4B72925 sqloEDUCodeTrapHandler + 0x0265
      0x00007FFFF79CE7E0 address: 0x00007FFFF79CE7E0 ; dladdress:
    0x00007FFFF79BF000 ; offset in lib: 0x000000000000F7E0 ;
      0x00007FFFF40923AE _Z8sqlktopnP8sqeAgentP9sqlri_taoP9SQLE_KRCB
    + 0x047e
      0x00007FFFF59174ED _Z8sqlriopnP8sqlrr_cbP9sqlri_taoPi + 0x0b01
      0x00007FFFF4F0CF3B
    _Z15sqlriReceiveDssP8sqlrr_cbP16sqlkdRqstRplyFmtPl + 0x063d
      0x00007FFFF4D4BCAF _Z16sqlrr_dss_routerP8sqlrr_cb + 0x027f
      0x00007FFFF4D4E21A
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0f48
      0x00007FFFF3EF77B9 _Z20sqleSubRequestRouterP8sqeAgentPjS1_ +
    0x0679
      0x00007FFFF3EF8228 _Z21sqleProcessSubRequestP8sqeAgent +
    0x00a6
      0x00007FFFF3119DE7 _ZN8sqeAgent6RunEDUEv + 0x0649
      0x00007FFFF380ADB8 _ZN9sqzEDUObj9EDUDriverEv + 0x00a6
      0x00007FFFF380AD0F _Z10sqlzRunEDUPcj + 0x0009
      0x00007FFFF35723C4 sqloEDUEntry + 0x02f4
      0x00007FFFF79C6AA1 address: 0x00007FFFF79C6AA1 ; dladdress:
    0x00007FFFF79BF000 ; offset in lib: 0x0000000000007AA1 ;
      0x00007FFFF118793D clone + 0x006d
    

Local fix

  • db2set APM_THROTTLE=26
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 10.1 Fix Pack 6                               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 10.1 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT18654

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-01-04

  • Closed date

    2017-03-02

  • Last modified date

    2020-05-22

  • APAR is sysrouted FROM one or more of the following:

    IT16614

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 May 2020