DB2 Set Integrity Command with LOAD Stage

[DKostelnik]

Here is the issue:

DataStage allows you to run the DB2 LOAD command with full knowledge that tables can go into a check pending state because of the command. Yet, apparently DataStage does not provide a solution to this common issue. There should be a simple method of running a set integrity command without having to jump through any hoops.

If a job has the authority to load a table, then it has the authority to process a set integrity command against that table. If other tables are involved, then it is a matter of giving the user permissions to run the command.

To have to go outside of DataStage to provide this basic database functionality seems out of line to me (being a DBA). There is a hole in the product that needs to be fixed.