Surrogate Key (Db Sequence) using Transformer: Very slow
Posted: Fri Dec 02, 2011 5:42 am
We have recently implemented PCI compliance on AIX box where Information Server is installed. Situation is whever we are trying to call Db sequence(DB2) in transaformer stage it is taking ages (1.5 hrs) to generate keys for paltry 0.1 million records. For testing we have designed a simple test job
ROW GEN -> XFMR -> PEEK
1) DBA gave the opinion that nothing is problematic from their end.
2) Same sequence when called in an SQL query using Db2 connector is running very fast, no issues with it.
Can we trace the process through which the transformer is calling the Db sequence and probably look for bottleneck.
Any suggestion would be higly appreciated.
thabnnks
ROW GEN -> XFMR -> PEEK
1) DBA gave the opinion that nothing is problematic from their end.
2) Same sequence when called in an SQL query using Db2 connector is running very fast, no issues with it.
Can we trace the process through which the transformer is calling the Db sequence and probably look for bottleneck.
Any suggestion would be higly appreciated.
thabnnks