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.
APT_DB2READ_LOCK_TABLE environment variable in DataStage
The APT_DB2READ_LOCK_TABLE environment variable controls whether a table is Db2 locked.
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.
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.
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.

Parent topic: Environment variables in DataStage