B2B Integration

Sterling B2B Integration

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Migration of DB from On-prmise to Private Cloud

    Posted Fri December 04, 2020 04:13 AM
    Hi, 
    Out B2B application running on Sterling 5.2.6.3_10 with Oracle 11g. DB and working on project to migrate On-Premise to Oracle Private Cloud. 
    While migrating to Cloud, we have proposed to keep same DB version, so that we don't have change drivers and other associated configurations. 
    Overall Plan goes like :
    1. DBA team clone DB instances over Cloud & Share new URL & port configuration
    2. validate connectivity by performing telnet to new DB URL 
    3. Replicate changes in customer override or jdbc group property files
    4. Bring up application and perform validation. 

    Has anyone experienced this situation or foresees any problem with approach? 

    I though of executing db_verify.sh script from bin directory, however while reading through IBM forum came across below

    Running dbverify.cmd/sh using an Oracle 12g or 11g database can cause table modification SQL to be unnecessarily created even though the tables are already defined correctly.
    Ibm remove preview
    Running dbverify.cmd/sh using an Oracle 12g or 11g database can cause table modification SQL to be unnecessarily created even though the tables are already defined correctly.
    When running dbverify.cmd/sh in IBM Sterling B2B Integrator (B2Bi), it was found that the script would try to change certain tables which had NUMBER or INT data type columns.
    View this on Ibm >

    Any direction or suggestion will be helpful.

    ------------------------------
    Atul Pawar
    ------------------------------

    #SupplyChain
    #B2BIntegration


  • 2.  RE: Migration of DB from On-prmise to Private Cloud

    Posted Mon December 07, 2020 03:17 AM
    Hello,

    On-Premise or Oracle Private Cloud is the same for SBI's DB connexion.
    it is only an issue of your network configuration.

    I think the following step is not the good methods:  3. Replicate changes in customer override or jdbc group property files.
    -> you will have some issue on the migration or in futur change (new service / adapter).

    The good process for SBI is the following one : 
    https://www.ibm.com/support/pages/move-database-one-server-another-sterling-b2b-integrator
    step 1 is very important (the only way to do a rollback if needed).
    the deployer.sh will update all file to be updated with the new DB parameter (defined in sandbox.cfg)

    best regard

    ------------------------------
    Vincent Lahousse
    Satisco
    ------------------------------

    Original Message


  • 3.  RE: Migration of DB from On-prmise to Private Cloud

    Posted Mon December 07, 2020 10:19 AM
    Hi Atul,

    Instead of dbverify.sh, have you considered testing the connection with a simple SQL using db_exec.sh?
    For example
    db_exec.sh "select count(*) from yfs_user"
    This will return successfully if the connections to the DB is correct and the DB is deployed correctly in the new instance.

    Regards

    ------------------------------
    Satya Venkataraman
    ------------------------------

    Original Message


Related Content