Offline backup for DB2 and SAP on Solaris

[Former Member]

Hi All,

I would like to know if it is possible to do a full offline filesystem backup for SAP and DB2.

Scenario:

Shutdown All SAP and DB2 process and apps. Run a full filesystem backup using NetBackup (basically using tar command) to tape.

I have tried the above but notice that upon restore the DB is unable to start. I saw a document saying that for DB2 offline backup the integrated tool needs to be used. I have yet to get any confirmation or supporting document that mentions a filesystem backup for DB2 is not supported.

DB2 Version: 9.5

OS Version: Sol 10

Thanks in advance.

[Former Member]

Hi ,

While doing DB2 offline backup you have to first login to the su - ID of the DB2 user and then use the offline command to do the db2 backup.

Then you can restore it using the command restore command and rollforward if necessary with the appropriate path of the logfiles.

Once the restore of db2 you have to complete the restore to use the database otherwise you will not be able to connect to the database.

Kiran

[Former Member]

Hello,

Anything that is not tested by IBM would not be documented. This is the case for a filesystem backup. It is not tested by IBM so you won't find any documentation that says it is not supported, but as I said, it is not tested so it will not be officially supported. Offline DB2 backups should be done using the DB2 command line 'db2 backup database ..." command. For details check the folowing link for hte complete command syntax:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0...

Regards,

Adam