r4 - 2017-08-07 - 17:08:10 - Main.ktessierYou are here: TWiki >  Deployment Web > DeploymentInstallingUpgradingAndMigrating > IBMQuickDeployer > IBMQuickDeployerSetupAndRun > IBMQuickDeployerChangeDefaultDB2Parameters

IBM Quick Deployer change default DB2 database parameters updated.png

Authors: ThomasPiccoli, KennethThomson, JenniferLiu, KenTessier, ClareCarty
Build basis: CLM 6.0, CLM 6.0.x, CE 6.0.x

The values contained in the default database parameters are used to configure the connections between the installed CLM applications and their individual databases. If you are going to use the Quick Deployer installed DB2 database then there is no need to change them prior to running the UCD application Install Applications process. However, you should have your database administrator review the configuration to make sure it conforms to internal security and reliability policies.

If you are going to use an existing DB2 database instance then you need to ensure that the default database parameters are updated to match the configuration used by your database instance. To do this follow the instructions in this topic.

Change default database parameters

  1. Open application Rational_QD_60x, click Environments, then click the Request Process icon for the target environment.

    run process

  2. In the Process field, select Change Default DB2 Parameters.

    change parameters

  3. If you fixed the component versions on the process you will not be prompted to choose versions. If offered to choose the component versions, then select Latest Available.

    choose version

  4. Modify the process property default values to match your database.

    The DB2 databases are created using this command db2 CREATE DATABASE ${app}DBName $create{app}DBOption which is populated using these property values:

    eg db2 CREATE DATABASE $jtsDBName $createjtsDBOption

    The properties are as follows
    • createjtsDBOption : command options for creating the jts database
      Default on Linux : "ON '/IBMQD/db2fs' DBPATH ON '/IBMQD/db2fs' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
      Default on Windows : "ON 'c:\IBMQD\db2fs' DBPATH ON 'c:' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
    • jtsDBName : name of the jts database
      Default : jtsDB
    • createdwDBOption : command options for creating the datawarehouse database
      Default on Linux : "ON '/IBMQD/db2fs' DBPATH ON '/IBMQD/db2fs' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
      Default on Windows : "ON 'c:\IBMQD\db2fs' DBPATH ON 'c:' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
    • dwDBName : name of the datawarehouse database
      Default : dwDB
    • createccmDBOption : command options for creating the ccm database
      Default on Linux : "ON '/IBMQD/db2fs' DBPATH ON '/IBMQD/db2fs' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
      Default on Windows : "ON 'c:\IBMQD\db2fs' DBPATH ON 'c:' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
    • ccmDBName : name of the ccm database
      Default : ccmDB
    • createqmDBOption : command options for creating the qm database
      Default on Linux : "ON '/IBMQD/db2fs' DBPATH ON '/IBMQD/db2fs' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
      Default on Windows : "ON 'c:\IBMQD\db2fs' DBPATH ON 'c:' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
    • qmDBName : name of the qm database
      Default : qmDB
    • creatermDBOption : command options for creating the rm database
      Default on Linux : "ON '/IBMQD/db2fs' DBPATH ON '/IBMQD/db2fs' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
      Default on Windows : "ON 'c:\IBMQD\db2fs' DBPATH ON 'c:' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
    • rmDBName : name of the rm database
      Default : rmDB
    • creategcDBOption : command options for creating the gc database
      Default on Linux : "ON '/IBMQD/db2fs' DBPATH ON '/IBMQD/db2fs' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
      Default on Windows : "ON 'c:\IBMQD\db2fs' DBPATH ON 'c:' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
    • gcDBName : name of the gc database
      Default : gcDB
    • createdccDBOption : command options for creating the dcc database
      Default on Linux : "ON '/IBMQD/db2fs' DBPATH ON '/IBMQD/db2fs' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
      Default on Windows : "ON 'c:\IBMQD\db2fs' DBPATH ON 'c:' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
    • dccDBName : name of the dcc database
      Default : dccDB
    • createrelmDBOption : command options for creating the relm database
      Default on Linux : "ON '/IBMQD/db2fs' DBPATH ON '/IBMQD/db2fs' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
      Default on Windows : "ON 'c:\IBMQD\db2fs' DBPATH ON 'c:' USING CODESET UTF-8 TERRITORY EN PAGESIZE 16384"
    • relmDBName : name of the relm database
      Default : relmDB
    • createlqeDBOption : command options for creating the lqe database
      Default on Linux : "ON '/IBMQD/db2fs' DBPATH ON '/IBMQD/db2fs' USING CODESET UTF-8 TERRITORY EN PAGESIZE 32768"
      Default on Windows : "ON 'c:\IBMQD\db2fs' DBPATH ON 'c:' USING CODESET UTF-8 TERRITORY EN PAGESIZE 32768"
    • lqeDBName : name of the lqe database
      Default : lqeDB
    • createldxDBOption : command options for creating the ldx database
      Default on Linux : "ON '/IBMQD/db2fs' DBPATH ON '/IBMQD/db2fs' USING CODESET UTF-8 TERRITORY EN PAGESIZE 32768"
      Default on Windows : "ON 'c:\IBMQD\db2fs' DBPATH ON 'c:' USING CODESET UTF-8 TERRITORY EN PAGESIZE 32768"
    • ldxDBName : name of the ldx database
      Default : ldxDB
    • createdmDBOption : command options for creating the dm database
      Default on Linux : "ON '/IBMQD/db2fs' DBPATH ON '/IBMQD/db2fs' USING CODESET UTF-8 TERRITORY EN PAGESIZE 32768"
      Default on Windows : "ON 'c:\IBMQD\db2fs' DBPATH ON 'c:' USING CODESET UTF-8 TERRITORY EN PAGESIZE 32768"
    • dmDBName : name of the dm database
      Default : dmDB
    • DB2InstancePort : database connection port
      Default : 50001

  5. Click on Submit and wait for the process to run to completion

    wait for completion

Miscellaneous

Notes:

  • Throughout the IBM Quick Deployer wiki the screen captures are for reference only.
    In some cases if the functionality they display has not changed in the latest release they will be from a previous release

Related topics:

External links:

Additional contributors: MichelleCrane, NathanBak, ChristianLopez

Edit | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r4 < r3 < r2 < r1 | More topic actions
Deployment.IBMQuickDeployerChangeDefaultDB2Parameters moved from Deployment.IBMQuickDeployerChangeDefaultDB2ParametersV20 on 2017-07-28 - 21:33 by Main.ktessier -
 
This site is powered by the TWiki collaboration platformCopyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our Terms of Use. Please read the following disclaimer.
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.