connect Z/OS database from windows

[amitjoshi01]

Hi,

I need to download some data from tables present on Z/OS. I need to download this data on my windows machine.

How can I use the DB2 client to connct to Z/OS from Windows? How to establish that connection and travese through the database on Z/OS?


Waiting for your suggestions.

Thanks & Regards,
Amit

[sakumar9]

You need to catalog the ZOS db on your windows machine. You can refer to the following commands:

db2 catalog tcpip node <name> remote <ip address> server <service> ostype mvs
db2 catalog dcs database <dbname> as <dbname>
db2 catalog database<dbname> as <dbname> at node <node-name> authentication DCS

[amitjoshi01]

Thank you very much for the guidance. Can you please tell me is there any documentation available on how to catalog this database? Can we use client configuration assistance to catalog the database?

Can you please simplify and explain this catalog procedure?

Waiting for your reply.

Thanks & Regards,
Amit

You need to catalog the ZOS db on your windows machine. You can refer to the following commands:

db2 catalog tcpip node <name> remote <ip address> server <service> ostype mvs
db2 catalog dcs database <dbname> as <dbname>
db2 catalog database<dbname> as <dbname> at node <node-name> authentication DCS