Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2016
    Posts
    3

    Answered: Backup db2 v11 error SQL1597N

    Hello.

    Please help. Here is my problem.

    Server: OS CentOS 7 x64
    DB: db2 v11.1 database createt db_name One.

    I am trying to make a online backup.

    My actions.

    create directory 'mkdir -p /home/db2inst1/backup/ArchiveDest'
    chown db2inst:db2iadm1 backup/ArchiveDest.


    db2 get db cfg for one | grep LOGARCH

    First log archive method (LOGARCHMETH1) = OFF
    Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF
    Options for logarchmeth1 (LOGARCHOPT1) =
    Second log archive method (LOGARCHMETH2) = OFF
    Archive compression for logarchmeth2 (LOGARCHCOMPR2) = OFF
    Options for logarchmeth2 (LOGARCHOPT2) =

    update parameter
    db2 update database configuration for one using LOGARCHMETH1 'DISK:/home/db2inst1/backup/ArchiveDest'

    obline backup
    db2 backup database one online to /home/db2inst1/onlinebackup/ compress include logs

    error
    SQL2413N Online backup is not allowed because the database is not recoverable or a backup pending condition is in effect.

    On the Internet, I found the council
    db2 update db cfg for MYDB using logretain RECOVERY
    error
    SQL1597N Configuring the DB2 environment failed because the specified DB2
    configuration parameter is discontinued.

    What am I doing wrong

  2. Best Answer
    Posted by mark.bb

    "Hi,

    You have to take an offline (not online) backup after switching to archive logging."


  3. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    112
    Provided Answers: 13
    Hi,

    You have to take an offline (not online) backup after switching to archive logging.

  4. #3
    Join Date
    Aug 2016
    Posts
    3
    Thank you.
    You really helped.

Tags for this Thread

Posting Permissions

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