ADD A NEW IDEA

All ideas

Showing 10185

We'd like a way to ALTER INLINE Scalar Functions

As noted in our 55126.379.000 PMR.... ‎ We recently encountered an issue when the need arose to change an inline UDF that has dependent objects (i.e. stored procedures). We ‎found we cannot simply ALTER the UDF as we do when changing a stored ...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Collect & Save DB2 Statistics Every Minute

Lack of “big picture” affects ability to tune DB2.When a DB2 performance problem is bought to our attention, the first thing that we need to determine is whether the problem is significant or not. Addressing an insignificant problem wastes tim...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Data Studio cannot display the TS data

Please see the PMR 72245,003,756
over 10 years ago in Informix / Informix Client Products 0 Not under consideration

Create a cdr client log that logs cdr command start and exit status

Cisco currently uses the CDR_FEATURES LOGCOMMANDS feature and redirects CDR client stderr and stdout to their application log file. The problem is when a CDR command fails due to a client side error, the server message log does not have any indica...
over 10 years ago in Informix / Informix Server 0 Not under consideration

I would like to create a "non-inline" SQL function that delivers a result set in DB2 for Z.

I would like to create a "non-inline" SQL function that delivers a result set in DB2 for Z. At the current time, this type of SQL function can be created on a DB2/LUW platform but the DB2/Z platform lacks this function. I look in the DB2/LUW manua...
over 10 years ago in Db2 for z/OS 2 Not under consideration

IWA Fragment Missing

We have the Informix Warehouse Accelerator running on version 11.70FC8 and the accelerator returns zero results if you try to query against a specific fragment that is not loaded into the Accelerator.
over 10 years ago in Informix / Informix Server 1 Not under consideration

IDAA COUNT(*) overflow SQLCODE difference

Count(*) on a very large table produces different SQLCODE when running on either DB2 or the IDAA : On db2 we get an SQLCODE -802 DSNT408I SQLCODE = -802, ERROR: EXCEPTION ERROR FIXED POINT OVERFLOW HAS OCCURRED DURING COLUMN FUNCTION OPERATION ON ...
over 10 years ago in Db2 Analytics Accelerator for z/OS 0 Not under consideration

Currently Committed for UPDATE

In DB2 10 for z/OS a new feature allowing currently committed data was deployed, enabling an application reading data to have the option of viewing previously committed work. This allowed for greater application concurrency, comparability with Ora...
over 10 years ago in Db2 for z/OS 0 Not under consideration

SQL Pruning for 0 > 1

The following SQL will not do a GETPAGE on 'table1' because the DB2 Optimizer recognizes that the predicate 'WHERE 0 = 1' has an empty result set: Select * from table1 where 0 = 1 The same is true if a date is used.:Select * from table1 where '201...
over 10 years ago in Db2 for z/OS 1 Not under consideration

SQEXPLAIN FILE IN VERSION 10 DISPLAYS SQL WITH STATISTICS, IN V11.70, SOME SQL IS NOT DISPLAYED.

Defect idsdb00497410 was opened and APAR IC98517 assigned after proper repro. Development rejected this based on the assumption that code was not complete in V10.00 as it is now after V11.50 and later editions. Product is working as designed. Cust...
over 10 years ago in Informix / Informix Server 1 Not under consideration

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.