I would probably post on the DB2 Newsgroup for this rather than IBMMAIN If you have not joined, go to IDUG.ORG and join the DB2 Newsgroup
Lizette > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf > Of Charles Mills > Sent: Monday, July 02, 2012 8:17 AM > To: [email protected] > Subject: DB2 accounting data source question > > Is anyone reasonably certain, for the data contained in the OMEGAMON XE FOR > DB2 PERFORMANCE EXPERT (V5R1) ACCOUNTING REPORT - SHORT, showing, for > example > > ACFBATCH 1411 15457 19.93 172.30 0.06 > 13.069422 23440.43 0.71 > 0 2526.63 5.86 172.30 25.785584 > 6.756138 605.15 0 > 0 8424.58 N/A 0.01 7.074654 > 120.3K 2582.54 > > > > ---------------------------------------------------------------------------- > ------------------------------------ > |PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME > CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP| > |xxx175C0 DBRM 1 N/A 3300.00 2.457909 > 0.443865 0.457534 74.00| > |xxx176C0 DBRM 1 N/A 1.00 0.404564 > 0.003418 0.219574 7.00| > > what is the SMF data from which that report data originates? Record type 101? IFCID > number? Which data section? > > Please forgive my near-total DB2 ignorance. What would be the DB2 parameter or > option to turn that data on, to cause DB2 to record it in SMF? > > Thanks much! > > (X-posted to DB2-L and IBMMAIN.) > > Charles > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, send email to > [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
