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!

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

#Db2Tools

Latest Blogs

  • 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 ...

  • 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.
  • 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 ...

  • 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.
  • 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.

Latest Discussions

  • 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. ...

  • 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 ...

  • 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 ...