SMF field data

Bill Giannelli

unread,

Sep 2, 2021, 11:30:21 AM9/2/21

to

We have some BMC data fields that are populated from SMF DB2 records and some fields are coming up blank. How can I read out the SMF record fields to see if the SMF fields are blank also?
One of the fields is QWHCEUWN
thanks
Bill

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to list...@listserv.ua.edu with the message: INFO IBM-MAIN

Wayne Driscoll

unread,

Sep 2, 2021, 1:46:58 PM9/2/21

to

The QWHC is the correlation header, which follows the standard header in the IFI record. I am assuming you are looking at data from IFCID 3, accounting records, which are externalized to SMF via record 101. Look at the DB2 SDNSMACS library for the DSNDQWxx macros that map these records.

Wayne Driscoll
Rocket Software
NOTE: All views expressed are my own, not my employers.

-----Original Message-----
From: IBM Mainframe Discussion List <IBM-...@LISTSERV.UA.EDU> On Behalf Of Bill Giannelli
Sent: Thursday, September 2, 2021 10:30 AM
To: IBM-...@LISTSERV.UA.EDU
Subject: SMF field data

EXTERNAL EMAIL

================================
Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ Main Office Toll Free Number: +1 855.577.4323
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.

Charles Mills

unread,

Sep 2, 2021, 2:16:14 PM9/2/21

to

Interpreting Db2 SMF records is devilishly complex.

Do you have a product that would format SMF records, such as MXG?

Perhaps a CBT program.

I'm serious. If you have little experience with reading SMF records then the Db2 records are not the place to start.

Charles

Bill Giannelli

unread,

Sep 2, 2021, 2:53:16 PM9/2/21

to

the product we have is the BMC reporting tool. I am trying to determine if it is reporting correctly and what the SMF source actually contains

James Crudele

unread,

Sep 2, 2021, 3:20:07 PM9/2/21

to

https://docs.bmc.com/docs/mainview/db2/en/package-accounting-detail-and-summary-tables-dmrapxxx-859711077.html

> On Sep 2, 2021, at 11:30, Bill Giannelli <billgi...@gmail.com> wrote:
>
> We have some BMC data fields that are populated from SMF DB2 records and some fields are coming up blank. How can I read out the SMF record fields to see if the SMF fields are blank also?

Martin Packer

unread,

Sep 3, 2021, 8:14:41 AM9/3/21

to

I think it's perfectly valid to have a blank QWHCEUWN - End User
Workstation Name. What Db2 connection type (QWHCATYP) and reason for
invoking accounting (QWACRINV) values do you have?

Cheers, Martin

Martin Packer

WW z/OS Performance, Capacity and Architecture, IBM Technology Sales

+44-7802-245-584

email: martin...@uk.ibm.com

Twitter / Facebook IDs: MartinPacker

Blog: https://mainframeperformancetopics.com

Mainframe, Performance, Topics Podcast Series (With Marna Walle):
https://anchor.fm/marna-walle

Youtube channel: https://www.youtube.com/channel/UCu_65HaYgksbF6Q8SQ4oOvA

Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number
741598.
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU