Hi,

The db cfg file for my database was somthing like:
Log retain for recovery status =RECOVERY
User exit for logging status = NO
Log retain for recovery enabled (LOGRETAIN) = RECOVERY

after, I used command: db2 update db cfg for smeal using logretain off, the db cfg file become:
Log retain for recovery status =NO
User exit for logging status = NO
Log retain for recovery enabled (LOGRETAIN) = RECOVERY

Now, in order to be able to backup tablespace, I want to recover db cfg file to the original one as:
Log retain for recovery status =RECOVERY

by issuing command: update db cfg using log_retain_status recovery

I received the following error:
SQL0104N An unexpected token "log_retain_status" was found following "USING".
Expected tokens may include: "ADSM_MGMTCLASS". SQLSTATE=42601

Does, anyone can tell me what's the update db command to change logretain for recovery status? and how to make tablespace backup available?

Thanks!
Lan

I think you meant to use
db2 update db cfg for smeal using logretain recovery