198 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
Issues with IBM Connections 5 / 5.5 and Chrome 60
Fri, Aug 18th 2017 4
Connections 6 migration observations
Tue, Jul 25th 2017 5
It’s that time of year again ..
Fri, Jun 16th 2017 4
Let’s get Stitch talking – Project #talkie pt 3
Mon, Jun 5th 2017 3
Building the AIY – Project #talkie pt2
Sat, May 27th 2017 6
Who knew my love for StarWars would win me a prize
Sat, May 27th 2017 4
Project #talkie pt1 – getting to grips with a rasberrypi
Sat, May 27th 2017 5
Top 10
MWLUG here I come
Fri, Aug 22nd 2014 8
FEB / Connections Surveys – custom LDAP attributes
Wed, Jul 1st 2015 8
So Docs 2 CR1 and iFix 1 is not playing ball
Mon, Nov 28th 2016 7
Building the AIY – Project #talkie pt2
Sat, May 27th 2017 6
Speaking at Engage
Fri, Feb 14th 2014 5
Please sponsor us Dandering for Dosh
Fri, Apr 25th 2014 5
Registration for ICONUK now open
Thu, May 1st 2014 5
Project #talkie pt1 – getting to grips with a rasberrypi
Sat, May 27th 2017 5
Connections 6 migration observations
Tue, Jul 25th 2017 5
dandering for dosh -the story so far
Wed, Jun 4th 2014 4


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

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 has been a pain .. like you wouldn’t believe .. what should be a simple process has turned into the project from hell!! BUT I am not one to throw the towel in so we have persevered. I must say I was not overly enthused by some of the issues and mistakes that have been made on our side and IBMs but we do have light at the end of the tunnel.

I am going to work through a series of Blog posts to help anyone else who needs to do this ..

Migrating Connections DB from Oracle to DB2

Overview

  1. Open a PMR – you will need specific help from IBM as this is an unsupported action – they will help you though. Be VERY specific and clear in exactly what you are trying to achieve as it can lead to confussion.
    • State the version of the DB you are moving from – in this case Oracle 11.2 on AIX
    • State the version of the DB are moving too – DB2 10.1 on Windows
    • State why you are doing this – as this is important for justifying the support time to help. In our case the customer is a current Connections 5 and Docs user, we have a requirement to upgrade Connections to  V5.5 to take advantage of the new features. As Connections 5.5 requires Oracle 12 and the customer can not update the underlying oracle system a move to DB2 is the best course of action. DB2 for Connections will be managed independantly from the rest of the applications.
    • Test the migrated Oracle data with DB2 and Connections 5 to ensure the system is working as expected.
    • Migrate the tested data to Connections 5.5
    • Then do it for real in live
  2. Make sure you have data to test – in our case there is a Connections 5 dev environment pointing to an oracle DB.
  3. Prepare a system to recieve the data – The Connections 5 dev system already had the correct version of DB2 installed as we were using IBM Docs and FEB (for Connections Surveys). We simply created the additional Connections 5 DBs on the dev machine ready to accept the data.
  4. Get good BACKUPS – Backup the clean Connections 5 DBs before attempting to migrate you may need to roll it back, also ensure you back up any existing DBs you have (such as CONCORD for Docs or FEB for Surveys).
  5. Become familiar with the DBT – The Database Transfer Tool is the only way to get the data out of one system and into another. There are files to prepare and commands to comprise. Have a good text editor, with tabs, you will need it – notepad isn’t going to cut it.
  6. Be preapred for multiple attempts – There is a lot of trail and error and fixing issues and trying again. This is not a one time deal.
  7. Logs and SQL queries – There will be a lot of looking at logs and running SQL queries, editing the create db scripts and running again. If you aren’t comfortable with that find someone to help you as you will be by the time we are done.

Things to note

I assumed that becuase I already have a DEV version 5 Connections system I could use that. Create new DBs, migrate the data, switch the datasources to the new database and we should be good – NO – THAT DOESN’T WORK!!

When Connections is installed and you select the type of DB that you are installing against, that is hardcoded somewhere in a config that we couldn’t find .. we WASTED SO MUCH TIME trying to get that sorted and eventually had to give up and reinstall.

If you have an existing system – BACK IT UP, blow it away and reinstall. Don’t waste time and effort trying to fix it .. files will not work.

 

Step 1 – Open a PMR

You MUST do this. IBM will help you even though they do not officially support moving DB types and OS’s. It is much easier if you are staying on the same OS or same DB type, but moving both isn’t fun. This should theoretically be a once only deal – once moved from Oracle AIX to Windows DB2 there will be no going back.

As I stated in the overview be VERY specific and explain exactly what you are trying to achieve. Give IBM the exact DB versions with fixes so they can give you new versions of any DB create scripts they need. In my case Files, Wikis and Blogs needed significant changes to the database create scripts. IBM also sent additional scripts for the fixup post migration so ensure you have those. Back up the original connections.sql folder under the V5 wizards directory (connections.sql.backup in my case) and add any changes to connections.sql.

 

Step 2 – Test data

Make sure you have data to test with. Initially I used the Connections 5 DEV system to test but have since moved on to live data, but the test data has to be from a working system so you can compare.

You must have access to read and write to the DBs as this is required to actually migrate the data. Back up the file system to copy the shared data over.

There may also be differences in data between your live and dev systems so be prepared to edit scripts again and keep copies of all the scripts and workings out you have done.. it will help you document it (yes I said the D word .. Write it all down, you will thank me for it later).

 

Come back for Part 2 in a couple of days where we will actually prepare the system and write everything we need to actually get on and do the data migration.

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



---------------------
http://feedproxy.google.com/~r/socialshazza/~3/v8L_b3TolcE/
Nov 23, 2016
4 hits



Recent Blog Posts
4
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
5
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
4
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
3
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
6
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
5
Project #talkie pt1 – getting to grips with a rasberrypi
Sat, May 27th 2017 9:45p   Sharon Bellamy
What’s all this #talkie stuff about then? So I have been posting stuff on facebook twitter and instragram with the #projecttalkie or #talkie hash tag .. Most of you know that I costume .. and as well as my love for star wars (and my mandalorian costume), I also LOVE to costume as Stitch … You can see me here as my favourite fluffy blue alien experiment (626) with my good pal and all around lovely Captain America friend Mr James Budd. Again most of you know that i am a HUGE supporte
1
Migrating Connections DB from Oracle to DB2 part 3
Sat, May 27th 2017 8:48p   Sharon Bellamy
In part 3 of the series we will actually attempt to migrate the data. Migrating Connections DB from Oracle to DB2 In my experience the database migration is always most time consuming, so I always do the database first Use the text file of Commands that we created in part 2. Back up the exisitng Connections databases Drop database, create database, app grants (for homepage also initdata, and re org and run stats) CR update scripts Pre DB fixer script Run the DBT command Application specific s
1
Docs 2.0 CR2 – here we go again
Sat, May 27th 2017 8:05p   Sharon Bellamy
I am blogging this mainly so I remember how to solve this Big thanks to fellow ICS community member and all round great guy Robert Farstad for blogging this Again you can see a problem when patching Docs 2 to CR2 as it can’t find the FQDN of the hosts. The code has changed so it’s not possible to use the work around that we had previously. There is a slight twist to getting it to work which Rob has explained fabulously so thank you mate .. you saved me a lot of grief .. and even IBM
2
Connections 6 system requirements are available
Wed, Mar 29th 2017 2:21p   Sharon Bellamy
thanks to my friend and co-speaker Roberto Boccadoro for sharing these .. you can find the system requirements for Connections 6 here The basic info is: WAS 8.5.5.10 IBM install manager 1.8.5 DB2 11.1.0 / Oracle 12.1.0.2.0 (enterprise) / MS SQL 2016 TDI 7.1.1 fix pack 6 Connections 6 is going to be released on Friday 31st of March – happy downloading and installing The post Connections 6 system requirements are available appeared first on Social Shazza.




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