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