Wednesday 27 January 2016

How to take Maximo DB2 Offline Backup - IBM Maximo

FIRST we have to stop maximo server to take offline backup, you can do it by using websphere GUI or by using ServerStop.bat, its totally up to your choice

now copy these below mentioned lines in notepad and save it with dot bat (i.e DB2BackupScript.bat) extension.
DB2 CONNECT TO MAXDB76 USER Administrator USING Maximo76
DB2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
DB2 CONNECT RESET
DB2 BACKUP DATABASE MAXDB76 USER Administrator USING Maximo76 TO "C:\Backup" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS EXCLUDE LOGS WITHOUT PROMPTING
DB2 CONNECT TO MAXDB76 USER Administrator USING Maximo76
DB2 UNQUIESCE DATABASE
DB2 CONNECT RESET

 run these this file by using this command
db2cmd /c /w /i DB2BackupScript.bat
Note: you also can make a bat file for this command also.

LAST: now Start WebSphere back by using GUI or StopServer.bat script. whatever you like. 

No comments:

Post a Comment