Issue in DB2
Posted: 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.
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.