Re: How do I connect from iSeries to MS SQL Server 2000?

Tom,

If the problem is performance, and the cost to upgrade
your AS/400 is prohibitive, and you're considering
migrating your database to MS SQL Server, then you
might want to consider eliminating any 5250 CPW
constraints instead.

For example, when you add the 5250 feature to a 6,000
CPW model 520, the base price raises from $66,000 to
$165,000, give or take...

A product like PCS400, which is supported by Joe
Pluta, could convert existing programs to deploy an
HTML interface, and bypass the traditional 5250
interface.

Another option might be to buy or develop an iSeries
based utility for returning SQL result sets to
browsers.

Even a small iSeries can process SQL queries against
tens of millions of records efficiently, unless you're
bumping into a 5250 CPW constraint, or an
application/database design constraint.

On an iSeries, you have a lot of options for
"managing" performance constraints, which simply are
not available under Windows or MS SQL Server.


Nathan Andelin


--- Tom <tomh5480@xxxxxxxxx> wrote:

> Our problem is performance; we're having scores of
> simultaneous searches on 
> 10s of millions of db records.  An upgrade to an
> iSeries system capable of 
> handling our projected needs over the next 3 years
> (hundres of simultaneous 
> searches on 100s of millions of records) will cost
> at about $500K, another 
> $1M+ after that.  My gawd.
> 
> So... I'm exploring alternatives to spending that
> kind of money.
> 
> Option 1 (for me) is quicker. I don't know what
> performance will be like 
> using a 3rd party connector (such as RPG2SQL), so
> I'll have one of our Java 
> programmers explore option 2 (JDBC).
> 
> That said: where can I find more info/examples of
> using JDBC to pull data 
> from a MS SQL server?  Our Java guys know virtually
> nothing about the 
> iSeries, and I'll need to give them a starting
> point.
> 
> Tom
> 
> <rob@xxxxxxxxx> wrote in message 
>
news:OF7BD5A123.2E23F2C0-ON05257018.0074F34D-05257018.007560B8@xxxxxxxxxxxx
> > Been a LOT of discussion on this support, or lack
> thereof, lately.
> >
> > You have a few choices:
> > 1 - Spend money for a canned solution
> > 2 - Learn java and use jdbc
> > 3 - Seek alternative solution.
> > 4 - Submit DCR to IBM to get what you are trying
> to work to do so.
> >
> > People happy to take your check:
> > a - IBM for something called websphere integrator.
>  What it has in common
> > with Websphere - who knows.  Marketing ploy I
> suspect.  Don't let it
> > confuse you.
> > b - Search for John Brandt for his solution
> > c - Search for Vern Hamberg and the company he
> works for now.
> > d - Possibly some others.  (Forgive me if I've
> missed you.)
> >
> > The native lack to do what you are trying to do is
> chafing us mightily.
> >
> > Rob Berendt
> > -- 
> > Group Dekko Services, LLC
> > Dept 01.073
> > PO Box 2000
> > Dock 108
> > 6928N 400E
> > Kendallville, IN 46755
> > http://www.dekko.com
> >



                
__________________________________ 
Discover Yahoo! 
Stay in touch with email, IM, photo sharing and more. Check it out! 
http://discover.yahoo.com/stayintouch.html