Results 1 to 5 of 5

Thread: backup pending

  1. #1
    Join Date
    Feb 2004
    Posts
    34

    Unanswered: backup pending

    DB2 version 6.1 UDB
    OS Win NT

    Just yesterday I designed to take online backup and fall into this error.
    How to come out from this error ? Any advice please ?


    SQL1116N A connection to or activation of database "SIEBELDB" cannot be made because of BACKUP PENDING. SQLSTATE=57019

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Probably it is expecting an offline backup ...

    Have you just set the logretain to YES ???

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jun 2004
    Posts
    5
    Hi ,

    You might have set the logretain to yes or userexit to yes. Once you change these parameters you must take the offline backup. After that only you can take the online backups.

    Let us know if it works for u.

    Thanks.

  4. #4
    Join Date
    Feb 2004
    Posts
    34
    How to set these parameters ?

  5. #5
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    2 Ways

    Hi Dingi,

    You can do it from the configure database logging option of the databases menu under the control center.

    OR You can customize the sample commands below.

    CONNECT TO SAMPLE
    QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
    UNQUIESCE DATABASE;
    CONNECT RESET;
    UPDATE DB CFG FOR SAMPLE USING logretain ON userexit ON logprimary 3 logsecond 2 logfilsiz 250;
    BACKUP DATABASE SAMPLE TO "E:\ARCHLOGS\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

    Please also read on backups to get a better picture.

    HTH
    HTH

    Nitin

    Ask the experienced rather than the learned

Posting Permissions

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