Search results

Showing 2618 of 2618

LOAD should allow collecting STATISTICS without USE PROFILE option for row based tables

LOAD collects "default" statistics like auto-runstats when loading into BLU (RUNSTATS ... WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL).I assume this got not changed because the fear of incompatibility with existing behavior. Therefore pleas...

over 7 years ago in Db2 0 Not under consideration

9 VOTE

ALTER TABLE LOCKSIZE TABLE for BLU tables

ALTER TABLE LOCKSIZE TABLE is an easy way to save lock list and lock acquire for tables that just get accessed by a single application at a given time.

over 7 years ago in Db2 0 Not under consideration

5 VOTE

AREO Status via select

Some ddl Changes are in table SYSPENDINGDDL Some ddl Changes are not there: for example alter table add column can only be see via -dis db() sp() adv It would be better to have the same bahavior for all ddl changes with AREO* Status.Maybe it could...

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

7 VOTE

Flag high volatile tables as 'VOLATILE' and access those tables differently than normal tables by the query optimizer

A volatile table is defined as a table whose contents can vary from empty to very large at run time. In other words , statistics data is often out of date and may result in wrong access plans by the optimizer and subsequently may have lock the ent...

almost 6 years ago in Informix / Informix Server 0 Not under consideration

7 VOTE

force the execution of a query on an accelerator if more than one is available.

The CURRENT ACCELERATOR special register specifies a preferred target accelerator or accelerators to which Db2 sends dynamic SQL queries. But If you have multiple accelerators on which the same set of Db2 tables are accelerated, by default the wor...

almost 6 years ago in Db2 Analytics Accelerator for z/OS 4 Planned for future release

3 VOTE

Provide a facility to track Db2 Command History

A table that would record commands (like START/STOP, ), when they were executed, by whom, etc. Some commands (like DISPLAY) could be excluded. One Use Case would be to analyze why a tablespace might be in UT status when no utilities are running. A...

over 2 years ago in Db2 for z/OS 3 Not under consideration

7 MERGED

DFD should provide message handler feature.

Merged

When customer compared two tables by Diff Stage, a warning messages were output for each difference. If there are too many differences in comparing two tables, many warning message would also be output. (ex : If there are differences in 100,000 ro...

almost 6 years ago in DataStage 1 Not under consideration

8 VOTE

Create Package for Self Service Analytics in OpenPages

As Cognos Analytics appeared with OpenPages, we had high hopes of enabling our customers to do self service analytics. This was then shattered as we realized, that in order to do that, we'd have to use Framework Manager to create packages that hav...

over 6 years ago in OpenPages Ideas / Reporting 2 Delivered

1 VOTE

the qualified NVIDIA GPU Operator and driver for CPD 4.8.6 and 5.0.3

When working with Nvidia chips for AI, one is required to have the "correct" Operator version for the Nvidia Operator, and the correct driver version. But this information is not published anywhere. The customers would like a table to driver and o...

10 months ago in watsonx.ai 0 Under review

4 VOTE

NUMA aware memory allocations.

In a system with more one NUMA node sometimes best to have all memory allocated on the first NUMA node for performance. E.g. With 2 NUMA nodes with 300Gb each, pin the lowest number CPU VPs pinned to the first NUMA node and allocate all hugepages...

over 3 years ago in Informix / Informix Server 0 Future consideration

Please enter your email address

FILTER BY CATEGORY