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 10
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 10
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
Migrating Connections DB from Oracle to DB2 part 2
Fri, Nov 25th 2016 10
6 years a Champion !!
Thu, Dec 15th 2016 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
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 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
5 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
10
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
5
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