Db2 for z/OS

Showing 957

I would like to force the use of the "DEFER" option on the creation of an index (using Zparm to make it optional).

We have DBAs that at times (accidently) run a "CREATE INDEX" and fail to include the "DEFER" option. This is rather easy to do because the reverse engineering tools fail to create syntax with the "DEFER" option. The creation of indexes can be very...

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

15 VOTE

Full Column Match and I1 Access on SQL with Correlated Sub-Queries Containing Column Expressions and Supporting IoE

Some queries with column expressions - DATE(A1.EFCTV_TS) <= DATE('04/05/2020') for example, and an Index on Expression to support the expression are achieving I1 access while others are not. It appears this is because of how the query is curren...

almost 4 years ago in Db2 for z/OS 2 Not under consideration

9 VOTE

DSN1COPY support for XML data in all cases

DSN1COPY does not currently supports XML table restore on another DB2 subsystem or in the case of a dropped XML tablespace. This lack can be easily bypassed by an UNLOAD / RELOAD in the case of a copy to another DB2 subsystem. But in the event of ...

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

9 VOTE

select ... from final table ( update table for portion of business time from ... )

the problem is that an update table for portition of business time can effect more than 1 row and if this is made in a bitemporal environment the System Start is set to the first change timestamp. But you didn't know the exact time you have to rea...

over 2 years ago in Db2 for z/OS 0 Future consideration

18 VOTE

Support DB2 LUW Specific Functions that are Missing in DB2 z/OS

State of California Office of Systems Integration (OSI) uses Db2 LUW in AIX environment, to support Child Welfare Reporting Caseworkers. We are working on a proof of concept to demonstrate transitioning of reporting workloads from Db2 LUW to IDAA ...

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

20 VOTE

Db2 To Provide A Way To Override Certain Implicit Table Space Parameters Default Values

TSYS has QMF applications running in 6 UAT and Production Db2 environments. There are approximately 2,600+ client users running QMF queries and procs for their applications in those Db2 environments. Many of the users are creating temporary tables...

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

4 VOTE

There should be a table like SYSUTILITIES that contains Db2 Commands that have been issued

There should be a table like SYSUTILITIES , say SYSCOMMANDS, that contains Db2 Commands that have been issued, including the full text of the Db2 command that was issued.

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

2 VOTE

Reduce message flooding on system console using Db2 System Profile Monitoring for security profiles when detecting non-secure connections and WARNING_DIAGLEVEL3

This Aha idea is being opened on behalf of Commerzbank (Ute Kleyensteuber). Security profiles are used with System Profile Monitoring filter LOCATION=*, ATTR1=WARNING_ DIAGLEVEL3, ATTR3=1 (TLS required) to discover all incoming non-secure connecti...

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

44 VOTE

Rename column should be possible if View is on table

We encountered that Rename column is not possible if a View esists on the appropriate table. We would like to exploit this new function (Rename Column), but we have views, which does not allow that. We already have a similar requirement MR02141152...

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

4 VOTE

Restart Time of DB2 should not be dependent on SCA size

During restart of DB2, the time difference between DSNR003I and DSNR004I is a function of the SCA size. Case TS009645595 was opened and has all the details. But in summary: this large time differenece of 30 seconds (in our case) is a function of t...

about 1 year ago in Db2 for z/OS 0 Under review

Please enter your email address

FILTER BY CATEGORY