Search results

Showing 2611 of 2611

Invalid maximum timestamp value availble in DB2

Currently there is documented maximum timestamp value available in DB2 as '9999-12-31-24.00.00.000000'. However, using this value can lead to various problems which are recognized by DB2 development already as during introduction of temporal table...

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

6 VOTE

Create a "RUNSTATS Check" report similar to the REORGCHK

Although there is an Automated RUNSTATS, some people prefer to execute RUNSTATS manually. Having some ability to run a report that "Recommends" that a table should have a RUNSTATS performed would assist in making decisions. with thousands of table...

over 2 years ago in Db2 0 Future consideration

16 VOTE

DSNTIAUL should support input LRECL size of > 80 bytes and not ignore input beyond the first 72 bytes

It is sometimes easy to put SQL all on one record as long as the LRECL of that record is very large. It becomes difficult to parse that SQL so it is divided into 72 byte records. Currently, the IBM utilities have input files that can have a LRECL ...

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

30 VOTE

Allow column ALIAS in HAVING clause

Just recently while working on a customer we were able to speedup a very slow query by using the recently introduced OLAP functions. The query looks like this: SELECT col1, col2, col3, col4, rank() over (partition by col1, col2 order by col4 desc)...

over 11 years ago in Informix / Informix Server 0 Not under consideration

1 VOTE

Missing functionallity from old IBM SPSS Modeler 18.2

In local installation SPSS modeler 18.2 the user have the possibility to export data into a table with the option to create table. This functionality is missing in CP4D 5.1.3. So the new feature needed is the possibility to export data to a new ta...

5 months ago in SPSS Modeler / SPSS Modeler 0 Submitted

29 VOTE

Allow triggers install/updates without taking an outage for the box

Currently to install new triggers on a table or update triggers on a table requires outage for the box which impacts our end user customer. Our operations are 24X7X365 and don't have any outage window to work with.

over 11 years ago in Informix / Informix Server 1 Functionality already exists

17 VOTE

DB2 LUW Allow Online (Mostly) Index Creation

Hello IBM, Currently whenever we create an index on a table we see significant number of lock timeouts for the applications. We are running a pureScale cluster and not able to create Indexes ONLINE. Pain points: We use DB2 LUW pureScale as a...

over 6 years ago in Db2 / pureScale 3 Not under consideration

19 VOTE

Replacing data in System Temporal Tables using LOAD

In most tables data can be replaced using LOAD RESUME NO REPLACE. In System Termporal Tables it cannot. We want to use LOAD REPLACE to replace the existing data instead of having to delete the current data and then load with RESUME YES. The old da...

over 7 years ago in Db2 Utilities Suite for z/OS 1 Planned for future release

29 VOTE

Convert PBR tablespace to PBG without an outage

Right now we have situations come up where applications and DBAs have created partition by range (PBR) tables, and there is a need later on to convert these to partition by growth (PBG). Currently there is no way to do this without dropping the ob...

over 11 years ago in Db2 for z/OS 3 Delivered

25 VOTE

Row based security using session ID in Data Modules

We have a need for row based security in the data modules. Ideally we would be able to filter content based on the session id of the user against a security table that is part of the model. Our business analyst users can do this in other tools and...

almost 10 years ago in Cognos Analytics 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY