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:[email protected]] On Behalf Of Steve Beaver Sent: Wednesday, September 13, 2017 2:07 PM To: [email protected] 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 [email protected] 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 [email protected] with the message: INFO IBM-MAIN
