Skip to Main Content
ADD A NEW IDEA

Db2

Showing 986

allow external UDFs to be precomputed by the DB2 compiler

what reported in PMR 14482.227.000 treated as expected and a RFE suggested to help address the need
over 7 years ago in Db2 / Federation 0 Not under consideration

db2ckupgrade detects objects in syscat.invalidobjects

If db2ckupgrade detects objects in syscat.invalidobjects, could the developers automatically invoke the revalidate procedure and then check syscat.invalid objects again before bombing out? In bad pseudocode: If rows exist in syscat.invalid objects...
over 7 years ago in Db2 / Installation & Upgrade 0 Not under consideration

DB2 additional segmentation fault protection

DB2 10.5 db2sysc process crashes on segmentation fault in accessed library.
almost 8 years ago in Db2 / High Availability and/or Disaster Recovery 0 Not under consideration

Ability to set concurrentAccessResolution when methods executeBatch() and executeQuery() are invoked from java.sql.Statement

Our database configuration has CUR_COMMIT = AVAILABLE. With this setting, you need to explicitly request for currently committed behavior to see the results that are currently committed. When using the IBM Data Server Driver for JDBC and SQLJ, thi...
almost 8 years ago in Db2 0 Not under consideration

TEXT INDEX USAGE STATISTICS

Implement in a SYSTEM VIEW a timestamp column with the last time a text index was used. I suggest this column on SYSIBMTS.SYSTSINDEXES.
almost 8 years ago in Db2 / Text Search 0 Not under consideration

Partial indexes or functional index updates

We would like functional/partial indexes, that is indexes that include a where clause. Currently when there is an index that includes a condition we have to put the condition as part of a field (NAME_IS_BLANK) and then include that conditional fie...
almost 8 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration

Avoidance of deadlock error in DB2 partitioning environment

After our customer delete and create the original table of view table with the partitioning environment, deadlock occurs when they access the view table from each partition at the same time.The view table is invalid when the original table is dele...
almost 8 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

DB2 Technote Searchable Index

Document Change Request: please supply a searchable index of all DB2 technotes - titles and URLs are all that's required. You will get 254 results (today), most of these will not be technotes and only if you are lucky will the one technote on the ...
about 8 years ago in Db2 / Serviceability 0 Not under consideration

Compression of Primary Key Indexes with Version 10.1 FP 5

While doing some testing with, we noticed that when you create a table compressed, that ALL indexes automatically get compressed. We found out that we have the ability to specify "normal" indexes without compression, but you can not have an uncomp...
about 8 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 1 Not under consideration

DB level default table and index compression parameters

Have a database parameter for the default table compression type, and another for the default index compression type.
over 8 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration