Db2 Support environment variables in DataStage

These environment variables are concerned with setting up access to Db2® databases from DataStage®.

APT_DB2INSTANCE_HOME environment variable in DataStage

The APT_DB2INSTANCE_HOME environment variable specifies the Db2 installation directory.

This variable is set by DataStage to values obtained from the Db2.erver table, representing the currently selected Db2 server.

APT_DB2READ_LOCK_TABLE environment variable in DataStage

The APT_DB2READ_LOCK_TABLE environment variable controls whether a table is Db2 locked.

If the APT_DB2READ_LOCK_TABLE environment variable is defined and the open option is not specified for the Db2 stage, DataStage runs the following open command to lock the table:


lock table 'table_name' in share mode

APT_DBNAME environment variable in DataStage

The APT_DBNAME environment variable specifies the name of the database if you choose to leave out the Database option for Db2 stages.

If the APT_DBNAME environment variable is not defined as well, the Db2.BDFT environment variable is used to find the database name. These variables are set by DataStage to the values obtained from the Db2.erver table, representing the currently selected Db2 server.

APT_RDBMS_COMMIT_ROWS environment variable in DataStage

The APT_RDBMS_COMMIT_ROWS environment variable specifies the number of records to insert into a data set between commits.

The default value is 2048.

APT_TIME_ALLOW_24 environment variable in DataStage

Set this environment variable to allow the time value 24:00:00 to be treated as a valid value, as allowed by Db2.