There can be a situation where you come across DB2 error SQL0290N and you are not allowed to access your tables. As many important data are being stored in table and losing it can give a great panic to anyone. But actually there is nothing to worry about as you can easily gain access to tables with simple solutions.
Process tried to access a table space which is an invalid state for which intended access is not permitted. If the tablespace is in inactive state, only processes which as well hold the table space in a quiesced state are permitted access to the table space. But if the tablespace is in any other state then only the process which is performing the specified actions are permitted to be access the table space.
It is not allowed to drop system or user temporary table space which have active system or declared temporary tables. And to set the container list the SET CONTAINER api cannot be used unless the table space is in a "restore pending" state.
So to fix the problem you can try taking possible actions such as: Try making an effort to acquire a q uiesced share or quiesced update state on the table space if the table space is in quiesced state. Otherwise try attempting to quiesce reset the table space. If you find that tablespace is in any other state then try waiting until tablespace returns to normal state.
If after the above methods you are still unable to gain access to tables then the last option for you is to try DB2 database repair tool. Software is easy to use and it will repair your DB2 database efficiently. So, just try out this application if you are unable to gain access with the above process.