Database error SQL1224N for the trx DB02

[Former Member]

Hi All,

When we excute the transaction DB02 we obtain the following DUMP

DBIF_DSQL2_SQL_ERROR:

============================================================

Database error text........: "[IBM][CLI Driver] SQL1224N A database

agent could

not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032#"

Triggering SQL statement...: "FETCH NEXT "

Internal call code.........: "[DBDS/NEW DSQL]"

============================================================

WE are on DB2 V 8.1 (put level 0709), z/os 1.8, AIX 5.3.5 and

DB2Connect V8.1 FixPak 15.

We have truncated and recreated the SYSIBM.TABLESPACESTATS and

SYSIBM.INDEXSPACESTATS in tablespace DSNRTSDB.DSNRTSTS (Real Time

Statistics). Now the db02 works fine.

Why is happened that?

Regards,

Bob

[thomas_vogt]

Hello,

SQL1224N is a subsequent error of a problem on DB2 server side. You should check DB2 MSTR AS for any errors and run software EREP to get more details on the possible abend in DB2.

Regards,

Thomas