Re: MVS and large database

In article <summersd.161.0013FA88_at_teleport.com>, David Summers <summersd_at_teleport.com> writes
>In article <iN9swBAoSm5xEwRI_at_mitc.demon.co.uk> Brian McCabe
><brian_at_mitc.demon.co.uk> writes:
>>Path:
>>nntp.teleport.com!netaxs.com!hunter.premier.net!news-
 res.gsl.net!news.gsl.net!ne
>>ws.mathworks.com!news.kei.com!nntp.coast.net!dispatch.news.demon.net!demon!mitc
 .
>>demon.co.uk!brian
>>From: Brian McCabe <brian_at_mitc.demon.co.uk>
>>Newsgroups: comp.databases.oracle
>>Subject: Re: MVS and large database
>>Date: Fri, 12 Jul 1996 15:43:52 +0100
>>Organization: McCabe IT Consulting Limited
>>Lines: 67
>>Distribution: world
>>Message-ID: <iN9swBAoSm5xEwRI_at_mitc.demon.co.uk>
>>References: <4r6d08$39d_at_news00.btx.dtag.de> <1996Jul8.220146.7060_at_rossinc.com>
>> <4ruqv3$h4_at_inet-nntp-gw-1.us.oracle.com> <Q1VakDAII14xEwtp_at_mitc.demon.co.uk>
>> <31E676C4.55D1_at_nla.gov.au>
>>NNTP-Posting-Host: mitc.demon.co.uk
>>X-NNTP-Posting-Host: mitc.demon.co.uk
>>MIME-Version: 1.0
>>X-Newsreader: Turnpike Version 1.12 <JuRssnRnjILJ3N01Yp$Sfk242+>
>
>
>>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. We get
>2-4Mg min transfer between to the two instances when doing inter instance
>table loading. Not blazing, but it works for most of our needs.
>
>
>David Summers - Pacificorp
>summersd_at_teleport.com

Thanks for the info. This could well be our problem and we are now closing in on SQL*Net as being the prime suspect in our investigations. I will keep you posted!

-- 
Brian McCabe
McCabe IT Consulting Limited
brian_at_mitc.demon.co.uk