Error: SQL0290N Table space access is not allowed

DB2 Error: SQL0290N

Description :Table space access is not allowed.

Explanation:

A process attempted to access a table space which is in an invalid state for which the intended access is not allowed.

• If the table space is in a quiesced state, only processes which also hold the table space in a quiesced state are allowed access to the table space.
• If the table space is in any other state, only the process which is performing the action specified is allowed access to the table space.
• A system or user temporary table space cannot be dropped which contains active system or declared temporary tables.
• The SET CONTAINER api cannot be used to set the container list unless the table space is in a "restore pending" state.

Solution:

Possible actions include:

• If the table space is in a quiesced state, attempt to acquire a quiesced share or quiesced update state on the table space. Or, attempt to quiesce reset the table space.
• If the table space is in any other state, wait until the table space has returned to normal state before attempting to access the table space.

Related Posts

1. Error: SQL0284N The table was not created
2. Weblogic Administration Error : Heap Space Utilization too high
3. Troubleshooting Error “The process cannot access the file because it is being used by another process”
4. Error: SQL1245N Connection Limit Reached
5. Error: SQL1762N Unable to connect to database

Tags: DB2 Error Codes, Tablespace Access Error, Tablespace Error