Mysterious error

[Burkhard Schultheis]

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
--
Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: sc********@tde-online.de
Phone: [phone]

[Knut Stolze]

Burkhard Schultheis wrote:

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)

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.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Ian]

Burkhard Schultheis wrote:

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

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.

[Burkhard Schultheis]

Burkhard Schultheis schrieb:

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)

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

Regards,
--
Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: sc********@tde-online.de
Phone: [phone]

[Serge Rielau]

Burkhard Schultheis wrote:

Burkhard Schultheis schrieb:

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)

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

Regards,

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

Gruss
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Burkhard Schultheis]

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,
--
Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: sc********@tde-online.de
Phone: [phone]