Error While Dropping the table

dinesh80 · #1 (**permalink**) 12-14-05, 02:46

HI,
I am getting the following error while running the drop commnd on the DB2 databse.
the command i am firing is

DROP TABLE REFERENCE.HC_TREAT_DIAG;

and the error i am getting is:-

[IBM][CLI Driver][DB2/6000] SQL0969N There is no message text corresponding to SQL error "-20241" in the message file on this workstation. The error was returned from module "SQLRLDRT" with original tokens "REFERENCE.HC_TREAT_DIAG". SQLSTATE=560C2

DROP TABLE REFERENCE.HC_TREAT_DIAG
did not complete successfully.

sathyaram_s · #2 (**permalink**) 12-14-05, 02:57

Google for sql20241

Check your db2diag.log

But mentioning your db2 client and server versions may have helped to guess the problem

Cheers
Sathyaram

przytula · #3 (**permalink**) 12-14-05, 04:21

is it a local or remote table or nickname ?
what target platform ? local platform : aix ?
what about authority - can you select from this table - do you have control authority on this table ?

juliane26 · #4 (**permalink**) 12-14-05, 05:20

SQL20241 in short is 'writing history file entry failed':

So you might have an authorization problem. Platforms and Versions would be good to know as well. Also file system might be full.

Solutions: disable 'dropped table recovery' for the tablespace if you don't care