Hi guys,
My developers are loading the DB2 tables from flat files through
DataStage.
DB2 V8.1.1 on AIX V5.2
They are committing every 500 rows.
Everything runs fine when they load empty tables, but when they load
tables that already contain data, they first delete the existing data and
then insert the new data into them.
This always fills up the log files and gives a log full error.
They do not commit while deleting the rows (no such option in DataStage
for them to do so).
Is there any solution to overcome this issue eg: some Procedure to delete
the data which can be called by DataStage?
Cheers,
San.