SQL2000 on 'card' on IBM AS400

Question

SQL2000 on 'card' on IBM AS400

judithfa

Newbie

Points: 1
More actions
September 16, 2003 at 10:08 am

#59013

My company has an AS400 running other comapny stuff (db2). They want to also use SQL Server2000 but do not want to buy another computer.
Does anyone have any ideas about putting on some sort of special 'NT processor ' card that can be added into the AS400? IBM says it can be done.
Thanks,
Judith

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

I've read about it, basically a "blade" server living in an AS/400 box. Separate NIC, disk, etc. Haven't worked with it, but the cost of the card is probably not that much lower than a small server. Don't quote me, need to check it out.

It does add the same admin cost, possibly less power, cooling, etc. Certainly less space. Not sure if it's a big savings, but honestly I haven't really evaluated or used it.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

md40 SSC-Addicted Points: 405 More actions · Answer 2

quote:
I've read about it, basically a "blade" server living in an AS/400 box. Separate NIC, disk, etc. Haven't worked with it, but the cost of the card is probably not that much lower than a small server. Don't quote me, need to check it out.
It does add the same admin cost, possibly less power, cooling, etc. Certainly less space. Not sure if it's a big savings, but honestly I haven't really evaluated or used it.

I would recommend against the integrated Netfinity server card. It's a bit of a hassle to get configured and to install the OS. It sucks up hard drive space from the 400 as well. It does not have its own hard drive.

I also don't think the card is near the speed and capacity of a relatively-inexpensive server.

We have one, but we don't consider it a production-use server. We do have SQL2k running on it, but we don't use it for "real" tasks. We use our stand-alone servers for that.

EdVassie SSC Guru Points: 60472 More actions · Answer 3

The card is really designed to allow Windows-based applications access AS400 resources, especially the DB2 database.

I would echo the opinion that if you want to ignore AS400 resources and just run Windows, it is cheaper all round to buy a separate server.

"All information provided is a personal opinion that may not match reality"

All information provided is a personal opinion that may not match reality.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

bnordberg SSCertifiable Points: 5480 More actions · Answer 4

I agree with above. I did this once and found the card was expensive and not lots of fun to troubleshoot. Much better off to buy a $2000 rack server with IDE RAID ...

spongemagnet SSCrazy Points: 2812 More actions · Answer 5

Yea, the cards can also leverage your storage costs - but using storage costs to justify anything is just silly anymore

Space is really all you'll save. You don't magically gain access to the AS/400, db2 etc... The kicker is, you'd still need to use ODBC to access any DB2 stuff.

-Ken