Search results

Showing 1355

SQL Generated by Data Module - Pull only those fields used in a query, similar to how packages work.

When creating reports against a data module, the SQL generated pulls all the fields from the table(s) used in the query. This is not ideal, as it is inefficient, and there are certain data types, such as bits, that cause issues in data modules. It...

almost 8 years ago in Cognos Analytics 0 Not under consideration

1 VOTE

Prevent immediate reflection of PARTITION key changes

When changing partition key of PBR using ALTER TABLE ALTER PARTITION, it may take effect immediately without AREOR status under certain conditions, so please provide an option to allow PARTITION key changes to be reflected in the AREOR state upon ...

4 months ago in Db2 for z/OS 1 Not under consideration

15 VOTE

Dynamic Plan Stability - Option to restabilize an invalidated query missing

We've got several SQL queries stabilized with dynamic plan stability. Reason is to prevent them from getting a bad accesspath. After operations like "ALTER TABLE ... ROTATE PARTITION..." the query is flagged to valid N in SYSIBM.SYSDYNQRY. Than we...

over 5 years ago in Db2 for z/OS 0 Not under consideration

6 VOTE

Unload LOCK YES Drain Writers instead of executing LOCK TABLE

When executing HPU in Native MODE with parameters ULLOCK = YES, ULLOCKTE = LOCK and ULLOCKMO = NATIVE_ONLY HPU executes a EXEC SQL LOCK TABLE. Sometimes table being locked is in a TS whose a IX TS lock was left in DB2 due to this table be used in ...

about 2 years ago in Db2 High Performance Unload for z/OS 1 Not under consideration

17 VOTE

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

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

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

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

19 VOTE

Trigger support for BLU tables

Trigger support is part of many replication technologies e.g.- ADMIN_MOVE_TABLE- trigger based Qrep- SAP zero downtime upgrade

over 7 years ago in Db2 0 Not under consideration

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

over 9 years ago in Cognos Analytics 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY