Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 10327
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 HEX value search in a DB2 query maxsubrat DB2 2 Wed Oct 04, 2017 3:04 pm
No new posts User access certification In Mainfram... Virendra Shambharkar All Other Mainframe Topics 4 Tue Oct 03, 2017 12:32 pm
No new posts Mainframe scheduling tool ddhar Compuware & Other Tools 2 Wed Sep 27, 2017 12:48 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us