Specify the Log Messages Repository for IBM Db2 on z/OS

You can configure a type of repository for the log messages, and then configure properties for the specific repository. You can also configure more than one repository for log messages.

Procedure

  1. On the computer where you installed Content Manager or the Application Tier Components, start IBM® Cognos® Configuration.
  2. In the Explorer window, under Environment, click Logging.
  3. In the Properties window, use the following table to help set the log server properties.
    Table 1. Log server properties
    Task Action

    Use TCP between IBM Cognos components on a computer and its local log server

    Set the Enable TCP property to True.

    UDP provides faster communication with a lower risk of lost connections than TCP.

    TCP is used for communication between a local log server and a remote log server.

    Change the number of threads available to the local log server

    Type the value in the Local log server worker threads property.

    Keep the default value of 10. The range is between 1 and 20. However, if you have a high number of log messages, you can allocate more threads to improve performance.

  4. In the Explorer window, under Environment, right-click Logging, and click New resource > Destination.
  5. In the Name box, type the name of the repository.
  6. In the Type list, click Database and then click OK.
  7. In the Explorer window, under Logging, right-click the database name, and click New resource > Database.
  8. In the Name box, type the name of the repository.
  9. In the Type list, click DB2 database and then click OK.
  10. In the Properties window, type the Database server and port number, User ID and password, and the z/OS® Database name.

    Ensure that the User ID is the same as the value you specified for the IPFSCRIPT_USERNAME parameter in the LS_tablespace_db2zOS.sql script file Create tablespaces for a logging database on Db2 on z/OS.

  11. In the Explorer window, click Local Configuration.
  12. In the Properties window, next to Advanced properties, click inside the Value box, and then click the edit icon Actions icon.
  13. Click Add, and then add the configuration parameter names and values from the following table:
    Table 2. Configuration parameter names and values
    Parameter Name Value

    IPFSCRIPT_CREATE_IN

    The base tables location.

    For example, databaseName.baseTablespaceName

    IPFSCRIPT_STOGROUP

    The name of the storage group.

    IPFSCRIPT_DATABASE

    The name of logging database.

    IPFSCRIPT_LS_ID

    The instance identifier for the audit database. This value must not be longer than two characters.
  14. From the File menu, click Save.
  15. Test the connection to the new database. In the Explorer window, under Environment, right-click Logging and click Test.

    IBM Cognos components connect to the database. If you configured more than one database for logging messages, IBM Cognos components test all the databases.