IBM Support

Is it possible to restore maximo db2 database from the backup taken on v 9.7 in v10.5 environment

Technical Blog Post


Abstract

Is it possible to restore maximo db2 database from the backup taken on v 9.7 in v10.5 environment

Body

Yes it is possible and the best way is to take the offline backup of the source database

 

db2 “backup database maximo to <directory> include logs”

 

then on the target server.

 

db2 “restore database maximo from <directory > taken at <timestamp>

redirect generate script maximo.clp “

and then execute the generated maximo.clp sript

The restore will autocratically upgrade maxmo database from v9.7 to v10.5

 

I hope this is helpful.

P.S

For more details please use this link:

 

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001976.html?cp=SSEPGG_9.7.0%2F3-6-2-4-104

 

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11132059