Decision Management (ODM,ADS)

Decision Management (ODM, ADS)

Connect with experts and peers to elevate technical expertise, solve problems and share insights

 View Only
Expand all | Collapse all

How to use the DB-Dump-Tool to import the data to ODM Decision Center (on AWS EKS Cloud)

  • 1.  How to use the DB-Dump-Tool to import the data to ODM Decision Center (on AWS EKS Cloud)

    Posted Fri September 10, 2021 01:24 PM

    We need to migrate the decision center data (including releases and change activities) from existing On-Premises Setup (utilizing DB2 with WAS) to On-Cloud ODM (utilizing AWS Cloud, EKS, ODM Image as Helm Chart and Postgres DB).

    We have following questions in using Reference: https://www.ibm.com/support/pages/migrate-ibm-operational-decision-manager-cloud-pak-business-automation

    1: Instructions for importing the db-dump file

    "From <ODM_InstallDir>/teamserver/bin, run the following commands:

    set ANT_OPTS=-Xmx2048m

    ant import-schema -DdumpPath=<my_dump_path>\my_dump.zip > import_log.txt

    where -DdumpPath references the database that you exported in the previous step"

    Question:

    Where do we execute these instructions ?

    - Is it our local ODM 8.10.5 installation( C:\Program Files\IBM\ODM8105\teamserver\bin) or the cloud where the new DC pod is running?

    - for either location, can you provide more detailed instructions as to what needs to change/be updated



    #OperationalDecisionManager(ODM)
    #Support
    #SupportMigration


  • 2.  RE: How to use the DB-Dump-Tool to import the data to ODM Decision Center (on AWS EKS Cloud)

    Posted Fri September 10, 2021 01:29 PM

    Detailed instructions below:

    1. open a command window in your Windows OS.

    2. switch the directory to C:\Program Files\IBM\ODM8105\teamserver\bin.

    3. make sure you can type "ant" command, if not install and configure the ant for your Windows OS: https://www.ibm.com/docs/en/odm/8.10?topic=tasks-setting-up-ant-environment

    4. open the file C:\Program Files\IBM\ODM8105\teamserver\bin\teamserver-anttasks.properties

    5. populate this file with following information:

    rtsAdmin.login=odmAdmin (change to your id)

    rtsAdmin.password=odmAdmin (change to your pw)

    protocol=https

    server.host=decisioncenter.odm.icp4adeploy.project.apps.myopenshift.cp.fyre.ibm.com (change to your server name, make sure the communication from this node to the server is open and not blocked, and not timed out, and not load size limited, not in anyway blocked by any firewall rules. This could be a long time, heavy load, https communication depending on your database size.)

    server.port=443

    server.url=${protocol}://${server.host}:${server.port}/decisioncenter

    datasourceName=jdbc/DCMigration (changed to your data source name)

    6. execute the following command:

    set ANT_OPTS=-Xmx2048m

    ant import-schema -DdumpPath=<my_dump_path>\my_dump.zip > import_log.txt

    where -DdumpPath references the database that you exported in the previous step. Note: This can take some time depending on the size of your database content.



    #OperationalDecisionManager(ODM)
    #Support
    #SupportMigration