Db2 for z/OS

Showing 958 of 14839

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

3 VOTE

Parameter to set REORG interrupt due to an unexpected wait

There are situations where a REORG utility can cause locks. A few weeks ago we suffered an episode of timeouts because a Reorg that was locking in the log phase. The Reorg was performing the consolidation of an ALTER DSSIZE in a UTS PBR. We didn't...

over 1 year ago in Db2 for z/OS 1 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

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

1 VOTE

CANCEL THREAD Enhancement - to cancel threads by specifying a SCOPE(ssid)

This will help in cancelling of threads running in any of the LPARs in a Parallel Sysplex. Currently, DISPLAY THREAD supports SCOPE(GROUP). So, this would be a good feature to have. These can be very useful during IPLs when some thread is holding ...

6 months ago in Db2 for z/OS 1 Not under 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...

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

25 VOTE

support list partitioning - Range-Partitioning allows only to define the upper limit for a partitioned Tablespace.

Full Support for LIST-Partitioning required! With classical Partitioning or UTS Partion-by-Range you can only define the upper limits (key-Ranges) for a partitioned Tablespace. The lower partition-range ist defined by the highest value of the next...

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

25 VOTE

Add MERGE-functionality on LOAD-utility

MR0112077423 GGDB207006

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

11 VOTE

Have GET generate a useful Swagger doc for REST services that call native SQL SPs

Within a REST client like Postman or SoapUI, you can call the URI for a Db2 REST service with the GET command and the client will, from information passed to it from Db2, build a Swagger document that describes the data being sent to/from the REST...

about 5 years ago in Db2 for z/OS 3 Not under consideration

Please enter your email address

FILTER BY CATEGORY