A WINDOWS JAVA DB2

The Windows/Java environment utilizing an IBM DB2 database example contains 3 application servers and 2 database servers. There are still three environments; development, QA and Production. The IBM DB2 database server will contain two separate databases. Clear and precise naming of the associated databases is recommended.

SoftRater can be run on a non-Windows machine if a compatible application server platform such as WebLogic, WebSphere, JBoss or TomEE is running as well. If a non-Windows machine is used for SoftRater, you will need to download a Java version of SoftRater from Oracle Software Delivery Cloud. The Java version of SoftRater will need to be loaded onto the machine with the compatible application server platform.

The IBM DB2 database can be setup after the subscriber has been created and proper permissions have been granted.

The Setup

  1. The Development environment:

    1. Contains one Windows Server app server and one separate MS SQL Server database.

    2. RateManager and IBFA/SR-WIN would be located on the same Windows machine. RateManager and IBFA must run on a Windows Server machine.

    3. OBI Publisher is installed for reports to be created.

    4. The subscriber ID would be created here.

    5. On the IBFA/SR-WIN for this environment, three database connections would be created and three logical environments would be created.

    6. The IBM DB2 client would be run on the Windows machine.

    7. Two databases would be attached to the MS SQL Server machine.

  2. The QA environment:

    1. Contains one JAVA application server with WebLogic, WebSphere or JBoss installed and running. There is one separate IBM DB2 database server that will be shared between QA and Production.

    2. IBSS/SR-JAVA would be loaded on the JAVA machine.

    3. On the IBSS/SR-JAVA for this environment, one logical environment would be created.

    4. One QA database would be created on the IBM DB2 machine.

  3. The Production environment:

    1. Contains one JAVA application server with WebLogic, WebSphere or JBoss installed and running. There is one separate Oracle database server that will be shared between QA and Production.

    2. IBSS/SR-JAVA would be loaded on the JAVA machine.

    3. On the IBSS/SR-JAVA for this environment, one logical environment would be created.

    4. One PRODUCTION database would be created on the IBM DB2 machine.

  4. The IBM DB2 Server:

    1. Requires that the DBA run have permissions so tables can be created