Results 1 to 7 of 7

Thread: Backup

  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unanswered: Backup

    How can I backup

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look in the command reference for the BACKUP command.
    This can also be done from the Control Center. Right click on the database name and pick Backup.

    Andy

  3. #3
    Join Date
    Dec 2003
    Location
    Johannesburg, South Africa
    Posts
    18

    Talking DB2 Information

    You backup DB2 data (I assume OS/390) with the COPY command.

    The basic format is ==>
    COPY TABLESPACE DBNAME.TSNAME

    You can also add FULL YES/NO for full and incremential Image copies
    and SHRLEVEL CHANGE/REFERENCE for the type of locking SHRLEVEL REFERENCE will allows users to only READ object you are backing up and SHRLEVEL CHANGE will allows users to chage data while backing up, please remember to do a QUIESCE ofter this type of backup to create a point of consistency.

    There are other option to create onsite (COPYDDN) and offsite image copy (RECCOVERYDDN), you can use both.

    DB2 also allows concurrent image copies but I would stear away from them as it really complicates recover, especially when recovering dropped objects and usingf DSN1COPY.

    By the way you can also use the DSN1COPY utility for backing up your data.
    Divvy

  4. #4
    Join Date
    Oct 2003
    Posts
    29
    > db2 ? backup

    -Racha

  5. #5
    Join Date
    Dec 2003
    Location
    Johannesburg, South Africa
    Posts
    18

    Wink DB2 Information

    The Samles I gave a DB2 backup for OS/390 platform.
    Divvy

  6. #6
    Join Date
    Dec 2003
    Location
    Johannesburg, South Africa
    Posts
    18

    Talking DB2 Information

    Hey it is early in the morning here, I am still waking up but what I was trying to say is that the examples I gave are for DB2 OS/390 backups.
    Divvy

  7. #7
    Join Date
    Dec 2003
    Location
    Johannesburg, South Africa
    Posts
    18

    Thumbs up DB2 Information

    I have looked up the Backup command in DB2UDB for Windows NT and here they are:

    ONLINE BACKUPS (using Parralelism)

    BACKUP DATABASE SAMPLE TABLESPACE USERPACE1 ONLINE TO C:\SQLLIB PARALLELISM 2;

    OFFLINE BACKUPS (Using Buffers)

    BACKUP DATABASE SAMPLE TABLESPACE USERPACE1 TO C:\SQLLIB WITH 2 BUFFERS;

    I hope this helps or lookmore familiar to most people using UDB.
    Divvy

Posting Permissions

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