Skip to Content
0
Jan 14, 2010 at 03:57 AM

BW System crashed due to DB6_ADM_RUNSTATS, error -911, -1032, --1224

214 Views

Hi Friends,

we are using AIX 5.2 with DB2 8.1 on BW 3.5/640 system.

The below warning is also coming very frequently which is causing system crash sometimes:

1.Function DB6_ADM_RUNSTATS failed for List of Tables . Reason: ADBC

2. Error and Database error -911 at EXE

3. BTC 029 061 SEMABL BYL Database error -1032

4. DIA 003 061 SEJABE BYM SQL error -1224 occurred;

work process in reconnect status

18:58:59 DP Q04 Connection to user

14871 (ITGARO ), terminal 125 (nbw20810 ) lost

19:04:06 BTC 029 061 SEMABL BYL Database error -1032

requires intervention from database administrator

19:04:06 BTC 029 061 SEMABL BY4 Database error -1032 at PRE

access to table SWT_LOGCAT

19:04:06 BTC 029 061 SEMABL BY0 > SQL1032N No start database

manager command was issued.

19:04:06 DIA 012 061 USEDBA BY2 Database error -1032 at CON

19:04:06 DIA 017 061 DEKASO BY2 Database error -1032 at CON

19:04:06 DIA 014 R19 Initialization DB-

Connect Failed, Return Code 000256

19:04:06 DIA 019 061 CHPAPR BYL Database error -1032

requires intervention from database administrator

19:04:46 DIA 003 061 SEJABE BYM SQL error -1224 occurred;

work process in reconnect status

19:04:46 DIA 012 061 USEDBA BYM SQL error -1224 occurred;

work process in reconnect status

19:04:46 DIA 005 061 DKKILA BYM SQL error -1224 occurred;

work process in reconnect status

19:04:46 DIA 015 061 NLBAGR BYM SQL error -1224 occurred;

work process in reconnect status

19:04:46 BTC 030 000 SESYSTADMJOB BY2 Database error -1224 at OPC

19:04:46 BTC 030 000 SESYSTADMJOB BY0 > SQL1224N The database

manager is not able to accept new

19:04:46 BTC 030 000 SESYSTADMJOB BY0 > requests, has terminated

all requests in progress, or has

19:04:46 BTC 030 000 SESYSTADMJOB BY0 > terminated your particular

request due to a problem with you

19:04:46 BTC 030 000 SESYSTADMJOB BY0 > request. SQLSTATE=55032

19:04:46 DIA 017 061 DEKASO BYM SQL error -1224 occurred;

work process in reconnect status

19:04:46 DIA 017 061 DEKASO R38 Error at DB commit, return

code 001024

any idea what can be done to resolve this issue.

Thanks and regards

Regards - Munish