Database stages

Follow these guidelines when using database stages in a job.

Note: This design feature of an IBM® InfoSphere® DataStage® job is applicable for Topology I (batch jobs), Topology II (batch jobs with an ISD Output stage), and Topology III (jobs with ISD Input and ISD Output stages).

Do not configure the stage to empty and create tables at the start of a job because IBM InfoSphere Information Server will empty a table each time a new instance is started.
To reduce the likelihood of table locking, use the Autocommit feature or a Commit frequency of 1. Do not configure the stage to commit rows at the end of a job.