Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Tool to access DB2 Zos - For Query purpose

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Thu Oct 04, 2012 6:17 pm    Post subject: Tool to access DB2 Zos - For Query purpose
Reply with quote

Hi,

Is there any freeware/shareware available which can be connected to DB2 Zos from windows?

I need this only for query purpose.

This shop does not have any such tool. There is DB2 Luw 9.1 available but i was not able to connect to DB2 zos.

Thanks in advance.
Back to top
View user's profile Send private message

Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Thu Oct 04, 2012 6:50 pm    Post subject:
Reply with quote

Look at Teradata sql assystant

http://www.teradata.com/tools-and-utilities/SQL-assistant-web/

It can connect to DB2\TERADATA\ORACLE \SQL SERVER etc..
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Oct 04, 2012 7:53 pm    Post subject:
Reply with quote

Squirrel.
And I do believe (but not 100%) that if you have a license for DB2 zOS, you get QMF for Workstation included.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Thu Oct 04, 2012 7:56 pm    Post subject: Reply to: Tool to access DB2 Zos - For Query purpose
Reply with quote

anyway... the whole thing is not a snap of fingers one...
a bit of setup has to be done

and also some authorizations are needed to install <software> on the employer WS
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Oct 05, 2012 8:33 am    Post subject:
Reply with quote

Hi,

What about IBM Data Studio, as enrico mentioned it requires local administration rights on the workstation to install it.

Also IBM Data Server Client, you can ask your support they would definately have it already configured to connect mainframe DB2 subsystems. This is a GUI tool, it has control center/Command Editor/configuration assistant using which you can can query mainframe DB2 tables.

Thanks,
Sushanth
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Oct 05, 2012 7:16 pm    Post subject:
Reply with quote

Hello,

If you connect to the mainframe as a 3270-type terminal, you should be able to run queries via SPUFI. Assuming you have permission to access the database(s).
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Mon Oct 08, 2012 3:23 pm    Post subject:
Reply with quote

Thanks... everyone for the replies... I have installed IBM data studio and its working fine but its little slow compared to QMF for windows in retrieving results.

I even tried with SQL assistant - teradata, I am not able to connect to ZOS.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Omegamon for DB2 query ashek15 DB2 0 Wed Feb 15, 2017 11:25 am
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us