Hi all,
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?
any ideas?
let me know
thanks,
fnana

Moving to DB2 forum.

pootle flump ur codings are working excelent.

SQL0291:

SQL0291N State transition not allowed on table space.

Explanation:

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.

User Response:

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
space states.

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.

Andy