Db2 Administration Tool for z/OS

Showing 132

DB2 Administration Tool enhancement for SQL, DDL, DML syntax checking

Add enhancement to syntax check SQL, DDL, DML before execution. Recently attended presentation of Db2 DevOps Experience for z/OS and it has a 'Smart Editor' which performed these checks. I asked about it and was told it is using macros from the DB...

over 5 years ago in Db2 Administration Tool for z/OS 0 Planned for future release

11 VOTE

Create online hierarchical DDL command

Currently, we have either the DDL or GEN commands to view the object definition. We would like GEN to be online (currently batch only) or have a new command. The action should produce the data in an online format (temporary dataset) for viewing or...

almost 5 years ago in Db2 Administration Tool for z/OS 3 Functionality already exists

10 VOTE

LKEY and TT for other table types

Please update the LKEY and TT commands to work with all table types (not aliases and views but should include regular tables like archive, history, and MQT, etc.) Also, TT should be displayed on first search screen. Refer to case TS003373784

over 4 years ago in Db2 Administration Tool for z/OS 1 Planned for future release

8 VOTE

Allow multiple deletes of change statements

In comparing databases from one environment to another there is likely a list of changes we do not want to apply yet for a variety of reasons. The resulting compare creates a change ID. The tool allows us to delete these statements. However, the p...

about 4 years ago in Db2 Administration Tool for z/OS 1 Not under consideration

9 VOTE

Tool needs to have memory of the object searched

If I go into view the catalog object. Let's say environment UNIT for table XYZ then back out to switch environments the tool should remember what I searched on last. Or even better be able to switch Db2 groups on the search panel and not have to g...

almost 5 years ago in Db2 Administration Tool for z/OS 2 Planned for future release

8 VOTE

ADB25 - LISTDEF and TEMPLATE tables should be part of the system and not be allow to have DBA decide on the names

Currently DBA can create tables for LISTDEF and TEMPLATES. This can cause each DBA to have a copy of their own table, backup issues since they are created in the temp DB. These tables should be created within DBADMIN. The feature to create them ad...

over 4 years ago in Db2 Administration Tool for z/OS 1 Not under consideration

6 VOTE

GOC - ADD PARTITION ENDING AT ('2021-02-10-23.59.59.999999'); generating TS drop/create instead of an alter

DB2 V12 allows ADD PARTITION ENDING AT ('2021-02-10-23.59.59.999999'); to be materialized with an Alter. GOC is using old DB2 rules which drop/create TS.

over 3 years ago in Db2 Administration Tool for z/OS 1 Not under consideration

8 VOTE

Add function to do a mass LIKE command

Instead of modeling a single table space or table, for example, we want to use an entire hierarchy of objects to start building a new sets of objects. For example, we do MASSLIKE (example command name only) on a table space and it would pull into ...

over 4 years ago in Db2 Administration Tool for z/OS 1 Not under consideration

8 VOTE

Change Management - copy then modify previously saved dialog

We are a new user of the IBM tools. I'd like the ability to copy the existing saved dialog and then modify it (change environments). If there is an existing way to do this or workaround let me know. Editing the dataset "user.ADMIN.SAVEDLGS" isn't ...

over 4 years ago in Db2 Administration Tool for z/OS 2 Not under consideration

1 VOTE

Add parameter to the TCz Db2 Parameters panel CCQPDB2

Adding the following parameter to the TCz Db2 Parameters panel CCQPDB2: Customized Table lib . . . ______________________________________

8 months ago in Db2 Administration Tool for z/OS 0 Future consideration

Please enter your email address

FILTER BY CATEGORY