Results 1 to 5 of 5

Thread: db2 archive

  1. #1
    Join Date
    Oct 2008
    Posts
    70

    Unanswered: db2 archive

    Dear all,

    In db2,db2/IRP/db2dump file system was full.I want to archive the db2dump.

    what is the command in db2 for archiving.give a example

    Please is urgent


    Regards,
    K.Manikandan

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    tar this directory and gzip it and move the file to a different filesystem
    cleanup the db2dump directory
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Oct 2008
    Posts
    70
    Hi,

    Can you give me one example

    Regards,
    K.manikandan

  4. #4
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    Manikandan,
    You will get some very goog example of Tar and Gzip in "about.linux.com".

    Its nothing but you are compressing your previous archive logs and then you are Zipping the same (which reduces the size by 40-60%). And moving to another directory.

    Regards,
    Jayanta
    New Delhi, India

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    The only thing you have to know is that DB2 will automatically re-create the contents of the db2dump/ directory when needed. So the "cleanup" is actually to remove all files in that directory. If you still need them for whatever purpose, you should create a backup. How exactly you do that doesn't matter, and using tar and gzip are just basic standard tools in Unix environments that can help you there.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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