Db2 for z/OS

Showing 957

Add a builtin table function that splits a character string

Db2 12 adds the useful LISTAGG function that aggregates a set of string values into a single string.It would be good to have an inverse: a table function SPLIT that takes a string and a separator, and returns a table of string values.The signature...

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

5 VOTE

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

2 VOTE

Set object status to prohibit data access

Before we drop a Db2 table we need to make sure that noone use the object in any way. We solve this now by stopping the tablespace and keeping it stopped for about six months. This means that noone can access the data and noone can run a utility a...

12 months ago in Db2 for z/OS 0 Future consideration

3 VOTE

Report Which Member(s) Are Holding Up Commit-LSN Advancement

Requesting that Db2 issue a message when the commit LSN enhancement hasn't made progress for in a reasonable period of time, preferably with the LSN of all Db2 members so that Db2 customers can identify which member(s) could be holding up the LSN ...

over 1 year ago in Db2 for z/OS 1 Future consideration

2 VOTE

Have new authority for REFRESH of MQT that does not require high privilege levels

We historically have an application batch userid that has DBADM authority. We are limiting all access to this ID to the minimally required authority it requires such as load, imagecopy and runstats at the DB level. When we started converting our t...

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

12 VOTE

MVS CANCEL should issue DB2 CANCEL THREAD first

Db2 and z/OS development should work together to integrate MVS CANCEL command and DB2 CANCEL THREAD. Since the DB2 recommended action is first Cancel thread in DB2 and then issue the MVS CANCEL, the MVS CANCEL command should automatically cancel d...

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

20 VOTE

Remove active trace limit of 32

Today there is a limit of 32 active traces within a db2 member. But we have the need to start more..

over 9 years ago in Db2 for z/OS 2 Planned for future release

4 VOTE

Increase messaging detail after STOP Db2 to provide shutdown status information.

As Db2 continues to allow more and more capacity in a single subsystem - larger bufferpools, more open datasets, etc - the time to shut down Db2 continues to increase. Operational staff has complained repeatedly that they cannot tell whether Db2 i...

almost 2 years ago in Db2 for z/OS 0 Future consideration

14 VOTE

Joining a temporal table with an archive-enabled table

In DB2 z/OS V11.1, we getting a -20555 SQLCODE when trying to join a temporal table with an archive-enabled table. We were surprised to see it didn't work. The manual talks about those tables being â€œmutually exclusiveâ€, which to me would mean ...

almost 7 years ago in Db2 for z/OS 4 Not under consideration

16 VOTE

Need JSON UDFs (JSON_TABLE, etc.) to perform similar to XMLTABLE

Need to performance (elapsed time, cpu time) for JSON UDFs to match or exceed XMLTABLE function.We will be using HTTPGETCLOB to invoke RESTful APIs for Web Services on non-mainframe platforms.Our DB2/Legacy applications will need to invoke these, ...

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

Please enter your email address

FILTER BY CATEGORY