This just showed up today and this program was working until this morning.
Has anyone seen this type of lock issue using sql:
5770SS1 V7R1M0 100423 07/20/18 09:20:07 SQL SERVICE DUMP SCHRISBA/CHRISB/113429
OP TREE LOCKED BY JOB
STARTING ADDRESS <80000000 00000000 F4AE4817 E702B960> LENGTH <0000 001C>
0000 0000 <F1F1F1F5 F3F361D2 D4C3D3D6 E4C7C861> <D6D7D7C3 F0F3F4F5 40404040 > <111533/KMCLOUGH/OPPC0345 >
5770SS1 V7R1M0 100423 07/20/18 09:20:07 SQL SERVICE DUMP SCHRISBA /CHRISB /113429 PAGE
THREADID
STARTING ADDRESS <80000000 00000000 F4AE4817 E702BBF8> LENGTH <0000 0008>
0000 0000 <00000000 00000117 > < >
Job that I am running is the schrisb/chrisb/113429 and is reporting the OP TREE locked by job 111533/kmclough/oppc0345 a second interactive job.
What is OP TREE and where do I look for these locks. It is happening at an SQL statement to read a file that only has a SHRRD lock.
Chris Bipes
Director of Information Services
CrossCheck, Inc.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
