Db2 for z/OS

Showing 980 of 15460

CAF plan name new feature

There are applications that have hardcoded the plan name in their programs using CAF. In some cases, it is wide spread that it will take a lot of work coding and testing due to program change. To avoid the cost of coding and testing, can there be ...

about 6 years ago in Db2 for z/OS 1 Not under consideration

1 VOTE

Sending a reply from MQ-Listener even when the MSGTYPE is not REQUEST

Currently it is possible to change the REPLY-Queue and REPLY-QueueManager via StoredProcedures which are started by the MQ-Listener if the Message was sended with MessageType = REQUEST. But it is not possible to send a REPLY if the MessageType is ...

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

3 VOTE

Parameter to set REORG interrupt due to an unexpected wait

There are situations where a REORG utility can cause locks. A few weeks ago we suffered an episode of timeouts because a Reorg that was locking in the log phase. The Reorg was performing the consolidation of an ALTER DSSIZE in a UTS PBR. We didn't...

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

1 VOTE

Externalize DDF Alias level statistics into SMF

Currently we do have SMF data for DB2 system level distributed workload but do not have DDF Alias level statistics with in SMF, only available adhoc option is to issue DIS DDF <alias> DETAIL to look at DDF alias level active dbats and connec...

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

1 VOTE

SQLJ Add support for use of Java Array in IN predicate

We would like to see support of Java type ARRAY for IN-LISTs. The use case would look like: SqljCtx sqljCtx = getSqljCtx(); Array fkpzOfflKtoIdsArray = sqljCtx.getConnection().createArrayOf("TIMESTAMP", fkpzOfflKtoIds); FremdkontoOfflineIterator i...

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

11 VOTE

Allow for an option in the syntax of a (compiled scalar) SQL function to use RELEASE(DEALLOCATE).

Thread reuse and High performance DBATs are dependent on packages being bound with RELEASE(DEALLOCATE). But, there is no provision for the package associated with compiled SQL scalar functions to have RELEASE(DEALLOCATE) as an option. I have been ...

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

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

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

12 VOTE

Enhancement request to turn off DB2 security

Could we get a ZPARM that allows the deactivation of DB2 security in favor of a security product (ie. RACF). It would be nice if RACF was the ONLY authoritative source for security requests. Currently if a result isn't returned by RACF, DB2 checks...

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

12 VOTE

Give the option to make an index "invisible" to DB2

Sometimes, when I have added and index, I have had some surprises in the optimizer using that index when it should not. I would like a quick way to make the index "invisible" to the optimizer and make it not eligible for access paths until I speci...

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

11 VOTE

Wrong result from reading Archive Enabled Tables with GET_ARCHVIE set to Y

When reading Archive Enabled Tables we set a value for the global variable GET_ARCHIVE in order to get the appropriate result. If we set it to N only the base table is read. If we set it to Y we want both the base table and the archive table to be...

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

Please enter your email address

FILTER BY CATEGORY