FileNet P8 Content Engine, Version 5.0.+              

Creating the data sources by using the command line

You must create the JDBC data sources for each object store that Content Engine uses. You must generate, edit, and execute a new configurejdbc-os.xml file for each object store in your environment.

Be sure that you have available the Installation and Upgrade Worksheet that was completed during your planning activities.

If you generated all of the configuration profiles at the same time, you have already created an initial configurejdbc-os.xml file for the initial object store data sources. If you have an existing configurejdbc-os.xml file, you can generate another file for each additional object store. Each additional file that you add is named configurejdbc-os.n.xml. You can generate multiple configurejdbc-os.n.xml files as needed, depending on the number of object stores in your environment. For best results, create an additional file for each object store.
  1. Open your completed Installation and Upgrade Worksheet file.
    Tip: In the worksheet file, verify that the Data > Filter > AutoFilter command is enabled. To view only Configuration Manager values for this task, filter by CM: Configure Object Store JDBC Data sources (object store 1) in the Installation or Configuration Program column.
  2. Log on to the application server as config_mgr_user, the user who runs Configuration Manager.
  3. If you did not generate all the configuration files at the same time or if you must create another file, generate the configurejdbc-os.n.xml file by running the following command:
     configmgr_cl  generateConfig -appserver  app_server_type -db  db_type
      -task configurejdbcos -profile myprofile

    where:

    -appserver appserver_name
    The -appserver appserver_type specifies the type of application server and must be WebSphere®, WebLogic, or JBoss.
    -db database_type
    The -db database_type parameter is required only when you are generating all the files at the same time or when you are generating a single file by using the configurejdbcgcd or configurejdbcos option. This parameter specifies the type of database to be used by Content Engine and must be mssql, oracle, oracle_rac, db2, or db2zos.
    -profile myprofile
    The -profile myprofile parameter specifies the profile to use. The myprofile value can be one of the following items:
    • The name of the profile, such as ce_was_tiv_db2. The profile must be located in the ce_install_path/tools/configure/profiles directory, where ce_install_path is the location where the Content Engine software is installed.
    • The absolute path to the profile directory, such as "C:\Program Files\IBM\FileNet\ContentEngine\tools\configure\profiles\ce_was_tiv_db2" or opt/IBM/FileNet/ContentEngine/tools/configure/profiles/ce_was_tiv_db2.
    • The absolute path to the profile input file, such as "C:\Program Files\IBM\FileNet\ContentEngine\tools\configure\profiles\ce_was_tiv_db2\ce_was_tiv_db2.cfg" or opt/IBM/FileNet/ContentEngine/tools/configure/profiles/ce_was_tiv_db2/ce_was_tiv_db2.cfg.
    Remember: If the path includes a directory name with spaces, enclose the entire path in quotation marks. For example, enter "C:\Program Files\IBM\FileNet\ContentEngine\tools\configure\profiles\ce_was_tiv_db2\ce_was_tiv_db2.cfg".
  4. Use a text editor to open the configurejdbc-os.n.xml file and edit it as follows:
    1. Provide the entries that are required for your environment by using the values in your worksheet.
      High availability In highly available environments, provide the following additional information for the object store data sources:
      Database server name
      If you are using a highly available database cluster, use the virtual name of the cluster.
      Database server name RAC node n
      If you are using Oracle RAC, then you must enter the database information for two nodes in the RAC cluster.
      Configuration Manager uses the values that you provided to create the JDBC URL in the format shown in the following table:
      Table 1. JDBC URL format for Oracle RAC
      Server Description Example
      WebSphere
      jdbc:oracle:@
      (DESCRIPTION = (load_balance=yes)
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)
      (HOST = rac node 1)
      (PORT = 1521))(ADDRESS = 
      (PROTOCOL = TCP)(HOST = rac node 2)
      (PORT = 1521)))
      (CONNECT_DATA =(SERVICE_NAME = 
      DB service name)
      (failover_mode = (type=select)
      (method=basic)
      (retries=retry number)(delay=
      delay value))))
      jdbc:oracle:
      @(DESCRIPTION =(load_balance=yes)
      (ADDRESS_LIST=(ADDRESS = 
      (PROTOCOL = TCP)(HOST = testrac1)
      (PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)
      (HOST = testrac2)(PORT = 1521)))
      (CONNECT_DATA =(SERVICE_NAME = 
      testracdb)(failover_mode = 
      (type=select)(method=basic)
      (retries=32)(delay=4))))
      Oracle WebLogic Server

      See the Oracle Technology Network Web site, http://www.oracle.com/technology/documentation/index.html

      Search for Configuring JDBC Multi Data sources.

       
      JBoss Application Server
      jdbc:oracle:@
      (DESCRIPTION =(load_balance=yes)
      (ADDRESS_LIST= (ADDRESS = 
      (PROTOCOL = TCP)
      (HOST = rac node 1)
      (PORT = 1521))(ADDRESS = 
      (PROTOCOL = TCP)
      (HOST = rac node 2)
      (PORT = 1521)))
      (CONNECT_DATA =(SERVICE_NAME = 
      DB service name)
      (failover_mode = (type=select)
      (method=basic)
      (retries=retry number)
      (delay=delay value))))
      jdbc:oracle:@
      (DESCRIPTION =(load_balance=yes)
      (ADDRESS_LIST=
      (ADDRESS = (PROTOCOL = TCP)
      (HOST = testrac1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)
      (HOST = testrac2)(PORT = 1521)))
      (CONNECT_DATA =(SERVICE_NAME = 
      testracdb)(failover_mode = 
      (type=select)(method=basic)
      (retries=32)(delay=4))))
    2. Replace each occurrence of ****INSERT VALUE**** with a value appropriate for your site. See the descriptions in the file for more information.
    3. Verify that the default values for the remaining properties are correct for your site.
    4. Set the enabled attribute value in the <configuration> tag to true so that you can run the configuration task in 6.
    5. Save your edits.
  5. Run the storepasswords command to encrypt and store the required passwords.
    configmgr_cl storepasswords -profile myprofile
  6. Run the following command to execute the configurejdbc.n.xml file:
    configmgr_cl execute -task configurejdbcos -profile myprofile
    Tip: If the storepasswords command prompts you to store passwords in configuration files on disk, you must respond with yes or no (instead of y or n).
  7. Optional: Check the completion status by running the following command:
    configmgr_cl checkStatus -task configurejdbcos -task configurejdbc.n.xml
     -profile myprofile

    Where configurejdbc.n.xml is the task file for the object store.

  8. Repeat 3 through 6 as needed for each additional object store.


Feedback

Last updated: November 2010


© Copyright IBM Corporation 2010.
This information center is powered by Eclipse technology. (http://www.eclipse.org)