Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    UK
    Posts
    11

    Exclamation Unanswered: problem during import

    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

  2. #2
    Join Date
    Apr 2003
    Posts
    191

    Re: problem during import

    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

    Originally posted by prakash56
    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

  3. #3
    Join Date
    Jan 2004
    Location
    UK
    Posts
    11

    Re: problem during import

    Originally posted by jsander
    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

  4. #4
    Join Date
    Apr 2003
    Posts
    191

    Re: problem during import

    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

    Originally posted by prakash56
    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

  5. #5
    Join Date
    Jan 2004
    Location
    UK
    Posts
    11

    Re: problem during import

    Originally posted by prakash56
    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

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •