Offline schedule Backup in inactive

[Former Member]

Hi,

When i am going to schedule backup by db13, in that time offline backup mode is showing inactive & i can only take online backup. We are using db2 9.1 with active license but why is it showing inactive of offline backup. Please suggest us.

SAP ecc6

DB2 9.1

Regards

Abhijit

[srinivasan_vinayagam]

Dear Abhijit,

Follow below link for DB2 offline Backup.

DB2: Performing a Complete Offline Backup (SAP Library - DB2 UDB Database Administration (BC-RRR))

Above guide more information is there.

Login as SIDADM or DB2SID in to server

Run - command prompt to enter db2cmd

"db2 backup db sid to E:/db2backup

Thanks & Regards,

V Srinivasan

[former_member188883]

Hi Abhijit,

My understanding is we cannot schedule offline backup using db13 for DB2 database.

You may need to shutdown application & then take offline backup using db2 commands.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi,

I know that db2 database backup which will be done by db2 command level but we needed sap schedule backup along with company's data & it is proceed using by db13 in both way (online or offline). Earlier, we took backup in both way but after database migrating, it shows only active on online mode. Here, i have attached screen as follows.

Regards

Abhijit

[former_member188883]

Hi Abhijit,

Refer SAP Note 427982 - DB6: Offline backup ends with job error (DB13)

As per this note : Offline backup for db2 is not supported as of NW04s.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi,

Thanks for replying about it & let me check.

Regards

Abhijit

[former_member188883]

Hi Abhijit,

Hope your issue is resolved. In this case you may close this thread.

Regards,

Deepak Kori

[Former Member]

Hi,

Actually, i found that offline backup mode is active on another server where, same OS and database only kernel different so i am just confirming that it will be seen same in both server. Please let me know why is this differences......

Regards

Abhijit