Db2

Showing 1339

Table partitioning for column-organized tables

Column-organized tables are currently not supported for table partitioning (e.g. PARTITION BY RANGE)..At the same time, table partitioning is used by many data warehouse customers to speed up ETL activities - e.g.:(a) load new data into a separate...

almost 7 years ago in Db2 / BLU Acceleration 0 Future consideration

9 VOTE

Increase the db2 licence limit for the DMC repository db.

16 VPC is a 2 VP value based on my server.(2core) I have more than 15 DBs to monitor, but the licence limit makes it difficult to increase the CPU. I apologize for the lack of clarity in my explanation. The bundled DB2 license for the DMC repos...

12 months ago in Db2 / Data Management Console 2 Not under consideration

9 VOTE

When setting 'DB2_COMPATIBILITY_VECTOR=ORA' in non-ora DB, the resulting string length is different.

when it's going to setup "db2set DB2_COMPATIBILITY_VECTOR=ORA"~ $ db2set DB2_COMPATIBILITY_VECTOR=ORA$ db2stop force03/27/2023 18:05:52 0 0 SQL1064N DB2STOP processing was successful.SQL1064N DB2STOP processing was successful.$ db2start03/27/2023 ...

12 months ago in Db2 / Application Development 4 Not under consideration

9 VOTE

Change replace System-defined in db2 luw to consider NLS characters in search.

Wrong result when executing the replace function with certain characters in the codeset euc-kr DB. (It comes out fine for utf-8 DB, but not for euc-kr.) Case No : TS012082536 *L3 team comment* ##################################################### ...

12 months ago in Db2 / Application Development 0 Not under consideration

58 VOTE

Decouple archive log purging from BACKUP utility

For databases using AUTO_DEL_REC_OBJ, at the end of the BACKUP utility there is a synchronous process which purges any history records and their associated archive logs. This can take a very long time on busy systems. It is necessary to decouple t...

over 6 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 1 Not under consideration

26 VOTE

A DB cfg parameter to set the default tablespace to prevent objects ending up in the wrong TS

When not explicitly set in the CREATE TABLE statement, a newly created table will end up in the last created tablespace. A lot of customers have problems with this for several reasons. They have no control over table placement when using a framewo...

almost 3 years ago in Db2 / Configuration Parameters 0 Future consideration

2 VOTE

DB2 Databases on RHEL want to use Active Directory without LDAP

Hello Team , One of the largest account from Norway wanted to use DB2 Databases on RHEL want to use Active Directory without LDAP . This is stopping orginization to migrate 20+ databases from other RDBMS . Currently DB2 databases on RHEL can only ...

3 months ago in Db2 / Other/Unknown 1 Under review

49 VOTE

Allow CREATE/REPLACE for users other than owner

Currently on Db2 LUW CREATE OR REPLACE is only allowed for the owner of a database object. CREATE OR REPLACE authorization should be opened up to allow create/replace by anyone who has the ability to drop the object and to create the object with a...

over 5 years ago in Db2 / Statements (DDL and DML) 3 Not under consideration

15 VOTE

Bitemporal tables and missing highest quantiles

If a user issues FOR BUSINESS_TIME AS OF clause against a bitemporal table, DB2 translates it to a where clause with two range predicates against business_time columns. In our system following situation occurs quite frequently: 1) At all time...

over 1 year ago in Db2 / BLU Acceleration 0 Future consideration

7 VOTE

Rebuild BLU columnar dictionaries and recompress data in BLU columnar tables

An engineered capability is required to automatically rebuild an optimal BLU columnar compression dictionary and recompress BLU columnar tables. A technique is needed to easily rebuild and recompress columnar tables like we have for adaptive compr...

10 months ago in Db2 / BLU Acceleration 0 Future consideration

Please enter your email address

FILTER BY CATEGORY