Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2011
    Posts
    3

    Unanswered: Db2 v7.1 instance crash.

    Hi There,

    I dont have good notices
    The DB2 v7.1 AIX have two instance db2inst1 and db2inst2.
    The db2inst2 instance start with error 0000 0011 and it not possible connect the database.
    I run the db2dart tool and some erros appear.
    About error details I attached the error log files.

    Some Questions:

    1. Is possible to execute the db2start command with some force parameter?

    2. The last backup failed and I believe that the datafiles are good state. Is possible to create a new instance and to use the db2inst2 datafiles? If it possible, How I do?

    3. In this scenario how I get the tablespace and object ID?

    Thanks Advanced
    Attached Files Attached Files
    Last edited by ifortunato; 06-20-11 at 15:14.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by ifortunato View Post
    2. The last backup failed and I believe that the datafiles are good state. Is possible to create a new instance and to use the db2inst2 datafiles? If it possible, How I do?

    3. In this scenario how I get the tablespace and object ID?

    According to the DB2DART report, some catalog objects are damaged. I'm not sure if trying to open this database under another instance will help.

    There is no supported way of opening a database under a different instance. I know some people managed to do that but cannot provide much detail. At the minimum you will need to create an instance with the same name, move the entire hierarchy of DB2 files to the same location on the new server (making sure the file and directory ownership and permissions remain the same), then try to catalog the relocated database. There's little chance that this will work though.

    Tablespace and object IDs can be found in the DB2DART report.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    I doubt you will be able to connect to this db. You need to find a good backup image you can restore from or check if you can recreate the db from some other source. If not, you can try db2dart with ddel option to unload the data.

  4. #4
    Join Date
    Jun 2011
    Posts
    3
    Thanks for all reply.

    BELLO4KA,

    The instance process start but when We execute connect do dbdesaix the command fail with several erros:


    Crash Recovery is needed.

    2011-06-20-11.58.07.350873 Instance:db2inst1 Node:000
    PID:26850(db2agent (DBDESAIX)) Appid:*LOCAL.db2inst1.110620142343
    recovery_manager sqlpresr Probe:1 DatabaseB2DES
    DIA3908W Crash recovery has been initiated. Lowtran LSN is "003E36C2000C",
    Minbuff LSN is "003E36C2000C".

    2011-06-20-11.58.07.538916 Instance:db2inst1 Node:000
    PID:26850(db2agent (DBDESAIX)) Appid:*LOCAL.db2inst1.110620142343
    lob_manager sqldxDirectReadAllocMap Probe:15 DatabaseB2DES
    DIA3823C A memory error has occurred.

    ZRC=FFFFF867

    2011-06-20-11.58.07.667254 Instance:db2inst1 Node:000
    PID:26850(db2agent (DBDESAIX)) Appid:*LOCAL.db2inst1.110620142343
    lob_manager sqldxDirectReadAllocMap Probe:15 DatabaseB2DES

    ---cut----

    n_i, Can I force the DB2 start with catalog corrupted?
    Is there is any command for it?

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    You cannot bypass crash recovery without getting help from IBM, but you're on v7 which has been out of support for a very long time.

Posting Permissions

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