Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    36

    Unanswered: update db cfg command help

    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

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    I think you meant to use
    db2 update db cfg for smeal using logretain recovery
    mota

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •