PT121E - GENERAL DB2 CONNECTION FAILURE

book

Article ID: 126770

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

when user issue the following command in a DB2V12R1M100, the command works as seen below:
------------------------------------------------------------  -DIS DDF ¦
******************************* TOP OF DATA ******************
Working after LEVEL(V12R1M100) in D2UA DSNL080I -D2UA DSNLTDDF DISPLAY DDF REPORT FOLLOWS: DSNL081I STATUS=STARTD DSNL082I LOCATION LUNAME GENERICLU DSNL083I D2U1DDF NETNFCT.D2UADDF -NONE DSNL084I TCPPORT=446 SECPORT=0 RESPORT=5031 IPNAME=-NONE DSNL085I IPADDR=::172.29.249.10 DSNL086I SQL DOMAIN=osa-test.nfcu.net DSNL086I RESYNC DOMAIN=osa-test.nfcu.net DSNL087I ALIAS PORT SECPORT STATUS DSNL088I D2U1MOBL 9655 0 CANCLD DSNL088I D2U1UAD 9656 0 STARTD DSNL088I D2U1NFOA 9657 0 STARTD DSNL088I D2U1ADHC 9658 0 STARTD But when he issues the same command in a DB2V12R1M500 he gets the following message:
PT121 PT121E - GENERAL DB2 CONNECTION FAILURE in DB2 command process
 

Environment

Release:
Component: COMDB2

Resolution

The problem was caused by an incorrect DB2 subsystem version (SSIDVER) and migration mode (SSIDMODE) values for D2XA subsystem (which was giving the connection error) in the HGHLVL.CDBAPARM(SETUPxx).
Whenever upgrading to a new DB2 release, migration mode, or function level on the DB2 subsystems, DB2 subsystem information needs to be updated in the SETUPxx global parmlib member. Here is the link to the R19 documentation for the same : https://docops.ca.com/ca-database-management-solutions-for-db2-for-z-os/19/en/installing/upgrade-to-new-db2-releases-modes-or-function-levels
In this case, both the DB2 subsystems have identical DB2 subsystem version (SSIDVER) and migration mode (SSIDMODE) values in the SETUPxx global parmlib member (V11 and NFM respectively). D2UA subsystem which is on DB2 function level V12R1M100 doesn't give the error since this function level is equivalent to DB2V11 NFM. However, D2XA subsystem doesn't have correct DB2 subsystem version (SSIDVER) and migration mode (SSIDMODE) values in the SETUPxx global parmlib member. The correct values for D2XA should be V12 and NF(Y) for DB2 subsystem version (SSIDVER) and migration mode (SSIDMODE) values in the SETUPxx global parmlib member. Important! We recommend that you use the Setup option on the Post-Install Tailoring panels to edit these members. The online help that is provided from the SETUP parmlib panels provides detailed information about the supported DB2 version, mode, and function levels. Manual editing in hlq.CDBAPARM is not recommended.