IBM.Data.DB2

Can I develop a Windows application using the .NET framework and the IBM.Data.DB2 provider to access a DB2 database running on OS / 390?

Thanks in advance.

0


source to share


3 answers


Defender IBM (or more accurately, allows its clients to protect) their mainframe access to DB2 is very close. I suspect this is because even business supporting applications even try to connect (JDBC clients that don't have the license file they need don't even get their requests appearing on the TCP mainframe ports, they are blocked on the client side) - mainframe is usually business critical as most desktop and server applications only dream of becoming :-).

When using JDBC drivers, one type 4 driver is used to access all DB2 platforms (LUW, iSeries, System z, etc.), but in fact you must have a license file installed in your CLASSPATH for certain platforms, or you get an exception.

This license file is of the form " db2jcc_cisuz.jar

", where cisuz specifies which platforms are allowed to access (cu is the most common, but does not give access to iSeries or System z).



Typically you need to purchase DB2 Connect from IBM in order to obtain these files, and I suspect this will be a similar situation for the .NET platform. You may find that the DB2 Connect products have .NET client drivers as well as JDBC (I haven't looked). Look for the "Enterprise" version of this product, as the standard ones are unlikely to be System z licensed.

And just a minor annoyance, it's not OS / 390 (unless you're one of the rare Japanese customers who pay specifically to support this dinosaur). This is z / OS.

+1


source


I'm not sure about OS / 390, but at work I'm co-developing a .Net application that connects to a Solaris DB2 instance. We are using standard IBM.Data.DB2, so I believe OS / 390 should work as well.



0


source


I've used MS Host Integration Server to connect a .Net application written in C # with DB2 before, maybe not what you're looking for, but I know it works. Below is the link for more information on MS HIS

0


source







All Articles