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

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.

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.

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?

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.