All ideas

Showing 15654

Sorting large amounts of data sequentially

We executed a query where a large amount of data had to be sorted. The execution stopped with SQLCODE -904 (temp. storage exceeded). This query was executed with DEGREE 1. When we executed the same query with DEGREE ANY, the query was executed by ...

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

16 VOTE

Report and Job run status should be at a User's tenant level

Currently on a Multi tenant setup, users are able to see public Report/Job run status in Cognos administration. Although the only visible details users see are the name of the report/job, time of execution, status and the name of the user who runs...

over 4 years ago in Cognos Analytics 0 Future consideration

6 VOTE

Override filesystem option for DSNASMKD, DSNLSMKD, DSNWSMKD and DSNISMKD jobs

For modules that create USS directories, the following modules exist: DSNASMKD, DSNLSMKD, DSNWSMKD, DSNISMKD They will all create directories under /usr/lpp/db2 or /usr/lpp/db2c10 (or another variant) It's possible to invoke these programs with a ...

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

11 VOTE

Enhance the SQLCODE screen to show total SQLCODE counts as well as the existing counts for SQLCODEs with details

The SQLCODEs screen is useful for tracking down SQL issues but when you drill into the details for a specific SQLCODE or change the grouping to PLAN/PACKAGE/USER/etc the screen looses the total count of the SQL errors and only gives you the count ...

almost 3 years ago in Db2 Query Monitor for z/OS 0 Planned for future release

7 VOTE

DB2_FMP_FODC variable needs to be extended to application traps

Failures in DB2 may result in Trap files, by default written to the directory where DIAGPATH is set, usually $HOME. To avoid disk-full conditions, this can be redirected with db2set variables DB2_FODC and DB2_FMP_FODC for most of the FODC traps. H...

almost 2 years ago in Db2 / Configuration Parameters 1 Future consideration

36 VOTE

Copy/Paste Reports (Deployment)

When deploying a report from one environment to another, using copy/paste to overwrite a report breaks report views and removes the schedule. Prior to Cognos 10.20 this never occurred. We'd like the old functionality back. A workaround currently e...

over 9 years ago in Cognos Analytics 0 Not under consideration

3 VOTE

Top/Bottom Filter for Barcharts

Currently, only Explorations can be filtered by TOP/Bottom members (Membercount, Percentage, SUM). When you change to exploration to a - for example - barchart, this information gets lost. It would be a good idea to keep that dynamic filtering fro...

10 months ago in Planning Analytics 1 Future consideration

27 VOTE

Financial Reporting Sign Formatting

Financial data which is sourced from a General Ledger typically requires the reversal of the accounting sign for the majority of management and statutory reporting. For example, Income accounts are held as negative values in the Ledger however the...

about 7 years ago in Planning Analytics 0 Future consideration

13 VOTE

Allow Objects to be excluded from Reporting Periods

Reporting Periods are extremely useful for a variety of use cases. Currently when a reporting period is created, all data in OpenPages is duplicated. Some data in OpenPages does not need to be included in reporting periods, so it would be great to...

over 3 years ago in OpenPages Ideas / Platform Features 2 Future consideration

47 VOTE

A View with Select * should be regenertated without Drop/Create View

We have a lot of views defined with Select *. Since DB2 V8 we have the option to add columns to the base table, but the view does not include the new column, which is ok and accepted. But to get the new column we have to drop and recreate the View...

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

Please enter your email address

FILTER BY CATEGORY