Getting the message "Table in use" when trying to edit a CA OPS/MVS RDF table.

Document ID : KB000025900
Last Modified Date : 14/02/2018
Show Technical Document Details



When trying to update one RDF tables, as STCTBL for example, the following error message can occur:

TABLE IN USE userid ON system HOLDS THE ENQ ON TABLE system>STCTBL                          


An unexpected termination of an user may leave an enqueue of a table in the held state.


If an OPSMVS SSM table is ENQUEUED or hung you can try one of the following methods to free it

Access the following panels via the OPSVIEW Primary Options Menu:

1) Using panel 2.6:
Type F at table name that is hung to free it.

2) From an ADDRESS TSO environment:

OI ASOTEAPI FREE TABLE(table_name) {USER(system>userid)}

If the methods above do not work, then perform the following...

3) Using panel 4.8

- Use GLVTEMP# being # 0 or 1 in the "Global Prefix" field

- Then find the userid that is holding the table, type D to free it.

Additional Information:

CA OPS/MVS - Use Edit Option Commands

CA OPS/MVS - Relational Table Editor Batch API Functions