Checking the status of Db2 and SAP connections

Edit online

This information discusses basic techniques for identifying problems that are related to the SAP connections to Db2, or Db2 itself. It describes various commands with which you can check the status of Db2 and SAP connections. More problem determination information can be found in the Database Administration Guide for SAP on IBM® Db2 for z/OS and the respective Planning Guide for SAP on IBM Db2 for z/OS.

Check that DB2® is running

Use the SDSF DA command to show the status of Db2.

The following figure shows a sample output. If the display does not show the Db2 systems running, then check the z/OS system log for messages (refer to z/OS syslog).

Figure 1. Results of SDSF DA command

SDSF DA COH1     (ALL)    PAG  0  CPU/L/Z   6/  2/  0  LINE 1-13 (13)
COMMAND INPUT ===>                                            SCROLL ===> CSR
NP   JOBNAME  StepName ProcStep JobID    Owner    C Pos DP Real Paging    SIO
     HA21DIST HA21DIST IEFPROC  STC03201 HA2USER    NS  FE 3788   0.00   0.00
     HA21MSTR HA21MSTR IEFPROC  STC03187 HA2USER    NS  FE 1632   0.00   0.00
     HA21DBM1 HA21DBM1 IEFPROC  STC03198 HA2USER    NS  FE  44T   0.00   0.00
     HA21IRLM HA21IRLM IRLM     STC03194 HA2USER    NS  FE  18T   0.00   0.00
     HA22MSTR HA22MSTR IEFPROC  STC03188 HA2USER    NS  FE  589   0.00   0.00
     HA22IRLM HA22IRLM IRLM     STC03195 HA2USER    NS  FE  18T   0.00   0.00
     HA22DIST HA22DIST IEFPROC  STC03203 HA2USER    NS  FE 1312   0.00   0.00
     HA22DBM1 HA22DBM1 IEFPROC  STC03199 HA2USER    NS  FE  12T   0.00   0.00
     HA23DBM1 HA23DBM1 IEFPROC  STC03197 HA2USER    NS  FE  33T   0.00   0.00
     HA23IRLM HA23IRLM IRLM     STC03192 HA2USER    NS  FE  20T   0.00   0.00
     HA23DIST HA23DIST IEFPROC  STC03202 HA2USER    NS  FE 1749   0.00   0.00
     HA23MSTR HA23MSTR IEFPROC  STC03186 HA2USER    NS  FE 2257   0.00   0.00

Check the SAP database connections

Use the Display Thread command to show the connections to Db2 from the SAP application server on z/OS UNIX. For example:

-HA21 DISPLAY THREAD(*)

The following figure shows the results of this command for configuration. It shows one AIX® application server p570coh1, with ABAP database connections to the Db2 member. In the example, ABAP connections use the AUTHID R3USER.

Figure 2. Results of Db2 Display Thread command

DSNV402I  -HA21 ACTIVE THREADS - 237
NAME     ST A   REQ ID           AUTHID   PLAN     ASID TOKEN
SERVER   RA *   291 HA2DIA003    R3USER   DISTSERV 0076   700
 V437-WORKSTATION=p570coh1, USERID=r3user,
      APPLICATION NAME=HA2DIA003
 V442-CRTKN=10.101.4.239.33093.100813131913
 V445-GA6504EF.O145.100813131913=700 ACCESSING DATA FOR
  ::FFFF:10.101.4.239
SERVER   RA *   599 HA2SPO014    R3USER   DISTSERV 0076   701
 V437-WORKSTATION=p570coh1, USERID=r3user,
      APPLICATION NAME=HA2SPO014
 V442-CRTKN=10.101.4.239.33094.100813131913
 V445-GA6504EF.O146.100813131913=701 ACCESSING DATA FOR
  ::FFFF:10.101.4.239
...
...