Arun Srinivasan wrote:
I need to speed up the inserts through informatica, and I came across
insert buf option with db2 packages for import statements and how we
can use that option to do the same in java programs. Are there any
packages to be bound for informatica powercenter, so that I can rebind
them with this option?
My informatica person says that Informatica does not bind any packages
to the database. Is he missing something. Any one who has worked in
informatica with db2, please help me guys,,.
He is correct. The native DB2 driver for Informatica uses DB2 CLI to
talk to the database.
Theoretically you can bind ALL of the CLI packages with buffered
inserts, but I would not recommend this (that would apply to pretty
much every application connecting to the database except those using
the JDBC Type 4 driver). This can create issues if the applications
have not been coded to handle errors that may occur asynchronously from
the actual call to insert the record.
The best options are using the parallel load option in Informatica
or using the bulk mode in Informatica.
However, one other option is just to have Informatica write to a flat
file and use LOAD. If you are doing multiple loads to the same table,
or have to deal with recoverable loads, then this is generally a better
idea than using bulk mode in Informatica idea because you can specify
load options that aren't available with bulk load mode.
One other thing you can do to enhance insert performance is to put your
tables in APPEND mode. Certain things will prevent this (MDC) or make
it a bad idea (if you have a clustering index and care about the tables'
cluster ratio).
Good luck,
Ian Bjorhovde