In my second job as a capacity/performance, MICS wasn't ready for DB2.
So, I took the manual and coded a SAS programme to parse the SMF records
produced.
The documentation didn't have offsets -- just type & length.
There were a lot of typo and offset errors before I got clean code.
Also, the meanings of a lot of fields were not clear -- not to mention
recording bugs!
This was the first release of DB2; I can't recall if it was V1.0 or V1.1 -- I
don't remember how IBM numbered them, circa 1983-84.
I did the coding because we needed the information, and we were one of the
first sites in Ontario (or Canada), and possibly the first in Toronto; we
didn't have many contacts to ask for help.
Even IBM wasn't sure of a lot, back then; we ended up as a guinea pig a few
times.
These days, I recomend not developing the code, yourself!
Sent wirelessly from my BlackBerry device on the Bell network.
Envoyé sans fil par mon terminal mobile BlackBerry sur le réseau de Bell.
-----Original Message-----
From: Charles Mills <charl...@mcn.org>
Sender: IBM Mainframe Discussion List <IBM-MAIN@bama.ua.edu>
Date: Wed, 13 Apr 2011 15:48:44
To: <IBM-MAIN@bama.ua.edu>
Reply-To: IBM Mainframe Discussion List <IBM-MAIN@bama.ua.edu>
Subject: Re: DB2 SMF Records
Oh boy, do you have some fun cut out for you!
//SYSLIB DD DISP=SHR,DSN=DB2.DSN710.ADSNMACS
//SYSIN DD *
* See DB2 Performance and Tuning Section 5.4.1.1
* *** DSNDQWST DSECT=YES,SUBTYPE=ALL Type 100
DSNDQWAS DSECT=YES,SUBTYPE=ALL Type 101
* *** DSNDQWSP DSECT=YES,SUBTYPE=ALL Type 102
END
/*
Good luck!
Charles
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf
Of Hal Merritt
Sent: Tuesday, April 12, 2011 1:10 PM
To: IBM-MAIN@bama.ua.edu
Subject: DB2 SMF Records
Anyone know I could find the layouts (DSECTs) of DB2 SMF records?
Specifically Type 100, 101, & 102 ?
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
