202 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
Connections Engagment Center coming to Connections Cloud
Tue, Nov 28th 2017 16
Connections 6 CR1 is now available
Wed, Nov 22nd 2017 9
Version 10 and beyond – I Aint Dead
Fri, Nov 3rd 2017 2
IBM Docs 2 CR3 is here – and with some cool new features
Tue, Oct 31st 2017 5
Issues with IBM Connections 5 / 5.5 and Chrome 60
Fri, Aug 18th 2017 8
Connections 6 migration observations
Tue, Jul 25th 2017 3
It’s that time of year again ..
Fri, Jun 16th 2017 9
Top 10
Connections Engagment Center coming to Connections Cloud
Tue, Nov 28th 2017 16
Building the AIY – Project #talkie pt2
Sat, May 27th 2017 10
It’s that time of year again ..
Fri, Jun 16th 2017 9
Connections 6 CR1 is now available
Wed, Nov 22nd 2017 9
Can you spare an item to help raise money for two amazing causes?
Wed, Jan 13th 2016 8
So Docs 2 CR1 and iFix 1 is not playing ball
Mon, Nov 28th 2016 8
Let’s get Stitch talking – Project #talkie pt 3
Mon, Jun 5th 2017 8
Issues with IBM Connections 5 / 5.5 and Chrome 60
Fri, Aug 18th 2017 8
Is Verse on prem the end of Connections Mail?
Tue, Nov 22nd 2016 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
2 hits



Recent Blog Posts
16
Connections Engagment Center coming to Connections Cloud
Tue, Nov 28th 2017 3:16p   Sharon Bellamy
IBM have announced (see announcement here), that Connections Engagement Center will be coming to Connections Cloud from the 30th of Novemember. Having used CEC On-Premises for sometime I know this is going to be a massive enhancement for Connections Cloud users. As with the On-Premises version it will be a seperately priced add-on for Cloud S1 and S2 subscriptions. Want to learn more about CEC for Connections Cloud? Register for a webinar run by Alan Hamilton & Thierry Batut which is running
9
Connections 6 CR1 is now available
Wed, Nov 22nd 2017 2:07p   Sharon Bellamy
As promised by IBM we have got it in November (so thanks Connections Team ) … The full Fix list can be found in this technote here – IBM Fix List for Connections CR1 You can download it from Fix Central here – IBM Connections 6 CR1 download Included in CR1 are all the day 1 fixes and the fixpacks from June – along with a bunch of other fixes, enhancements and preperations for Connections Pink Current Status – Patching Dev will let you know if i see any issues. Th
2
Version 10 and beyond – I Aint Dead
Fri, Nov 3rd 2017 2:15p   Sharon Bellamy
You are a Connections / WebSphere admin what do you care about Domino? I hear people ask – well actually I care a lot .. I use these products every day – I can’t do my job with out Domino / Verse / Notes and Sametime. After what can only be described as a lack of love for the Domino/Notes stack IBM have made a HUGE announcement in partnering with the development team at HCL Technologies to bring a new version to the beloved Domino stack. IBM signs strategic partnership with HCL
5
IBM Docs 2 CR3 is here – and with some cool new features
Tue, Oct 31st 2017 12:10p   Sharon Bellamy
So at last IBM Docs 2 CR3 has been released and with it some awesome new features that the community have been asking for (thank you IBM). What’s new in Docs 2 CR3? LOADS of new features and fixes including … The most exciting is probably the ability to deploy the Conversion server on linux (finally)!! You can directly deploy Conversion server on Linux when installing IBM Docs. If you already have IBM Docs installed with Conversion server on Windows, you can migrate existing Conve
8
Issues with IBM Connections 5 / 5.5 and Chrome 60
Fri, Aug 18th 2017 9:58a   Sharon Bellamy
There is a known issue with Connections 5 CR4 and all versions of Connections 5.5 when using Chrome version 60. It affects events not being displayed and errors relating to events in the UI. It has also been reported that comments can be affected also. After multiple BP’s and Customers reported this IBM Support have come up with a fix very quickly. The fix you need is IFLO92844 – currently it is only available from IBM support – not sure how long it will be until it is availabl
3
Connections 6 migration observations
Tue, Jul 25th 2017 4:00p   Sharon Bellamy
I am sure that lots of you have installed or started migrations to Connections 6 by now .. but I have found a couple of gotchas across the installs and updates that I have managed so far. I am listing them here for sanities sake as I know when we google an error – this blog will show up Connections 6 itself Generally this was a nice smooth install and all worked as it should in a clean 6 environment On testing a migration though I found issues when trying to migrate some of the DBs. A
9
It’s that time of year again ..
Fri, Jun 16th 2017 5:38p   Sharon Bellamy
I am Running for Feel the Force Day …. My partner in crime Sam will be joining me again this year, along with Jonathan and Mandy will make up the #TeamRun4FTFD to raise funds. Jonathan has cerebal palsy and he doesn’t let that slow him down. Mad on trucks, cars and any kind of awesome vehicle (just see Shaw on Tour for details), he has recently done a bunch of exciting stuff including running (in a race chair), ice skating and trampolining. Mandy is the biscuit queen Famous for her
8
Let’s get Stitch talking – Project #talkie pt 3
Mon, Jun 5th 2017 2:41p   Sharon Bellamy
So after building the kit and testing that it worked .. It was time to get creative .. there are some examples on what to do code wise on the AIY kit voice site First I had to go through the billing set up and processes. Even though the code is free, and the kit is free and they give you $300 worth of credit – you still have to set up billing. It was a pain as I already had a cloud dev account for some of the APIs I use on bit of my sites, but eventually I worked it out – I may have
10
Building the AIY – Project #talkie pt2
Sat, May 27th 2017 11:55p   Sharon Bellamy
Before I could attempt to get creative with the code examples – we first had to build the kit and make sure it worked with the things and code that was provided. I have used the images from the aiyprojects.withgoogle.com/voice page. They are great pictures and show step by step how to put things together, I may have forgotten to take step by step pics as we built it too. Prep the SD Card With the voice SD image we downloaded in pt1 – use etcher to flash the SD card and get it ready f
4
Who knew my love for StarWars would win me a prize
Sat, May 27th 2017 10:29p   Sharon Bellamy
On May the 4th (also known as StarWars day – you work it out) one of my good friends and former co worker (not sure how he put up sitting opposite me for 2 and a half years ) Mr Dave Sheryn pinged me with an interesting link to a starwars costume competition .. “That’ll be fun”, I thought, “will give it ago .. have a snowballs chance in hell of winning” – so I posted this pic of me With the message O well if we are showing off star wars costumes .. thi




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