Does anyone have any pointers or recommendations for books
on the Oracle Transparent Gateway for DB/2 for MVS.
(Going from an F50 RS/6000 box with oracle 7.1.3 to DB/2 3.1 on MVS)
I desperately need tuning advice and information.
I have a handful of queries that take way too long.
I am interested in parameters on the Oracle side that may help,
how to tune the statements, ( i.e. tune them for DB/2 or tune them
for Oracle or doesn't it matter) - and possible flaws in the system
and how to get around them. Oracle has conceded that doing a join of
tables, some on one side, some on the other is enormously slow, because
the entire DB/2 table is brought over to execute the join. Why? There
seems to be an amazing absence of information on the subject.
Please respond to dcowles_at_bigfoot.com if you can.
Thanks,
Dc.
Received on Mon Sep 07 1998 - 23:40:36 CDT
