How to query the status of a table in db2?

In DB2, you can use the following SQL statement to query the status of a table:

SELECT TABNAME, STATUS
FROM SYSCAT.TABLES
WHERE TABSCHEMA = 'SchemaName'
   AND TABNAME = 'TableName';

SchemaName refers to the name of the schema where the table is located, and TableName refers to the name of the table.

The table’s status can have a few possible values:

1. N: In normal condition, it can be read and written.
2. R: Read-only mode, only able to access data, unable to write.
3. U: Unavailable state, unable to access the table.
4. The table is currently in use by another process.

By checking the status of the table, you can see the current availability of the table.