I have a DTS package that uses the Transform Data Task to copy rows from SQL Server to DB2 MVS.
The package works fine - except - when we watch the process in DB2, the ID is connecting to DB2, inserting one record, committing the insert, then getting swapped out. The process continues this in/out for every row being loaded.
This causes the process to run slow and take up a lot of needless CPU time on the mainframe/MVS System.
Does anyone know what, if anything, can be done to stop the constant swapping in and out and issuing a commit for every row being inserted?
The package works fine - except - when we watch the process in DB2, the ID is connecting to DB2, inserting one record, committing the insert, then getting swapped out. The process continues this in/out for every row being loaded.
This causes the process to run slow and take up a lot of needless CPU time on the mainframe/MVS System.
Does anyone know what, if anything, can be done to stop the constant swapping in and out and issuing a commit for every row being inserted?