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 E-mail: [EMAIL PROTECTED] Web: http://www.triton.co.uk Mobile: +44 (0)7919 013065 Office Tel: +44 (0)870 2411550 Office Fax:+44 (0)870 2411549 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wise Ltd Sent: 27 January 2004 10:29 To: [EMAIL PROTECTED] Subject: [DB2EUG] Recover dropped table problem 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 - ::: 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
