Page 1 of 1

Loading Records - Batch and DB2 connect

PostPosted: Thu Apr 26, 2012 12:03 pm
by jaggz
Dear All,

We observed when a DB2 tester inserting Records using DB2 connect consumes more ASM(DSN1DBM1) but when it is done via batch the server performance is good. Could anyone please enlighten me why DB2connect consumes more ASM than the batch process.

Jaggs

Re: Loading Records - Batch and DB2 connect

PostPosted: Thu Apr 26, 2012 9:12 pm
by dick scherrer
Hello,

Possibly because there is more overhead associated with the DB2 Connect interaction. This is probably not something the developer/coder has much control over.