All ideas

Showing 15403

Improving Insert Performance for LOBs

As mentioned in Case TS004024647 there are some situations where inserts in lob structures do not provide the expected performance. Instead they cause massive CPU consumption in the Coupling Facility for the spacemap search. The problem is excessi...

about 4 years ago in Db2 for z/OS 0 Not under consideration

49 VOTE

Allow CREATE/REPLACE for users other than owner

Currently on Db2 LUW CREATE OR REPLACE is only allowed for the owner of a database object. CREATE OR REPLACE authorization should be opened up to allow create/replace by anyone who has the ability to drop the object and to create the object with a...

about 6 years ago in Db2 / Statements (DDL and DML) 3 Not under consideration

53 VOTE

Tuple and other OLAP functions need to be available in Dashboards

Need for Tuple and other OLAP functions in Dashboards

almost 7 years ago in Cognos Analytics 1 Planned for future release

3 VOTE

Setting up the “Run in the Background” as default option at user level

Most of our customers are using “Run in the Background” option for long running reports. They will be okay to use this option however the user has to explicitly set this option every time they run the report which they want to avoid, and it would ...

5 months ago in Cognos Analytics / Reporting 0 Submitted

3 VOTE

Add option to set explain on to see what the optimizer is doing.

Add option to set explain on to see what the optimizer is doing. - Which statistics were looked at - Relative costs for table scan/index usage - Why a given index is not used - Which join orders are considered - Why join orders are excluded from t...

5 months ago in Informix / Informix Server 0 Submitted

3 VOTE

Add the option for a columns with changed values column to the Change Capture stage

Currently the Change Capture stage will give you the information (in the Column change_code) if your After Data is a Copy (0), Insert (1), Delete (2) or Edit (3), it would be good to have the option to generate an addition column change_columns (V...

5 months ago in DataStage 0 Submitted

3 VOTE

Improve the functionality of the Join stage

Currently when doing a join in DataStage and tyring to achieve the same as e.g. a between in a SQL join, you either have to use the Lookup stage (which has other limitations, is not well documented (according to documentation, the Lookup stage doe...

5 months ago in DataStage 0 Submitted

6 VOTE

Allow a join of a temporal table with an archive-enabled table.

Allowing us to join a temporal table with an archive-enabled table would allow us to take advantage of both features. As is we will have to choose one or the other.

9 months ago in Db2 for z/OS 4 Not under consideration

24 VOTE

zIIP enables FPECMAIN

Processing huge volume of DB2 Accounting records require significant amount of GCP CPU, DB2PM has become a less attractive product in terms of processing costs. To maintain the product's attractiveness, portion of processing should be made zIIP el...

about 3 years ago in OMEGAMON XE for Db2 Performance Expert for z/OS 2 Future consideration

10 VOTE

Add Materialized Views to Infomrix same as Oracle and DB2

over 1 year ago in Informix / Informix Server 1 Under review

Please enter your email address

FILTER BY CATEGORY