By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,310 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

Error while running sdl scripts

P: n/a
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.

Mar 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
<ed*****@gmail.com> a écrit dans le message de news:
11**********************@j33g2000cwa.googlegroups. com...
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.


Mar 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.