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.
run these this file by using this command
LAST: now Start WebSphere back by using GUI or StopServer.bat script. whatever you like.
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.batNote: 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