Alert or Threshold Based on Number of Execution of SQL Query
We have noticed that customer is facing database failover issue when number of execution of any one query is very high which is utilizing all of the system resources. Is there any feasiblity of creating alert/threshold on number of execution of qu...
In Cognos log: Change Classification of expected behaviour from Level ERROR to INFO
As of now in the Cognos log files there are a great amount of lines classified as error eventhough it is an expected behaviour. Could you please chnage the classification of these expected behaviours to either info or maybe a new level. This would...
Scenario: When the report have a lot of prompts and user needs to scroll down to see all the prompts.
Problem: re-prompt button causes page refresh and web page returns at the beginning of the page.
Dashboard filter bar should allow single select or multi select, optional or mandatory
The filters available in the All Tabs / This Tabs area of dashboards are multi-select only. We often have dimensions, that if a user filters on multiple values, will produce an invalid result. Some examples include currency - if you select multipl...
We encountered significant recovery performance issues (recovery time increasing exponentially as the number of objects rises) and the analysis in a Case showed that this was due to enhanced recovery’s non target index serialization (our backups a...
We recently had an IBMi system that lost 2 disks in the same RAID set and lost the machine. We had to rebuild from BRMS tape and after the system was made available, users indicated data was incomplete. In researching, it appears there is no easy ...
about 2 months ago
in Db2
1
Not under consideration
Method for downgrading FixPack level of Db2 pureScale
In order to downgrade FP level of pureScale, uninstall the product, re-install and recovery from backup are needed.This is time consuming and cannot be done online.Customer want some easy FP fallback method.Most customer plan to FP upgrade with so...
Include CTQ reason / details in db2exfmt advanced diagnostics
We need an "Extended Diagnostic Information" in Explain (db2exfmt) that details if and why the column organized tables had been (early) converted to the row format for processing it in the row engine. This is important to detect performance issues...