Db2 Administration Tool for z/OS

Showing 141

Db2 Admin Tool - issue regenerate view after table column alter

After altering a table column referenced by a view an alter regenerate view should be issued as best practice. IBM Db2 Admin Tool does not issue the regenerate view command currently and we believe it should. After discussing with Db2 Support and ...

almost 2 years ago in Db2 Administration Tool for z/OS 1 Future consideration

3 VOTE

Out of date rebind listings in admin tool implementation and backout jobs

We request a new feature that would ensure the rebind listings were up to date at the point of execution e.g. dynamically check at run time for relevant packages with a bind date AFTER the analysis timestamp, generating a "missing binds" step to run.

about 1 year ago in Db2 Administration Tool for z/OS 0 Future consideration

11 VOTE

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 3 years ago in Db2 Administration Tool for z/OS 0 Planned for future release

5 VOTE

SEL Prototype to include HIDDEN columns

Contents of Hidden columns can only be viewed by explcitly naming them in a SELECT statement. There is no problem with this but there are times when I want to a) know that a column is hidden from the column panel ADB21TC b) issue a SELECT that wil...

over 1 year ago in Db2 Administration Tool for z/OS 0 Future consideration

9 VOTE

ADB27C panel constraint/primary key column flag

On the ADB27C panel, give the user a facility (or let them know upfront) whether any columns are part of a constraint, index or anything that requires “extra work” (e.g. Having to use UP,DP to update, etc.

about 3 years ago in Db2 Administration Tool for z/OS 0 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...

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

1 VOTE

Different Utility options for Implementation and Backout

A-HA is raised for the tool to provide the choice for different utility options for implementation and Recovery. At the moment the utility options apply to BOTH implementation and recovery job stream. There may be a need for choosing a Reorg when ...

4 months ago in Db2 Administration Tool for z/OS 0 Future 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...

over 3 years ago in Db2 Administration Tool for z/OS 2 Planned for future release

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

about 3 years ago in Db2 Administration Tool for z/OS 1 Future 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 ...

about 3 years ago in Db2 Administration Tool for z/OS 2 Future consideration

Please enter your email address

FILTER BY CATEGORY