{"id":101,"date":"2017-07-07T23:21:15","date_gmt":"2017-07-07T21:21:15","guid":{"rendered":"http:\/\/blog.xoupix.fr\/?p=101"},"modified":"2018-07-25T16:15:49","modified_gmt":"2018-07-25T14:15:49","slug":"upgrading-from-db2-9-7-to-db2-10-5","status":"publish","type":"post","link":"https:\/\/blog.xoupix.fr\/index.php\/2017\/07\/07\/upgrading-from-db2-9-7-to-db2-10-5\/","title":{"rendered":"Upgrading from DB2 9.7 to DB2 10.5"},"content":{"rendered":"

Today, I was confronted to a specific problem related to FileNet. When adding lots of properties \/ class definitions, and creation new property definitions to all my class definitions, FileNet (version 5.2.1 fix pack 6) just returns me an aggressive FNRCD0022E: DB_ROWLENGTH_LIMIT_EXCEEDED, which means that the table just exceeded the maximum size allowed (c.f.\u00a0this IBM thread<\/a>). After some research, it appears that this bug is resolved in DB2 version 10.5, so I had to upgrade my environment !<\/p>\n

<\/p>\n

Upgrading DB2 from 9.7 to 10.5<\/h1>\n

This was the easy part. I just got the DB2 10.5 binaries, then installing it using the following command line :<\/p>\n

db2stop\r\ntar xfz v10.5fp8_linuxx64_universal_fixpack.tar.gz -C \/tmp\/db2\r\n.\/db2setup -r \/media\/sf_FileNet\/Install\/db210.5.rsp \/tmp\/db2\/db2install.txt<\/pre>\n
I used the silent installer version. Just about that, be careful with the PROD argument,\u00a0ENTERPRISE_SERVER_EDITION is not supported anymore. You will have to change it with\u00a0DB2_SERVER_EDITION.<\/p>\n
After that, because your environment is DB2 9.7 version related, you will have to upgrade your environment. To do this, run the following command lines :<\/p>\n
cd \/opt\/IBM\/db2\/V10.5\/instance\r\n.\/db2iupgrade dsrdbm01<\/pre>\n
Where dsrdbm01 is my unix user running DB2. This may take a while, so just be patient :). When it’s done, just run the following command lines to verify your DB2 version :<\/p>\n
db2start\r\ndb2level<\/pre>\n
The output must correspond to DB2 version 10.5<\/p>\n
Upgrading Databases<\/h1>\n
When db2 version 10.5 is installed, you will have to upgrade your databases. To do this, just run the following command line for each of your database :<\/p>\n
db2 upgrade database <database-name><\/pre>\n
For example, in my case, I had 5 databases to upgrade :\u00a0dsrdbm01, GCD_DB, DESIGNDB, TARGETDB and NEXUSDB. So I had to run this command 5 times. The upgrade time is related to your database size, so it can take several minutes to do it.<\/p>\n
To configure the EXTENDED_ROW_SZ, you must execute the following command lines, on each database :<\/p>\n
db2 connect to <database name> user <database user>\r\ndb2 update db cfg using EXTENDED_ROW_SZ ENABLE<\/pre>\n
After that, the specific error\u00a0FNRCD0022E: DB_ROWLENGTH_LIMIT_EXCEEDED will not occurs anymore.<\/p>\n
Configuring WebSphere<\/h1>\n
After upgrading your DB2 component and all of your databases, don’t forget to change your DB2_JCC_DRIVER_PATH variable to change it from DB2 9.7 to DB2 10.5 ! When it’s done, you can test your datasource connections throught WebSphere.<\/p>\n
Optionnal, upgrading WebSphere<\/h1>\n
In my case, when I upgraded my DB2 version, I forget to upgrade all of my databases \ud83d\ude41 ! I just upgraded the dsrdbm01 database, and when I tried to connect to my datasources, I had a very specific SQL error. I firstly thought, before upgrading all of my databases, that this error was related to my WebSphere version (which was, unfortunately, WebSphere Application Server 8.5.5 with JAVA 6). I just had to follow the instructions specified in this specific IBM thread (c.f.\u00a0https:\/\/www.ibm.com\/support\/knowledgecenter\/en\/SSAW57_8.5.5\/com.ibm.websphere.installation.nd.doc\/ae\/tins_installation_jdk7_cl.html) using IBM Installation Manager to upgrade my WebSphere version to 8.5.5 fix pack 11, and installing java 7 in the same way.<\/p>\n
With all of this actions, I’m able to access my FileNet ObjectStores without any errors !<\/p>\n","protected":false},"excerpt":{"rendered":"
Today, I was confronted to a specific problem related to FileNet. When adding lots of properties \/ class definitions, and creation new property definitions to all my class definitions, FileNet (version 5.2.1 fix pack 6) just returns me an aggressive … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-101","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/posts\/101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/comments?post=101"}],"version-history":[{"count":6,"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/posts\/101\/revisions"}],"predecessor-version":[{"id":298,"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/posts\/101\/revisions\/298"}],"wp:attachment":[{"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/media?parent=101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/categories?post=101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/tags?post=101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}