Search results

Showing 216

Need a function or pseudo-field to return the number of elements in a BSON array

Put in simplest terms, if I have a JSON/BSON record with an embedded array, I need to know how many elements are in the array. I need a function similar to bson_size() (which returns the string length of the total array) which instead returns the ...

almost 4 years ago in Informix / Informix Server 1 Future consideration

1 VOTE

Foreign keys to use compound indexes

In the below the foreign key does not use the compound index. Another index is created with adds overhead. create table p1 (t char(4) not null); create unique index px1 on p1(t); alter table p1 add constraint primary key (t) constraint p1_pk; ...

almost 4 years ago in Informix / Informix Server 0 Future consideration

1 VOTE

Foreign keys to be able to use compound indexes.

With the following the existing compound index is not used for the foreign key and another index is required. This adds overhead with additional maintenance. create table p1 (t char(4) not null); create unique index px1 on p1(t); alter table p1 ...

almost 4 years ago in Informix / Informix Server 0 Future consideration

1 VOTE

Enable chunk rename during log recovery

Whenever Informix performs a backup of the rootdbs, it automatically backs up Informix critical files (oncfg, onconfig & sqlhosts). When the Informix critical files are restored via "onbar -r -cf only -t <A TIMESTAMP>", it restores the l...

almost 4 years ago in Informix / Informix Server 0 Future consideration

1 VOTE

ISO/IEC 9075:2016-2, T612: Add ability to declare window frame that can be shared between window functions

When you need to use the same window frame for several window functions, T612 can simplify the query. Example from code of advent, day 1: select id, case when count(1) over w = 3 then sum(depth) over w end depth from day1.input window w as (order ...

almost 4 years ago in Db2 0 Future consideration

1 VOTE

Add possibility to create dashboards over several databases

I would really to be able to create a dashboard, containing the activity response time of my top-10 databases. Or to be able to look at the graphs of some databases in 1 glance.

almost 4 years ago in Db2 / Data Management Console 0 Future consideration

1 MERGED

Please Disregard... This Is a Duplicate

Merged

Currently when an alter is performed on the primary constraint for a table, Admin Tool will warn that a corresponding change should also be performed on the primary index. However, you can back out of that warning and generate WSL which does not i...

almost 4 years ago in Db2 Administration Tool for z/OS 1 Future consideration

1 VOTE

Status for REPO should not be affected by imported journals

The customer is using period locking on company level for REPO. When submission 1 is closed for the company, a company journal can be entered and this will not affect the status for submission 1. But if the same journal is imported through "Import...

almost 4 years ago in Cognos Controller (On Prem and On Cloud) 1 Future consideration

1 VOTE

Preserve joins with accessing multiple underlying DVMs in a single SQL statement

I have a SQL statement that joins 3 tables from 1 PEER DVM with a single table from a different PEER DVM. Currently DVM is breaking this statement into 4 separate SQL statements before sending them to Db2. A better approach, when possible would be...

almost 4 years ago in Data Virtualization Manager for z/OS 0 Future consideration

1 MERGED

Application connections storm slow downs the DB response

Merged

I've been assisting with an ecommerce site. During typical days, let's say non-peak/low volume of orders, the DB response is always good. However, the DB response time slows down for a few seconds, notably during peak season/high amount of orders....

almost 4 years ago in Db2 0 Future consideration

Please enter your email address

FILTER BY CATEGORY