DB2 UDB
version 7.2 fix pack 6

I have got a problem during insert.
the same statement has executed 1030 times , but giving error as describe below. I am deleting the records in a chunksize of 1000 records. total number of records, which are to be delted are 1.2 milion.
out of the appx 1 milion records have already deleted.

-------
----------------------------------------------------------------------------------
carry_on code = Y
Return code from check_time is 0 ... time is ok - continue

Thu 12 Feb 15:03:55 2004
delete from cbs.cc_statement_head a where (a.account_num, a.card_num, a.from_date) in (select b.account_num, b.card_num, b.fr
om_date from cbs.cch_to_delete b where b.id between 1029001 and 1030000)
DB20000I The SQL command completed successfully.

delete from cbs.cch_to_delete where id between 1029001 and 1030000
DB20000I The SQL command completed successfully.

----------------------------------------------------------------------------------
carry_on code = Y
Return code from check_time is 0 ... time is ok - continue

Thu 12 Feb 15:04:04 2004
delete from cbs.cc_statement_head a where (a.account_num, a.card_num, a.from_date) in (select b.account_num, b.card_num, b.fr
om_date from cbs.cch_to_delete b where b.id between 1030001 and 1031000)
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



Thanks
Prakash Gautam

Hi,

I take it from your code you have got a problem with SQL deletes, right?

Could you please pass on the relevant portion of db2diag.log?

What about upgrading to fixpack 11?

Johann

thanks for reply ..

you are absolutely right in saying that this is delete problem.
please find the relavent portion of db2diag.log

2004-02-12-16.39.03.815849 Instance:udb Node:000
PID:15348(db2agent (SYSTEM)) Appid:*LOCAL.udb.040212161111
data_protection sqlpgrsp Probe:50 DatabaseYSTEM

Hi,

I don't see a problem within your db2diag.log.

The question is who or what did the interrupt.

The tool db2dart allows you to check the integrity of a database, and tables. You may want to have a look at it. Are you able to select from the delete target at will?

You should consider upgrading to fixpack 11 now. If this is a case for IBM support, I doubt you will get much aid once they know which fixpack you are on.

Johann

thanks for follow up,
I have the solution of this problem.
the problem was due to querytime out parameter in db2cli.ini file.
Regards
Prakash