Re: SMF field data
Glad you found it. Seems your Db2 subsystems aren't entirely cloned... ... I was pondering Datasharing Group level things versus Subsystem things. DSNZPARM is, of course, a Subsystem thing - so members even in the same Datasharing Group can have different DSNZPARM values, such as this one. Cheers, Martin Martin Packer WW z/OS Performance, Capacity and Architecture, IBM Technology Sales +44-7802-245-584 email: martin_pac...@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 From: "Bill Giannelli" To: IBM-MAIN@LISTSERV.UA.EDU Date: 05/09/2021 19:29 Subject:[EXTERNAL] Re: SMF field data Sent by:"IBM Mainframe Discussion List" finally found out that I had a zparm accumuid set to 1 once I changed it to 0 the data started showing up. Bill -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMF field data
finally found out that I had a zparm accumuid set to 1 once I changed it to 0 the data started showing up. Bill -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMF field data
Open a ticket with IBM. Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Bill Giannelli Sent: Saturday, September 4, 2021 6:15 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SMF field data It appears that these 2 fields, ENDUSERWN and ENDUSERWN_L in BMC (QWHCEUWN and QWHCEUWN_Var in SMF) are blank for all records from 2 of our LPARS for all DB2 members on those LPARS. The fields are populated from a third LPAR for all DB2 members on that LPAR. I have not found any differences in the DB2 traces. Is there something LPAR specific that would restrict this data? thanks Bill -- 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
Re: SMF field data
Can you identify what the names may map back to? Are they IP host names, NetBIOS computer names? I know DB2 tries to do a reverse look-up when a remote I IP host when they connect to it. If so, could 2 of your LPAR's be using different DNS servers than the 3rd? Or maybe the hosts connecting to the one LPAR have PTR records while the hosts connecting to the other 2 LPAR's don't have PTR records. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMF field data
I'm not aware of anything., I'd talk to BMC about this but I suspect it's how the clients are set up. You also didn't say what client connection types. Also it could be a Db2 bug. Again, not being a Db2 specialist, I wouldn't know about a Db2 bug. Cheers, Martin Martin Packer WW z/OS Performance, Capacity and Architecture, IBM Technology Sales +44-7802-245-584 email: martin_pac...@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 From: "Bill Giannelli" To: IBM-MAIN@LISTSERV.UA.EDU Date: 04/09/2021 14:15 Subject:[EXTERNAL] Re: SMF field data Sent by:"IBM Mainframe Discussion List" It appears that these 2 fields, ENDUSERWN and ENDUSERWN_L in BMC (QWHCEUWN and QWHCEUWN_Var in SMF) are blank for all records from 2 of our LPARS for all DB2 members on those LPARS. The fields are populated from a third LPAR for all DB2 members on that LPAR. I have not found any differences in the DB2 traces. Is there something LPAR specific that would restrict this data? thanks Bill -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMF field data
It appears that these 2 fields, ENDUSERWN and ENDUSERWN_L in BMC (QWHCEUWN and QWHCEUWN_Var in SMF) are blank for all records from 2 of our LPARS for all DB2 members on those LPARS. The fields are populated from a third LPAR for all DB2 members on that LPAR. I have not found any differences in the DB2 traces. Is there something LPAR specific that would restrict this data? thanks Bill -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMF field data
Having been that novice several times over :-) I agree with you. Hopefully I got it right in https://github.com/MartinPacker/Db2-DDF-Analysis-Tool. If not it's open source so someone can correct it... :-) Cheers, Martin Martin Packer WW z/OS Performance, Capacity and Architecture, IBM Technology Sales +44-7802-245-584 email: martin_pac...@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 From: "Charles Mills" To: IBM-MAIN@LISTSERV.UA.EDU Date: 03/09/2021 17:42 Subject:[EXTERNAL] Re: SMF field data Sent by:"IBM Mainframe Discussion List" Yeah, the layout is complex and hard to fathom, but once you get your code right it is going to work every time. I am going to guess the BMC report falls into that category. I am going to struggle to say this well: not trying to be insulting, but I would trust a report over the opinion of someone trying to decode the layout for the first time. If I had an established report program that said the field was blank and a novice SMF 101 person saying "no, look here, it says " I would tend to trust the report. Again, not trying to be insulting -- it is just a darned tricky layout. Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Martin Packer Sent: Friday, September 3, 2021 9:05 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SMF field data I very clearly don't work for BMC, either. :-) And it's not just professional courtesy that suggests they're almost certainly correct: 1) It's probably a more-or-less simple copy from the source to the destination - and would've been reported as a bug long ago. 2) As I indicated, the data makes sense. For example, what would the End User Workstation ID be for a batch job? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMF field data
Yeah, the layout is complex and hard to fathom, but once you get your code right it is going to work every time. I am going to guess the BMC report falls into that category. I am going to struggle to say this well: not trying to be insulting, but I would trust a report over the opinion of someone trying to decode the layout for the first time. If I had an established report program that said the field was blank and a novice SMF 101 person saying "no, look here, it says " I would tend to trust the report. Again, not trying to be insulting -- it is just a darned tricky layout. Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Martin Packer Sent: Friday, September 3, 2021 9:05 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SMF field data I very clearly don't work for BMC, either. :-) And it's not just professional courtesy that suggests they're almost certainly correct: 1) It's probably a more-or-less simple copy from the source to the destination - and would've been reported as a bug long ago. 2) As I indicated, the data makes sense. For example, what would the End User Workstation ID be for a batch job? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMF field data
I very clearly don't work for BMC, either. :-) And it's not just professional courtesy that suggests they're almost certainly correct: 1) It's probably a more-or-less simple copy from the source to the destination - and would've been reported as a bug long ago. 2) As I indicated, the data makes sense. For example, what would the End User Workstation ID be for a batch job? Cheers, Martin Martin Packer WW z/OS Performance, Capacity and Architecture, IBM Technology Sales +44-7802-245-584 email: martin_pac...@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 From: "Charles Mills" To: IBM-MAIN@LISTSERV.UA.EDU Date: 03/09/2021 16:44 Subject:[EXTERNAL] Re: SMF field data Sent by:"IBM Mainframe Discussion List" Yes, the fields are not "intuitive." It is hard to predict -- or at least it was for me -- what fields would be populated under what circumstances. I am going to venture a wild guess that the BMC report is correct. (I don't work for BMC, and I am not familiar with the specific product.) Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Martin Packer Sent: Friday, September 3, 2021 5:14 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SMF field data 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_pac...@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 From: "Bill Giannelli" To: IBM-MAIN@LISTSERV.UA.EDU Date: 02/09/2021 19:53 Subject:[EXTERNAL] Re: SMF field data Sent by:"IBM Mainframe Discussion List" 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN 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 -- 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 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMF field data
Yes, the fields are not "intuitive." It is hard to predict -- or at least it was for me -- what fields would be populated under what circumstances. I am going to venture a wild guess that the BMC report is correct. (I don't work for BMC, and I am not familiar with the specific product.) Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Martin Packer Sent: Friday, September 3, 2021 5:14 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SMF field data 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_pac...@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 From: "Bill Giannelli" To: IBM-MAIN@LISTSERV.UA.EDU Date: 02/09/2021 19:53 Subject: [EXTERNAL] Re: SMF field data Sent by:"IBM Mainframe Discussion List" 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN 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 -- 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
Re: SMF field data
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_pac...@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 From: "Bill Giannelli" To: IBM-MAIN@LISTSERV.UA.EDU Date: 02/09/2021 19:53 Subject:[EXTERNAL] Re: SMF field data Sent by:"IBM Mainframe Discussion List" 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMF field data
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 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? > One of the fields is QWHCEUWN > thanks > Bill > > -- > 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
Re: SMF field data
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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SMF field data
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 -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Wayne Driscoll Sent: Thursday, September 2, 2021 10:47 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SMF field data 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 On Behalf Of Bill Giannelli Sent: Thursday, September 2, 2021 10:30 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: SMF field data EXTERNAL EMAIL 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 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 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. -- 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
Re: SMF field data
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 On Behalf Of Bill Giannelli Sent: Thursday, September 2, 2021 10:30 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: SMF field data EXTERNAL EMAIL 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 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 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. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN