DB2 Message Error- Help??? 
Author Message
 DB2 Message Error- Help???

We got this error last night during our backups:

Stopping DB2
DB20000I  The FORCE APPLICATION command completed successfully.
DB21024I  This command is asynchronous and may not be effective
immediately.

02-22-2002 02:01:15     0   0   SQL1064N  DB2STOP processing was
successful.
SQL1064N  DB2STOP processing was successful.
SQL1072C  The database manager resources are in an inconsistent state.
 DB2 may
have been incorrectly terminated, or another application may be using
system res
ources in a way which conflicts with DB2's use of system resources.
System reso
urce cleanup may be required.

To get things working again this was done:

To get things going again,

I ran a DB2 stop,  then checked for db2 processes, there were none.
I checked fo ipcs resources, which there were for the instance id
db2as (used by websphere).
I removed them (ipcrm),  then started db2

My question is, what would cause this to happen in the first place???



Tue, 10 Aug 2004 23:11:21 GMT
 DB2 Message Error- Help???

Suggest you retain any trap/dump files and the db2diag.log, and open up a
PMR with IBM support.

Larry Edelstein

Quote:

> We got this error last night during our backups:

> Stopping DB2
> DB20000I  The FORCE APPLICATION command completed successfully.
> DB21024I  This command is asynchronous and may not be effective
> immediately.

> 02-22-2002 02:01:15     0   0   SQL1064N  DB2STOP processing was
> successful.
> SQL1064N  DB2STOP processing was successful.
> SQL1072C  The database manager resources are in an inconsistent state.
>  DB2 may
> have been incorrectly terminated, or another application may be using
> system res
> ources in a way which conflicts with DB2's use of system resources.
> System reso
> urce cleanup may be required.

> To get things working again this was done:

> To get things going again,

> I ran a DB2 stop,  then checked for db2 processes, there were none.
> I checked fo ipcs resources, which there were for the instance id
> db2as (used by websphere).
> I removed them (ipcrm),  then started db2

> My question is, what would cause this to happen in the first place???



Wed, 11 Aug 2004 04:29:18 GMT
 DB2 Message Error- Help???
as i'm curious, i'd check if there are still indoubt transactions.
(db2 ? list)

PM



Wed, 11 Aug 2004 02:33:49 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Help:Record/Key Deleted message and Error message Numbers

2. Help Help Help Oracle Error Message ORA-01041

3. ** prob retrieving Error message using DAO/ODBC on DB2 or others databases like Oracle

4. How to get error message associated with an SQLSATE from DB2 SP

5. Strange DB2 on AIX error message

6. Strange error message from DB2 control center

7. Received a 7105 Error Message, need help finding object error was on

8. Req: Help needed with error message UNEXPECTED ERROR

9. getting message description using message error code..

10. oninit -i: "Cannot find message file"- Error Messages

11. Read error messages from message-area

12. Help! Error message in SQL Server 6.5


 
Powered by phpBB® Forum Software