Return Code 46 - TABLE ALREADY OPEN FOR UPDATE

CA Datacom/DB Return Codes › Return Codes › Return Code 46 - TABLE ALREADY OPEN FOR UPDATE

Return Code 46 - TABLE ALREADY OPEN FOR UPDATE

Reason:

The attempt to open a table for update can fail because DBUTLTY or a program operating in another Multi-User Facility region is currently updating a table in the database in which this table resides. Also, the error can be caused by the Multi-User Facility attempt to open the Compound Boolean Selection Facility index for update when the index has been opened by another Multi-User Facility.

Action:

Determine the name of the program which is updating this database. If it is a legitimate job, allow it to finish before reissuing the OPEN command. If the job was canceled or has abended, execute the DBUTLTY RESET AREA=CXX, DBID=nnnn, where nnnn identifies the database containing the table to be updated. Upon successful completion of the RESET function, repeat the attempt to open the table for update.

If the Compound Boolean Selection Facility index is causing the error, and the index was not opened by another Multi-User Facility, execute the DBUTLTY RESET AREA=CXX, DBID=nnnn, where nnnn identifies the database specified by the MUF startup option parameter CBS. Upon successful completion of the RESET function, repeat the attempt to open the table for update.

Note: Before attempting to CATALOG the Compound Boolean Selection Facility database, you must comment out the MUF startup option CBS and restart the Multi-User Facility.

Caution Never execute the RESET function while any CA Datacom/DB job is active against the database in question.

See the following internal return codes for details.

Return Code 46 Internal Return Codes

Dec	Hex	M	B	Explanation	User Response
001	01	N	N	You attempted to use the DBUTLTY COMM CLOSE function to close one or more bases that had a User Requirements Table(s) open.	Close the open User Requirements Table(s) and execute the CLOSE function again.
002	02	N	N	UTILITY OPEN CONFLICT For the REPLACE function of the CA Datacom/DB Utility (DBUTLTY), the table to be replaced is currently open by another application.	Wait for all other applications to close the table before attempting to replace the data.
046	2E	Y	N	You attempted to open a table for update in more than one partition. Or, a transaction requiring the maintenance of the Directory (CXX) (such as CREATE TABLE or CATALOG) is being done in an update-eligible Multi-User Facility for a database while a read-only Multi-User Facility has the same database open and the CXX is shared between the two Multi-User Facilities.	Wait for the job which has the table open to complete and then run the other job or transaction.
128	80	Y	N	You attempted to drop a table which is currently open. If you are running in a MUFplex environment, the table could be open on another Multi-User Facility.	Wait for the job which has the table open to complete.