Db2 for z/OS

Showing 793

Modify the DSNJU003 utility to allow it to define anything stored in the Db2 BSDS

When creating and new Db2 member, we must bring it all the way up before we can create the bufferpools, size them, and set the thresholds. We would like the ability to defined them prior to starting the Db2 member/subsystem. When creating an alias...

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

1 VOTE

CREATE TABLE LIKE "table-controlled partitioning" should create the table with same partitioning scheme and rules

When a table that uses table-controlled partitioning is identified in the LIKE clause, the new table should automatic inherit the partitioning scheme of that table and create an uts PBR.

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

5 VOTE

DB2 for zOS correlated column behavior

Problem statement - unqualified column name interpreted as correlated reference. As per example below: DELETE FROM SYSADM.T1 WHERE COL3 IN (SELECT COL3 FROM SYSADM.T2)--> DSNT404I SQLCODE = 012, WARNING: THE UNQUALIFIED COLUMN NAME COL3 WAS INT...

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

4 VOTE

Enable UUID as a column type, and generation of UUIDs

As we are moving towards more microservices on Z, and more interaction with cloud services, where UUIDs are much more used, we see a growing need for saving and generating UUIDs on Z. We therefore propose that UUID be made a column type in DB2. Th...

about 1 year ago in Db2 for z/OS 3 Not under consideration

20 VOTE

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

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

25 VOTE

FL LEVEL support

In Db2 12 the Functional Level is currently *not* externalized in various places where it most definitely should be. Notably the PLAN_TABLE, IFCID 316 and IFCID 401. If you are attempting tuning you *must* know under which FL level the SQL in ques...

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

about 4 years ago in Db2 for z/OS 2 Not under 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 ...

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

11 VOTE

Allow for "OPTIMIZE FOR n ROWS" to be added to DELETE, UPDATE Statements

OPTIMIZE FOR 1 ROW can be added to SELECT SQL. One reason may be to influence the optimizer to chose one index over another, or to not perform a SORT with List Prefetch Adding OPTIMIZE FOR 1 ROW to a DELETE statement results in an error: EXPLAIN A...

almost 3 years 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

Please enter your email address

FILTER BY CATEGORY