Database configuration details for Maximo Manage

If your Maximo® Application Suite offering includes the Maximo Manage application, you must configure a database that this application can use. Maximo Manage supports IBM® Db2®, IBM Db2 Warehouse, Microsoft SQL Server, and Oracle Database.

Note: If you choose to install Maximo Application Suite with Manage, you can use the default IBM Db2 instance that is provisioned by IBM instead of configuring your own external Db2 instance. To configure the default IBM Db2, do not add information in the username, password, JDBC URL, certificate URL, and demo data fields.

The internal Db2 configuration is available from Maximo Application Suite 8.10 or later.

Restriction: The default IBM Db2 instance for configuring Internal Db2 is unavailable for Microsoft Azure Red Hat® OpenShift®.
For more information, see Preparing your database for deployment.

After you configure the database that you want Maximo Manage to use, you can specify the following configuration details when you enter the Maximo Application Suite installation parameters:

  • Username
  • Password
  • Java™ database connectivity (JDBC) URL,
    For example, use the following parameters for the database that is configured.
    • For IBM Db2 database:
      jdbc:db2://1.2.3.4:50051/FTMDB:sslConnection=true
    • Starting in 8.11, for Microsoft SQL Server database:
      jdbc:sqlserver://;serverName=10.5.0.4;portNumber=1433;databaseName=maxdb80;
sendStringParametersAsUnicode=false;selectMethod=cursor;encrypt=true;trustServerCertificate=true;
    • Starting in 8.11, for Oracle Database:
      jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=63.246.112.120)
(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=maxdb)))
    Note: Only secure sockets layer (SSL) connections to the database are supported.

  • HTTP location of the database's public certificate with SAS token, for example: https://masocpstgacnt.blob.core.windows.net/masocpfiles/db2-certificate.crt?sp=r&st=2022-04-06T04:02:45Z&se=2022-06-30T12:02:45Z&spr=https&sv=2020-08-04&sr=c&sig=CN27jhRfxHDmDgz%2FugkyFT7h%2BEZdp9H5fVgoaxP%2FURY%3D.

    Ensure that you can retrieve your certificate based on your database type. For example, for IBM Db2 Warehouse, go to the Details view of the IBM Db2 instance in Cloud Pak for Data , and click Download SSL certificate.

    In your Microsoft Azure account, upload the certificate to a storage account Blob container. Create the SAS token and form the HTTP location for the certificate file.

    Your Microsoft Azure account has access to the Microsoft Azure storage account service. If you do not yet have any storage accounts created, first sign in to the Microsoft Azure portal and open the Storage accounts service. Then, click Create and follow the steps in the wizard. If you already created a storage account, in the storage accounts list, choose the name of the storage account that you want to upload your Maximo Application Suite license key file to, create a container, and then upload the files to the container.

  • Whether you want to import demo data into the database. This data might be useful for development or test environments.

Ensure that you are aware of the location site for the database, depending on where the database was provisioned compared to where the Cloud Pak for Data server is located. If the locations are far apart, the maxinst/updatedb operations might take several days or fail due to connection issues, especially in cases where you install several Manage extensions.

If you deploy the Maximo Manage application, you can add or update the database configuration information.