473,405 Members | 2,344 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

connect Z/OS database from windows

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
Jul 31 '08 #1
2 3954
sakumar9
127 Expert 100+
You need to catalog the ZOS db on your windows machine. You can refer to the following commands:

Expand|Select|Wrap|Line Numbers
  1. db2 catalog tcpip node <name> remote <ip address> server <service> ostype mvs
  2. db2 catalog dcs database <dbname> as <dbname>
  3. db2 catalog database<dbname> as <dbname> at node <node-name> authentication DCS
Aug 1 '08 #2
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:

Expand|Select|Wrap|Line Numbers
  1. db2 catalog tcpip node <name> remote <ip address> server <service> ostype mvs
  2. db2 catalog dcs database <dbname> as <dbname>
  3. db2 catalog database<dbname> as <dbname> at node <node-name> authentication DCS
Aug 2 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
5
by: mayamorning123 | last post by:
A comparison among six VSS remote tools including SourceOffSite , SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET To view the full article, please visit...
5
by: Daniel Bass | last post by:
I setup a asp.net project running on http://localhost/ which connects to a database on another server running sqlserver... I was able to connect to the database and create my application no...
3
by: asemeiks | last post by:
I'm using Access 97, Jet 4.0. the data resides on a Win 2000 domain server. Using .Net 1.1 and IIS 5.0 on a local XPPro computer I am trying connect to a Jet database on the server. If the data...
4
by: traceable1 | last post by:
I have a couple new servers - Windows 2003 R2 - with SQL Server 2000 SP4 installed. They are all Active/Active clustered instances (my first ones). I am trying to create database links to other...
3
by: Gregor =?UTF-8?B?S292YcSN?= | last post by:
Hi! Is it possible to alter tablespace so that you don't connect to the database? The problem I have is this. I got a DB backup from a machine with 16 Gb of RAM. There was a bufferpool set to...
3
by: =?Utf-8?B?Ulc=?= | last post by:
Using this code: Dim oConn As SqlClient.SqlConnection oConn = New SqlClient.SqlConnection() oConn.ConnectionString = "..." 'Connection string I got via an .udl file oConn.Open() I get an...
2
by: jeffhan | last post by:
we have os/400 db2 database at the backend. i installed db2 v9 connect server on one windows server which is locating the same network with database server. now how to i configure the connect...
3
by: =?Utf-8?B?ZGF2aWQ=?= | last post by:
Last week I asked a question about connection to database from client machine (developer machine). I have changed the database security setup for "SQL Server and Windows" under (local)Windows NT...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.