------=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...
Administration console: implement as DB2 stored procedures
In order to make more efficient the IDAA administration task it could be a great improvement to include all administration functions in administration console (telnet) as new functions, performed by stored procedures and accessibles through IDAA S...
[This requirement originates from JPMC EDW/RTC group] The db2diag.log is an extremely useful reference for both customers and db2support persons. We are able to identify milestones events, find errors, and gather clues to their issues, all before ...