Db2 for z/OS

Showing 96

Need a Db2 option to return control (and not wait) if the maximum number of threads is already reached

We've seen cases in z/OS DFSMS OAM where the application invoking OAM can use up the available Db2 connections/threads so when OAM goes to process their request, there are no longer any threads available resulting in a deadly embrace. Typically th...

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

5 VOTE

ALTER STOGROUP can run in parallel to applications => Deferred ALTER

We need to move a lot of page sets and hence a lot of data from one z/OS catalog to another and also to other stogroups and volumes. For this task we nned to ALTER the hlq of the page sets and move them via DFDSS FASTREPLICATION. Unfortunately the...

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

1 VOTE

Db2/Z SQL timeout on behalf of application

Purpose : Submit DB2Z ‘AHA’ request for Angela Yang – Scotiabank Canada Ltd. Background: Customer Situation is that an application (cobol) invokes a IMS Fast Path transaction, which subsequently invokes a DB2Z/OS SQL request. This DB2Z SQL request...

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

12 VOTE

Db2 Developer Extension - Native Stored Procedure (NSP) edit in place, run and deploy from catalog listing

Currently to edit a native stored procedure, you have to make a copy of it and put it in a new file. We would like it to work like Data Studio where you can display the stored procedure in Data Source Explorer, right click and open with routine ed...

4 months ago in Db2 for z/OS 1 Future consideration

4 VOTE

SQL Tuning Services and full support of Security mechanism 18

We are about to finish the installation of SQL Tuning Services in our sandbox environment. What we learnt last week from Xuqin Zhao at the IBM lab is that the product currently not fully support Security mechanism 18, especially for db2_authid_R -...

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

1 VOTE

Add LOB Support for db2 autonomous storedprocedures

Currently it is not possible to use lob attributes in autonomous procedures. To insert large data into db2 outside the "normal" transaction of work it would be usefull to have autonomous procedures which supports lob data

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

7 VOTE

Add auditing to Db2 profile tables

We need a way to determine who/what/when changed something on the profile tables. DSN_PROFILE_TABLE DSN_PROFILE_ATTRIBUTES Current tables have timestamp but it's static. Would be nice to have row change timestamp added so we have both insert and u...

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

3 VOTE

Allow Encrypted Connection for IBM Debug Tool and Unified Debugger

Reviewing the connection with the Db2 Unified debugger, it was determined it was not using an encrypted port. All tools (mainframe or otherwise) should support full encryption over ATL-TLS.

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

2 VOTE

Remove the limit on the number of secondary IDs

The documentation states: If RACF is active and the “list of groups” option is active, the routine sets the list of Db2 secondary IDs to the list of group names to which the RACF user ID is connected. The maximum number of groups is 1012. Since RA...

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

2 VOTE

Status change or pending DDL when adding a KEY LABEL to an existing table

When an existing table is altered to add a KEY LABEL to enable encryption on the table, the encryption only takes effect post a Reorg (effectively post a redefinition of the underlying VSAM datasets). So the alter is effectively incomplete until s...

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

Please enter your email address

FILTER BY CATEGORY