193 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
IBM Cloud migration and management Webinar
Mon, Feb 6th 2017 7
Want to go to IBM Connect .. be nice to a Champion for a discount
Thu, Jan 19th 2017 7
6 years a Champion !!
Thu, Dec 15th 2016 9
So Docs 2 CR1 and iFix 1 is not playing ball
Mon, Nov 28th 2016 5
Migrating Connections DB from Oracle to DB2 part 2
Fri, Nov 25th 2016 9
Migrating Connections DB from Oracle to DB2 part 1
Wed, Nov 23rd 2016 4
Is Verse on prem the end of Connections Mail?
Tue, Nov 22nd 2016 8
Top 10
FEB / Connections Surveys – custom LDAP attributes
Wed, Jul 1st 2015 11
Calling my developer friends
Tue, Apr 21st 2015 10
dandering for dosh -the story so far
Wed, Jun 4th 2014 9
It’s almost time for ENGAGE :)
Mon, Mar 21st 2016 9
A new challenge …
Tue, Jul 5th 2016 9
Migrating Connections DB from Oracle to DB2 part 2
Fri, Nov 25th 2016 9
6 years a Champion !!
Thu, Dec 15th 2016 9
Is Verse on prem the end of Connections Mail?
Tue, Nov 22nd 2016 8
MWLUG here I come
Fri, Aug 22nd 2014 7
Want to go to IBM Connect .. be nice to a Champion for a discount
Thu, Jan 19th 2017 7


Migrating Connections DB from Oracle to DB2 part 2
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
Sharon    

In part 2 of this series we will cover preparing the system and the commands and files required.

There is a fair bit of file creation to do and configuring of the Database Transfer Tool (DBT)

 

Migrating Connections DB from Oracle to DB2

Step 3 – Prepare a system to recieve the data

As I stated previously do not think you can recycle an existing Connections server if it has been installed with the DB type you are migrating away from as it causes issues with files particually.

In my case I had an existing V5 dev system using the test oracle DB. I backed it all up – Existing DB2 databases, Docs configuration files, file system (connections shared data) and docs/viewer shares – we will need this later.

Blow that system away and rebuild a clean, fresh V5 system – should only take a few hours 🙂

Once you have a clean V5 system – make sure it all works .. then back up the empty DBs and filesystem files.

Its essential that you know the system works before attempting to migrate data.

Step 4 – Prepare files and commands

4.1 Prepare the Database Transfer Tool

Create the DBT_HOME directory

On the db2 server create the DBT_HOME directory under <CONNECTIONS_ROOT>ConfigEnginelib

On my system this was D:IBMConnectionsConfigEnginelibDBT_HOME

Under DBT_HOME create additional directories of files to hold the xml files required for migration and logs for all logs relating to the migration

Locate the dbt.jar from the Connections machine (<CONNECTIONS_ROOT>ConfigEnginelib in my case  D:IBMConnectionsConfigEnginelib)  and copy it to the newly created DBT_HOME directory on the DB2 server.

 

Create the XML files required

Create an XML document for each application DB that is to be copied over and place it in the the DBT_HOMEfiles folder

D:IBMConnectionsConfigEnginelibDBT_HOMEfiles

Example below of the activites.xml :

<dbTransfer xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<database role="source"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@oracledbhost:port:dbinstancename"
userId="OAUSER"
schema="ACTIVITIES"
dbType="oracle"/>
<database role="target"
driver="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://db2host:50000/opnact"
userId="db2admin"
schema="ACTIVITIES"
dbType="DB2"/>
<table sourceName="activities.system_lastmod" exclude="true"/>
</dbTransfer>

 

The source in this example is is oracle the target is db2

Once completed you will have the follwing xml documents in the DBT_HOMEfiles directory

  • activities.xml
  • blogs.xml
  • dogear.xml
  • files.xml
  • forum.xml
  • homepage.xml
  • metrics.xml
  • mobile.xml
  • people.xml
  • sncom.xml
  • sncomcal.xml
  • wikis.xml

Ensure the DB drivers are accessible

It is essential that the oracle drivers are accessible by the DB2 (target) server.

Oracle driver & DB2 driver paths – we need these later.

D:IBMOracleojdbc6.jar
D:IBMSQLLIBjavadb2jcc.jar

 

V5 & V5.5 Wizards are required

When building the commands to migrate the DB some scripts are missing from the V5 Wizards directory. After speaking with IBM its safe to use the V5.5 wizard files for the missing scripts.

 

Replace the connections.sql scripts

Replace the SQL scripts given to you by IBM into the relevant directories .. in my case they were for files, wikis and blogs

 

4.2 Prepare the commands required

Prepare the commands for each DB  they will comprise of the following:

drop database, create database, app grants (for homepage also initdata, and re org and run stats)

CR update scripts

Pre DB fixer script

the DBT command string which has the following syntax

java -cp <path to DBT home>DBT_HOMEdbt.jar;<Oracle driver>ojdbc6.jar;<db2 driver>db2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir <path to DBT homelogs>DBT_HOMElogs -xmlfile <path to DBT homefiles>DBT_HOMEfiles<application xml>.xml -sourcepassword sourcepassword -targetpassword targetpassword

Application specific scripts (IBM provided addional fixup scripts for Blogs, Files and Wikis for me)

Post DB fixer script

Re org script

Run stats script

 

== Activities Example==

cd C:InstallTempConnectionsV5Wizardsconnections.sqlactivitiesdb2

db2 -td@ -vf dropDb.sql

db2 -td@ -vf createDb.sql

db2 -td@ -vf appGrants.sql

cd C:InstallTempConnectionsV5CR350cr3-database-updates50cr3-database-updatesFrom-50db2

db2 -td@ -vf 50-CR1-activities-db2.sql

cd C:InstallTempConnectionsV55connections.sqlactivitiesdb2

db2 -tvf predbxfer50.sql

cd C:InstallTempConnectionsV5Wizardsjvmwinjrebin

java -cp D:IBMConnectionsConfigEnginelibDBT_HOMEdbt.jar;D:IBMOracleojdbc6.jar;D:IBMSQLLIBjavadb2jcc.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir D:IBMConnectionsConfigEnginelibDBT_HOMElogs -xmlfile D:IBMConnectionsConfigEnginelibDBT_HOMEfilesactivities.xml -sourcepassword sourcepassword -targetpassword targetpassword


cd C:InstallTempConnectionsV55connections.sqlactivitiesdb2

db2 -tvf postdbxfer50.sql

cd C:InstallTempConnectionsV5Wizardsconnections.sqlactivitiesdb2

db2 -td@ -vf reorg.sql
db2 -td@ -vf runstats.sql

note: The RED section of the example script above should be run in a standard command window. The other scripts should be run from a db2cmd window.

 

I have a long list of commands in a text file that contains one of these blocks for each application a example of this can be downloaded here to use as a template for the syntax – note: that you should use this at your own risk, take advice from IBM and ensure that all the paths and passwords are set correctly before running.

One of the main reasons for dropping and creating manually is that the gui db wizards seem to have real issues – unsure why, but when we ran the db scripts manually they worked no issue – also there is an advantage that if we do see problems the script logs can be piped to a specific file. This was very helpful with all of the troubleshooting we had to do. If you do see issues with any of the commands they can be piped to a log to send to IBM – for example:

db2 -td@ -vf createDb.sql > C:Installtempactivities_createDb.txt

This was a lifesaver / timesaver for troubleshooting any db commands – as each command can be output to easily isolate what the issue is.

 

Step 5 – BACKUP

Before we start to do anything  we are going to make some backups. Stop the existing V5 DEV server now we know its working and back it up. Take a copy of the clean DBs (including additional DBs such as FEB for surveys, CONCORD for Docs and any 3rd party tool DBs such as PROJEXEC etc.)  and the file system (Connections datashared, docs share, viewer share etc.). In my case I had to prove that it was working prior to the DB migration so this back up was essential.

If you are going to run a test against your live systems data ensire that you also get a good back up of the file system when the system is down, if possible run the test when the live system is down (out of hours / on a weekend etc.) as the DB peice of the migration is very time consuming and you may need to troubleshoot issues.

The basic rule of thumb is treat this test like any normal Connections DB migration or update Stop it all and back it up.

 

What’s next?

Now we are all prepared .. we can attempt a test at the data migration .. check back in a few days for part 3 of Migrating Connections DB from Oracle to DB2 – where the fun really begins

The post Migrating Connections DB from Oracle to DB2 part 2 appeared first on Social Shazza.



---------------------
http://feedproxy.google.com/~r/socialshazza/~3/iHgsG_2P1sA/
Nov 25, 2016
10 hits



Recent Blog Posts
7
IBM Cloud migration and management Webinar
Mon, Feb 6th 2017 2:27p   Sharon Bellamy
I have the pleasure of giving another webinar on Wednesday at 4pm UK / 11 am EST – with my friend and IBMer Luis Guirigay We will be talking about migrating to the cloud and user management once you are there …. Join this webinar to learn more. Register here. Are you interested in running some or all of your messaging platform in the Cloud? Interested in IBM Verse? Worried about how to manage the user-lifecycle in a hybrid or cloud environment? Not sure about how or where to start?
7
Want to go to IBM Connect .. be nice to a Champion for a discount
Thu, Jan 19th 2017 11:01a   Sharon Bellamy
Being an IBM Champion is great and it does come with some benefits. Today all IBM Champions are happy to announce that we can offer YOU a discount of $100 for IBM’s upcoming ICS event – IBM Connect in San Francisco So what do you need to do – just reach out to an IBM Champion tell us why you want to go to Connect and what your expectations are and as if by magic we will give you the dscont code. Now is a great time to register .. and I wish I was going to be there with you all
9
6 years a Champion !!
Thu, Dec 15th 2016 11:24a   Sharon Bellamy
I recieved an email yesterday – just before I joined a live stream to watch the IBM Champions for ICS be announced. On behalf of IBM, it is my great pleasure to recognize you as a returning IBM Champion in 2017. Congratulations! I am so honoured to be amongst a great group of champions again. I have been an ICS IBM Champion since the program began in 2011. Being an IBM Champion is all about being part of a great extended  community, sharing knowledge, giving feed back and constructive c
5
So Docs 2 CR1 and iFix 1 is not playing ball
Mon, Nov 28th 2016 2:46p   Sharon Bellamy
I knew that some of our community had seen issues with applying Docs 2 CR1 and the accompanying iFix, so I purposely held off applying it. But low and behold on Saturday afternoon when I did attempted to install CR1 I had problems. The Docs and Viewer applications deployed without issues, but the Conversion server had these errors: WASX7303I: The following options are passed to the scripting environment and are available as arguments that are stored in the argv variable: "[remote_install_a_vers
10
Migrating Connections DB from Oracle to DB2 part 2
Fri, Nov 25th 2016 12:12p   Sharon Bellamy
In part 2 of this series we will cover preparing the system and the commands and files required. There is a fair bit of file creation to do and configuring of the Database Transfer Tool (DBT) Migrating Connections DB from Oracle to DB2 Step 3 – Prepare a system to recieve the data As I stated previously do not think you can recycle an existing Connections server if it has been installed with the DB type you are migrating away from as it causes issues with files particually. In my case I
4
Migrating Connections DB from Oracle to DB2 part 1
Wed, Nov 23rd 2016 10:58a   Sharon Bellamy
For those of you that follow me on twitter, you will have noticed that I have posted a number of tweets relating to a fun project I am working on. I have been working with a customer to move them from Connections 5 to Connections 5.5 – Not a massive issue – EXCEPT they are currently using Oracle for the Connections DB and they can not upgrade it to the version required by 5.5 for quite some time, as most of their business systems require the version of Oracle currently running. This
8
Is Verse on prem the end of Connections Mail?
Tue, Nov 22nd 2016 11:41a   Sharon Bellamy
A technote has come to light – marking the end of life for Connections Mail https://www-01.ibm.com/support/docview.wss?uid=swg21993196 The content states November 2016 is the end of support for the following versions of ICM V 1.0 (for Connections 4.0), and version 1.3 (for Connections 4.5). End of support for ICM 1.6 (for connections 5.0) will be one year from the publication of this TechNote, November 17, 2017. We intend continue to support the latest version of the plug in, 1.7 with C
6
Sutol, Pokemon and an awesome time
Fri, Nov 18th 2016 4:55p   Sharon Bellamy
As blogged over on the BCC page .. a round up of Sutol with some extra Shaz related bits  Last week we were in the beautiful city of Prague for the 8th annual SUTOL Czech user group. It was a small affair with approx. 100 attendees – making it more like an extended family gathering, which actually worked really well. The sessions were well attended and there seems to be a chunk of Czech business that already have hybrid and cloud environments and are uses of IBM Connections. The Keynote: L
4
SUTOL Presentations
Thu, Nov 17th 2016 2:51p   Sharon Bellamy
I was lucky enough to be selected to speak at the 8th SUTOL conference which was held in the beautiful city of Prague. A round up blog post is coming. In the meen time please find below the slides from the presentations given with Wannes Rams & Roberto Boccadoro Sutol – A Hitchhiker’s Guide to troubleshooting IBM Connections from Sharon Bellamy James Sutol How To Be A Lion Tamer from Sharon Bellamy James The post SUTOL Presentations appeared first on Social Shazza.
5
So much going on
Tue, Nov 15th 2016 12:11p   Sharon Bellamy
I know its been quiet here but that is because I have been a little busy with the new job at BCC .. which is great .. I love to be busy so what I have I been doing .. Starting at BCC which is awesome, I have been to MWLUG and spoke their again which was also great, We had ICONUK which was much fun (if a little stressful for the organisation team), Run a 5k and raised over £1,000 for charity, and I have been to SUTOL in Prague – all this and the day job at BCC BUT I do have lots to blog o




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition