This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
Shape the future of IBM!
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Search existing ideas
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updateson them if they matter to you. If you can't find what you are looking for,
Post your ideas
Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
Add option ：statement rollback is able to release the locks for the failed statement.
When -803 ( violating unique key constrain ) happen on a statement, there are two things happen1) db2 still hold the lock on the row accessed by the statement that cause -803 , no matter the statement had fail.2) The transaction was not rollbacked...
Currently it is merely possible to lock a complete table by means of the "lock table" statement. However, for range partitioned tables, it would be beneficial to be able to lock a specific data partition. That is, a statement like: â€œlock data pa...
Create a new type of table based on the size or on the time.create table packagevent (.... ) with history based 1 year on event_timestamp / 1Gb. It could be an ITC table. The oldest data / extent are automatically reused when new data is added and...
UNIQUE INDEXES over BIGINT column can't be compressed
unique indexes over id columns (bigint) are not compressed whereas the same unique index over decimal column gets compressedindex compression for unique indexes is urgently needed to reduce disk and memory footprint
Victimization of unused compression dictionaries from DBHEAP(RIMS)
Compression and Expansion dictionaries for each object (table, index) remain in memory until database deactivation time. This is problematic because enough DBHEAP must be allocated to host a compression/expansion dictionary for EACH object that is...
Parallel index creation for partitions of a partitioned-table(RIMS)
[JPMC EDW] Currently, a create-index statement with the PARTITIONED clause will process each partition sequentially. Ideally DB2 would perform this with some degree of parallelism. Currently, this can be accomplished by detaching the individual pa...
Creation of range-partitioned tables during TRANSPORT
Whilst working on a recent pureScale POC with a customer, we came to the stage of upgrading their existing database to pureScale. Existing database had a catalog SMS tablespace. pureScale has a requirement that all tablespaces have to be AUTOMATIC...
Do not place IBM confidential, company confidential, or personal information into any field.