DB2 process hang (load process) collection script

The database has a remote connection to the connection, the state has been loadperforming, lasted for more than a week, suspect that the client from the remote load data when the network exception, resulting in the connection hang.

Dear Customer, Hello:

The data you uploaded is not helpful for hang's problem. Next time if you have a similar problem, please accept the following data.

1. Find the application handle of load hang

DB2 list Applications Show Detail |grep db2bp > List_ap.out

2. db2pd-d <db>-apinfo <appl handle> > Db2pd_apinfo.out

3. Db2pd-edus-agent-util-latch > Db2pd_edu.out

4. Db2pd-stack apphdl=<appl handle>-repeat 60 3

The output of the db2pd-stack will be placed in the Db2dump (or DIAGPATH directory)

5. Trace Application Handle

DB2TRC on-t-apphdl <appl handle>-F db2trc.dmp

---Trace for ten sec

DB2TRC off

DB2TRC flw-t db2trc.dmp DB2TRC.FLW

DB2TRC FMT db2trc.dmp db2trc.fmt

6. DB2 get snapshot for application applid <appl handle> > Snapshot_ap.out

7. Final collection of Db2support.zip

Db2support. -D <db>-s-o Db2support.zip

DB2 process hang (load process) collection script