Search results: Db2

Showing 452 of 2594

Table Partition creation auto extension Functionality

Today DB2 doesn’t provide the auto table partition extension Functionality. We would like to have the Functionality available, could you please let us know if this is feasible and if yes how soon it would be available. This is Functionality is ava...

almost 4 years ago in Db2 0 Future consideration

5 VOTE

SELECT * FROM FINAL TABLE (MERGE ...)

SELECT * FROM FINAL TABLE (MERGE ...) - It would be very usefull to select records that were just merged. The same way like with DELETE / UPDATE and INSTERT: SELECT * FROM FINAL TABLE (DELETE / UPDATE / INSERT)

almost 10 years ago in Db2 / Application Development 1 Not under consideration

2 VOTE

UOW size for mass delete on table with data capture

requesting that DB2 generate reasonably sized URs when performing a mass delete action against a table with DATA CAPTURE set to CHANGES. in a specific case, we were rotating partitions on a base source table which was being replicated with data ca...

about 4 years ago in Db2 / Replication 0 Future consideration

5 VOTE

Real-time statistics with statistics profile can lead to deadlocks and lock timeouts

DB2 real-time statistics facility honors RUNSTATS options specified in the statistics profile, while performing synchronous statistics collection during statement compilation. If the statistics profile contains ALLOW READ ACCESS option, this can l...

about 10 years ago in Db2 0 Not under consideration

1 VOTE

DMC - Display Fine Grained Access Control (FGAC) values of Column Masks and Row Permissions for each Table

This would be a useful feature to allow DBAs to not have to leave the DMC tool and use a different tool to verify the FGAC items are in place for various tables in a Database. The DSM tool had a Tab FGAC that would display the FGAC values in place...

about 2 years ago in Db2 / Data Management Console 0 Future consideration

1 VOTE

Limit query for DMC Storage panel to active tables

Limit query scope for storage panel to active tables. Query on a peoplesoft DB takes 53 min whereas limiting scope to active tables (MON_GET_TABLE), it takes < 5 min. On Peoplesoft DB, we have about 65K tables when only 7K are used.

about 2 years ago in Db2 / Data Management Console 2 Delivered

4 VOTE

DDL creation support thru implicit trusted connection

Trusted context is a very good security mecanism to promote a user from an application server to a specific role. We face 2 problems:- DDL issued from Siebel application server, when applying a change, fails for CREATE TABLE- If user has no direct...

over 8 years ago in Db2 0 Not under consideration

4 VOTE

DB2 V9.7

When doing the case sensitive search, the index on ALT_IDENTIFIER is used correctly, and the query takes around 0.2 seconds as expected. When doing the case insensitive search, the optimiser correctly uses the V_N1999152021 column rather than the ...

over 8 years ago in Db2 0 Not under consideration

2 VOTE

on DB2 LUW , Create all indexes on nicknames, including those with key greater than 1024 bytes

When I create a nickname on a remote table with an index and the index key is greater than 1024 bytes, the index spécification is not created on the local database : There is no warning for this when the nickname is created, nothing in db2diag.log...

over 4 years ago in Db2 / Db2 Federation 0 Future consideration

5 VOTE

DB2 to add support for alter table without going on need for reorg immediately and allow full access (read,write,alter...etc)

After setting compatibility vector to ORA, we expect alter table to not affect read/write access. In our test, we see that after dropping even a single column, table goes in reorg_pending = Y status and we can not use reorg inplace to continue ins...

almost 11 years ago in Db2 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY