If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > db2dump

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-13-08, 02:16
manikandank_1984 manikandank_1984 is offline
Registered User
 
Join Date: Oct 2008
Posts: 65
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
File Type: doc db2dump error.doc (27.5 KB, 73 views)
Reply With Quote
  #2 (permalink)  
Old 11-13-08, 02:36
nick.ncs nick.ncs is offline
Registered User
 
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 -

Quote:
cd db2/usr/db2dump
tar -czf db2dump.tgz *
then move your folder
Quote:
mv db2dump.tgz /db2/irp/sapdata1/db2olddum
finally cleanup db2/usr/db2dump location
__________________
IBM Certified Database Associate, DB2 9 for LUW
Reply With Quote
  #3 (permalink)  
Old 11-13-08, 02:43
manikandank_1984 manikandank_1984 is offline
Registered User
 
Join Date: Oct 2008
Posts: 65
Db2 dump

Hi,

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

Regards,
K.MANIKANDAN
Reply With Quote
  #4 (permalink)  
Old 11-13-08, 02:48
nick.ncs nick.ncs is offline
Registered User
 
Join Date: May 2007
Location: somewhere in dbforums
Posts: 221
coz it should be db2diag and not db2 diag

so your query will be
Quote:
db2diag -A /db2/IRP/sapdata1/db2olddum or
db2diag -archive /db2/IRP/sapdata1/db2olddum
missed out on your incorrect command earlier...
__________________
IBM Certified Database Associate, DB2 9 for LUW

Last edited by nick.ncs; 11-13-08 at 02:52.
Reply With Quote
  #5 (permalink)  
Old 11-13-08, 02:55
manikandank_1984 manikandank_1984 is offline
Registered User
 
Join Date: Oct 2008
Posts: 65
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.
Reply With Quote
  #6 (permalink)  
Old 11-13-08, 03:05
nick.ncs nick.ncs is offline
Registered User
 
Join Date: May 2007
Location: somewhere in dbforums
Posts: 221
did this commands not work???

Quote:
db2diag -A /db2/IRP/sapdata1/db2olddum
OR
Quote:
db2diag -archive /db2/IRP/sapdata1/db2olddum
__________________
IBM Certified Database Associate, DB2 9 for LUW
Reply With Quote
  #7 (permalink)  
Old 11-13-08, 04:40
manikandank_1984 manikandank_1984 is offline
Registered User
 
Join Date: Oct 2008
Posts: 65
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
Reply With Quote
  #8 (permalink)  
Old 11-13-08, 07:19
JAYANTA_DATTA JAYANTA_DATTA is offline
Registered User
 
Join Date: Oct 2004
Location: DELHI INDIA
Posts: 336
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On