Db2 for z/OS

Showing 953 of 14488

The ability to apply the DB2 Connect Unlimited Licence directly on zOS

It would be useful for DB2 sysprogs to be able to apply the DB2 Connect Unlimited Licence to a database natively on zOS without the need to install the runtime client and run the db2connectactivate utility.

6 months ago in Db2 for z/OS 2 Functionality already exists

53 VOTE

API to write dictionary to log

A number of our common customers run DB2 utilities from third party vendors and IBM replication solutions. They are requesting that our LOAD and REORG utilities write the old dictionary pages to the log for later retrieval by a replication product...

over 4 years ago in Db2 for z/OS 3 Not under consideration

3 VOTE

DB2 Regions creating a lot of messages for AB/S004E SYSTEM ABEND CODE: 004E in LOGREC

It was reported thru GTIECSMFDB-10132 on both the SDPLEX and SBPLEX that the DB2 regions are producing thousands of error messages in the System Logrec for AB/S004E SYSTEM ABEND CODE: 004E each day. The following error messages are filling up the ...

3 months ago in Db2 for z/OS 3 Planned for future release

4 VOTE

Sorting large amounts of data sequentially

We executed a query where a large amount of data had to be sorted. The execution stopped with SQLCODE -904 (temp. storage exceeded). This query was executed with DEGREE 1. When we executed the same query with DEGREE ANY, the query was executed by ...

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

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

7 months ago in Db2 for z/OS 0 Planned for future release

17 VOTE

z/OSMF workflow artifacts for Db2 UPDATE and ACTIVATE process

IBM z/OSMF workflows are being improved to be used for Db2 installation and migration. It would be nice if we have also the artifacts for the other CLIST processes: UPDATE and ACTIVATE. The UPDATE process is what we use the most.

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

18 VOTE

JDBC connection property currentSchema should be externalised in an IFCID

We have jdbc applications which have set the jdbc property currentSchema to determine the collection of db2 objects like tables, views etc. When we want to trace the application with a performance trace, we're not able to analyse the correct colle...

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

2 VOTE

Create a new BiF to do a real TIMESTAMPDIFF

The current scalar function TIMESTAMPDIFF is great if the difference is not over one month, then it starts guessing at how many days are involved. If you want to know the number of seconds between two timestamps it gives variously bad degrees of e...

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

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

8 months ago in Db2 for z/OS 4 Needs more information

5 VOTE

Add schema to ifcid 62

Hi! I use IFCID 62 to track DDL usage and I have always found it a little bit annoying that the SCHEMA name is not part of the IFCID062 ouput. You get everything else but not the schema... this makes it difficult to impossible to see exactly what ...

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

Please enter your email address

FILTER BY CATEGORY