Issue in DB2

revanthga · Post by **revanthga** » Thu Feb 10, 2011 1:44 am

Hi guys,

I want to remove records from Db2 table.
I had 20 lakh records in the table.
I had executed "del from table name"
it is not working.
Then i tried to execute
"load from /dev/null of del replace into Schema.tablename nonrecoverable"

now i am unable to open the table when i execute the query i am facing this error "A database manager error occurred. : [IBM][CLI Driver][DB2/AIX64] SQL0668N Operation not allowed for reason code "1" on table "Tablename". SQLSTATE=57016"

any suggestions will be appreciated.

priyadharsini · Post by **priyadharsini** » Thu Feb 10, 2011 2:00 am

There is a high possiblity that load from /dev/null command will lock the table. Contact your DBA to release the lock and try.

revanthga · Post by **revanthga** » Thu Feb 10, 2011 3:04 am

There is a high possiblity that load from /dev/null command will lock the table. Contact your DBA to release the lock and try.

So i want to know whether there will be any other issues.
If this is the only issue then DBA can resolve this issue.
So DBA can resolve this problem.

ppgoml · Post by **ppgoml** » Thu Feb 10, 2011 9:40 am

check if you have reference integrity on that table. if so, your table might be in the Set Integrity Pending No Access state. Ask your DBA to Execute the SET INTEGRITY statement to put the table active.