Originally posted by spincema
My DB2 version is 7.2.6 on Aix 5.1
I can't select any data on a tablespace wich is created with automatics parameters "USERSPACE1"
I'm beginer in DB2, Could you help me to solve this problem.
Visit the new-look IDUG Website , register to gain access to the excellent content.
This is the return of the command (in french, sorry) when all my tablespaces are availables.
I would like to precise that the problem is the same if i create the tablespace with the "system management" or a "manual management".
In the case i create my tablespace with "manual management" i give a space of 40Mo for the contener. The tablespace contains 10 tables with no more than 30 records. But i always have this problem.
Someone of my company told me that the problem could come from the number of transaction on the table of the tablespace. It's true that we are in a development phasis but i don't think that 1000 transactions per day can't be managed. Do i have to reorganise the tablespace each nigth, and how to do ?
Thank you very much for your help.
Espaces table pour base de données en cours
All the tablespaces listed above are in a normal state. However, none of them seem to have the name userspace1 which is the one the post seems to be about. Also, tablespace access not allowed is not about the tablespace running out of space - it is about the state of the tablespace. How is the table in question loaded? Are the users using autoloader? If so ensure that the non-recoverable parameter is used - this will ensure that the tablespace is not in a backup pending state. The other thing that occurs to mind is that someone loaded one of the tables in the tablespace, the load failed or stalled and left the table in quiesced exclusive state. One way to test out which one it is is by the list tablespaces command. Another way is to issues a select against one of the tables - if you continue to get the error then the tablespace was quiesced - if you can access data with a select statement but cannot load/insert data, then the tablespace is in backup pending.
Thank you for your explanations but i've got no skills in DB2 for the moment and i don't know the commands wich allow me to know if my database is recoverable or not.
Our users don't use autoloader
I think that my tablespace locks the table in quiesced exclusive state because i can't select any data on it. In that case what to do to in order to make the table un-quiesced.
Thank you very much for your advises and explanations.
If you do not know who quiesced the tablespace, it will be difficult to release the lock. It depends on how important it is. If you require recoverability, issue a db2dart. If it is ok to loose the data and you have the ddl for bot table and tablespace, drop the tablespace, recreate it and create the table again.