Re: Oracle Transparent Gateway Tuning

I am having EXACTLY the same problem with DB/2 for MVS.. If anyone knows anything....
Thanks,
Doug C.
dcowles_at_i84.net

David Sisk wrote:

> Hello:
>
> Unfortunately, there isn't much you can do about this performance problem.
> The distributed SQL processing on DB2/400 V3R1 - V3R2 is inherently slow.
>
> If there are lots of queries happening, you can increase the number of
> pre-start jobs in the OTG subsystem. You can also backup, delete, and
> recreate the subsystem description class to pre-start the listener jobs with
> a higher priority.
>
> One additional possibility is to modify the SQL*Net parameters SDU and MDU
> to send larger block sizes. You would need to do this in ORA/SQLNET member
> used by the OTG listener, and on the Oracle instance's tnsnames.ora. (I
> don't remember the exact syntax for modifying these parameters, but Oracle
> Supports SQL group should be able to help you with this one.)
>
> Hope this helps a little. If you get any good results, please email me and
> let me know.
>
> Thanks and regards,
> Dave
>
> vdelrosario_at_my-dejanews.com wrote in message
> <6vdflg$d2$1_at_nnrp1.dejanews.com>...
> >Does anyone know of any books, white papers, or web pages, basically any
> >resources that would aid in the tuning of the Oracle Transparent Gateway
> for
> >DB/2 for AS/400. Queries such as simple select statements take much too
> long
> >to execute. I am basically interested in both Oracle and AS/400 side
> tuning
> >tips that may aleviate the slow down. We have determined that the slow
> down
> >is not due to network traffic. By themselves, Queries on the AS/400 and
> >Oracle side are fine. Once the Gateway is thrown into the mix.... well
> SLOW!
> > I am surprised that there is not many resources other than opening up a
> TAR
> >with Oracle.
> >
> >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.
> >
> >Thanks in advance
> >Regards,
> >Vince Del Rosario
> >Obvious Professional Services
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sun Oct 11 1998 - 16:24:20 CDT