Search results: Db2 for z/OS

Showing 41 of 348

When AHA-RFE is implemented -> the APAR and/or KC -> include reference to AHA-RFE nbr

When an AHA -RFE is implemented and the knowledge center (KC) is updated AND/OR the APAR is updated/created then please consider putting a reference in the documentation pointing back to the AHA-RFE number! There may be pros and cons to including ...

over 4 years ago in Db2 for z/OS 0 Future 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 ...

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

7 VOTE

Request to convert classic partitioned to UTS PBR by partition

Would like to see if it could be considered to perform an alter classic partitioned tablespace and then reorg by partition instead of the entire tablespace. While I agree it may be more housekeeping, some of the tablespaces we eventually will need...

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

4 VOTE

Allow multiple ALTER PART nnn VALUES clauses in one ALTER TABLE stmt instead of SQLcode -637 error

Requirement to alter many partition limit key values for a PBR tablespace. New values come from external source so REORG REBALANCE is not suitable. With index-based partitioning it is possible to alter multiple partition limit keys in a single AL...

almost 7 years ago in Db2 for z/OS 2 Delivered

2 VOTE

If ADMIN_UTL_SCHED is used for imagecopies it should put the triggering jobname/CorrID into SYSIBM.SYSCOPY

If ADMIN_UTL_SCHED is used do to image copies it writes the name of the wlm-addressspace to the jobname columne of SYSIBM.SYSCOPY. We like to see the name of the triggering job/CorrID there, because we need this information. An alternative would b...

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

6 VOTE

Alter Index add column

When altering index adding columns ' the index status change to rebuild pendig ' need to put in in change pending and let appliction use this index until rebuild or reorg the index , and then rebind packeges

about 12 years ago in Db2 for z/OS 0 Not under consideration

3 VOTE

Would like means of collecting Maxdbat information by AUTHID

We are in the process of providing max thread limits via the Db2 Profile tables AUTHID entries for our applications. We would like to use a AUTHID=* entry to provide a default thread limit and use AUTHID=xxx values for applications which may need ...

over 6 years ago in Db2 for z/OS 1 Delivered

2 VOTE

LOAD utility by pass checking pending status for empty tables

When LOAD utility is run on a referentially integrated table (child table) while both parent and child tables are empty (no rows) let DB2 refer to RTS data and decide NOT to put the table in CHECK PENDING status.

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

3 VOTE

Allow the alteration to another bufferpool (with the same page size) for a specific partition.

When deciding on which bufferpool to place a tablespace in, I have found that different partitions have different requirements. when the "hotspot" of a table (that would benefit by being in a larger bufferpool) is at the end, putting the last part...

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

1 VOTE

Adding new values to CHECK Constraints should not put Table in CHECK PENDING

There are many instances today when existing CHECK Constraints have to be modified to add additional values. Currently, making any modifications to CHECK Constraints to add or remove values requires that the Constraint be dropped and re-created. T...

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

Please enter your email address

FILTER BY CATEGORY