Db2 Administration Tool for z/OS

Showing 20

Add capability of using GEN parameters in change management batch interface procedure (GOCCM)

We had below requirement from the user: We have an existing column in an existing table that we are adding a new RI to a new domain table. If we issue the compare normally using object comparison tool, we get both the table create DDL and the new ...

3 months ago in Db2 Administration Tool for z/OS 0 Planned for future release

9 VOTE

Allow execution of revoke impact in batch mode

During migration of security from native DB2 to RACF, there is cleanup activity after creation of all profiles and permits completed in order to remove grants in DB2 for a clean picture. Also, for any other security configuration change, clean up ...

6 months ago in Db2 Administration Tool for z/OS 0 Planned for future release

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

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

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.

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

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

7 VOTE

Control DEFER YES/NO based on type of index

Provide mask to control the DEFER setting based on the UNIQUERULE(SYSINDEXES) of the index (either via REXX or standalone). Currently the REXX won’t handle this because the Db2 catalog row sent to masking is the SYSINDEXPART row which doesn’t cont...

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

8 VOTE

DB2 Administration Tool enhancement for runstats profiles

Enhance the Administration tool when accessing objects via the system catalog, table info. When using the RP(runstats profiles) at the table level it shows just a portion of the data in the profile_text column from the SYSIBM.SYSTABLES_PROFILES. E...

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

5 VOTE

Object search screen - lengthen space for object names

Currently, the length of a table name or similar object is limited to 18 characters. This is an outdated standard since Db2 can accept much longer names. The pain point is that it's difficult to view or search for tables and impossible to copy/pas...

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

5 VOTE

DROP Aliases listed with a single DROP command

Hello IBM In Panel ADB21A you can list ALIASES and there are some line commands. One of them is DROP. In some cases our DBA would need to drop a whole bunch of ALIASES at a time. And it is quite uncomfortable to acknowledge all of DROP one by ...

about 4 years ago in Db2 Administration Tool for z/OS 0 Planned for future release

Please enter your email address

FILTER BY CATEGORY