Question:
anyone the command to backup db2/udb 8 for sap 620 (BW)
I am used to oracle and brbackup etc/ and have now installed the db2/udb 8 for BW (company decision) - sap don't provide as many courses in australia for db2 so if any can provide a good website or tools on this it would also help.
In the meantime, I need to know how to backup correctly and test restore. (at the moment we are shutting down and running file by file backup)
Answer:
I have the hardcopy material but ????
Actually, there are not too much difference between ORA and UDB. As UDB is close integrated with Tivoli so it is even unneccsary to buy an extra backup interface for SAP R/3 (yes, still recommended).
For the old SAP versions, you can choose or not choose build an extra admin database which manage the backup & archive. There is no summary log and detail log on OS level.
DB2 admin training is recommended if you can not find related SAP training.
Answer:
Hi,
U can use the following commands :
1) logon to DB server as user db2<dbsid>
2) > db2 backup db <DBSID>
To check the integrity of your backups you can use the ' db2ckbkp ' utility to verify backup image or disk or tape.
You can also use the 'dmdb6bkp' tool. You will need to logon as <sid>adm user to use this tool. It resides in the /sapmnt/SID/exe folder.
Send me you email address, I will send you DB2 Universal DB guide. Very useful and invaluable.
Rix