Search results: Db2 for z/OS

Showing 79

Allow us to use the profile tables to set the ACCUMACC zparm more granular

At the present time we have ACCUMACC set to 20. We have had to set this to 1 for problem determination purposes. In our active system it causes issues with our SMF jobs when we have done this for even a short time. We would like the ability to use...

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

1 VOTE

Db2: V13 Access Path regression: Tablespace scan regresses to nonmatching index scan. After turning this in as a problem, we were told that it was working as designed. Our suggestion is that the design is flawed.

We feel the design is flawed and strongly feel this is a bug. The only time a non-matching index scan should be considered versus the tablespace scan is when it can at least filter the result somewhat. There are ZERO columns in the index that matc...

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

13 VOTE

Db2 z/OS limitations with ALTER TABLESPACE MOVE TABLE

I love the upcoming FL508 and this new availability even though I have not used it. Looking deeper into the Knowledge Center there seems to be some limitations that I would like to see resolved. The two items are: a) Exist in the same data...

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

27 VOTE

Pseudo IFCID 316

When using REOPT(ALWAYS) on a batch package to deliberately avoid filling the Dynamic Statement Cache (DSC) the SQL is, correctly, not inserted into the DSC and is not exrternalized by an IFCID 316. However this then "hides" the workload from moni...

over 9 years ago in Db2 for z/OS 1 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 4 years ago in Db2 for z/OS 1 Not under consideration

4 VOTE

Sorting large amounts of data sequentially

We executed a query where a large amount of data had to be sorted. The execution stopped with SQLCODE -904 (temp. storage exceeded). This query was executed with DEGREE 1. When we executed the same query with DEGREE ANY, the query was executed by ...

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

11 VOTE

DB2 Z/OS Sync Logical and Physical Parts after full Reorg

ADD PART was used to insert a new physical partition in the middle of a tablespace. Now the Logical and Physical partitions are mismatch. If a Full Reorg on the full tablespace is performed, the utility can include an option to resync the logical ...

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

1 VOTE

allow CREATE TABLE LIKE another table and propagate table partition limits

Today, it is possible to create a PBG tablespace and then use CREATE TABLE like another table and the new table is in the new ts. CREATE TABLESPACE ZPOLCL IN DDB01P SEGSIZE 64; CREATE TABLE TPOLCL LIKE DBCCLP1.TPOL IN DDB01P.ZPOLCL; If the source...

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

23 VOTE

Allow for LISTDEF processing when using CHECK Utility

Details: 1) Manual does not mention use of "LIST" on the "CHECK DATA" page. Example proposed syntax: LISTDEF CHKLIST INCLUDE TABLESPACE DB123.* CHECK LIST CHKLIST SCOPE ALL EXCEPTIONS 0 SORTDEVT WORK

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

Please enter your email address

FILTER BY CATEGORY