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

On 6/7/05, 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.

I would first look at a socket connection to a windows networked PC.
When a .NET program runs a query against SQL database ( could be SQL
Server, could be iSeries DB2 ) it basically passes an SQL statement to
the server and receives back a detachable, standalone data set.   With
a socket connection to the PC, your RPG program could be effectively
accessing the SQL server database the same way a .NET program would. 
Pass an SQL statement to an interface, get back a data set.

As far as ramping up to handle the volume you expect - that should
just be a matter of adding more PCs that your RPG program would be
connecting to.  I dont have first hand experience with load balancing,
but that is what this scenario would be about, no?

-Steve


> 
> 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
> >
> >
> >
> >
> >
> > "Tom" <tomh5480@xxxxxxxxx>
> > Sent by: midrange-l-bounces@xxxxxxxxxxxx
> > 06/06/2005 03:55 PM
> > Please respond to
> > Midrange Systems Technical Discussion
> > <midrange-l@xxxxxxxxxxxx>
> >
> >
> > To
> > midrange-l@xxxxxxxxxxxx
> > cc
> >
> > Subject
> > How do I connect from iSeries to MS SQL Server 2000?
> >
> >
> >
> >
> >
> >
> >
> > I have a database on a MS SQL Server (SP3a), installed on a Windows XP Pro
> >
> > (SP2) testbed.  I think that I've got the DRDA stuff set up properly on
> > the
> > AS400:
> >
> > 1. ADDTCPHTE INTNETADR('192.168.30.66') HOSTNAME((TOMDELL))
> > 2. QSYS/ADDRDBDIRE RDB('TOMDELL') RMTLOCNAME('192.168.30.66' *IP)
> > 3. ADDSVRAUTE USRPRF(TOMH) SERVER(TOMDELL) USRID(TOMH)
> > PASSWORD('PASSWORD')
> >
> > I start up Interactive SQL on the 400, and enter this command:
> >
> > connect to TOMDELL user tomh using 'PASSWORD'
> >
> > And I get this error log:
> >
> >>strsql
> >>A remote host refused an attempted connect operation (CPE3425)
> >>DDM TCP/IP communications error occurred on connect() to Application
> > Server
> >>(CPD3E34)
> >>File QCNDDMF was already closed, never opened or not from this process
> >>(CPF4404)
> >>Cannot establish DDM connection with remote system (CPF9162)
> >>Communication error occurred during distributed database processing
> >>(SQ30080)
> >
> > I'm weak on the PC side of things - to allow the connection to the pc
> > database:
> > 1. I've "heard" DRDA is available for MS SQL Server - true?  How do I
> > get/activate it? Or is it already active after initial MS SQL Server
> > installation?
> > 2. Is there some config that I need to check in MS SQL Server 2000?  How
> > about in Windows XP Pro?
> > 3. There's no firewall running on the PC, there is a corporate firewall.
> > Do
> > I need to make sure that some particular ports are open?
> > 4. Is there some .net or other PC software thing that I should install to
> > get this working?
> >
> > Tom
> >
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email:
> > MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email:
> > MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
> 
> 
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>