Re: MVS and large database

summersd_at_teleport.com (David Summers) wrote:

>>In article <31E676C4.55D1_at_nla.gov.au>, Bruce Pihlamae
>><bpihlama_at_nla.gov.au> writes
>>>Brian McCabe wrote:
>>>> The site I am working at is also experiencing problems with Oracle
>>>> performance on MVS. We are planning to migrate from AIX to MVS and
>>>> although the database only currently stands at less than 100Gb, we
>>>> intend to reach pretty near to the 1Tb figure next year.
>>>>
 

>>>> Initial performance of Oracle on MVS is very disappointing and no
>>>> obvious bottle-neck has been determined to date. The Orace Instance is
>>>> idling, the network is not under any great stress and the MVS-Gurus tell
>>>> us that nothing is pushing the operating system or disk IO sub-system.
>>>>
>Is it possible that you are being limited by the speedof your SQL*net
>connection? I use the DB2 transparent gateway( which uses an oracle7 instance)
>on MVS connected to an Oracle7 Instance on a Solaris bax via SQLNet2. Without
>a doubt the slowest piece is the SQLnet. We've monitored it with a sniffer and
>discovered that data transfet involves many small messages bracketting a
>maximum 2k packet. We haven't found any way (yet) to improve on this.

Is this SQL*Net problem limited to it's implementation on MVS or is it problematic with all SQL*Net implementations?

George Received on Wed Jul 17 1996 - 00:00:00 CEST