Have y’all ever failed back to a previous version of DB2 after few weeks. \u00c2\u00a0Try it…its a nightmare ! \u00c2\u00a0Failing back during a migration window is pretty easy if you are doing a side by side migration. \u00c2\u00a0I had recently migrated to from DB2 V8.2 to DB2 V9.5 , after a few weeks, the application software vendor tells us, they were wrong in their documentation that stated they support DB2 V9.5, but they do support DB2 V9.1 . Even though we have been running the application on DB2 V9.5 for couple of months in our test system without any issues.\u00c2\u00a0<\/p>\n
When I checked the DB2 manuals and site, I didn’t see any way of falling back after few weeks of usage. Luckily I hadn’t migrated my production system…thank god ! \u00c2\u00a0I need to fall back on my QA system, which is used pretty heavily and data is changed very often. \u00c2\u00a0The manual says to restore the pre migrate offline back, but this means I will lose all the data since then.<\/p>\n
The only method I figured how I can do it is :<\/p>\n
Create a new instance under V8.2<\/p>\n
Create database and schema on v8.2 instance using db2look from V9.5 database<\/p>\n
Unload data from V9.5 database and load it to V8.2 database<\/p>\n
Shutdown the V9.5 instance\u00c2\u00a0<\/p>\n
Change the port number \/ SVCENAME of \u00c2\u00a0V8.2 instance with the one in V9.5 instance<\/p>\n
Drop the V9.5 database and instance once validation is complete.\u00c2\u00a0<\/p>\n
I wish there is an unload feature in LUW as there is in Z\/os. \u00c2\u00a0Instead of bringing down row at a time, wish it could bring a page at a time.<\/p>\n","protected":false},"excerpt":{"rendered":"
Have y’all ever failed back to a previous version of DB2 after few weeks. \u00c2\u00a0Try it…its a nightmare ! \u00c2\u00a0Failing back during a migration window is pretty easy if you are doing a side by side migration. \u00c2\u00a0I had recently migrated to from DB2 V8.2 to DB2 V9.5 , after a few weeks, the application […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[3],"tags":[943,34,33,24,35,32],"class_list":["post-91","post","type-post","status-publish","format-standard","hentry","category-db2","tag-db2","tag-db2move","tag-fallback","tag-install","tag-restore","tag-upgrade"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/91","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=91"}],"version-history":[{"count":2,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/91\/revisions"}],"predecessor-version":[{"id":111,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/91\/revisions\/111"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}