DB2 Support

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

APT_DB2INSTANCE_HOME
APT_DB2INSTANCE_HOME specifies the DB2 installation directory.
APT_DB2READ_LOCK_TABLE
APT_DB2READ_LOCK_TABLE controls whether a table is DB2 locked.
APT_DBNAME
APT_DBNAME specifies the name of the database if you choose to leave out the Database option for DB2 stages.
APT_DEBUG_DB2
Set this environment variable to obtain debug information from DB2 operators.
APT_RDBMS_COMMIT_ROWS
APT_RDBMS_COMMIT_ROWS specifies the number of records to insert into a data set between commits.
APT_TIME_ALLOW_24
Set this environment variable to allow the time value 24:00:00 to be treated as a valid value, as allowed by DB2.
DB2DBDFT
DB2DBDFT is used to find the DB2 database name.

Parent topic: Environment Variables