Db2 for z/OS

Showing 789

Avoid Reorg Abends by improving estimation of average row length

Today, for estimating the average row length being passed to sort, REORG gets that from catalog statistics with either AVGROWLEN or COMPRESSRATIO. The reason RTS stats is not used, is because RTS only contains the compressed data size.

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

3 VOTE

Display Trace owner when OPx buffer used

The -DISPLAY TRACE(*) command does not indicate which address space owns the trace when the destination is OPx. Since the OPx destination must be managed by some product/address space it would be helpful to know this. A typical scenario: The syspr...

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

2 VOTE

High CPU utilisation in CF structure xxxx_SCA

We have noticed that the structure DB2P_SCA in production the reason for high CPU consumption in the Coupling Facility is. Our reporting proofs this behaviour. We opened a case and did a deeper dive with IBM’s experts into. At the end we can say t...

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

17 VOTE

Change DCLGEN to generate S9(4) COMP-5 instead of S9(4) COMP for SMALLINT columns

DCLGEN generates SMALLINT fields as S9(4) COMP with acceptable values +32767 through -32768. A Cobol 'MOVE' makes truncation possible and renders any value over 9999 risky. IBM Case Number: TS003249935

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

47 VOTE

A View with Select * should be regenertated without Drop/Create View

We have a lot of views defined with Select *. Since DB2 V8 we have the option to add columns to the base table, but the view does not include the new column, which is ok and accepted. But to get the new column we have to drop and recreate the View...

almost 12 years ago in Db2 for z/OS 1 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...

about 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

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

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

2 VOTE

Register all dependencies in SYSPACKDEP

Today SYSPACKDEP records the dependencies of packages - but not dependencies related to RI. That means that a user or a tool needs to run additional queries to understand all dependencies to e.g. answer the question: which packages do I need to RE...

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

Please enter your email address

FILTER BY CATEGORY