Db2 Tools for z/OS

View Only

Welcome to the Db2 Tools for z/OS Community!

When you join and sign in, you will have access to current discussions, events, blogs, articles, and other content related to Db2 Tools for z/OS as well as Data Virtualization Manager for z/OS (DVM for z/OS) and QMF. This integrated community will provide you with insights into how these offerings can deliver exceptional value to support and extend your data infrastructure investment.

As a member, we encourage you to share your best practices, tips, and techniques. You can also pose questions in the discussion forum where others, including IBM subject matter experts, can respond. The library contains product-specific and more detailed how-to information. To get started - check out the content below.

Quick Links

Join related communities!

Db2 for z/OS and its ecosystem

Please direct any questions/comments about the community to azawacki@us.ibm.com or jwreed@us.ibm.com

#Db2Tools

Latest Blogs

Creating a user-defined schema using the new multiple schema support in the IBM Data Virtualization Manager Studio

By: Clive Harriss yesterday

Introduction. Until recently, IBM Data Virtualization Manager for z/OS (DVM) could only create virtual tables or views under the default schema DVSQL. This limited the ability for multiple organizations to define virtual tables with the same name ...
Fine tune your Db2 Automation Tool jobs using advanced SQL and job groups.

By: Robbie Hargett 4 days ago

IBM Db2 Automation Tool simplifies the process of generating Db2 utility JCL by using job profiles. Job profiles incorporate utility, exception, and object profiles, and can be easily customized to trigger Db2 utilities for selected objects. For example, ...

2 people like this.
Extracting DBDs and PSBs from the IMS Catalog in IBM Data Virtualization Manager

By: Clive Harriss 15 days ago

Introduction IBM Data Virtualization Manager for z/OS (DVM) provides seamless, real-time controlled access to IBM Information Management System (IMS) database data. It allows ODBC, JDBC, DVM client, and web clients to access IMS database data as a ...
Db2 Administration Tool: New "Tips and Tricks" video for the catalog navigation command

By: Kate Wheat 2 months ago

This new video shows you how to use the ? (CAT) command in Db2 Admin Tool as a shortcut to quickly view Db2 catalog information. https://video.ibm.com/channel/24061261/video/catnav Db2 Admin Tool video playlists: Tips and Tricks videos: ...

1 person likes this.
Db2 Administration Tool: New "Tips and Tricks" video for GEN and masking

By: Kate Wheat 2 months ago

This new video shows you how to generate DDL for multiple objects and use masks to change names in the generated DDL. https://video.ibm.com/channel/24061261/video/gen The complete video playlist for Db2 Admin Tool is available at https://video.ibm.com/playlist/638786 ...

1 person likes this.

RE: Information Xchange - 5th Topic

By: Jesper Krommes , 17 hours ago

Hi Sowmya It is good news to hear that Index-Adbisor will be built in into Administration Foudation. The API enabled service is not an option for our developers. The developers have to have a GUI interface as in Data server manager and Data Studio. ...
RE: Information Xchange - 5th Topic

By: SOWMYA KAMESWARAN , yesterday

Hello Jesper, The Index-advisor capability for tuning single SQL as well as SQL Workloads will be made available through the Query Workload Tuner for zOS (API enabled service) and the User experience is being built on Db2 Administration Foundation. Work ...
RE: Information Xchange - 5th Topic

By: Jesper Krommes , 5 days ago

Do you have any news about the future for index-advisor functionality in "Data Server Manager" "IBM DBb2 Data Management Console" "IBM DB2 Administration Foundation" The Index Advisor is essential for DBA in tuning thousands of long running ...