All ideas

Showing 609

Add FETCH FIRST n ROWS ONLY (FFRO) to ARRAY_AGG function

This would work along the same lines as ORDER BY in the ARRAY_AGG and will restrict the number of array elements. I believe this feature would be a feature in demand as more DB2users utilize DB2 arrays. I had to resort to a workaround of using a s...

over 1 year ago in Db2 / Data Types 4 Functionality already exists

1 VOTE

Monitor thread causing DB2 abend

Hi Team, We had a Db2 system abend for production environment because of QUERY ON BLOCKING_THREADS has cancelled . We had a business impact for this. If we can monitor such thread proactively before it get cancel, then it may save us from DB2 aben...

10 months ago in Db2 for z/OS 1 Functionality already exists

1 VOTE

Add SET CURRENT QUERY ACCELERATION WAITFORDATA setting into Profile Table in Db2 for z/OS

When Waitfordata setting is required for HTAP queries in IDAA for dynamic SQLs, waitfordata should be defined either in zPARM or as a register setting in application before the SQL statement which requires application change. It would be better to...

10 months ago in Db2 for z/OS 2 Functionality already exists

1 VOTE

Delete functionality in the import specifications in Controller Web

It would be useful to have the delete functionality in the import specifications of Controller Web, similar as it is available in Controller Client.

10 months ago in Cognos Controller (On Prem and On Cloud) 2 Functionality already exists

5 VOTE

Need enhancement in product to be able to have entry fields to be able to specify for NPSI objects CARDF limit to select partitions, such as only reorg up to 100M rows using RTS LASTREORGTIME

Had to develop REXX code to prune the 7B row NPSI TS to 100M row per execution. Product should handle this.

about 4 years ago in Db2 Automation Tool for z/OS 1 Functionality already exists

8 VOTE

Callout/Highlight (add to Canvas) to have conditional formating

Callout/hightlight (add to canvas) requires conditional formatting (text/ background) to display eg1 Green for positive or Red for Negative, 2 Green, Amber, Red to show the impact Sorry I could not find a name to describe this function in the IBM ...

almost 7 years ago in Planning Analytics 0 Functionality already exists

1 VOTE

An environmental variable that sets the database to use "Enforced" as a default for constraints.

For some shops, constraints are always created as "Enforced". This used to be the default behavior, but the default behavior was changed to "Not Enforced" in Db2 V11.Creating an environmental variable would allow the teams to choose the default be...

10 months ago in Db2 / Statements (DDL and DML) 2 Functionality already exists

9 VOTE

Data module: Filter on expressions

In Data module it would be nice to ba able to filter a table on a condition rather than tapping checkboxes. Eg. year(Invoicedate) between year(getdate())-2 and year(getdate())

almost 8 years ago in Cognos Analytics 0 Functionality already exists

1 VOTE

Clean left over job's daemon processes after job res finished

We have several workflows that the job script can run tools that will spawn processes in the backgroup or as daemons that will stay active once the job script ends. Since the job script ends, res will end with the exit code of the job script, but ...

11 months ago in Spectrum LSF / Other 3 Functionality already exists

2 VOTE

Snowflake Native Functions in FM

Snowflake database native functions are not available by default in FM installations due to that we are not able to use snowflake-related functions in report authoring, we have to only common functions which are limited sometimes. installation und...

almost 2 years ago in Cognos Analytics / Data Access and Modelling 2 Functionality already exists

Please enter your email address

FILTER BY CATEGORY