All ideas

Showing 661

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

1 day ago in Db2 for z/OS 0 Under review

1 VOTE

For online REORG, create parameter to set RC=4 when DRAIN fails

I am creating a scheduled job to perform regular REORGs of the Db2 Catalog. I am generating a list of catalog objects and feeding it to LISTDEF and then using ITEMERROR,SKIP I am using extremely gentle DRAIN settings...DRAIN_WAIT of 2 or 3 seconds...

1 day ago in Db2 for z/OS 0 Under review

1 VOTE

IKC Policy enhancement with AI

Extend the functionality of policies in CP4D by using AI to automatically propose actionable governance and protection rules based on a data governance policy. The current policy management feature in CP4D is limited to capturing a policy (or sub-...

1 day ago in Knowledge Catalog 0 Under review

2 VOTE

REORG with a new keyword should transfer the page set work to DFDSS

Why is the above idea useful? Sometimes you need to move page sets around due to altering the HLQ, due to removing extents etc. These actions do not require an unload and reload of the data, because it is external stuff out of DB2 scope. For small...

4 days ago in Db2 for z/OS 0 Under review

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

4 days ago in Db2 for z/OS 0 Under review

14 VOTE

Folder-Level Access Control in CP4D Volumes

Currently, in IBM Cloud Pak for Data (CP4D), access control for data stored in persistent volumes (PVs/PVCs) can only be managed at the volume level. This means that any user with access to the volume can view and modify all folders and files with...

23 days ago in Cloud Pak for Data / Cloud Pak for Data Platform 0 Under review

2 VOTE

REORG PREFORMAT of 1 TB page set should be interruptable

With PH64760 one can create 1TB page sets in one step. If one runs a REORG PREFORMAT on such large objects, the Media Manager Preformat task is not interruptable. Such a size of 1TB needs ~1.5hours to preformat the page set. In the meanwhile neith...

4 days ago in Db2 for z/OS 0 Under review

96 VOTE

Data gate instance be able to write on more the one S3 Bucket (Data Gate for watsonx)

The client, Itaú, has structured its organization into independent and agile business squads, which is reflected in their data domain organization and data governance. To accommodate this structure, the data architecture requires flexibility. Curr...

6 months ago in Db2 for z/OS Data Gate 2 Under review

94 VOTE

Credentials from HashCorp Vault (Data Gate for watsonx)

Itaú, one of the largest banks in Brazil, is known for its advanced cloud adoption, managing over 8,000 AWS accounts. This model, while providing agility and independence, also increases the complexity and potential security risks. To mitigate the...

6 months ago in Db2 for z/OS Data Gate 1 Under review

67 VOTE

Assume IAM Role instead of using IAM Access Key and Secret (Data Gate for watsonx)

The client, Itaú, follows a strict security policy based on the principle of least privilege, which requires all authentication and authorization operations to be carried out through IAM Roles, rather than using IAM Access Key and Secret pairs, wh...

5 months ago in Cloud Pak for Data / Db2 for z/OS Data Gate 0 Under review

Please enter your email address

FILTER BY CATEGORY