Db2 for z/OS

Showing 789

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

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

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

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

27 VOTE

IFCID 316 401 ZiiP Usage Statistics

Currently the IFCIDs 316 and 401 contains great data for monitoring and tuning SQLs. It would be excellent if these IFCIDs could be extended to include a separate set of ZiiP counters. IFCID 25 does this for Utilities at the moment.

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

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

2 VOTE

REPORT RECOVERY - new syntax requested to externalise just the image copy and log datasets

REPORT RECOVERY provides the CURRENT and SUMMARY keywords but even for these options the job output is either very verbose (Unit of Recovery, SYSCOPY entries, Archive log datasets, volume numbers for the LOG datasets etc) or too little (just the v...

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

48 VOTE

Command confirmation in joblog of DB2MSTR.

DB2 has many commands which display or alter the status of something. There are a lot of distinct environments from which the commands can be executed (z/OS console, DSN session, TSO DSN command processor, IMS or CICS terminal, special STPs, IFI-i...

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

9 VOTE

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

about 2 years 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...

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

1 VOTE

LOAD Replace improvement for RI tables

We had a Db2 DDL change where a new table "b" was created with a RI constraint to a parent table "a" which was also modified (DROP/CREATE). Table "a" had several rows which were unloaded before the change and loaded back after the DDL changes (LOA...

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

Please enter your email address

FILTER BY CATEGORY