online DB6 backup procedure

[Former Member]

Hai Friends,

I am Jagadeesh,expecting u r the person to give right solutions to these questions. Ours is small co., i hv 2 take daily and weekly backup of PRD n DEV systems.

Configurations:

Ecc 6.0

DB6

AIX

_DB^ data base backup in AIX flatform**_

1. how 2 schedule d daily backup of Prd.(Plz send step by step procedure)

2.How 2 take daily backup of PRD data to tape device.

3.How 2 take weekly backup of PRD data to tape device.

4..How 2 take backup of DEV data to normal cd or hard disk

5.how 2 take backup to local mechine HDD.

Please respond.

Edited by: jagan jagadeesh on Sep 9, 2008 1:21 PM

Edited by: jagan jagadeesh on Sep 9, 2008 1:31 PM

[Former Member]

Remember please backup your archive log and purge it too.. without archive logging activated you cant do online backup..

"

1. how 2 schedule d daily backup of Prd.(Plz send step by step procedure)

2.How 2 take daily backup of PRD data to tape device.

3.How 2 take weekly backup of PRD data to tape device.

4..How 2 take backup of DEV data to normal cd or hard disk

5.how 2 take backup to local mechine HDD"

you can use tx DB13 to schedule your backup or you can make use cronjob in the aix system

for cronjob you can create a file like called backupweekly.sh with db2 backup command inside it

you can backup dot tape / file system

eg.

db2 backup db ER6 to /dev/rmt2 with 4 buffers buffer 32 . or

db2 backup db ER6 to /backup with 4 buffers buffer 32.

backup to CD ? i dont think its possibel since CD and DVD having limited sizes

try to goole with keyword "db2 backup" and "db13" plentry explaination for you.

If you dont want this troubles, buy a backup solution

[Former Member]

Hi,

if you are familiar with SAP systems, you could use the DBA Planning Calendar to schedule jobs to perform your backups.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b0571f59-4bd8-2910-269d-ef73f0e2...

Chapter 6.2

Regards, Jens