Welcome users! Here you have an opportunity to collaborate directly with the product development teams and other product users.

Filter the page content by brand and product


This is a table showing requests
Number of votes Request headline and description

35
votes

Please remove the deprecation tag from db2_install

I have been told that the db2_install command is now deprecated, and IBM wants us to use db2setup,    We believe that IBM is doing is customers a disservice by removing db2_install and making folks use ...

Submitted

25
votes

Reorg pending after three ALTER TABLE statements is not useful in 24x7 envi...

After three ALTER TABLE statements (depending on the clause, but an error can be forced by changing type from VARCHAR to CHAR ) table switches into reorg pending state. This state can only be resolved...

Information Provided

19
votes

Grant SELECT ACCESS on DATABASE

Please add a new security authority to DB2 to allow SELECT access on all tables/views in a database.

This is a similar authority that already exists DATAACCESS but would allow SELECT only.

Submitted

19
votes

Reduce xhshlatc contention with high concurrecy applications

When lots of applications want to acquire or release the same package lock, DB2 becomes very slow and transaction processing is almost interrupted.

Submitted

17
votes

Can't create a nickname on a table containing a STRUCT datatype

Can'create a nickname on a DRDA table containing a geospatial column . Problem description and business impact Using DB2 ESE 10.5 FP8 (and the Spatial Extender component) on Redhat 7.2, I can't create...

Submitted

17
votes

Turn on reclaimable storage without dropping/recreating the tablespaces

After a migration from db2 9.5 to 10.1, several days passed, and    we reached the maximum size of a DMS tablespace of 4K.

We moved one table to a different tablespace, but still noticed that the free ...

Under Consideration

15
votes

Introduce reorg table with write access by utilizing ADMIN_MOVE_TABLE funct...

Many customers want to REORG their tables quickly and efficiently. The classic REORG is by far the fastest option but puts the table in read only mode. Inplace reorg allows write access but is much sl...

Submitted

12
votes

Support of DB2 V11 on Solaris needed

IBM has not released DB2 V11 for Solaris Sparc platform yet.
95% of our customers (33% of German statutory health insurance) are working with DB2 10.5 on SOLARIS SPARC with round about 25.000 users. D...

Submitted

9
votes

purescale support HADR ROS

System: DB2 LUW pureScale
Actor: User needing HADR read of standby on pureScale environment
Now db2 V10.5 and above had provided HADR component for pureScale but missed Read of standby feature. 
Descr...

Submitted

9
votes

Grant insert, select, update and delete on a schema

Ability to grant insert, select, update and delete on a schema

Submitted

7
votes

Online Index Creation

Customer request to create and rebuild indexes online. This makes to update base tables at the same time user is building or rebuilding indexes on that table. so user can perform DML operations while ...

Submitted

7
votes

automatically activate a database when DB2 LUW is started

See PMR 14855,227,000.

We would like some way to automatically activate a specific database when a DB2 instance is started without the use of external scripts or DB2 APIs.

Submitted

6
votes

Remote DB2 connections via Universal Diver T4 not well balanced.

Sysplex workload balancing does not guarantee that executions are distributed among the available systems. It depends on the capacity of the systems (WLM choose systems with more CPs/ZIIPs), performan...

Under Consideration

6
votes

Parameter to specify Recovery Window

Provide db parameter to ensure auto_del_rec_obj will not delete or prune from recovery history objects required to do recovery within a window.
rec_his_retentn and num_db_backups do not provide this p...

Submitted

5
votes

BLU Load message improvement for SQL3119W

DB2 BLU load on LUW provides a less than optimal message for SQL1119W. It reports that an input data value has been replaced by NULL but does not indicate which specific input row caused the error res...

Submitted

Your ideas matter!

As of today:

13 new
3 planned
6 delivered


256 users
1021 votes
408 comments

Give us feedback

Participate in the RFE Community survey to help us improve your experience.