| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2003-02-20 : 13:24:44
|
| Does anyone have experience with connection SQL2k to a DB2 Mainframe Database? I believe I can set it up using OLEDB through a gateway, but has anyone ever gone directly to DB2, through IP?Any comments are greatly appreciated.ThanksBrett8-) |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-02-25 : 14:20:30
|
| 7000 members and no one has experience with this? I'll post it when I figure it out.Brett8-) |
 |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-02-25 : 15:49:31
|
| Where I come from we either:a) Have nightly batches transfering datab) Use MQSeriesThe mainframe people here would never let us set up a direct connection to a mainframe database. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-02-25 : 15:58:32
|
| Thanks for your reply AndraaxI'm immersed in both worlds, and they are light years apart. I've already started setting up DB2 Unloads in JOBTRAC scheduled to run every 60 minutes (bottom of the hour), and then FTP to the server. A scheduled job on SQL server will wake up every 60 minutes (top of the hour) and truncate all of the tables and bcp the data in and archive the files to folders.....All of this is VERY PAINFUL (BORING) compared what I can do with things like sp_addlinkedserveraaaaaaaahhhhhhhhhhhhhhhhhhhhhhhhBrett8-) |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-02-27 : 08:52:56
|
| Yeah, I see your point... I would love to have direct access to some of the DB2 databases for our legacy systems. BTW I have set up my own "listening" procedure running once/minute, which looks for new files from the mainframe to process. Works OK for us when realtime is not required.For realtime we work with MQ, as I mentioned earlier. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-02-27 : 08:59:40
|
| I found the following that deasls with OLE DB direct to DB2:http://www.hitsw.com/but the pricing is somewhat high. I've downloaded a demo and am trying it out now.Someone told that .NET should be able to do this easily, but not that I've figured out yet.Brett8-)Pricing is per processor:Brett,Here is our pricing for an Open Server.HiT ODBC Server/DB2 Open Server for DB2 OS/390 PlatformThis licensing option provides you open concurrent connections betweena single NT/2000 server and DB2 server(s). This license is priced basedon the size (number of processors) of your NT/2000 Server.Number of Processors PriceSingle........................... $5,995Dual............................. $8,995Quad............................ $14,995Support - Basic Maintenance and AMSCBasic Maintenance is standard with each product license. It includes 30days of technical support via email and telephone, plus future electronicMaintenance Releases (patches) for the purchased version of product.An optional Annual Maintenance and Support Contract (AMSC) is available.AMSC fees are 20% (minimum $500) of the total license cost and include,in addition to Basic Maintenance, the following:- Major Product Upgrades (major feature and performance enhancements)- Minor Product Upgrades (secondary feature and performance enhancements)- New Documentation Releases- Annual Technical Support (telephone and email) |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-02-27 : 09:28:41
|
| Have you looked at MS Host Integration Server? I think it has some kind of OLEDB provider for DB2 on mainframe. |
|
|
|
label
Posting Yak Master
197 Posts |
Posted - 2003-03-04 : 07:33:05
|
quote:
Someone told that .NET should be able to do this easily, but not that I've figured out yet.
[/b1. You mentioned "gateway"......I'm unclear what that is? If my server is on the samenetwork I'm on, why couldn't I just establish a linked server using the IP addy of the server. 2. I'm using .NET to develop.....have you run across any more info on how to utilize it to connect with a DB2? Thanks. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-03-04 : 09:41:01
|
| I guess you're talking about UDB on Linux/Unix/NT. My problem is with DB2 OS/390 (Mainframe). Sorry for the confusion.Brett8-) |
|
|
|
label
Posting Yak Master
197 Posts |
Posted - 2003-03-04 : 09:53:21
|
quote:
I guess you're talking about UDB on Linux/Unix/NT. My problem is with DB2 OS/390 (Mainframe). Sorry for the confusion.Brett8-)
Actually, the DB2 server I have to connect to is on an IBM AS400 mainframe so I might have the same issues as well and just haven't gotten that far. I was under the impression that I could just plug the IP addy assigned to the instance of the DB2 server on the mainframe and that would allow me to connect to it? |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-03-04 : 10:22:16
|
| Might do... Although the AS/400 is not really a mainframe computer. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-03-05 : 02:04:51
|
| Hmmm ... We had some really INTERESTING issues using SQL7 and DB2 v6 for z/os.Largely around the dirvers, we got to the stage where we could run a simple select query on the SQL box, targeting the DB2 MF db, and SQL blue screened ! Eventually, we found a way around by using SNA server to install a driver we could use. Give me an email and I'll post you the doc, although bear in mind we eventually went away from this solution - i.e. when we finally got it working, they decided they didn't need it any more, so I can't comment on further problems you might experience, and I have no knowledge about licencing costs etc. involved.remove SPAM, and to:regan.galbraith@sanlam.co.zaSPAMFYI - I'll review the doc, and find out if there are any issues about making it available for the articles section - since I'm not the author, I can't go a sub it now.*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
sp_AddLinkedServer to DB2 zOS