db2 connect to os390 with .Net

[ingresman]

Hi,

Hs anyone attempted to connect to db2 on os390 with .Net on windows 2000 please ?

I've got to do a proof of concept, and I'm not a mainframe expert at all. I've looked for the release notes in the ibm site but it only covers 7.1 of db2 connect and even then it didn't say anything about os390 dependencies.

The version of DB2 on os390 is 6
db2 connect 8.1
.Net framework 1.1

I'll be usign the oledb .net class (as a .net native provider doesn't exist yet).

I'd be interested to see if anyone has done it ?, can a db2 connect 8.1 client talk to version 6 of db2 ?

My nightmare is that you need 8.1 for .net but 8.1 won't connect to 6 !!

any help or comments would begreatfully recieved.

Regards

Kevin

 

[sguslan]

With .net and any DB2 on os390, i find that by installing the microsoft HIS2000 client and using the microsoft oledb driver for db2 work easily and efficiently.
You need however to run a utility that ships with HIS2000 called something like "create odbc package" which creates some packages( isolation level stuff) on DB2, albeit, you need a DB2 admin with SYSADMIN authority to login from the utility in order for it to create such packages.
Once that is done, search SQL Server or HIS2000 books online to find out how to create a connection to DB2. Search SQL Server books online for "sp_asslinkedserver" and if you do not have it , take a peek at it from the ms sql server web site.
You will need to supply and know:
*Host IP address or name
*Port number
*Package name ( created by the oledb/his200 utility)
*DB2 Location name, it is the db2 subsystem name found in db2 sysibm.syslocations.
*db2 default schema, which can be sysibm or your db2 user account name
*the Code Page on the host db2, normally 37 if you are in the US and the pc apgecode, nromally 1252

Hope i did not forget anything ..

Do not dispair though ... I have been trying to get Java/J2EE stuff(even ibm's own WebSphere 5 ) to connect to the host and it is a nightmare. Still struggling for the past 5 days to do it. With .net it took me a mere 15 minutes to connect and display data from DataGrid...

Good luck ..

________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[sguslan]

Sorry for the typo ..
i meant sp_addlinkedserver ...

________________________________________________________________________________
If you do not like change, get out of the IT business...