Hi there,
I am trying to create a db on db2 and when running the scripts, which
have been successfully ran before, I get the following error:

DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
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

This happens randomly along the script meaning that it happens in
different statemets from run to run.
For some reason DB2 is shutting down complete while running this
scripts.

I am using DB2 Express 8.1 FIXPACK 10 on WXP pro.

Thanks a lot

erick.

I'd go investigate the instance log file: db2diag.log
It should have messages with the timestamp at which you receive your error
messagres.
The db2diag.log is there and one of its reasons is to present messages as to
how the instance behaves.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<edovale@gmail.com> a écrit dans le message de news:
1141831337.368587.143860@j33g2000cwa.googlegroups. com...[color=blue]
> Hi there,
> I am trying to create a db on db2 and when running the scripts, which
> have been successfully ran before, I get the following error:
>
> DB21034E The command was processed as an SQL statement because it was
> not a
> valid Command Line Processor command. During SQL processing it
> returned:
> 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
>
> This happens randomly along the script meaning that it happens in
> different statemets from run to run.
> For some reason DB2 is shutting down complete while running this
> scripts.
>
> I am using DB2 Express 8.1 FIXPACK 10 on WXP pro.
>
> Thanks a lot
>
> erick.
>[/color]