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...
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
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...
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...
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 ...
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...