DB2 Rollforward DB query status

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jadionne@gmail.com
    #1

    DB2 Rollforward DB query status

    I am doing a rollforward and want to query the status of the
    rollforward. I issue the command: DB2 Rollforward database namdwh
    query status.
    I get the following error:
    C:\Documents and Settings\webi>d b2 rollforward database namdwh query
    status
    SQL1035N The database is currently in use. SQLSTATE=57019

    I know its in use...I am the one using it. How do I get around this?

    Tags: None
    • Norbert Munkel
      #2
      Re: DB2 Rollforward DB query status

      Hi,

      jadionne@gmail. com schrieb:[color=blue]
      > I am doing a rollforward and want to query the status of the
      > rollforward. I issue the command: DB2 Rollforward database namdwh
      > query status.
      > I get the following error:
      > C:\Documents and Settings\webi>d b2 rollforward database namdwh query
      > status
      > SQL1035N The database is currently in use. SQLSTATE=57019
      >
      > I know its in use...I am the one using it. How do I get around this?[/color]

      "query status" does not work while the database is rolling forward. The
      SQL1035N results from an ongoing rollforward operation.

      "db2 list utilities show detail" and db2diag.log should tell you a
      little bit more about the current rollforward state.

      regards,

      Norbert

        Comment

        • jadionne@gmail.com
          #3
          Re: DB2 Rollforward DB query status

          Thanks for the fast reply!! This helped greatly.

            Comment

            • jdokos
              #4
              Re: DB2 Rollforward DB query status

              You can also use 'db2pd -db dbname -recovery' if you are on 8.2

                Comment

                Previous template Next
                Working...