Just a small add-on:
You can issue LIST even without going to option 8 first,
You're lucky as INSIGHT allows you to write your own reports
DBMS & IT Consultant
IBM Certified Solution Expert
DB2 V7.1 Database Administration for OS/390
From: DB2 Data Base Discussion List
[mailto:[login to unmask email]
On Behalf Of Humphris,Richard P.
Sent: Friday, November 22, 2002 5:37 PM
To: [login to unmask email]
Subject: Re: How to break down 'Other DB2 Time' and I/O wait time
Just found this out a little while ago, INSIGHT has a I/O
request trace you can start:
- go to option 8 (user started reports)
- enter the command "LIST" (from the command line)
- then insight will show you all the members from hlq.REQUESTS
- scroll to request "DSIOSTAT" and enter a "S" to start it
- when the start menu comes up, just press enter (and it will
- note: you may have to go back to the main menu, then enter
"8" again to go back into user started reports to see DSIOSTAT
and information on pageset i/o activity.
Usage notes on DSIOSTAT (why I don't like it):
1) you'll only see the screen get updated when you press enter.
And even if you press enter the numbers only change once every
minutes. And there is no past history.
2) Note: the numbers are only for the "active" DB2 datasets
during the last 5 minute interval. Actually, active means active
I/O to the datasets. So, your very good (but very small)
probably rarely does any I/O and so will never appear in this
even though pages reside in memory and getpages are heavily
those in-core pages.
But, you can write a better request than the one INSIGHT
1) Edit dataset hlq.REQUESTS
2) Select DSIO$NEW (to create a new member by that
3) Copy DSIOSTAT (into DSIO$NEW)
4) look near the end of the request
5) Change "INTERVAL = DEMAND" to "INTERVAL = 5 MINUTES"
6) Comment out " TERMINAL ..." line like "* TERMINAL
7) add a line like "
8) now you're done editing member.
2) Now allocate a dataset like "TESTP.C63401.CNTL.DSIOSTAT.A"
which is DSORG=PS, RECFM=VB, LRECL=4092, BLKSIZE=4096 (actually
can be smaller, but who cares)
3) Go thru above procedure to start your DSIO$NEW request...
now it will write the information to a file every 5 minutes and you
view it at your leisure.
4) Note: still only "active" db2 datasets are reported.
the DB2-L webpage at http://listserv.ylassoc.com.
owners of the list