467,113 Members | 1,318 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

DB2 ver 7.1 Processing was cancelled due to an interrupt


I feel I am going nuts trying to figure out something and get into other problems.
I have a DB2 UDB Enterprise Edition version 7.1. I recently upgraded to FixPack 14.
I try to update a column for a table, but it doesn't happen anything.
I used the following command in the Command Center:

And sometimes the result says:
------------------------------ Command Entered ------------------
and nothing else.
When I try to see the content of the table, I type a simple command:
and the table shows the column TEST with the old values. Nothing changed.

Sometimes for either the UPDATE or the SELECT command, I get this 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:
SQL0952N Processing was cancelled due to an interrupt. SQLSTATE=57014
SQL0952N Processing was cancelled due to an interrupt.

(For example when I have this error for the SELECT command, and I try to press CTRL + ENTER the second time to execute the command, it will show the results. But still the UPDATE command doesn't change anything)

Does it mean that it is something wrong with my DB2 installation?

Best Regards,
Jul 17 '07 #1
  • viewed: 5760
3 Replies
Looks like you are using DB2 Command editor. Instead try using db2clp.
To Invoke db2clp type db2cmd in the Run window or on the command line.
Aug 17 '07 #2

Is it better to use the db2clp? In the Command Editor is easier to change the commands. Editing is more user friendly. Is it not supposed to have the same result?

Aug 21 '07 #3
I trust db2clp more. GUI features from IBM are not worth talking about. They are painfully slow.
I know why people dont like the command line. An easier way out is to use the option db2 -t to get into the db2 environment (This enables ; as sql command terminator, so you can write multiline sql queries. Remember to end yr queries with a ; semicolon).
Write and edit you queries in a notepad, copy and paste to the db2clp to run the command.
Its definitely better than 'Command Editor'.

Aug 21 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by bvermeersch@gmail.com | last post: by
1 post views Thread by mailpitches@email.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.