Search results

Showing 1354

ALTER TABLE DROP multiple COLUMNs

If you want do delete multiple columns of a table using "ALTER TABLE tbname DROP COLUMN colname", you currently have to execute many ALTER TABLE statements. The execution time increases exponentially with the number of columns to be deleted. If th...

over 1 year ago in Db2 for z/OS 1 Not under consideration

8 VOTE

Customizable Table Naming in IBM Cognos Dataset Store

I have a suggestion for enhancing the Dataset Store feature in IBM Cognos, which automatically creates a table in DB2 upon uploading a CSV file. Currently, the table names are generated with a pattern that includes a prefix 'Cog' followed by two s...

over 1 year ago in Cognos Analytics / Data Access and Modelling 1 Not under consideration

12 VOTE

Externalize non-DSC SQL in IFCID 316

An old request that got rejected but is for me, and at least 52 other voters, important was the IFI 316 for non-DSC eligible Dynamic SQLs. The business case here has two major reasons: First and most important these days – Audit. Any Dynamic SQL m...

almost 2 years ago in Db2 for z/OS 1 Not under consideration

35 VOTE

Ability to add extra table(s) to a view of tables in data module

Using release 11.1x we like the ability to create a view of tables in a data module like we used query subjects in framework manager. Unfortunately it's not possible to add extra to tables to a existing view after the creation. This means that in ...

almost 6 years ago in Cognos Analytics 4 Not under consideration

18 VOTE

Capture DB segment replace calls which actual data is not updated.

Our client is currently using Dprop(IMS DataPropagater for z/OS) for creating Data Warehouse. Dprop captures replace calls and writes to PRDS(Propagation Request Data Set) even when DB segment was not actually updated. Client’s Dprop application p...

almost 3 years ago in Data Replication: IMS / VSAM / Classic Change Data Capture 0 Not under consideration

1 VOTE

Consolidate Open and Fetch data into one value

When running queries against SYSIBM.CQM_SUMM_METRICS, we noticed that for the same program, there are some high getpage counts in the Open Cursor and other statements high getpage counts shown in the Fetch. The time is usually calculated in the Fe...

2 months ago in Db2 Query Monitor for z/OS 2 Not under consideration

21 VOTE

TABLESPACE LOGGED NO-integrity available even Rollback

We wonder a new type LOGGED tablespace attribute, similar to LOGGED NO but without any consequences at Rollback processes. Currently TABLESPACE LOGGED NO doesn´t log Row changes, but: TS change to Icopy state at first Row change TS change to RecPe...

over 3 years ago in Db2 for z/OS 0 Not under consideration

28 VOTE

Capability to remap a Data items in a data module

Current problem: No easy way to remap data items of a table with re-named items or new items with the same logic. If a table item changes name or your DB developer changes the Capital or other settings there is no easy way to relink the Data ITEM ...

almost 5 years ago in Cognos Analytics 0 Not under consideration

34 VOTE

Enhancement Cognos Audit

We need to create Audit report for showing usage of reports ,Cognos - Dashboard ,Data Module ,Story and exploration .We need usage/audit data from Cognos Dashboard,Data Modules and all the new tools added in CA 11 to be updated in Audit database i...

almost 6 years ago in Cognos Analytics 2 Not under consideration

47 VOTE

Improve performance of EXPLAIN

With early versions of DB2 the performance of EXPLAIN was not relevant. Nowadays, where DBAs do thousands of EXPLAINs, the performance and turnaround is getting critical. I think there is room for better performance and throughput of mass EXPLAINs...

over 8 years ago in Db2 for z/OS 5 Not under consideration

Please enter your email address

FILTER BY CATEGORY