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
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
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...
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
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.
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 ...
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
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...