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.

-----------------------
Learn about recent announcements!

On October 17, IBM announced Db2 Automation Expert for z/OS 1.1. This exciting new tool can help you improve efficiency, better meet business continuity goals and most importantly reduce IT costs. IBM also announced IBM Db2 Query Monitor for z/OS 3.4 and IBM Db2 High Performance Unload for z/OS 5.2. Learn more about these exciting product announcements -- read the announcement letter.

Download the latest content.

Use 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 Discussions

RE: Reorg SHRLEVEL REFERENCe

By: Soledad Martinez , 12 days ago

Hello Ka Chun, Thanks for your reply and points, very interesting. Really appreciate also the explanation about why even IBM thinking about moving from NONE to CHANGE finally it was discarded for not being realistic due to some customers needs or concerns. ...
RE: IDAA - IBM Db2 Analytics Accelerator - How to check ...

By: MEHMET CUNEYT GOKSU , 12 days ago

Hi Rajesh, You can use -DISPLAY STATS command (Db2) - IBM Documentation command with SCOPE(GROUP) option. The output will tell the status of Integrated synchronization for each IDAA targets from Data Sharing Group. Regards, Cuneyt ------------------------------ ...
RE: Reorg SHRLEVEL REFERENCe

By: Ka Chun Ng , 13 days ago

Hello Soledad and all, While there are some exception cases like NOT LOGGED table space, spatial index and expression index on LOB column which REORG does not support log apply today (and hence does not support SHRLEVEL CHANGE), I would say those scenarios ...

1 person likes this.
RE: Reorg SHRLEVEL REFERENCe

By: Ka Chun Ng , 13 days ago

Hello Soledad and all, While there are some exception cases like NOT LOGGED table space, spatial index and expression index on LOB column which REORG does not support log apply today (and hence does not support SHRLEVEL CHANGE), I would say those scenarios ...

1 person likes this.
IDAA - IBM Db2 Analytics Accelerator - How to check ...

By: Rajesh Chandran , 13 days ago

Hi, Can you someone tell me the steps to check the data synchronization between two accelerators ? I am having two accelerators defined in my IDAA alias. Recently due to an issue, I had to stop acceleration for one of the problematic ...

Profile Feature in QMF Z Client

By: Rajeev Das 6 days ago

Introduction: PROFILE is a newly introduced feature for customizing the application to each user's preference. The customized preference is retained if the user exits and relaunches the application. The customized preference is saved in each user’s ...
Db2 Administration Foundation: Loading object data to one or more accelerator servers

By: Preethi N 26 days ago

What have we introduced? We have implemented infrastructure changes to discover IBM Db2 Analytics Accelerator Loader Server for z/OS from IBM Db2 Administration Foundation for z/OS. You can use the Db2 Administration Foundation user interface changes ...

1 person likes this.
Conditional Formatting In QMF Z Client

By: Shashank Sonavane one month ago

Introduction: Conditional Formatting is a newly introduced feature within the form suite. Its primary objective is to enhance the readability of reports by highlighting specific rows or cell data based on predefined conditions. This feature significantly ...

1 person likes this.
Ordering Information for Db2 Administration Foundation for z/OS

By: Janet Figone one month ago

To make it easier for new IBM Db2 Administration Foundation customers to order the products that are needed to set up an initial Db2 Administration Foundation environment, see the newly published Ordering Information for Db2 Administration Foundation ...
Gain insights into potential savings with the new Db2 Utility Compare Report in IBM Db2 Automation Expert for z/OS.

By: Chris Pomasl one month ago

Gain insights into potential savings with the new Db2 Utility Compare Report in IBM Db2 Automation Expert for z/OS. IBM Db2 Automation Expert for z/OS has been enhanced recently with a brand-new Db2 Utility Compare report feature. It examines ...

1 person likes this.
Db2 Administration Tool and Utilities History: More Enhancements

By: Kate Wheat 2 months ago

Support for viewing Db2 utility history (in Db2 13 function level 501) was available in Db2 Administration Tool 13.1 at the time of GA (general availability). For a quick 5-minute video that demos this support, see Db2 Administration Tool 13.1: Utility ...

3 people like this.