Db2 for z/OS

Showing 958

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

51 VOTE

DSNREXX-GET-DIAGNOSTICS-Support

GGDB212004Please add Get diagnostics support in DSNREXX.

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

34 VOTE

Provide SQL access to product statistics API's

Provide a way to bring statistics from various products API's into an SQL context. Sample has been shown to selected zBLC customers during the Dublin face-2-face. Requirement has been discussed with Jeff Josten / Chris Crone. Offer has been made t...

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

3 VOTE

Meter "dirty" pages written to DB2 table spaces (disk) from CF or local buffer pools

DB2 uses 300 tasks (DB2 writers - it could be more now with later DB2 releases) to write modified (aka, "dirty") pages to the DB2 table spaces (either permanent tables or DB2 work files). From a DB2 perspective this is "efficient" but from a resou...

8 months ago in Db2 for z/OS 4 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...

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

11 months ago in Db2 for z/OS 3 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

9 VOTE

Full EXPLAIN support for all types of trigger

With Triggers you cannot use the REBIND option OWNER on a rebind. Why not? Not even for EXPLAIN(ONLY). We must get the ability, like with "normal" packages, to EXPLAIN into another set of EXPLAIN tables. Further, if you are using Advanced Triggers...

about 2 years ago in Db2 for z/OS 2 Future consideration

11 VOTE

RLF DSNRLMTxx table field RLFIP allow subnet wildcard

we have a need to restrict threads with RLF by specifying userid and source IP with a subnet wild card. the source ips change with each "logon". In order to restrict all possible ips under a given subnet, we would need to enter 255 X 255 ips. allo...

over 2 years ago in Db2 for z/OS 0 Future 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...

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

Please enter your email address

FILTER BY CATEGORY