473,320 Members | 1,990 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DB2 ver 7.1 Processing was cancelled due to an interrupt

8
Hi,

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:
UPDATE USER.T2 SET TEST = 'A'

And sometimes the result says:
------------------------------ Command Entered ------------------
UPDATE USER.T2 SET TEST = 'A'
-----------------------------------------------------------------------------
and nothing else.
When I try to see the content of the table, I type a simple command:
SELECT * FROM USER.T2
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,
Steven
Jul 17 '07 #1
3 6235
Jal
10
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
nstefi
8
Hi,

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?

Steven
Aug 21 '07 #3
Jal
10
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'.

Jalaj
Aug 21 '07 #4

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

Similar topics

0
by: Laura Arbilla | last post by:
We are running Postgres 7.3 on a Debian Linux system. Our python web application uses psycopg to talk to the Postgres server. Our problem is that our queries can be on millions of records of data...
5
by: Oleg Berfirer | last post by:
I'm running a resource-intensive stored procedure, which reads a file with about 50,000 lines with a BULK INSERT into a temp table, then goes through it and inserts a record for each line into...
5
by: Bill Henning | last post by:
Does anyone know a good method of preventing keyboard and mouse events from interrupting processing? My situation is: 1) I need to track and handle all key and mouse events 2) I need to perform...
2
by: bvermeersch | last post by:
Hi, Here I am again, just learning C# and always wanting to learn the hard things first. As you might already know from other posts I'm trying to convert c++ code to C#. The problem I'm...
1
by: JM | last post by:
i have an aspx page that imports 15k records from ms access into sql server. the page is running pretty slow, so i have to reevaulate the code. I tested the page, while is was processing, i hit the...
6
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...
1
by: mailpitches | last post by:
X-No-Archive: yes a function, the return value of the function is a boolean. What does this boolean value mean? Example: <body onload="document.getElementById('field').onkeydown=function(x) {...
0
by: koredump | last post by:
Hi all, I have a windows app that makes some asyc calls to my webservice (WSE 3.0 with MTOM). exception gets thrown in the client win app. I know this exception is caused on the async...
5
by: AMBLY | last post by:
Hi everyone! Could someone help me with this, please? I run Access2000 on XP Have created a Report. Have placed a button on a form to email the report Works fine - email is generated, ready...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.