IFCID Reporting

Mike Martin

IFCID Reporting
Hi all,

We've had DB2 for z/OS for a few years now and I've seen several articles about IFCIDs. It sounds like IFCIDs provide a lot of useful information. Most of the articles I have found though, talk about the information that an IFCID provides but often don't explain how to report on the information.

As an example, I'd like to look at the information provided by IFCID's 366 and 376. Which tool(s) are good for viewing the information provided by an IFCID?

Mike Martin

This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

Philip Sevetson

IFCID Reporting
(in response to Mike Martin)
Mike,

There are several products which look at this, and a couple of courses, and High Masters of the art like Joel Goldstein (Stand up and bow, Joel). And there's a module in your installation library called SDSNSAMP, which has layouts and 8-character abbreviations for all of the fields in all of the IFCIDs (Instrumentation Facility Class Identifiers).

But, fundamentally, this is a space where things are hard to find and take serious work and practice to understand, which is why the products and courses and expert(s) are out there. BMC (MAINVIEW), CA(name?), ASG (TMON), and IBM (name?) have offerings in this space.

To activate a class, you need to use the START TRACE statement, and use the CLASS which is right for the IFCIDs you're looking at, and probably specify the IFCIDs.

--Phil S.

From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Monday, February 05, 2018 10:37 AM
To: [login to unmask email]
Subject: [DB2-L] - IFCID Reporting

Hi all,

We've had DB2 for z/OS for a few years now and I've seen several articles about IFCIDs. It sounds like IFCIDs provide a lot of useful information. Most of the articles I have found though, talk about the information that an IFCID provides but often don't explain how to report on the information.

As an example, I'd like to look at the information provided by IFCID's 366 and 376. Which tool(s) are good for viewing the information provided by an IFCID?

Mike Martin
This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

Lizette Koehler

IFCID Reporting
(in response to Mike Martin)
Depending on your version of DB2, there may be various ways to do this.



What tools do you have for processing SMF?

That is typically what you would need for SMF Processing. FCIDs are part of the
SMF Record produced by DB2



https://www.segus.com/media/WP-Collecting-DB2-Metrics-in-SMF.pdf



https://www.ibm.com/developerworks/library/ba-smf-data-db2-analytics-accelerator
/index.html



http://ibmsystemsmag.com/blogs/db2utor/archive/where-to-find-d/





SAS/MXG



SAS/MICS



And probably much much more



Lizette





From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Monday, February 05, 2018 8:37 AM
To: [login to unmask email]
Subject: [DB2-L] - IFCID Reporting



Hi all,



We've had DB2 for z/OS for a few years now and I've seen several articles about
IFCIDs. It sounds like IFCIDs provide a lot of useful information. Most of
the articles I have found though, talk about the information that an IFCID
provides but often don't explain how to report on the information.



As an example, I'd like to look at the information provided by IFCID's 366 and
376. Which tool(s) are good for viewing the information provided by an IFCID?




Mike Martin

_____

Chris Hoelscher

IFCID Reporting
(in response to Mike Martin)
We use CA-SMF manager to pull the ifcid 376 from smf102 and mxg/sas/mics to format the extracted smf data for reporting / manipulation

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Monday, February 5, 2018 10:37 AM
To: [login to unmask email]
Subject: [DB2-L] - IFCID Reporting

Hi all,

We've had DB2 for z/OS for a few years now and I've seen several articles about IFCIDs. It sounds like IFCIDs provide a lot of useful information. Most of the articles I have found though, talk about the information that an IFCID provides but often don't explain how to report on the information.

As an example, I'd like to look at the information provided by IFCID's 366 and 376. Which tool(s) are good for viewing the information provided by an IFCID?

Mike Martin
This email may contain confidential and privileged material for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. Any review or distribution by others is strictly prohibited. Personal emails are restricted by policy of the State Employees' Credit Union (SECU). Therefore SECU specifically disclaims any responsibility or liability for any personal information or opinions of the author expressed in this email.

-----End Original Message-----

Robert Plata

RE: IFCID Reporting
(in response to Mike Martin)

I've used batch reports in CA Sysview, BMC Mainview, and IBM Omegamon.  I am currently using CA Sysview batch reports.  All three have the capability of formatting the SMF input suitable to load into a performance database in the DBMS of your choice. 

Robert Plata