Provide migration path for new functionality without having to build new objects. I.e. we want new type of tablespace in 9.7 to eliminate HWM problem. Cant always drop and recreate/rebuild objects as we dont have time, cant have outage, etc. Hi...
------=Customer Information=------ Deutscher Sparkassen Verlag, Finanz-Informatik heribert.gausmann@f-i.de +49 251 288 33436 ---------------------------------- During db2start a set of environment info is written into db2diag.log, e.g. installed m...
SQL0659N message should identify object and limit reached(RIMS)
'SQL0659N Maximum size of a table reached' In above message SQL0659N the customer would like the object identified with it's name or Object ID and Tablespace ID as well a what was the limit reached (64GB, 256GB...). This is in order to identify th...
DB2LOOK improve dependency order for MQTs/UDFs(RIMS)
DB2LOOK improve dependency order for MQTs/UDFs DB2LOOK does not currently generate view/MQT/UDF in proper dependency order. We have MQTs dependent on views dependent on other MQTs, and DB2LOOK generates all tables (including MQTs) before it gene...
Db2look allow a parameter to only pull specific tablepaces; by name (-l tspace)(RIMS)
Db2look allow a parameter to only pull specific tablepaces, by name (-l tspace). And add a parameter to include the tablespace(s) when listing a schema or specific table. So either l when used with t or z or z/-t would ONLY bring back the ta...
Add a new database configuration parameter to let DB2 the use of several query optimization classes when compiling an sql statement and choose the best access path depending on the query cost. It could be done automatically depending on a fixed th...
Cognos Connection, Report options: "Overriding default values" for just one specific value
When using the report options to e.g. override the default output format, you always have to override the other values such as language or accessibility as well. And because it's a DropDown-selection, there is no way to define more than one langua...