467,882 Members | 1,238 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,882 developers. It's quick & easy.

Error while running sdl scripts

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
  • viewed: 1589
Share:
1 Reply
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.

Similar topics

1 post views Thread by Wayno | last post: by
9 posts views Thread by Mairhtin O'Feannag | last post: by
17 posts views Thread by JStemper | last post: by
13 posts views Thread by Shawn | last post: by
6 posts views Thread by Ben Allen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.