Backup in AIX

[#1]

Dear All,

I want to take Online/Offline Backup in AIX as my DB will be DB2 on TAPE.

Can anyone help me regarding the same.

Can anyone share some links of helpful threads regarding the same.

Thanks & Regards

Ajitabh

[former_member182505 · Accepted solution]

Hi

Please use the command will help you

Login to :-

>su - db2sid

and run the below command

Offline:-

db2 backup database SID to /sapbackup(path of the Tape) with 2 buffers buffer 1024 parallelism 3 compress without prompting

online

db2 BACKUP DB SID ONLINE TO /backup1 including logs with 2 buffers buffer 1024 parallelism 3 compress without prompting

Thanks

Sadiq

[former_member189725]

Please follow this link to initialize tape drive .

[http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.ha.doc%2Fdoc%2Fc0006201.html]

Then you can go ahead with the following command for online/offline backup.

db2 BACKUP DATABASE <SID> ONLINE TO /dev/rmt0 [COMPRESS [COMPRLIB lib-name [EXCLUDE]] [WITH num-buff BUFFERS] [BUFFER buffer-size] [PARALLELISM n] [WITHOUT PROMPTING]

The options within brackets are optional and may be used if required.

For details of all the options , do

db2 \? backup database

[Former Member]

Dear All,

Issue Resolved.

Closing this question.

Thanks & Regards

Ajitabh

[hans-juergen_zeltwanger]

Hello,

please consult the following paper:

[A Practical Guide to Backup and Recovery of IBM DB2 for Linux, UNIX and Windows in SAP Environments|https://www.ibm.com/developerworks/wikis/download/attachments/116426414/IBM-Backup-and-Recovery-Guide-of-DB2-in-SAP-Environments.pdf?version=1]

Hans-Juergen

[thomas_vogt]

Moved thread to Db6 forum.