Running DB2 V7.1 for Z/os datasharing with 2 members. The first online
transaction after batch period is doing one single insert on table with 2
indexes. From trace I see long time spending acquire locks for syslog range
recording - but I can't figure out why. Tablespace has been inactive for
hours in both members when doing insert. Tablespace is defined with locksize
(row) and close(no). Indexes is defined with copy(yes) and close(no).
What can I look for to achieve better performance?
Detector trace output attached.
kind regards
Leif Hansen
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
1 2006/05/19 14:41
PAGE 1
SEQNO TIME PROGRAM STMTÆ EVENT
EVENT_DATA
-------- --------------- -------- ----- --------------------------
-------------------------------------------------------------
00000001 06:59:59.151087 ITE0100Ø 00224 START INSERT
00000002 06:59:59.151900 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=PSET STATE=IX DBASE=SY33P PSET=TSY0010
00000003 06:59:59.151911 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=TABL STATE=IX DBASE=SY33P TABL=S99TSY0010
00000004 06:59:59.152206 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=WRDL STATE=S DBASE=SY33P PSET=KSY0101
00000005 06:59:59.152214 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=PSOP STATE=X DBASE=SY33P PSET=KSY0101
00000006 06:59:59.152228 ITE0100Ø 00224 LOCK RELEASE(GROUP)
TYPE=WRDL STATE=ANY
00000007 06:59:59.152233 ITE0100Ø 00224 LOCK RELEASE
TYPE=DPAG STATE=ANY DBASE=SY33P PSET=KSY0101
00000008 06:59:59.189597 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=WRDL STATE=S DBASE=SY33P PSET=TSY0010
00000009 06:59:59.189606 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=PSOP STATE=X DBASE=SY33P PSET=TSY0010
00000010 06:59:59.189622 ITE0100Ø 00224 LOCK RELEASE(GROUP)
TYPE=WRDL STATE=ANY
00000011 06:59:59.189627 ITE0100Ø 00224 LOCK RELEASE
TYPE=DPAG STATE=ANY DBASE=SY33P PSET=TSY0010
00000012 06:59:59.211947 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=SREC STATE=X DBASE=SY33P PSET=TSY0010
00000013 06:59:59.767671 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=PGRL STATE=S DBASE=DBID0500 PSET=OBID0229
00000014 06:59:59.767746 ITE0100Ø 00224 LOCK CHANGE
TYPE=DPAG STATE=U
00000015 06:59:59.796397 ITE0100Ø 00224 LOCK RELEASE
TYPE=DPAG STATE=ANY DBASE=SY33P PSET=TSY0010
00000016 06:59:59.796487 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=PGEP STATE=X DBASE=DBID0500 PSET=OBID0229
00000017 06:59:59.796506 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=ROWL STATE=X PAGEÆ=00007B
00000018 06:59:59.796708 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=SREC STATE=X DBASE=SY33P PSET=KSY0101
00000019 07:00:01.861628 ITE0100Ø 00224 LOCK RELEASE(GROUP)
TYPE=DPAG STATE=ANY
00000020 07:00:01.861746 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=PGRL STATE=S DBASE=DBID0600 PSET=OBID0229
00000021 07:00:01.861901 ITE0100Ø 00224 LOCK CHANGE
TYPE=DPAG STATE=U
00000022 07:00:01.886751 ITE0100Ø 00224 LOCK RELEASE
TYPE=DPAG STATE=ANY DBASE=SY33P PSET=KSY0101
00000023 07:00:01.888866 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=WRDL STATE=S DBASE=SY33P PSET=KSY0102
00000024 07:00:01.888877 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=PSOP STATE=X DBASE=SY33P PSET=KSY0102
00000025 07:00:01.888892 ITE0100Ø 00224 LOCK RELEASE(GROUP)
TYPE=WRDL STATE=ANY
00000026 07:00:01.888897 ITE0100Ø 00224 LOCK RELEASE
TYPE=DPAG STATE=ANY DBASE=SY33P PSET=KSY0102
00000027 07:00:01.933574 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=SREC STATE=X DBASE=SY33P PSET=KSY0102
00000028 07:00:03.964673 ITE0100Ø 00224 LOCK RELEASE(GROUP)
TYPE=DPAG STATE=ANY
00000029 07:00:03.964782 ITE0100Ø 00224 LOCK ACQUIRE
TYPE=PGRL STATE=S DBASE=DBID0600 PSET=OBID0229
00000030 07:00:03.964864 ITE0100Ø 00224 LOCK CHANGE
TYPE=DPAG STATE=U
00000031 07:00:03.990740 ITE0100Ø 00224 LOCK RELEASE
TYPE=DPAG STATE=ANY DBASE=SY33P PSET=KSY0102
00000032 07:00:03.990785 ITE0100Ø 00224 END INSERT
RET_CODE=0
00000033 07:00:04.866243 IAD0006Ø 00061 START OPEN CURSOR
00000034 07:00:04.866260 IAD0006Ø 00061 END OPEN CURSOR
RET_CODE=0
00000035 07:00:04.866394 IAD0006Ø 00086 START FETCH
00000036 07:00:04.866423 IAD0006Ø 00086 START SCAN (SEQU)
SCAN=SEQU DBASE=KT33P PGSET=TKT0040 TAB
00000037 07:00:04.866614 IAD0006Ø 00086 END FETCH
RET_CODE=0
00000038 07:00:04.866668 IAD0006Ø 00105 START CLOSE CURSOR
00000039 07:00:04.866673 IAD0006Ø 00105 END SCAN (SEQU)
SCAN=SEQU DTYP=DATA --- STATISTICS FOLLOW ------>
00000040 07:00:04.866683 IAD0006Ø 00105 END CLOSE CURSOR
RET_CODE=0
00000041 07:00:05.306814 ISK0900Ø 02499 START OPEN CURSOR
00000042 07:00:05.306822 ISK0900Ø 02499 END OPEN CURSOR
RET_CODE=0
00000043 07:00:05.306941 ISK0900Ø 02524 START FETCH
00000044 07:00:05.306974 ISK0900Ø 02524 START SCAN (INDX)
SCAN=INDX DBASE=KT33P PGSET=TKT0060 INDEX=KKT0602 TAB
00000045 07:00:05.307068 ISK0900Ø 02524 END FETCH
RET_CODE=0
00000046 07:00:05.307116 ISK0900Ø 02543 START CLOSE CURSOR
00000047 07:00:05.307121 ISK0900Ø 02543 END SCAN (INDX)
SCAN=INDX DTYP=INDX --- STATISTICS FOLLOW ------>
00000048 07:00:05.307127 ISK0900Ø 02543 END CLOSE CURSOR
RET_CODE=0
00000049 07:00:05.307210 ISK0900Ø 02579 START OPEN CURSOR
00000050 07:00:05.307225 ISK0900Ø 02579 END OPEN CURSOR
RET_CODE=0
1 2006/05/19 14:41
PAGE 2
SEQNO TIME PROGRAM STMTÆ EVENT
EVENT_DATA
-------- --------------- -------- ----- --------------------------
-------------------------------------------------------------
00000051 07:00:05.307284 ISK0900Ø 02604 START FETCH
00000052 07:00:05.309521 ISK0900Ø 02604 LOCK ACQUIRE
TYPE=PSET STATE=IS DBASE=PD33P PSET=TPD0110
00000053 07:00:05.309530 ISK0900Ø 02604 LOCK ACQUIRE
TYPE=TABL STATE=IS DBASE=PD33P TABL=S99TPD0110
00000054 07:00:05.309557 ISK0900Ø 02604 START SCAN (INDX)
SCAN=INDX DBASE=PD33P PGSET=TPD0110 INDEX=00D90000 TAB
00000055 07:00:05.317555 ISK0900Ø 02604 END FETCH
RET_CODE=0
00000056 07:00:05.317660 ISK0900Ø 02623 START CLOSE CURSOR
00000057 07:00:05.317666 ISK0900Ø 02623 END SCAN (INDX)
SCAN=INDX DTYP=DATA
SCAN=INDX DTYP=INDX --- STATISTICS FOLLOW ------>
00000058 07:00:05.317670 ISK0900Ø 02623 END CLOSE CURSOR
RET_CODE=0
*** END OF QPRINT REPORT - INCOMPLETE (DATA LINE SIZE > PRINT LINE SIZE)
