Db2

Showing 989

5 VOTE

WLM thresholds and compound expressions

I would like WLM thresholds to have compound expressions.

almost 6 years ago in Db2 / Workload Management 0 Not under consideration

5 VOTE

Increase maximum numbers of columns in an index key from 64 to 120

Db2 has the lowest limit of allowed index columns compared to the competitors.

almost 6 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration

5 VOTE

Let Physical Detach and Attach Operations on the same table run at the same time

Today there is no timeout on Detach Physical Phase and Attach alter cannot run on the same table at the same time as Detach alter. Some detach alters are taking over 20 hours to finish placing daily partitions at risk of not being created. Also th...

almost 6 years ago in Db2 0 Not under consideration

5 VOTE

Improve performance of retrieving large result sets

Performance of Db2 client/server communications in a network environment needs to be significantly increased in cases where large amount of data (100s of MB or more) are being moved between Db2 server and remote client. This needs to be provided n...

about 6 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

5 VOTE

Tool to check SSL certificate connectivity with KEYSECURE

Need some way to check if provided SSL certificate for secured connection to KEYSECURE is indeed valid before putting it in kmip cfg. This reduces the risk of any issues with SSL certificate on actual implementation day on production system.

over 6 years ago in Db2 / Security 0 Not under consideration

5 VOTE

Union all View (or common table expression of a UNION ALL) lead to HSJOIN

Case #0000086 Worked with developer and provided following explanation:When there is a join between a UNION ALL view (or a common table expression of a UNION ALL) to another input (let's named it Z), to be able to utilize index access on the table...

over 6 years ago in Db2 / Application Development 0 Not under consideration

5 VOTE

Add synopsis tables and Columnar Page Map usage to BLU explain plans.

over 6 years ago in Db2 / Monitoring 0 Not under consideration

5 VOTE

Introduction of a hard limit on the size of the Package Cache to avoid memory exhaustion .

Although the package cache is set to a fixed value, it was using more space than the configured size.

over 6 years ago in Db2 / Serviceability 0 Not under consideration

5 VOTE

Add BEFORE and/or AFTER clause to ALTER TABLE

For the ALTER TABLE statement, it's relevant to add an "AFTER ..." OR "BEFORE ..." clause specifying where in the table the new column is to be placed. This statement component exists in DB2 for i and in certain other databases (like Informix and ...

over 6 years ago in Db2 / Statements (DDL and DML) 2 Not under consideration

5 VOTE

Provide SYSTEM / UNIQUE collation sequence support for column organized tables when codepage is 819

The lack of support for anything other than IDENTITY collation sequence for codepage 819 makes migration to BLU very difficult for customers who use it.

almost 7 years ago in Db2 / BLU Acceleration 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY