ca.portal.admin

Re:Re: [IDMSVENDOR-L] Access to Lock Data Used in PMRM?

Discussion created by ca.portal.admin on Mar 10, 2010
But can you get idms statistics to SMF without PM?

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

you only need to test the programs that you want to work correctly






From:
""David E Matthews (DHL CZ)"" <David.Matthews@DHL.COM>
To:
IDMSVENDOR-L@LISTSERV.IUASSN.COM
Date:
03/09/2010 02:36 PM
Subject:
Re: [IDMSVENDOR-L] Access to Lock Data Used in PMRM?
Sent by:
IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



I don't know how this will look on IDMS-L.
It's a standard 132 byte report from SMF data via Perfmon, a custom-written
report just using wait records (like PMARPT36, but just for DBKEY Waits)

REPORT NO. 89 LISTDBKW - TASK
DBKEY WAITS 03/09/10 PAGE 1
CV DATE TIME WAIT PROGRAM TASK GRP PAGE LINE
AREA TYPE HOLD1 HOLD2 3

20 03/08 00:00 00000.2170 OPS-D186 3590594 030 04439390 0015
OPERDB.OPER-AREA-SGEN8 NL IMPD021A 03590694 T
20 03/08 00:00 00000.0163 OPS-D186 3590594 030 04439390 0015
OPERDB.OPER-AREA-SGEN8 NL EDI-D991 03590734 T
20 03/08 00:01 00000.0090 OPS-D102 3594312 030 03939641 0004
OPERDB.OPER-AREA-SGEN28 NL EDI-D991 03594319 T
20 03/08 00:01 00000.0063 OPS-D104 3594678 030 05907089 0036
OPERDB.OPER-AREA-SGEN X COS-D020 03594668 T
20 03/08 00:01 00000.0046 IMPD021A 3597729 030 04439390 0000
OPERDB.OPER-AREA-SGEN8 X IMPC0010 03597358 T
20 03/08 00:01 00000.0029 IMPD021A 3597729 030 05834991 0073
OPERDB.OPER-AREA-SGEN S IMPC0010 03597358 T
20 03/08 00:01 00000.3538 IMPD021A 3597773 030 04439390 0000
OPERDB.OPER-AREA-SGEN8 X IMPC0010 03597358 T
20 03/08 00:01 00000.0049 IMPD021A 3597773 030 06004232 0045
OPERDB.OPER-AREA-SGEN S IMPC0010 03597358 T
20 03/08 00:02 00000.1964 IMPD150A 3597788 030 04439390 0000
OPERDB.OPER-AREA-SGEN8 X IMPC0010 03597358 T

Just to show you what ""autopsy"" type data is out there. . .=20 Regards, dem

Outcomes