IBM DB2 online database backup

[Former Member]

Hi All,

We have installed SAP Net weaver 7.4 single stack JAVA, on window , database IBM DB2 10.5 ASE for LUW and IBM 4.1 studio. We want to take the back up of SAP server at OS level, we installed the DB studio, but we are not able change the logging mode to archive mode and take the online back up ( failure error and not running) .

Please tell us the parameters to set in studio and proceed run the set-up.

Thanks & Regards

Ambi

[former_member182505]

Hello Ambi

Use the below command for archive activation

db2 update db cfg for SID using LOGARCHMETH1 DISK:/db2/SID/log_archive

after changing the parameter you need to take offline backup,

use the command below,

db2 "backup database SID to D:\backup\ with 12 buffers buffer 1024 parallelism 6"

Thanks

Sadiq

[Former Member]

Hello Ambi,

After changing the parameter like Sadiq explained and you don't want to make a "cold" offline backup, you can use that command to bypass this obligation:

su - db2<SID>

db2dart <DBSID> /CHST /WHAT DBBP OFF

Regards,

Serhat

[maria_shen]

Hello Ambi,

The second attachment shows the database has the logging type with archive. But the archive log destination seems not defined in LOGARCHMETH1, as we see it is 'OFF' in first attachment.

On the other hand, you may consider to directly update the database configuration parameter via DB2 command line. If the issue persists, please at least attach the complete output file of  command 'db2 get db cfg for <sid> > db_cfg.out'.

Kind regards
Maria