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.
Issue in DB2
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 40
- Joined: Mon May 11, 2009 12:19 am
- Location: Madurai