Sometimes users suffer with problem- The table space will not work properly & receive an error message:
SQL0294N The container is already in use.
This error message occurs at the time of mounting the database which will make the database inaccessible.
Why This error occurs:
There are lots of cause of this issue but generally this error message occurs when user uses ‘DB2untag' command on a container which is being used by the DB2 database. In these circumstances both the database will get corrupted and data will become inaccessible.
To Resolve this issue:
1. Do one of the following:
- If the database previously existed, drop the database using the dropDBs command.
- If the database did not previously exist, continue to Step 2.
- Windows :
- Linux :
To rectify this issue first you need to restore or copy the database backup which is done previously.
If above both solutions fails to resolve this issue then use third party DB2 Recovery Software. DB2 Recovery Software are very easy to use & made for novice user as well as for technical expert.