Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2004
    Posts
    115

    Unanswered: backup database greater then 2Gb

    Hi

    How do i backup a database greater then 2 GB as the db2 backup command creates a single backup file of the database.My unix file system does not allow files greater then 2Gb.

    Can db2 backup command split files with sizes less then 2 GB also what steps do i need to take while restoring these spilt files.

    regards
    Hrishy

  2. #2
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    what OS R U using , if solaris , can setup , file size as large , that you can tabke , backup




    Lekharaju Ennam

  3. #3
    Join Date
    Sep 2002
    Posts
    456
    Assuming you are using UNIX, you can ask the unix engineers to change the user limits for the person taking the backup. On AIX you can see the limits by "ulimit -a" command on the prompt. Even if you are unable to change the limits you can still take a backup image BUT you will get more than one backup files...with same naming format but at the end you will find..000, 001....and so on each with 2GB or little less in size.

    While restoring you do a restore as you would normally do, DB2 will automatically pick the right file one after another.

    dollar

  4. #4
    Join Date
    Jun 2004
    Posts
    115
    Hi Dollar

    The db2 backup command will automagically spli the files with sizes less then 2Gb am i right do i need to pass it some option.I am on redhat Advanced server 3.0 with Veritas Volume Manager

    regards
    Hrishy

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    In the backup database command, you can provide multiple paths for db2 to write the backup to ... You may specify the same path too ...

    Refer Command Reference for details

    Cheers
    Sathyaram

  6. #6
    Join Date
    Sep 2002
    Posts
    456
    Hrishy,

    Backup command will automatically split the files for you...nothing else is required from you side besides the command itself

    dollar

  7. #7
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    in backup command use compress option , that will compress you backup file


    Lekharaju Ennam
    Lekharaju Ennam
    Certified Oracle8i & DB UDB DBA
    Florida A&M University

  8. #8
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The COMPRESS option is available on DB2 version 8.1 FP4 or later.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  9. #9
    Join Date
    Aug 2004
    Location
    India
    Posts
    13
    Hi
    you can create a " Large file enabled journal file system" " If working on AIX " through smit utility and the you can take your DB backup on that files system as " Large file enabled journal file system" permits individual files more than 2GB also

    Regards


    Falcon

Posting Permissions

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