Search results

Showing 1357

Ability to force the next partition PBG

We would like to be able to force a partition by growth table space to take the next partition even if its not ready to grow.

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

2 VOTE

ALTER TABLE ADD COLUMN diagnostic log record needs more information to be useful

The ALTER TABLE ADD COLUMN diagnostic log record (type = 0x4400, subtype = 0x0083) lacks two crucial pieces of information as of DB2 V11 beta. 1. The inline length of the column if the added column is a LOB data type. 2. An indication that the col...

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

1 VOTE

merge node: join small local dataset to large remote dataset by sending the local data literally in the sql query

In a merge node, when joining a small local dataset to a large remote database table, Modeler downloads the entire contents of the large table in order to perform the join. This is often prohibitive. Instead, if the local dataset is small enough (...

over 6 years ago in SPSS Modeler / SPSS Modeler 0 Not under consideration

1 VOTE

terminate rollback

When database is rollback a long transaction , it may take a long time. User don't want to wait for rollback to finish. One scenario is that user has made a large change on a table that is not that important table so they are willing to drop it (o...

over 6 years ago in Db2 1 Not under consideration

1 VOTE

AODA - Avoid using tables to format text documents in columns unless the table can be linearized

The message was generated from Dynamic Assessment Plugin which is a tool to check accessibility. The tool is recommending not to use tables to format text in columns as the table cannot be linearized which is affecting WCAG section 1.3.2. However,...

over 6 years ago in Cognos Analytics 0 Not under consideration

1 VOTE

Create and use a BTS index over a temporary table.

drop table if exists tp01 ;create temp table tp01 ( nome varchar(100) ) with no log ;insert into tp01 select first 1000 tabname from systables ; create index i1_tp01 on tp01( nome bts_varchar_ops) using bts ; select * from tp01 where bts_contains ...

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

1 VOTE

Run SQL queries having joins on the tables

We use the Relational Archive Facility in IBM's InfoSphere Optim z/OS Solution to archive and then purge the data. We have created Access Definitions (AD) and each AD has a set of tables with SQL WHERE clause for some of them for extracting the da...

over 6 years ago in Optim / Optim Archive 6 Not under consideration

1 VOTE

Settlement to post a system log error message when the accumulator assigned does not exist in the IZR_ACCUM table with the affected Batch/ICL number

If an item has assigned an accumulator that is not defined in the IZR_ACCUM table, balancer can find the missing money more easily if Settlement posts system log error messages that provides the affected batch/ICL number and invalid accumulator nu...

over 6 years ago in Financial Transaction Manager / Check 0 Not under consideration

1 VOTE

Depth First By /Breadth First By support in Recursive CTE

Oracle user can order of the rows by the SEARCH clause of Recursive Common Table Expression. There are two methods, BFS and DFS. For easy application migration, this feature should be enabled.

over 6 years ago in Db2 / Application Development 0 Not under consideration

1 VOTE

Control of Locksize and Maxpartitions for implicitly defined tablespaces.

We must be able to control parameters like locksize and maxpartitions on implicitly defined tablespaces.In DB2 V12R1M504 multi table tablespaces are deprecated, so we need to use implicitly defined tablespaces for QMF useres. Today we use segmente...

over 6 years ago in Db2 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY