Results 1 to 8 of 8

Thread: db2dump

  1. #1
    Join Date
    Oct 2008
    Posts
    70

    Unanswered: db2dump

    Dear All,

    I need to archive the db2dump file in db2.

    I created the new directory db2/irp/sapdata1/db2olddum.I went into the path db2/usr/db2dump.I executed the commmand "db2 diag -A /db2/IRP/sapdata1/db2olddum".But It show the error.Please help me for this error.I attached the screen shot also.

    Regards,
    K.Manikandan
    Attached Files Attached Files

  2. #2
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    I guess you have raised this question elsewhere... so why this new thread....


    Anyways


    do this

    tar your folder -

    cd db2/usr/db2dump
    tar -czf db2dump.tgz *
    then move your folder
    mv db2dump.tgz /db2/irp/sapdata1/db2olddum
    finally cleanup db2/usr/db2dump location
    IBM Certified Database Associate, DB2 9 for LUW

  3. #3
    Join Date
    Oct 2008
    Posts
    70

    Db2 dump

    Hi,

    This is the only procedure to archive??.Why db2 diag -A path is not working.

    Regards,
    K.MANIKANDAN

  4. #4
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    coz it should be db2diag and not db2 diag

    so your query will be
    db2diag -A /db2/IRP/sapdata1/db2olddum or
    db2diag -archive /db2/IRP/sapdata1/db2olddum
    missed out on your incorrect command earlier...
    Last edited by nick.ncs; 11-13-08 at 03:52.
    IBM Certified Database Associate, DB2 9 for LUW

  5. #5
    Join Date
    Oct 2008
    Posts
    70

    db2 dump

    Hi,

    Thank you for your reply.Sorry i can't understad the previos mail.Please explain clearly.It is very urgent.I want to archiv the db2dump folder then i need to move into different location.Can you give me the command for archive the db2dump folder.

    Regards,
    K.Manikandan.

  6. #6
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    did this commands not work???

    db2diag -A /db2/IRP/sapdata1/db2olddum
    OR
    db2diag -archive /db2/IRP/sapdata1/db2olddum
    IBM Certified Database Associate, DB2 9 for LUW

  7. #7
    Join Date
    Oct 2008
    Posts
    70

    Db2 dump

    Hi,

    Thank you very much.now my data was archived .After archiving db2dump.can you tell me i need to delete the which files now?.Please reply me.

    Regards,
    K.Manikandan

  8. #8
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    The Archive files which are no more required can be deleted.

    It depends on whether you want to retain backup for whatever days. (e.g. 7 days of backup dump). All previous files can be deleted as you don't need the archive files which are older than your 7 day old backup.

    Thanks

Posting Permissions

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