IFCID Reporting

Mike Martin

IFCID Reporting
Thanks everyone,

Sounds like the only tool we currently have for IFCID reporting is Omegamon. I’ve been searching for how to run reports. Can someone point me in the right direction? (Omegamon doc seems very burdensome for finding what I need)

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.

Robert Plata

IFCID Reporting
(in response to Mike Martin)
Hi Mike,
The manuals are not too bad to read, assuming that you can find them, in my opinion.

Documentation link (you can change versions on this page):
http://www-01.ibm.com/support/docview.wss?uid=swg27020910

The manual that I found that was most useful (V5.3.1 shown):
http://publibfp.dhe.ibm.com/epubs/pdf/ko2ru531.pdf
Reporting User’s Guide – chapter 5 explains the Interactive Report Facility. You can use the IRF to get you started composing the command strings for your desired report. The remaining chapters, after 5, give good JCL examples for batch reports.

If your installation has separated DB2-specific IFCIDs to a separate dataset, then you are ahead of the game. If you must scan an SMF dataset that includes all IFCIDs, then your report will take some time to execute if you don’t have well-defined command specification. You may want to ask your sysprogs in what dataset you may read SMF data for input to Omegamon batch reports.

Please contact me outside of this list if you have more specific questions.

Robert Plata

From: MARTIN, MIKE [mailto:[login to unmask email]
Sent: Wednesday, February 7, 2018 8:59 AM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - RE: IFCID Reporting

Thanks everyone,

Sounds like the only tool we currently have for IFCID reporting is Omegamon. I’ve been searching for how to run reports. Can someone point me in the right direction? (Omegamon doc seems very burdensome for finding what I need)

Mike Martin
-----End Original Message-----

Steven Lamb

RE: IFCID Reporting
(in response to Mike Martin)

Hi Mike,

An example input for an IFCID report might be something like

RECTRACE TRACE LEVEL (LONG)     
    DDNAME(RTFILE1)             
    INCLUDE (IFCID(261)         
            SUBSYSTEMID(SMPB)   
            )                   
EXEC         

or

RECTRACE   TRACE            
INCLUDE(IFCID(202) )           
LEVEL(LONG)         
SORTBY(TIMESTAMP)   
EXEC                                    

 

Regards,

Steve

J&#248;rn Thyssen

RE: IFCID Reporting
(in response to Mike Martin)

Hi Mike,

I have attached some examples:

CRD376: runs the OMPE batch CRD facility to collect traces. In order to get a sample I just stopped the job after 1 record. You will obviously want to run it for longer. My job is based on member FPEZCRDJ from the distribution library TKO2SAMP or runtime library RKO2SAMP.

Alternatively you can start the trace with destination SMF and run the report job against an SMF extract (maybe run IFASMFDP first to extract the records of interest).

 

RECTR376.txt: run OMPE RECTRACE report to format the traces to human readable format.

We have just released APAR PI80819 which adds support in the OMPE Performance Database for 366/376 records, so you can load the trace records collected into a Db2 table. If you have a lot of 366/376 records it may be easier to run reports against Db2 tables.

Feel free to contact me off list for further assistance

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal. 

Attachments

  • rectr376.txt (<1k)
  • rep376.txt (25.6k)
  • crd376.txt (9.2k)

Mike Martin

IFCID Reporting
(in response to Jørn Thyssen)
Thanks Jørn and Robert! (and everyone else) You have been a tremendous help getting me going with the Omegmaon reports. -Mike Martin

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Thursday, February 08, 2018 5:18 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: IFCID Reporting


Hi Mike,

I have attached some examples:

CRD376: runs the OMPE batch CRD facility to collect traces. In order to get a sample I just stopped the job after 1 record. You will obviously want to run it for longer. My job is based on member FPEZCRDJ from the distribution library TKO2SAMP or runtime library RKO2SAMP.

Alternatively you can start the trace with destination SMF and run the report job against an SMF extract (maybe run IFASMFDP first to extract the records of interest).



RECTR376.txt: run OMPE RECTRACE report to format the traces to human readable format.

We have just released APAR PI80819 which adds support in the OMPE Performance Database for 366/376 records, so you can load the trace records collected into a Db2 table. If you have a lot of 366/376 records it may be easier to run reports against Db2 tables.

Feel free to contact me off list for further assistance



Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

Views are personal.

________________________________
Attachment Links: rectr376.txt (0 k) https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_fo_do_-3Fdownload-3D1-26fid-3D9038&d=DwMFaQ&c=dOIHEx_m7N7yjf0u0gEwLgJTqmAETLnPN05Bbp0BqA8&r=DLy8kYClAcx9uxflXv--UwjMFy5MfFSkf1O5jxkToQA&m=B_PayAU13u0UStdynwpe9wceGpmfqWZkjazCq97eTco&s=PoCXk4WWNT1KMplA8jLeGQwm5-NfOysUUwf5AGlkUIk&e= rep376.txt (26 k) https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_fo_do_-3Fdownload-3D1-26fid-3D9039&d=DwMFaQ&c=dOIHEx_m7N7yjf0u0gEwLgJTqmAETLnPN05Bbp0BqA8&r=DLy8kYClAcx9uxflXv--UwjMFy5MfFSkf1O5jxkToQA&m=B_PayAU13u0UStdynwpe9wceGpmfqWZkjazCq97eTco&s=BTPzwuMXvTShmJRekt_ElZTC8cLodrt1AHy8GWwM5Jc&e= crd376.txt (9 k) https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_fo_do_-3Fdownload-3D1-26fid-3D9040&d=DwMFaQ&c=dOIHEx_m7N7yjf0u0gEwLgJTqmAETLnPN05Bbp0BqA8&r=DLy8kYClAcx9uxflXv--UwjMFy5MfFSkf1O5jxkToQA&m=B_PayAU13u0UStdynwpe9wceGpmfqWZkjazCq97eTco&s=YNWv79G_J6FJvzu7hcqdnRRC2kiGCCIZhQQ7N09mZ98&e=
Site Links: View post online https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_fo_st_-3Fpost-3D184704-26anc-3Dp184704-23p184704&d=DwMFaQ&c=dOIHEx_m7N7yjf0u0gEwLgJTqmAETLnPN05Bbp0BqA8&r=DLy8kYClAcx9uxflXv--UwjMFy5MfFSkf1O5jxkToQA&m=B_PayAU13u0UStdynwpe9wceGpmfqWZkjazCq97eTco&s=fcQ_qSKAIi-Hg011lzdru-X1yf83j6knHtQYwJfecLU&e= View mailing list online https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_fo_si_-3Ftopic-3D19&d=DwMFaQ&c=dOIHEx_m7N7yjf0u0gEwLgJTqmAETLnPN05Bbp0BqA8&r=DLy8kYClAcx9uxflXv--UwjMFy5MfFSkf1O5jxkToQA&m=B_PayAU13u0UStdynwpe9wceGpmfqWZkjazCq97eTco&s=IOfqFq6kL_tlMKMtTD2e9rbdP-rqN9n7YUwM1p6jcjM&e= Start new thread via email<mailto:[login to unmask email]> Unsubscribe from this mailing list<mailto:[login to unmask email]?Subject=Unsubscribe> Manage your subscription https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_us_to_&d=DwMFaQ&c=dOIHEx_m7N7yjf0u0gEwLgJTqmAETLnPN05Bbp0BqA8&r=DLy8kYClAcx9uxflXv--UwjMFy5MfFSkf1O5jxkToQA&m=B_PayAU13u0UStdynwpe9wceGpmfqWZkjazCq97eTco&s=pvvtgr8-NFwRec-MVxopcS8MNsZP-Ey3-pDJQ-Nb4m4&e=

This email has been sent to: [login to unmask email]<mailto:[login to unmask email]>

** ** ** IDUG DB2 Data and Analytics Technical Summit in Bengaluru, India 2018 ** ** **
---> Bengaluru, India, March 27, 2018 <---
http://ibm.biz/IDUGBengaluru2018 https://urldefense.proofpoint.com/v2/url?u=http-3A__ibm.biz_IDUGBengaluru2018&d=DwMFaQ&c=dOIHEx_m7N7yjf0u0gEwLgJTqmAETLnPN05Bbp0BqA8&r=DLy8kYClAcx9uxflXv--UwjMFy5MfFSkf1O5jxkToQA&m=B_PayAU13u0UStdynwpe9wceGpmfqWZkjazCq97eTco&s=pvRg5ntt0UTmJGQQFUIHn1bpy4KEpaN2iqADI8MgRXc&e=

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_cm_ld_fid-3D2&d=DwMFaQ&c=dOIHEx_m7N7yjf0u0gEwLgJTqmAETLnPN05Bbp0BqA8&r=DLy8kYClAcx9uxflXv--UwjMFy5MfFSkf1O5jxkToQA&m=B_PayAU13u0UStdynwpe9wceGpmfqWZkjazCq97eTco&s=1ZSSofkDaJn2PJQPfzwrVYVK6Nrd_MOhm7l7N8vThLo&e=

________________________________

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.