CHISTDDn views
To display DB2 plan information for any of the first five resources that the task accessed, hyperlink from the Expand data for field (with a type of DB2) on the CHISTDIO view.
The CHISTDDn view is displayed (where n is 1-5), depending on which of the five entries you hyperlink from. If you hyperlink from the first entry, the CHISTDD1 view is displayed. All CHISTDD n views look the same.
CHISTDD1 view
ddmmmyyyy hh:mm:ss ------ MAINVIEW WINDOW INTERFACE(Vv.r.mm)------------------
COMMAND ===> SCROLL ===> PAGE
CURR WIN ===> 1 ALT WIN ===>
W1 =CHIST====CHISTDD1=BCVDS66C=*========ddmmmyyyy==hh:mm:ss====MVCICS===D====1==
> Target........... BCVDS66C
< Task Number...... 126 I/O Operation Avg Time Tot Time Count
Transaction ID... TSNX ------------------ -------- -------- -----
Open..............
Detach Date (Lcl) 17NOV2010 Close.............
Detach Time (Lcl) 07:41:42.1 Select............ 0.0008 0.0615 77
Fetch.............
> File Name........ TSMCOMXN Insert............
Update............
. File Type........ DB2 Delete............
Commit............
Prepare...........
Describe..........
Execute...........
Execute Immediate.
Other.............
Total I/O Requests 0.0008 0.0615 77
COMMAND ===> SCROLL ===> PAGE
CURR WIN ===> 1 ALT WIN ===>
W1 =CHIST====CHISTDD1=BCVDS66C=*========ddmmmyyyy==hh:mm:ss====MVCICS===D====1==
> Target........... BCVDS66C
< Task Number...... 126 I/O Operation Avg Time Tot Time Count
Transaction ID... TSNX ------------------ -------- -------- -----
Open..............
Detach Date (Lcl) 17NOV2010 Close.............
Detach Time (Lcl) 07:41:42.1 Select............ 0.0008 0.0615 77
Fetch.............
> File Name........ TSMCOMXN Insert............
Update............
. File Type........ DB2 Delete............
Commit............
Prepare...........
Describe..........
Execute...........
Execute Immediate.
Other.............
Total I/O Requests 0.0008 0.0615 77
Usage notes
- You can use the transaction navigation arrows (Next >, Previous <) located next to the Target and Task Number fields to move through records without having to go back to CHISTDIO.
- You can use the resource navigation arrows (Next >, Previous <) located next to the File Name field to move through resource records for the selected transaction.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*