Results 1 to 5 of 5

Thread: Load

  1. #1
    Join Date
    Dec 2004
    Posts
    54

    Unanswered: Load

    Whenever I load data by using DB2 LOAD utility I am forced to take backup. can this be avoid by anyway?

    Thanks,

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by allian
    Whenever I load data by using DB2 LOAD utility I am forced to take backup. can this be avoid by anyway?

    Thanks,
    Yes, use the NONRECOVERABLE option. Cautiously... make sure you look over the docs to make sure you really want to do this, as implied it means you cannot recover that table data.

    jono
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Feb 2005
    Posts
    36
    I have the same problem, where can I find docs relate to nonrecoverable option? Can you jave me a sample contains db2 load with nonrecoverable option?

    Thanks!
    Lan

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Look in Command Refference.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  5. #5
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    It's in the Command Reference.

    LOAD FROM xxx.del of del insert into mytable NONRECOVERABLE

    Again - be careful. If you ever get put in a position where you have to RESTORE, that table is toast if you used this option and go past the point in time of the LOAD.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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