Db2 for z/OS

Showing 959 of 14787

Enhance DSNACCOX

Based on the recommendations from the recent Best Practices webcast, I believe that DSNACCOX should be enhanced to reflect these recommendations. Rules to trigger reorgs For indexes: Pseudo-deletedentries: REORGPSEUDODELETES/TOTALENTRIES > 5% I...

about 4 years ago in Db2 for z/OS 0 Functionality already exists

26 VOTE

Dictionary last build date

MR0622114827 GGDB211003

over 11 years ago in Db2 for z/OS 2 Not under consideration

6 VOTE

Enhance DPfD support so that statement cache, thread storage, DDF Comms buffers and any other areas that may contain SPI data are marked as eligible for redaction

We tried DPfD (Db2 APAR PH15940) but found that an SVC dump of Db2 still contained SQL statements in the dynamic statement cache after redaction (using BLSJDPFD). We appreciate that bufferpools are redacted, but we are concerned that SPI may be ca...

over 2 years ago in Db2 for z/OS 1 Not under consideration

2 VOTE

Set object status to prohibit data access

Before we drop a Db2 table we need to make sure that noone use the object in any way. We solve this now by stopping the tablespace and keeping it stopped for about six months. This means that noone can access the data and noone can run a utility a...

11 months ago in Db2 for z/OS 0 Future consideration

12 VOTE

Use CURRENT SCHEMA for EXPLAIN table SCHEMA

Currently the CURRENT SQLID is the only SCHEMA used by EXPLAIN processing. This is a real pain as changing the CURRENT SQLID is an auditable event. The use of SET CURRENT SCHEMA works for *all* other cases - Only EXPLAIN fails here. So the request...

over 5 years ago in Db2 for z/OS 0 Not under consideration

2 VOTE

Have new authority for REFRESH of MQT that does not require high privilege levels

We historically have an application batch userid that has DBADM authority. We are limiting all access to this ID to the minimally required authority it requires such as load, imagecopy and runstats at the DB level. When we started converting our t...

11 months ago in Db2 for z/OS 1 Not under consideration

8 VOTE

Add catalog information when a Compression Dictionary was created

The compression dictionary date created is currently not available to help identify the age of the dictionary. The age would also help to identify dictionaries create before upgrading to the latest release.

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

3 VOTE

Report Which Member(s) Are Holding Up Commit-LSN Advancement

Requesting that Db2 issue a message when the commit LSN enhancement hasn't made progress for in a reasonable period of time, preferably with the LSN of all Db2 members so that Db2 customers can identify which member(s) could be holding up the LSN ...

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

17 VOTE

Provide option to control the bypassing of the authorization checking for mapping objects when dbname is used in REORG job

Implicit mapping objects are seen as transient as they get created and dropped within the duration of the REORG. Therefore REORG logic was enhanced to bypass the authorization checking for it (PI08339). These objects might be transient and interna...

almost 8 years ago in Db2 for z/OS 1 Not under consideration

20 VOTE

Add and drop include columns to/from unique index as a pending change

To accomplish high availability for schema changes in a 24/7 environment, an addition of an Include Column to a unique index should be implemented as a pending change that is materialized by an online REORG. Dropping an include column from a uniqu...

about 9 years ago in Db2 for z/OS 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY