Loading Records - Batch and DB2 connect



IBM's flagship relational database management system

Loading Records - Batch and DB2 connect

Postby jaggz » Thu Apr 26, 2012 12:03 pm

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
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 5 times

Re: Loading Records - Batch and DB2 connect

Postby dick scherrer » Thu Apr 26, 2012 9:12 pm

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post