IBM Support

Db2 for LUW 11.5 mod pack 8 fix pack 0 client may crash when retrieving database configuration from remote host

News


Abstract

Db2 for LUW 11.5 mod pack 8 fix pack 0 client may crash when retrieving database configuration from remote host.

Issue is fixed by DT170035: GET DB CFG TRAPS IF USING DB2NODE TO FETCH DATA FROM A REMOTE NODE

Content

In 11.5.8 client an attempt to retrieve database configuration from database node located on host remote relative to client host will crash the client with the following callstack. Database server is unaffected and remains up.
 
sqleriar(SQLE_DB2RA_T*)
db2CfgCall(unsigned int, void*, sqlca*, unsigned int)
clpbp_exe_sqlfxdb()
clp_bp_con()
main

Example:
db2nodes.cfg file:
0 head-0 0
1 head-0 1
2 data1-0 0
3 data1-0 1

Running from head-0 host
db2 terminate
export DB2NODE=2
db2 get db cfg for <db name>

The workaround is to use Db2_all and direct it to a single node:
 Db2_all "<<+2<" Db2 get db cfg for <db name>

[{"Type":"MASTER","Line of Business":{"code":"","label":""},"Business Unit":{"code":"","label":""},"Product":{"code":"SSLS7E","label":"Db2 Universal Database for Linux, UNIX and Windows"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Product Synonym

11.5 mod pack 8 fix pack 0

Document Information

Modified date:
08 November 2022

UID

ibm16830731