Db2 for z/OS

Showing 915

Identify when all members of a Data Sharing Group are up and operational

After a crash or hard down, Db2 will perform its recovery processing including GRECP and LPL processing. There are external systems (e.g. CICS, MQ, etc.) that are dependent on all members in the data-sharing group to be fully up and operational an...

8 days ago in Db2 for z/OS 0 Submitted

1 VOTE

JSON Indexing on non-inline LOBs

Currently IBM allows the creation of indexes for JSON docs stored in an inline LOB but not a non-inline LOB. We want to make full use of JSON docs in DB2 for zOS. We wanted to avoid having to move more apps to MongoDB.

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

4 VOTE

Resolve issue where DB2 has an issue with invalid MDSNxx Class profiles created in RACF

IBM Please read the case TS013914362. In summary DB2 created dumps/abends when the RACF administrator deleted permissions to some incorrectly formatted profiles in one of the MDSNxx classes. When the administrator performed the permit delete and i...

9 days ago in Db2 for z/OS 1 Under review

2 VOTE

Link FLA messages to auto recovery task id

We did a large GRECP recovery test with around 68.000 GBP dependend objects. After restart and the automatic GRECP recovery we see a lot of DSNI025I, DSNI026I, DSNI027I, DSNI028I and DSNI029I messages as expected, but they have no correlation to t...

9 days ago in Db2 for z/OS 0 Submitted

1 VOTE

Display info about stopped Stored Procedure

We have a few Stored procedures that has been stopped intentionally waiting for them to be dropped. We want to keep them in a stopped state for a period of time so that we can be sure no one use them. One example of this is when we rewrite externa...

11 days ago in Db2 for z/OS 0 Submitted

1 VOTE

Expand IFCID 258 to include the last available partition (based on MAXPARTITIONS) of a partitioned table spaces.

IBM already produces IFCID 258 when an extent is taken. Would IBM may consider the expansion into the last available partition to be a noteworthy event or either inform the MAXPARTITION value. So, the percentage of available partitions can be calc...

12 days ago in Db2 for z/OS 0 Submitted

6 VOTE

Improve INDOUBT thread processing in two-phase commit scenario

Recently we had a pretty severe production outage on an 8-way data sharing group. After resolution of the root cause, WAS and Db2 z were quite slow in recovery. Following the crash, there were dozens of indoubt threads and lots of retained locks a...

12 days ago in Db2 for z/OS 0 Submitted

1 VOTE

Materialize changes through partition rotation

We have some large tables that need to be updated from time to time. Each time a partition is rotated it is reset, so I think that could allow the table/tablespace change to be materialize. This would allow use to save the time and processing cost...

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

1 VOTE

Masking function with GRANT per column

Column masking has been great help in managing sensitive data and complying with the General Data Protection Regulation (GDPR).But today’s solution to know if a user has access to data without masking is to create a Mask using a CASE with SESSION_...

18 days ago in Db2 for z/OS 2 Under review

1 VOTE

Improve the usability of the masking function

According to the manual, column masking has incompatibility with some SQL functions that we use a lot. In our environment, we have many abends with SQLCODE = -20478, example: SELECT CASE WHEN ST_EMAIL LIKE 'MARIA%' THEN 'OK' ELSE 'NOT OK' ENDFROM ...

18 days ago in Db2 for z/OS 1 Under review

Please enter your email address

FILTER BY CATEGORY