What is the reason code when NUMLKTS is reached

King C. Au

What is the reason code when NUMLKTS is reached
DB2 reason code 00C90096 is issued when NUMLKUS is reached. Can some experts tell me what is the DB2 reason code when NUMLKTS is reached.

Thanks.

King

The Gap, Inc.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Cathy Taddei

Re: What is the reason code when NUMLKTS is reached
(in response to King C. Au)
It's kind of a slow week here, so I'll take a stab at this. According
to the V7 (z/OS) Diagnosis Guide and Reference:

"NUMLKTS controls the maximum number of page or row locks in a single
table space or table before lock escalation occurs."

So, I would guess that there is no reason code given unless lock
escalation fails. If it fails to obtain the next higher lock, I imagine
the return code would be 00C9008E, a timeout.

Regards,
Cathy Taddei

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of King Au
Sent: Tuesday, December 21, 2004 4:20 PM
To: [login to unmask email]
Subject: What is the reason code when NUMLKTS is reached

DB2 reason code 00C90096 is issued when NUMLKUS is reached. Can some
experts tell me what is the DB2 reason code when NUMLKTS is reached.

Thanks.

King

The Gap, Inc.

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else, unless expressly approved by the sender or an authorized addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution or any action omitted or taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender, delete this e-mail and destroy all copies.

======

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm