Schedule DB2 db offline backup

[Former Member]

Hi,

we are taking daily online backup including logs from DB13.

but offline option ( Radio button) is inactive in DB13.

Please suggest how to take schedule offline backup of DB2

database in SAP.

regards

--Sanjay Motwani

[former_member220077]

If your using any flavor of Unix, you'll need the following steps, we do all of ours from the OS level to make sure there are no issues, we also setup email and paging alerts if one of the steps fails.

DO the following steps

Shutdown SAP

Check and see if SAP is still up

Do a force applications all against DB2 (some of the scripts, I just shutdown db2 and restart it)

run your offline backup

when it finishes start sap back up.

If your using windows, you can do the same steps in a .bat file.

[former_member640873]

Hello Sanjay,

In SAP Netweaver 2004 or below, you can still schedule DB2 offline backup with DB13, but the following problem may occur according to OSS Note 427982:

o Incorrect logging

Even though the backup exits successfully, the corresponding job

ends with an error.

The log then contains entries such as the following:

Job was started

Step 001 started (Program RSDBAJOB, Variant &0000000000002, ...

The logical command DB6_DBBACKUP is executed on host pcibm01

Parameter:C46 OFFLINE TO /dev/st0 BUFFERS 1 BUFFERSIZE 1024

PARALLELISM

Backup successful. The timestamp for this backup image is :

200108161023

Backup size is : 12071MB.

TemSe: Input/output error

Job was terminated

Instead of the above-mentioned error, other I/O errors or runtime

errors can also be reported. Another error message that may

appear in the job log is, for example:

ABAP processor: ZDATE_ADJUST_FAILED

o Offline backup is not possible

The offline backup terminates with SQL error 1035.

As of SAP Netweaver 2004s, DB2 offline backup is no longer supported. And you are suggested to use a combination of online backup with the "INCLUDE LOGS" option to get a full backup.

Please also refer to this existing discussion about the same issue.

[;

Regards,