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 CHISTDDn 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==
NR Target........... BCVDS66C
PR Task Number...... 126 I/O Operation Avg Time Tot Time Count
Transaction ID... TSNX ------------------ -------- -------- -----
QM 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==
NR Target........... BCVDS66C
PR Task Number...... 126 I/O Operation Avg Time Tot Time Count
Transaction ID... TSNX ------------------ -------- -------- -----
QM 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
- Use the transaction navigation hyperlinks (NR, PR) located next to the Target and Task Number fields to move through records without having to go back to CHISTDIO.
- Use the QM hyperlink to display the quick menu for the current view set.
- Use the resource navigation arrows (>, <) 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*