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.
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.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*