Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Exclamation Unanswered: solutions to error sql0291n, sqlstate: 55039

    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

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Moving to DB2 forum.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •