Thanks for the suggestion. Yes, this option was set. I think that the problem lies with the syntax we are trying to use. If anyone has a syntax example that works, I'd be grateful...
Thanks in advance, Judy -----Original Message----- From: Iqbal Goralwalla [mailto:[EMAIL PROTECTED] Sent: 27 January 2004 14:23 To: 'Wise Ltd'; [EMAIL PROTECTED] Subject: RE: [DB2EUG] Recover dropped table problem Judy, Is the tablespace where the dropped table resided enabled to recover dropped tables? That is, has it been defined with the DROPPED TABLE RECOVERY ON option? If not, you can use the ALTER TABLESPACE command to turn it on and try the rollforward again ... Iqbal Iqbal Goralwalla, Ph.D. Principal Consultant Triton Consulting - The Database Experts We are having a problem executing the following statement when trying to recover a dropped table: db2 "rollforward db <db-name> to end of logs recover dropped table <table-id> to <export-directory>" This error message is returned: SQL4904N The pointer to parameter "droppedTblID" of function "roll forward" is not valid. which would suggest that the wrong <table-id> is being used. We obtained the <table-id> by issuing the following: db2 "list history dropped table all for db <db-name>" Does anyone have any suggestions? Thanks, Judy Porter-Wise - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
