I am using a visual basic 6.0 application to send about 170 insert statements in a batch to a IBM DB2 (UDB database). The packet size that is defined is set to 4096. With this packet size only 20 inserts statements are being executed. When I chnage my packet size to 100 all the 170 inserts are being executed. I was wondering is there a setting on the server that I need to increase so that all the insert statements can get executed with the packet size of 4096.

Thanks in advance.