Configuring environment variables

Edit online

You can configure environment variables to change the behavior of the DataStage® agent.

Procedure

  1. Open the following file in a text editor:
    1. Windowsinstall_dir\TMAITM6_x64\KDTENV_instance_name
    2. Linuxinstall_dir/config/.dt.environment
  2. Edit the following environment variables:
    • KDT_FIRST_COLLECTION_INTERVAL: The time interval in seconds for first data collection. Set this time interval to a duration by which the agent would collect previous Job runs data in the specified time until the agent starts. The default value is 300 seconds (5 minutes). So, if the agent starts at 2:00 PM, it collects the Job runs data from 1:55 PM to 2:00 PM. This is to avoid data storm of historical job runs when the agent starts collecting data. All subsequent agent data collection for job runs fetch only the newly added job runs that took place since the last collection.
    • KDT_SSL_CONTEXT: The SSL protocol that is enabled on the Service Tier (WebSphere Application Server). The default value is TLS.
    • KDT_META_SCHEMA_NAME: The name of database schema that is created for the metadata repository. The default value is DSODB for Db2 and xmeta for MSSQL and Oracle databases.
    • KDT_DATABASE_SERVICE_NAME: The database or service name that is used by the agent to connect to the metadata repository. The default value is XMETA for Db2, xmeta for MSSQL, and ORCL for Oracle databases.
    • KDT_DISABLED_ATTRIBUTEGROUP: A comma-separated list of attribute groups whose data collection needs to be unavailable. Following values can be set as single or multiple for respective attribute group: JobRuns, JobProperties, JobRunLog, JobStages, JobParameters, EngineSystemConfiguration, EngineSystemResources, EngineServiceStatus, EngineStatusSummary, JobActivity, AgentConfiguration, and JobConfiguration.
    • KDT_TIMEOUT: The time interval in seconds after which the data collection SQL query timeouts. This variable accepts positive integer values only. The default value is 30.
    • KDT_JC_ROW_NUM: Set the number of data rows fetched for Job Configurations attribute group. The default value is 50.