Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: backup pending because of load command, please help!!!!

    I use db2 v8.2.2 and aix 5.2

    archive logging in database is ON, when I ran load command tabale space went to backup pending and made a lot of touble in production box, yes I know I should take a backup and continue or restore and turn OFF archive logging and run load command, my question is if I use IMPORT command instead of LOAD it seems is ok and I will not get backup pending

    Am I right?

    I am a little bit panick, I want to use import and I want sure I will not get any problem, please help.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Import uses inserts (which are logged, so you will not get any copy pending). Make sure you set the commitcount parm so you take commits every 1000 or so inserts to keep the active log from filling up.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by Marcus_A
    Import uses inserts (which are logged, so you will not get any copy pending). Make sure you set the commitcount parm so you take commits every 1000 or so inserts to keep the active log from filling up.
    Thank you so much Marcus_A

  4. #4
    Join Date
    Dec 2005
    Posts
    39
    You won't get backup pending state if you use nonrecoverable option in your load statement. Load is much faster than import so if data is huge you might be better off with load. However you need to ensure integrity is set once load is over.

  5. #5
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by murali_sb
    You won't get backup pending state if you use nonrecoverable option in your load statement. Load is much faster than import so if data is huge you might be better off with load. However you need to ensure integrity is set once load is over.
    Thank you murali_sb for your help

Posting Permissions

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