IBM InfoSphere Information Services Director
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.