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

Reply via email to