The customer is considering to deploy multi-active system cross multiple sites, the distance among sites might be more than 1000km. The data could be distributed by hash, and rarely cross site data access by transaction/query. DPF might be a good ...
For the most OLTP system, some table only keep data for a period of time. We are looking for support to automate the management of this by DB2, ie. auto-prune older data.
The output from the command 'get dbm cfg' without the option 'show detail' is misleading in that in shows the 'wrong' values for parameters that have been changed but needs an instance restart. It could be solved by changing the output to use the ...
Some option to disable Repeatable Read. At least on the database level if not the instance level. Once set any set isolation to Repeatable Read statement would either return an error, or be transformed into Committed Read, or just be ignored, what...
the OS_MEM_FREE Column from Sysmaster:SysMachineInfo is Misleading on AIX
Take for example the following query: select os_mem_free from sysmaster:sysmachineinfo; This returns the amount of free memory on the OS in bytes. Weappear to get this information from the same function thatgathers that info for OAT (via the SMI q...
Report required to see average & max license usage consolidated over two or more license servers per hierarchical and independent user mapping fields, per license server, per feature, per user aggregated over a period of time and in addition a...
almost 10 years ago
in Spectrum LSF
3
Not under consideration
Informix Query Engine generates bad query/explain plan
There are situations where two or more columns from the same table are related to each other. For example, product_type and product_code from the products table are related, since only certain product_code values can be associated with a given pro...
Enable compatibility mode and new function mode like DB2 z/OS. The compatibility mode will allow to use the binaries of a new db2 version without using the new features. The new function mode will allow to use the binaries of a new db2 version and...