Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

AS/400 DataServer

SYMPTOM(s):

Error 4600 modifying an AS/400 database.

Lock table overflow. Use the CRTPROLKT command for <database-name>. (4600)

CAUSE:

This error may appear when using the Progress Lock Table and the limit of locks is reached. This table can be created automatically when creating the schema with DUPPRODB if *YES to the "Create Progress Lock Table" parameter is specified, or it can be created manually afterwards with the CRTPROLKT command. The default value for the Progress Lock Table is 500.

FIX:

There are two alternatives to avoid this error:

1) Not using the Progress Lock Table and let the DataServer work with
the standard DB2/400 locks. See in chapter 2.3.2 "Record Locking"
of the Progress/400 DataServer Guide a discussion about the
Progress Lock Table.

2) Increasing the lock table. To do that you have to execute the
CRTPROLKT command. See also chapter 2.3.2 in the Progress/400
DataServer Guide.

The description of 4600 error message cites the PROCRTLKT command because this is how the command was called in the Progress/400 DataServer version 6. For DataServer version 7 and later the command is called CRTPROLKT.

The syntax of this command is

CRTPROLKT PRODCT(library-name) NUMLCK(number)

where number is the number of locks wanted in the table.

The Lock Table is contained in a *USRSPC called PROLKT. Removing this object you remove the Progress Lock Table and you will use the standard DB2/400 locks.