It's not exactly what you asked for, but this 1995 Newsletter Note provides
some information on DB2 I/O counts in SMF 42 Subtype 6 records,
MXG dataset TYPE42DS.
2. It has always been impossible to track DB2 I/O activity (because the
Media Manager thought itself so fast that it was not necessary to
count I/Os!), but now, the TYPE42DS dataset (from type 42 SMF data)
records both interval and close statistics on ALL datasets (not just
those managed by SMS). As both the DB2 Database and Tablespace or
Indexspace names are contained in the DSNAME in TYPE42DS, you can
analyze DB2 I/O for each tablespace for each DB2 subsystem. The naming
pattern for the DB2 VSAM datasets looks like this:
DSNAME=subsystem.DSNDBD.database.table
or, written with MXG variable names (from T102S105 dataset):
DSNAME=QWHSSSID.DSNDBD.QW0105DN.QW0105TN
as QWHSSSID is the DB2 subsystem Name (almost always DB2...)
DSNDBD is a constant string for the data component
QW0105DN is the DB2 Database Name, and
QW0105TN is the DB2 Tablespace or Indexspace Name.
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Wayne Driscoll
Sent: Wednesday, September 13, 2017 2:13 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: DB2
Q1 - Yes
Q2 - No, DB2 performance records report on the physical level, so the DBID an
OBID, internal 2 byte fields the uniquely identify the space (table or index)
being accessed is reported on, not the table id, which is a logical construct.
There are some audit records that contain DB2 table OBID's, but they are only
captured at the first access of the thread.
Wayne Driscoll
Rocket Software
Note - All opinions are strictly my own.
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Steve Beaver
Sent: Wednesday, September 13, 2017 2:07 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: DB2
Are there any DB2 systems level people in the Group?
Is there a SMF DB2 performance record/or just record that contains the name of
the table(s) being accessed In the DB2 Space
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to
lists...@listserv.ua.edu with the message: INFO IBM-MAIN
================================ Rocket Software, Inc. and subsidiaries ■ 77
Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 877.328.2932
Contact Customer Support:
https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport
Unsubscribe from Marketing Messages/Manage Your Subscription Preferences -
http://www.rocketsoftware.com/manage-your-email-preferences
Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy
================================
This communication and any attachments may contain confidential information of
Rocket Software, Inc. All unauthorized use, disclosure or distribution is
prohibited. If you are not the intended recipient, please notify Rocket
Software immediately and destroy all copies of this communication. Thank you.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to
lists...@listserv.ua.edu with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
