IBM Support

JR27078: DB2 V7 CLIENT CONNECTION IS CLOSED BY DB2 V9.1SERVER WHEN NO NEW REQUEST IS RECIEVED IN 2 MINUTES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Db2 V7 client connection will be closed by the DB2 V9.1
    server, when no new request is recieved from the client for more
    than 2 minutes. The following entries in the db2diag.log file on
    the server indicate this at DIAGLEVEL 4:
    
    2006-10-20-17.01.24.287857+120 I162814C474        LEVEL: Info
    PID     : 462990               TID  : 1           PROC :
    db2agent (LHJ) 0
    INSTANCE: db2inst3             NODE : 000         DB   : LHJ
    APPHDL  : 0-8                  APPID: 099CB018.D9FA.061020144930
    FUNCTION: DB2 UDB, DB2RA Downlevel Support,
    sqledDb2raServerDriver, probe:115
    RETCODE : ZRC=0x8000006D=-2147483539=SQLZ_RC_CA_BUILT
              "SQLCA has been built and saved in component specific
    control block."
    
    2006-10-20-17.01.24.295009+120 I163289C389        LEVEL: Info
    PID     : 462990               TID  : 1           PROC :
    db2agent (LHJ) 0
    INSTANCE: db2inst3             NODE : 000         DB   : LHJ
    APPHDL  : 0-8                  APPID: 099CB018.D9FA.061020144930
    MESSAGE : error! terminate bit is on and the ddsretcode is
    0x2141, Probe:115
    DATA #1 : String, 22 bytes
    sqledDb2raServerDriver
    
    This is similar to APAR LI70026 except covers the case when
    database is cataloged explicitly with the same
    authentication type as on the server.
    

Local fix

  • Recatalog the database on the client so that the authentication
    parameter is not used.
    
    i.e.
    
    Use:
    catalog db <db> at node <node>
    
    Instead of:
    catalog db <db> at node <node> authentication <auth_type>
    

Problem summary

  • Db2 V7 client connection will be closed by the DB2 V9.1
    server, when no new request is recieved from the client for more
    than 2 minutes. The following entries in the db2diag.log file on
    the server indicate this at DIAGLEVEL 4:
    
    2006-10-20-17.01.24.287857+120 I162814C474        LEVEL: Info
    PID     : 462990               TID  : 1           PROC :
    db2agent (LHJ) 0
    INSTANCE: db2inst3             NODE : 000         DB   : LHJ
    APPHDL  : 0-8                  APPID: 099CB018.D9FA.061020144930
    FUNCTION: DB2 UDB, DB2RA Downlevel Support,
    sqledDb2raServerDriver, probe:115
    RETCODE : ZRC=0x8000006D=-2147483539=SQLZ_RC_CA_BUILT
              "SQLCA has been built and saved in component specific
    control block."
    
    2006-10-20-17.01.24.295009+120 I163289C389        LEVEL: Info
    PID     : 462990               TID  : 1           PROC :
    db2agent (LHJ) 0
    INSTANCE: db2inst3             NODE : 000         DB   : LHJ
    APPHDL  : 0-8                  APPID: 099CB018.D9FA.061020144930
    MESSAGE : error! terminate bit is on and the ddsretcode is
    0x2141, Probe:115
    DATA #1 : String, 22 bytes
    sqledDb2raServerDriver
    
    This is similar to APAR LI70026 except covers the case when
    database is cataloged explicitly with the same
    authentication type as on the server.
    

Problem conclusion

  • Problem was first fixed in Version 9.1 Fix Pack 5
    

Temporary fix

  • Recatalog the database on the client so that the authentication
    parameter is not used.
    
    i.e.
    
    Use:
    catalog db <db> at node <node>
    
    Instead of:
    catalog db <db> at node <node> authentication <auth_type>
    

Comments

APAR Information

  • APAR number

    JR27078

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-07-13

  • Closed date

    2008-06-23

  • Last modified date

    2008-06-23

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

    JR27035

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

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R910 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021