db2_error

[former_member186895]

Hi experts,

                 I am using db2 database for sap on windows 2008 due to some database error all workprocess are getting terminated.

                 And my prd system is not getting started.

                 when i am running command "r3trans -d" getting rc error =12.

                 And when trying to connect with database with command "connect to prd" getting below error

"SQL1224N  The database manager is not able to accept new requests, has

terminated all requests in progress, or has terminated the specified request

because of an error or a forced interrupt.  SQLSTATE=55032"

please help with some solution

Thanks in advance

Ramesh yadav

[former_member185239]

Hi Ramesh,

1. stop the db2

2. start the db2

3. then check the db2diag.log

Also check the log_archive directory and paste the content of db2diag.log

With Regards

Ashutosh Chaturvedi

+919818619396

[Former Member]

Hi,

Please attach db2diag.log and apart from this R3trans log also.

Rableen

[Sriram2009]

Hi Ramesh

Could you check this SAP KBA

1218513 - Error: "...A database agent could not be startd to service a request,..."

1306835 - Error: (WIS 10901) while refreshing Web Intelligence report first time

1594631 - DB2 V9.7 FP3SAP on Linux X86 with federated database

Regards

Sriram

[former_member186895]

Thanks for reply but that is applicable for AIX O.S.

And i am using windows o.s

[Sriram2009]

Hi Ramesh

Check this IBM links -

IBM IC84352: DB2 ABEND ON DROP TABLESPACE COMMAND - United States

IBM IC81307: DB2 ABEND ON DROP TABLESPACE COMMAND - United States

Regards

Sriram