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)