RE: Job holds large number of locks (CPI1466)

Chuck,

Do you have client apps using ODBC?  It may be they aren't performing a
commit frequently enough.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chuck Lewis
Sent: Wednesday, February 25, 2004 4:55 AM
To: midrange-l
Subject: Job holds large number of locks (CPI1466)


Hi folks,

 

For the last 3 days (and never before according to a scan of QHST) we
have
been getting:

 

CPI1466 - Job holds large number of locks                       

 

And the verbiage goes "The job 529586/CHUCK/RBBU001C has 30000 locks.
30000
is a suspiciously large number of locks, and it indicates that an
application may be leaving locks behind."

 

The # of locks is the same each time. This is our nightly backup and
QINTER
is down and no other jobs are running.

 

Checking in QHST shows that our biggest library by far had 1 object not
saved (a journal receiver) and it also shows a library not saved (it was
one
specified in the CL but it no longer exists).

 

Could the 1 object not saved cause this ?

 

Thanks !

 

Chuck                                                     

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.