Mysterious error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Burkhard Schultheis - 28 Nov 2005 14:34 GMT

A select count (*) from table shows
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

A select * from table shows, there is no data in the table.

Some tables shows the same behavior, others are OK.

Where can I look to determine the reason?

It's DB2 V8.2.3 on Linux with kernel 2.6 (SuSE 10.0)

Regards

Signature

Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: schultheis@tde-online.de
Phone: +49 7245 9287-21

Reply to this Message

Knut Stolze - 28 Nov 2005 15:39 GMT

> A select count (*) from table shows
> SQL1224N A database agent could not be started to service a request, or
[quoted text clipped - 8 lines]
>
> It's DB2 V8.2.3 on Linux with kernel 2.6 (SuSE 10.0)

That looks like a trap in the db2agent. Are there any trap files (t*.*) in
the sqllib/db2dump/ directory? If yes, then you should probably contact
IBM support to get the issue resolved.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Ian - 29 Nov 2005 03:48 GMT

> A select count (*) from table shows
> SQL1224N A database agent could not be started to service a request, or
[quoted text clipped - 10 lines]
>
> Regards

Is it possible that something is forcing your connection off of the
database? This is the normal error you receive if a DBA (or perhaps
the DB2 governor) has forced your connection.

Reply to this Message

Burkhard Schultheis - 29 Nov 2005 10:30 GMT

Burkhard Schultheis schrieb:

Thank you for your help. It was an error with our installation.

Regards,

Signature

Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: schultheis@tde-online.de
Phone: +49 7245 9287-21

Reply to this Message

Serge Rielau - 29 Nov 2005 11:56 GMT

> Burkhard Schultheis schrieb:
>
[quoted text clipped - 14 lines]
>
> Regards,

Warum so wortkarg? Any lessons learned for the communal wisdom?

Gruss
Serge

Signature

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Reply to this Message

Burkhard Schultheis - 29 Nov 2005 15:21 GMT

Serge Rielau schrieb:

> Warum so wortkarg? Any lessons learned for the communal wisdom?

OK. We use hot standby servers. If the second server joins the other, it
copies all database files and then all log files and starts DB2. The
problem was, that we had 2 different locations for one table space. Now
we had old files for this table space. ;-)

Grüße,

Signature

Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: schultheis@tde-online.de
Phone: +49 7245 9287-21

Reply to this Message