Return Code 31 - KEY LENGTH INCONSISTENCY

Reason:

An Index Area (IXX) update is required for the key to be processed.

Action:

See the following internal return code for details.

Return Code 31 Internal Return Codes

Dec	Hex	M	B	Explanation	User Response
058	3A	Y	Y	The Index Area has not been updated to reflect a length change for the key to be processed.	Use the following procedure to update the Index Area: Execute either the ACCESS console command or DBUTLTY function ACCESS OFF (and, if optimized, COMM CLOSE) to disable the database containing the key ID to be removed. Verify that there are no active jobs by using the information provided in message DB00607I. If there are active jobs remaining, repeat steps 1 and 2. Execute the REMOVE AREA=IXX for the indicated database ID and key ID. (Initializing the Index Area with the INIT function is the recommended alternative only when the database contains a single area with fewer than 100,000 records.) Execute the RETIX function for the database area to be rebuilt. (Executing the LOAD function for this area is an acceptable alternative.) Execute either the ACCESS MAINT, ACCESS WRITE, or ACCESS READ console command or the DBUTLTY function ACCESS STATUS=MAINT, ACCESS STATUS=WRITE, or ACCESS STATUS=READ to reenable the previously disabled database.

Dec

Hex

Explanation

User Response

058

The Index Area has not been
updated to reflect a length change
for the key to be processed.

Use the following procedure to update the Index Area:

Execute either the ACCESS console command or DBUTLTY function ACCESS OFF (and, if optimized, COMM CLOSE) to disable the database containing the key ID to be removed.
Verify that there are no active jobs by using the information provided in message DB00607I. If there are active jobs remaining, repeat steps 1 and 2.
Execute the REMOVE AREA=IXX for the indicated database ID and key ID. (Initializing the Index Area with the INIT function is the recommended alternative only when the database contains a single area with fewer than 100,000 records.)
Execute the RETIX function for the database area to be rebuilt. (Executing the LOAD function for this area is an acceptable alternative.)
Execute either the ACCESS MAINT, ACCESS WRITE, or ACCESS READ console command or the DBUTLTY function ACCESS STATUS=MAINT, ACCESS STATUS=WRITE, or ACCESS STATUS=READ to reenable the previously disabled database.