197 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
User provisioning for IBM Connections Cloud – You have the choice
Mon, Aug 28th 2017 4
SAML & IBM Connections 5.5 – not a dream team
Fri, Aug 18th 2017 6
IBM Docs – Migration from DB2 –> ORACLE
Fri, Jul 7th 2017 6
IBM Connections – trouble adding additional nodes
Wed, May 31st 2017 3
SNOUG 2017 Presentation – SikaConnect goes External
Thu, Mar 23rd 2017 2
Whiteboard in IBM Sametime Meeting 9.0.1 removed
Fri, Mar 17th 2017 2
Wikis content not accessible…
Thu, Jan 26th 2017 4
Top 10
DB2 Instance autostart does not work on SLES 12 / RHEL 7
Tue, Jul 12th 2016 14
Security Bulletin: Vulnerabilities in Apache Struts affects IBM WebSphere Application Server (CVE-2016-1181 and CVE-2016-1182) (2016.06.28)
Tue, Sep 13th 2016 13
CCM – Problems accessing libraries using Domino LDAP
Mon, Nov 17th 2014 10
Security Bulletin: IBM Connections Security Refresh for CVE-2016-2954, CVE-2016-2956,CVE-2016-3008
Tue, Sep 13th 2016 10
Configuration of secret key storage in WebSphere Application Server
Thu, Mar 12th 2015 9
What would you expect from an IBM Connections / Sharepoint integration?
Wed, Jul 29th 2015 9
IBM Open Batch program – IBM Champion
Tue, Mar 22nd 2016 9
IBM Connections 5.5 – Problem with ibm_upload_module and NFS
Mon, Jul 4th 2016 9
Automatic modification of WebSphere Plugin (Primary / BackupServers) to maintain two-line concept
Wed, Jul 6th 2016 9
IBM Connections Docs – file preview not possible for some CCM pdf files
Thu, Nov 17th 2016 9


IBM Docs – Migration from DB2 –> ORACLE
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
Julius Schwarzweller    

IBM Docs – Migration from DB2 –> ORACLE

Hi,

within our last big project, we had the challenge to transfer the IBM Docs database from DB2 to ORACLE. Within this database comments and other document related data is stored.

Officially there is no script available to perform this move using DBT (remove constraints / transfer / reapply constraints). We looked into the database and figured out how to perform this task using DBT – so we are not dependent on any other products. We migrated from DEV (IBM Docs CR1) to PROD (IBM Docs CR1)

The following procedure is officially NOT supported by IBM:

1.Create the source databases on ORACLE

sqlplus "USER/PWD@ORACLE_SID"
 @createDb.sql
 ./updateDBSchema.sh

 #UPDATE TO 2.0 CR1
 updateDBSchema.sh

2.Drop constraints

 DELETE FROM CONCORDDB.PRODUCT;
 ALTER TABLE CONCORDDB.TASK DROP CONSTRAINT CONSTRAINT_TASK;
 ALTER TABLE CONCORDDB.TASKHISTORY DROP CONSTRAINT CONSTRAINT_TASKHIS;

3. Create dbt transfer xml file (Oracle RAC config taken into consideration in this example):

<dbTransfer xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<database role="source"
driver="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://DB2_SERVER:50001/CONCORD"
userId="docinst1"
schema="CONCORDDB"
dbType="DB2"/>
<database role="target"
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ORACLE_SERVER_1)(port=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=ORACLE_SERVER_2)(port=1521)))(FAILOVER=on)(LOAD_BALANCE=off)(CONNECT_TIMEOUT=10)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORACLE_SID)))"
userId="DOCSUSER"
schema="CONCORDDB"
dbType="oracle"/>
</dbTransfer>

4.Transfer the data

6.0-Wizards/jvm/linux/jre/bin/java -Xms3072m -Xmx8192m -cp /MIGRATION/_DOCS/DBT_HOME/dbt.jar:/MIGRATION/_DOCS/DBT_HOME/jdbc/ojdbc7.jar:/MIGRATION/_DOCS/DBT_HOME/jdbc/db2jcc4.jar com.ibm.wps.config.db.transfer.CmdLineTransfer -logDir /MIGRATION/_DOCS/DBT_HOME/logs -xmlfile /MIGRATION/_DOCS/DBT_HOME/concord.xml -sourcepassword xxx -targetpassword xxx

5.Reapply the constraints

ALTER TABLE CONCORDDB.TASK ADD CONSTRAINT CONSTRAINT_TASK FOREIGN KEY (ASSOCIATION_ID) REFERENCES CONCORDDB.ASSOCIATEDWITH (ASSOCIATION_ID) ON DELETE CASCADE;
ALTER TABLE CONCORDDB.TASKHISTORY ADD CONSTRAINT CONSTRAINT_TASKHIS FOREIGN KEY (TASK_ID) REFERENCES CONCORDDB.TASK (TASK_ID) ON DELETE CASCADE;

That`s it

All content was available during our tests and we created an easy and reproducible procedure when transferring databases from one to the other vendor.



---------------------
http://techblog.gis-ag.info/2017/07/07/ibm-docs-migration-from-db2-oracle/
Jul 07, 2017
7 hits



Recent Blog Posts
4
User provisioning for IBM Connections Cloud – You have the choice
Mon, Aug 28th 2017 1:42p   GIS Techblog
User provisioning for IBM Connections Cloud – You have the choice Customers who use IBM Cloud for Connections, Sametime or other applications face the problem to manage their cloud accounts. For some single users you can use the Web frontend to add or change user accounts or to assign subscriptions and licenses to users. But in real world scenarios it is not possible to manage thousands of users manually or to keep them synchronized with an on-prem user repository or LDAP. This can be handled
6
SAML & IBM Connections 5.5 – not a dream team
Fri, Aug 18th 2017 7:45a   GIS Techblog
Hi all, last week we had to fight with an activation of SAML on a IC 5.5 CR3 environment. The setup was: IBM Connections 5.5 CR3 as test instance ADFS Server 3.0 (I know… it is only tested with ADFS 2.0 – but works with 3.0 too) We followed the instructions from the IBM Connections Knowledge Center. Smooth setup everything standard procedure. When testing this setup, the redirect to the IdP was initiated. After logging into the IdP the browser was redirected to IBM Connections ACS
7
IBM Docs – Migration from DB2 –> ORACLE
Fri, Jul 7th 2017 9:52a   GIS Techblog
IBM Docs – Migration from DB2 –> ORACLE Hi, within our last big project, we had the challenge to transfer the IBM Docs database from DB2 to ORACLE. Within this database comments and other document related data is stored. Officially there is no script available to perform this move using DBT (remove constraints / transfer / reapply constraints). We looked into the database and figured out how to perform this task using DBT – so we are not dependent on any other products. We m
3
IBM Connections – trouble adding additional nodes
Wed, May 31st 2017 2:52p   GIS Techblog
IBM Connections – trouble adding additional nodes Hi all, we are currently involved in a project where we installed a 1 node IBM Connections 6 Cluster and later added a second node to the cell. So far so good… Everything that needs to be done after adding the second node is described here … Everything? Yes, mainly… but not in the mandatory details as I think! Missing custom properties and other settings might result in non-functional nodes. Especially not setting httpSess
2
SNOUG 2017 Presentation – SikaConnect goes External
Thu, Mar 23rd 2017 1:06p   GIS Techblog
SNOUG 2017 Presentation – SikaConnect goes External Hi all, yesterday I was at SNouG in Zurich. I had a great time there – good speakers and a overall perfectly organized event (would we expect sth. else from Switzerland? ) Raymond Weber from SIKA Informationssysteme AG and I did a session about the SIKA Extranet Feature:
2
Whiteboard in IBM Sametime Meeting 9.0.1 removed
Fri, Mar 17th 2017 10:43a   GIS Techblog
Whiteboard in IBM Sametime Meeting 9.0.1 removed IBM implemented in Sametime Meeting 9.0.1 a whiteboard function as technical preview. Ben described in his articel how to enable this feature: https://collaborationben.com/2016/05/20/whiteboard-in-sametime-9-0-1/ With the current cumulative Fix 901-ST-General-FP-SMOL-AK4G43  for the Meeting Server IBM has removed this function. The response on my PMR was: “I can confirm The Meetings Whiteboard feature release is being put on hold indefinitely.
4
Wikis content not accessible…
Thu, Jan 26th 2017 10:54a   GIS Techblog
Wikis content not accessible… Hi, it`s been quite a long time; many projects at the moment so that blogging needs to wait Last week we had a very interesting problem at one customer’s environment. When accessing a Wiki, the page was displayed blank – no content was available. Browsing to older versions of this wikis worked. The error in the log: Parsing error… Wikis content (the body) gets store in the filesystem as xml files. If you access a Wiki there is a XML parser
6
Automatic WebSphere plugin modification II – PowerShell for Windows
Thu, Dec 1st 2016 6:54p   GIS Techblog
Automatic WebSphere plugin modification II – PowerShell for Windows Hi, some months ago I published a shell script to automatically modify the Primary / BackupServer definition in a WebSphere plugin-cfg.xml file. As we have several Windows customers we decided to transfer this script to PowerShell so that it is also useable for a Windows Cluster installation. My colleague Jan Bruns did a great job implementing this script. It basically works the same way as the Linux script: modifywasplug
9
IBM Connections Docs – file preview not possible for some CCM pdf files
Thu, Nov 17th 2016 2:15p   GIS Techblog
IBM Connections Docs – file preview not possible for some CCM pdf files Hi all, last week we had trouble in a customer environment using the file preview functionality for some pdf files (only those that were uploaded using CCM). Instead of a preview the message was displayed: At the same time we saw the following warning in the log: The mime-type was set to “image/pcl” instead of “application/pdf”… this mime-type is not supported by IBM Docs File viewer. We had to dig deep into th
3
IBM Connections 5.5 CR2 released
Thu, Nov 10th 2016 8:13a   GIS Techblog
IBM Connections 5.5 CR2 released Hi all, IBM released CR2 for IBM Connections 5.5: The Fix list Download the CR Database updates are mandatory (Activities, Files, Homepage, Mobile, Wikis) Filenet updates are mandatory Updates for Community Surveys (Fixes the TLS 1.2 issues) A prerequisite for CR2 is at least WAS 8.5.5 FP9 (let`s see when FP10 will be officially supported) A general step-by-step guide installing CR2 is provided by IBM. A new CR2 version of the Cognos wizard can be downloaded (y




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