IBM published the document for migrate your DB2 data (like SSC policies or Meeting DB) to the new Sametime 9 enviroment.<\/p>\n
You can either stay on DB2 Version 9.5 (Sametime 8.5.0\/8.5.1) or 9.7 (Sametime 8.5.2) or you can upgrade DB2 to Version 10.1 (see the IBM statement)<\/p>\n
„Please note that none of the deprecated or discontinued features in 10.1 have a direct impact on Sametime deployments.“<\/span><\/p><\/blockquote>\n
Here is a „shorcut“ for the steps<\/p>\n
Because IBM references directly to the DB2 documentation i will give you a indeep migration step.<\/em><\/span><\/p>\n
Keep Sametime Community Server before upgrading<\/strong><\/p>\n
\n
- unregister ST Community Server(s)\/MUX from ST System Console\n
\n
- check entries in\u00a0 …\/domino\/console\/productconfig.properties & console.properties<\/li>\n
- …\/domino\/console\/unregisterproduct.bat<\/strong> <\/span>> should remove ST Community Server from SSC<\/li>\n
- Deregistration will you disconnet from SSC policies and policies in stpolicy.nsf will take place !!!<\/span><\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
Uninstall Sametime 8.5.2.x enviroment
\n<\/strong><\/p>\n\n
- Start Installation Manager and deinstall all components within<\/li>\n
- Deinstall Installation Manager 1.4.2<\/li>\n
- Delete or Move kept Installation folder \\Websphere\\*<\/li>\n<\/ol>\n
in-place DB2 Server Upgrade to Version 10.1 (or you can stay on Version 9.5 or 9.7)<\/span>
\n<\/strong><\/p>\n\n
- Check if databases are DB2 V10.1 compatible\n
\n
- Extract DB2 V10.1 Installation package<\/li>\n
- C:\\install\\db2v10setup<\/span>\\WSER\\image\\db2\\Windows\\utilities\\db2ckupgrade.exe STMS -L c:\\db2.log -u db2admin -p passwort<\/span>
\nMessage should be like this >> DBT5508I\u00a0 The db2ckupgrade utility completed successfully. The database or databases can be upgraded.<\/span><\/em><\/li>\n<\/ul>\n<\/li>\n- Check\/Show DB2 instances C:\\IBM\\SQLLIB\\BIN>db2ilist<\/strong><\/span><\/li>\n
- Install\/Update DB2 to Version 10.1<\/li>\n
- Install DB2 NetExtender Addon<\/li>\n<\/ol>\n
Upgrade DB2 database(s) to Version 10.1<\/strong><\/p>\n
\n
- Drop\/Disconnet all connections to DB2\n
\n
- C:\\IBM\\SQLLIB\\BIN>db2stop force<\/strong> <\/span>\u00a0 \u00a0>>> Disconnects all users and stops the instance
\nSQL1064N\u00a0 DB2STOP processing was successful.<\/em><\/span>
\nC:\\IBM\\SQLLIB\\BIN>db2 terminate<\/strong><\/span> \u00a0 >>> Terminates back-end process
\nDB20000I\u00a0 The TERMINATE command completed successfully.<\/em><\/span><\/li>\n<\/ul>\n<\/li>\n- Check if upgrade of DB2 is needed\n
\n
- C:\\IBM\\SQLLIB\\BIN>db2level<\/span><\/strong>
\nDB21085I\u00a0 Instance „DB2“ uses „64“ bits and DB2 code release „SQL10010“ with<\/span><\/em>
\n level identifier „0201010E“.<\/span><\/em>
\n Informational tokens are „DB2 v10.1.0.872“, „s120403“, „NTX64101“, and Fix Pack \u00a0„0“.<\/span><\/em>
\n Product is installed at „C:\\IBM\\SQLLIB“ with DB2 Copy Name „DB2COPY1“.<\/span><\/em><\/li>\n- Otherwise use C:\\IBM\\SQLLIB\\BIN>db2iupgrade DB2 \/u:db2admin.password<\/span><\/strong><\/li>\n<\/ul>\n<\/li>\n
- Upgrade Sametime DB2 database – otherwise you get the error message „The database must be upgraded to the current release.<\/span><\/em>“\n
\n
- C:\\IBM\\SQLLIB\\BIN>db2 upgrade database STMS
\n<\/b><\/span><\/li>\n- C:\\IBM\\SQLLIB\\BIN>db2 upgrade database STADV<\/b><\/span><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n
System Console<\/strong> (you will loose all your configuration, so you have to document it first and then reasign it to the new SSC<\/span>)<\/p>\n
==> NOVI recommendation<\/span>: Write down all Policy Settings and recreate the settings in the new STSC DB in Sametime 9 SSC<\/strong><\/em><\/span><\/p>\n
\n
- >>> Miss Step 1 & 4
\n<\/em><\/span><\/strong><\/li>\n<\/ul>\n\n
- Export Policy Tables POLICY.TEMPLATE & POLICY.ASSIGNMENT from ST 8.5 SSC<\/li>\n
- Backup\/Delete old STSC database\n
\n
- Backup\/Rename STSC database if needed\n
\n
- create db2rename.cfg<\/span><\/strong> file manually
\n\u00a0\u00a0 DB_NAME=STSC,STSC85<\/span><\/em>
\n\u00a0\u00a0 DB_PATH=c:\\<\/span><\/em>
\n\u00a0\u00a0 INSTANCE=DB2<\/span><\/em>
\n\u00a0\u00a0 NODENUM=0<\/span><\/em><\/li>\n- C:\\IBM\\SQLLIB\\BIN>db2stop<\/strong><\/span><\/li>\n
- C:\\IBM\\SQLLIB\\BIN>db2relocatedb.exe -f c:\\install\\db2rename.cfg<\/span><\/strong>
\nFiles and control structures were changed successfully.Database was catalogued successfully.DBT1000I\u00a0 The tool completed successfully.<\/em><\/span><\/li>\n<\/ul>\n<\/li>\n- Delete STSC database\n
\n
- C:\\IBM\\SQLLIB\\BIN>db2 drop database STSC<\/b><\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
- Create a NEW SSC Database (e.g. STSYCON)<\/li>\n
- Import Policy Tables into ST 9 SSC
\n>> Just check before if you need this step or if it is faster to recreate the policies again<\/span><\/em><\/li>\n- Install new Sametime 9 System Console Server (with the new STSYSCON DB)\n
\n
- Install Installation Manager 1.6.2 (IM)<\/li>\n
- Import Websphere 8.5.5 & WAS iFixes for Sametime into IM<\/li>\n
- Install Websphere without config<\/li>\n
- Install ST System Console Server<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n
Meeting Server<\/strong><\/p>\n
==> If you change the DB2 to other operating system you have to move the db2 completly – see this link about it
\n<\/strong><\/em><\/p>\n\n
- Update schema for Meeting DB to get new tables for the Sametime 9 features
\n>> C:\\install\\st9meetingsetup<\/span>\\….DatabaseScripts\\….\\applyDDLUpdate.bat migration_meetingServer_85x-90.dll STMS db2admin<\/strong><\/span><\/em><\/li>\n- Add the Meeting DB to the Sametime Configuration Application (deployment plan)<\/li>\n
- Create a new Meeting Server deployment plan and add the existing Meeting DB<\/li>\n
- Install new Sametime 9 Meeting Server\n
\n
- Install Installation Manager 1.6.2 (IM)<\/li>\n
- Import Websphere 8.5.5 & WAS iFixes for Sametime into IM<\/li>\n
- Install Websphere without config<\/li>\n
- Install ST Meeting Server<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n
Proxy Server<\/strong><\/p>\n
\n
- Shut down the Sametime 8.5.x\u00a0Proxy Server to get exclusiv access to the Proxy DB<\/li>\n
- Drop the Proxy DB and create a new Proxy DB with the Sametime 9 database script
\n!!! Please use the database create scripts from the actual Sametime proxy package – otherwise you will loose tables you need !!!<\/span>
\nI had to learn this the hard way because i used the db scripts from 9.0 gold release with the 9.0 Fix1 :-((<\/li>\n- Add the\u00a0Proxy DB to the Sametime Configuration Application (deployment plan)
\nTHATS a NEW one (in ST 8.5 you had to start db2 scripts yourself)<\/li>\n- Create a new\u00a0Proxy Server deployment plan and add the existing Proxy DB<\/li>\n
- Install new Sametime 9\u00a0Advanced Server\n
\n
- Install Installation Manager 1.6.2 (IM)<\/li>\n
- Import Websphere 8.5.5 & WAS iFixes for Sametime into IM<\/li>\n
- Install Websphere without config<\/li>\n
- Install ST Proxy Server<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n
Advanced Server<\/strong><\/p>\n
\n
- Shut down the Sametime 8.5.x Advanced Server to get exclusiv access to the Advanced DB
\nNO SCHEMA UPDATE NEEDED<\/span><\/li>\n- Add the\u00a0Advanced DB to the Sametime Configuration Application (deployment plan) and add 3 NEW tables manually\n
\n
- \nINSERT INTO ORGCOL.PC_SETTING (SETTING_NAME,SETTING_TYPE,SETTING_VALUE) VALUES (‚admin.only.delete‘, 3, ‚false‘);<\/span><\/em><\/address>\n<\/li>\n
- \nINSERT INTO ORGCOL.PC_SETTING (SETTING_NAME,SETTING_TYPE,SETTING_VALUE) VALUES (‚remove.invalid.members‘, 3, ‚true‘<\/span><\/em><\/address>\n<\/li>\n
- \nINSERT INTO ORGCOL.PC_SETTING (SETTING_NAME,SETTING_TYPE,SETTING_VALUE) VALUES (‚wildcard.search.enabled‘, 3, ‚false‘);<\/span> <\/em><\/address>\n<\/li>\n<\/ul>\n<\/li>\n
- Create a new\u00a0Advanced Server deployment plan and add the existing\u00a0Advanced DB<\/li>\n
- Install new Sametime 9\u00a0Advanced Server\n
\n
- Install Installation Manager 1.6.2 (IM)<\/li>\n
- Import Websphere 8.5.5 & WAS iFixes for Sametime into IM<\/li>\n
- Install Websphere without config<\/li>\n
- Install ST Advanced Server<\/li>\n<\/ul>\n
!!! If you restricted the ST Advanced Users because of license limitation in version 8.5\u00a0 you have to change manually <\/span><\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 the table: ORGCOL.LICENSE<\/span><\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 the parameter: LIC_COUNT<\/span><\/em>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 set from the number counted to ZERO (0)<\/span><\/em><\/li>\n<\/ol>\nThe documentation also shows how you could change the data sources (e.g. for testing) for DB2 databases.
\nI think that is a bad idea<\/span> <\/em>because the DB name is also referenced inside the SSC application DB<\/span> (see deployment name) and this could be a problem for further updates !!!<\/p>\n","protected":false},"excerpt":{"rendered":"IBM published the document for migrate your DB2 data (like SSC policies or Meeting DB) to the new Sametime 9 enviroment. Sametime 8.5.2.x Migration to Sametime 9 Migrating from Sametime 8.5.2x (Wiki Doku) You can either stay on DB2 Version 9.5 (Sametime 8.5.0\/8.5.1) or 9.7 (Sametime 8.5.2) or you can upgrade DB2 to Version 10.1 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101],"tags":[102],"class_list":["post-164","post","type-post","status-publish","format-standard","hentry","category-sametime","tag-sametime"],"_links":{"self":[{"href":"https:\/\/blog.novaknet.de\/index.php?rest_route=\/wp\/v2\/posts\/164"}],"collection":[{"href":"https:\/\/blog.novaknet.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.novaknet.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.novaknet.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.novaknet.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=164"}],"version-history":[{"count":12,"href":"https:\/\/blog.novaknet.de\/index.php?rest_route=\/wp\/v2\/posts\/164\/revisions"}],"predecessor-version":[{"id":251,"href":"https:\/\/blog.novaknet.de\/index.php?rest_route=\/wp\/v2\/posts\/164\/revisions\/251"}],"wp:attachment":[{"href":"https:\/\/blog.novaknet.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.novaknet.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.novaknet.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}