Stored Procedures/Configuration

Stored Procedures/Configuration

 

  

Running DB2 8.2 (fixpack 8) on AIX 5.3, we're seeing a VERY SIMPLE stored
procedure that just returns the next value from a sequence run slowly. Is
there anything special in terms of configuration that might make stored
procedures run faster?

Also if anybody's worked with DB2 and Informatica and has any tips, that
would be helpful.

We're working with some Oracle/Informatica bigot consultants who are not
being nice about this.

Thanks,
Vicki



DB2 & UDB email list listserv db2-l LazyDBA home page