Unanswered: solutions to error sql0291n, sqlstate: 55039
I backed up my database successfully,am currently running db2 v7.1 on windows platform
then when trying to run my actuate reports I get the above errors.
sql0291n, sqlstate: 55039
how do I solve these errors?
let me know
SQL0291N State transition not allowed on table space.
An attempt was made to change the state of a table space. Either
the new state is not compatible with the current state of the
table space, or an attempt was made to turn off a particular
state and the table space was not in that state.
Table space states change when a backup is taken, the load
completes, the rollforward completes, etc., depending on the
current state of the table spaces. Refer to the systems
administration guide for further information about the table
sqlcode : -291
sqlstate : 55039
This means you have a tablespace in a non-normal state. Issue a "list tablespaces" command to see whaich tablespaces are affected and what state they are in.