Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2012
    Posts
    3

    Red face Unanswered: A particular record is not deleted & ddl opearion allowed

    I am trying to delete one record table table, but not able to delete. It seems that operation is hanged and after waiting a long time, record does not deleted not an even any error raised. I am able to delete other rows as well but problem is with one single record.

    If do any DDL operation the same thing happened.

    I Checked table is in normal state and no FK- constraints & Check constraints exist for this.

    Please help me to resolve my issue.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What DB2 version and OS? What statement are you executing? What is the DDL for the table and its indexes? How many rows are in the table?


    Andy

  3. #3
    Join Date
    Mar 2003
    Posts
    280
    Quote Originally Posted by hemantkumar View Post
    I am trying to delete one record table table, but not able to delete. It seems that operation is hanged and after waiting a long time, record does not deleted not an even any error raised. I am able to delete other rows as well but problem is with one single record.

    If do any DDL operation the same thing happened.

    I Checked table is in normal state and no FK- constraints & Check constraints exist for this.

    Please help me to resolve my issue.
    What is the locktimeout?

  4. #4
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    not able to delete

    Post the platform details. You are making exclusive connection or some other parallel connections are there.

    Post db2diag output.

    cheers

  5. #5
    Join Date
    Mar 2012
    Posts
    3
    I am using DB2 9.7 and Solaris x86, There are only 30 rows, problem is with only one row. There is not any exclusive lock and no other application or user using this table.
    Last edited by hemantkumar; 09-26-13 at 11:25.

Tags for this Thread

Posting Permissions

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