{"id":215,"date":"2009-04-20T22:47:07","date_gmt":"2009-04-20T16:47:07","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=215"},"modified":"2016-01-07T11:31:13","modified_gmt":"2016-01-07T05:31:13","slug":"upgrading-from-db2-v82-to-db2-v95","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=215","title":{"rendered":"Upgrading from DB2 V8.2 to DB2 V9.5"},"content":{"rendered":"

I recently went through a rally of upgrading the DB2 UDB V8.2 to DB2 9.5 . \u00c2\u00a0IBM slowly sneaked in the end of support for DB2 V8.2, though this has created lot of unhappy customers as lot of third party vendors have not yet certified Db2 V9.5 . Siebel for one does not yet support DB2 V9.5 ! \u00c2\u00a0 Something to remember when upgrading is there are few DB2 fixpaks for V9.5 already, the latest being FP3b. \u00c2\u00a0Its important these fixpaks are installed as you upgrade them mainly because of \u00c2\u00a0certain “bad” ones. \u00c2\u00a0On AIX there is a catch, you might get segmentation fault if you install FP2 + before you migrate instance, unless you install an APAR. \u00c2\u00a0So the route<\/a> I took was to install DB2 V9.5 on a new path, migrate the instance, migrate the databases and then install the fixpack. \u00c2\u00a0This worked for me. \u00c2\u00a0 I did encounter couple of interesting issues during migration, mostly because of oversite ! \u00c2\u00a0But I thought I will share it here, since when I searched on google, I couldn’t get any information and had to figure it out myself.<\/p>\n

One if my servers is on HACMP , so the db2node.cfg has the cluster name on it :<\/p>\n

0 db2servercl 0<\/em><\/span><\/p>\n

even though the server name is db2server1<\/em><\/span>.\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 During DB2CKMIG, db2 checks at the db2nodes.cfg and tries to associate that with the DB2SERVER value to find the files on the local database directory.\u00c2\u00a0 If the entry on the db2nodes.cfg file doesn’t match the server name, it would not find the database on the local directory and db2ckmig fails.\u00c2\u00a0 An easy way to test this is :<\/p>\n

    \n
  1. Stop the instance (db2stop)<\/li>\n
  2. Run : db2 list db directory<\/li>\n
  3. Run : db2 list db directory on <dbpath><\/li>\n<\/ol>\n

    If step 3 works then you should be ok with db2ckmig,\u00c2\u00a0 if it does not then you have an issue. Easy fix is during the migration, change the db2node.cfg\u00c2\u00a0 entry to match the server name. Infact try and run the above test , it should work.<\/p>\n

    Another issue I encountered during the migration was when I was installing the FixPack.\u00c2\u00a0 The installFixPack failed at “update of runtime path<\/em><\/span>“\u00c2\u00a0 task.\u00c2\u00a0 From Db2 V9.x IBM has changed the way installFixPacks work, you can no longer just apply the fixpak and has changed the options that go with it too.\u00c2\u00a0 installFixPack will check the prereq and figure out what all it needs to do and will let you know how many tasks its going to perform and how long it will take.\u00c2\u00a0 However it will not tell us what all the tasks are ahead of time (thats lousy coding), it will tell you the task as it goes.\u00c2\u00a0 The approx time it estimates has always been wrong !. Luckily it always overestimates. <\/span><\/p>\n

    As I mentioned earlier,\u00c2\u00a0 I encountered an error during “update of runtime path” task.\u00c2\u00a0 I got the following error :<\/span><\/p>\n

    Starting the update of runtime path …
    \nSun Apr 19 01:56:30 CDT 2009<\/em><\/span><\/p>\n

    Changing the embedded runtime path for DB2 deliverables installed
    \nunder \/opt\/IBM\/db2\/V9.5 from \/opt\/IBM\/db2\/V9.5\/ to \/opt\/IBM\/db2\/V9.5\/
    \n—> Please wait<\/em><\/p>\n

    db2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libdb2locale.a’: error: 26(Text file busy)
    \ndb2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libdb2genreg.a’: error: 26(Text file busy)
    \ndb2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libdb2osse_db2.a’: error: 26(Text file busy)
    \ndb2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libdb2dasapi.a’: error: 26(Text file busy)
    \ndb2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libdb2install.a’: error: 26(Text file busy)
    \ndb2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libdb2osse.a’: error: 26(Text file busy)
    \ndb2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libdb2.a’: error: 26(Text file busy)
    \ndb2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libdb2g11n.a’: error: 26(Text file busy)
    \ndb2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libdb2dascmn.a’: error: 26(Text file busy)
    \ndb2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libdb2sec.a’: error: 26(Text file busy)
    \ndb2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libdb2trcapi.a’: error: 26(Text file busy)
    \ndb2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libgcf.a’: error: 26(Text file busy)
    \ndb2chglibpath: Unable to open file for write: ‘\/opt\/IBM\/db2\/V9.5\/lib64\/libgcffm.a’: error: 26(Text file busy)<\/em><\/p>\n

    ——————————————————————
    \nThe embedded library path of the following files could not be
    \nupdated with the current installation path
    \n\/opt\/IBM\/db2\/V9.5\/.
    \ndue to some unexpected error. Please rerun db2chgpath. If the
    \nproblem can not be resolved, please contact IBM DB2 Support.
    \n——————————————————————<\/em><\/p>\n

    FAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libdb2locale.a
    \nFAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libdb2genreg.a
    \nFAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libdb2osse_db2.a
    \nFAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libdb2dasapi.a
    \nFAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libdb2install.a
    \nFAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libdb2osse.a
    \nFAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libdb2.a
    \nFAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libdb2g11n.a
    \nFAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libdb2dascmn.a
    \nFAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libdb2sec.a
    \nFAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libdb2trcapi.a
    \nFAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libgcf.a
    \nFAIL (unexpected error): \/opt\/IBM\/db2\/V9.5\/lib64\/libgcffm.a
    \n——————————————————————
    \nOutput was saved in the log file \/tmp\/db2chgpath.log
    \nSun Apr 19 01:57:21 CDT 2009<\/em><\/p>\n

    ———————————————————–
    \nERROR: There were errors during the run of the db2chgpath
    \nprogram to change the embedded runtime path of the
    \nrelated DB2 library and executable files
    \nfrom
    \n\/opt\/IBM\/db2\/V9.5\/
    \nto
    \n\/opt\/IBM\/db2\/V9.5\/<\/em><\/p>\n

    You may need to manually rerun db2chgpath.<\/em><\/p>\n

    Check the log file \/tmp\/db2chgpath.log for details.<\/em><\/p>\n

    If the rerun is successful, please follow the DB2
    \nquick beginning books to configure DB2 instance(s)
    \nand\/or DAS as needed.<\/em><\/p>\n

    If the problem persists, please contact IBM DB2 Support.<\/em><\/p>\n

    After a bit of research I found\u00c2\u00a0 that the db2fmd process was respawned by initab since I had not commented out the step.\u00c2\u00a0 Once I commented that out and killed the db2fmd process. The installFixPack went smooth.<\/p>\n

    Be sure to check this link<\/a> before you migrate your instance so you know what all bugs and issues you might face.<\/p>\n

    Here is the document that outlines the\u00c2\u00a0 migration steps\u00c2\u00a0 I followed when I migrated my databases from DB2 V8.2 to DB2 V9.5 and installed FP3b :db2-v95-migration-steps-for-aix<\/a> This document can be used only as a reference and in noway warranty that it will work on your environment.<\/p>\n

    Good luck with your upgrade effort and do let me know if you find any errors or process improvements I can make on my document.<\/p>\n","protected":false},"excerpt":{"rendered":"

    I recently went through a rally of upgrading the DB2 UDB V8.2 to DB2 9.5 . \u00c2\u00a0IBM slowly sneaked in the end of support for DB2 V8.2, though this has created lot of unhappy customers as lot of third party vendors have not yet certified Db2 V9.5 . Siebel for one does not yet support […]<\/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":[25,943,115,108,54,118,109,121,116,122,110,119,120,114,111,117,113,112,123,32],"class_list":["post-215","post","type-post","status-publish","format-standard","hentry","category-db2","tag-aix","tag-db2","tag-db2-fixpak","tag-db2-upgrade","tag-db2-v95","tag-db2chglibpath","tag-db2chgpath","tag-db2ckmig","tag-db2fmd","tag-db2imigr","tag-db2node","tag-db2nodecfg","tag-db2server","tag-fix-pack","tag-fp3a","tag-initab","tag-installfixpack","tag-migrate","tag-runtime-path","tag-upgrade"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/215","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=215"}],"version-history":[{"count":7,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/215\/revisions"}],"predecessor-version":[{"id":225,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/215\/revisions\/225"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}