Db2

Showing 1372

Backup Db2 to on premisses S3 API devices (ie. EMC ECS)

Backup Db2 databases to low cost object storage devices such as EMC ECS using the S3 API. The current implementation of the S3 interface only works for a small list of known S3-style endpoints. (ie....s3.amazonaws.com, softlayer.net). This would a...

over 5 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 0 Not under consideration

1 VOTE

Functions for converting Unix Epoch Time and Dealing with RHEL 8 Native Posix MQ

SQL scalar functions for Converting between human-readable date/time and Unix Epoch Time. For example: db2 "values ept2date(123456789,0)" is equivalent to Linux GNU date command date -d "1970-01-01 1234567890 sec UTC db2 "values "date2ept('now')" ...

almost 3 years ago in Db2 / Statements (DDL and DML) 1 Future consideration

1 VOTE

DB2 LUW support for CentOS 8 Stream

As announced in December of 2020, The CentOS Project has shifted focus from CentOS Linux to CentOS Stream. Here are the expected end of life (EOL) dates for CentOS 8release. CentOS Linux 8 EOL: 2021-12-31 Today DB2 11.5.6 is certificated/compatibl...

almost 3 years ago in Db2 / Operating System/Virtualization 0 Future consideration

2 VOTE

Tool db2batch should be able to display Number of rows affected

Often db2batch is used for tuning / benchmarking purposes and very often the number of affected rows is interesting. Command line tool. 'db2'. provides the option to display the Number of rows affected, db2 -tvmf <SQL-DML-File> $ db2 -tvmf...

over 5 years ago in Db2 / Other/Unknown 0 Not under consideration

3 VOTE

Enhance db2exfmt

Please enhance db2exfmt to support querytag and queryno so that db2exfmt can format a previous explain when the timestamp of the explain is not known (and -w -1 will not work since it's not the last explain). This would allow scripting of multiple...

over 8 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

1 VOTE

Adding storage path to specific partition

Recently I faced a problem on a DPF environment. I had raised below case with IBM and seems as of now this is not possible. In DPF environment, how can I add storage path to a specific database partititon? The below command adds the storage path t...

almost 3 years ago in Db2 / Warehouse 0 Future consideration

1 VOTE

Index support for "expression op expression"

In our environment, we have many queries with predicate: "expression op expression". As they don't use indexes they're performing a table scan. We would like DB2 to be able to use indexes to resolve this type of predicate. Examples: SELECT [id], [...

almost 3 years ago in Db2 / Application Development 0 Future consideration

2 VOTE

Enable automatic index reorganization in volatile tables for non-SAP databases

per case TS001700030: Db2 autonomic features make a great contribution towards customer loyalty, usability and DB administration. It is important to have all autonomic features extended to all type-customers and not just some (i.e. SAP databases).

over 5 years ago in Db2 / Configuration Parameters 0 Not under consideration

3 VOTE

Add invisible index

Add the possibiltity to set an index as visible or invisible so that, when it is alter as invisible, the optimizer only takes it in account when the session ask for the index

over 8 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

2 VOTE

Block locking for U/D on MDC when LOCKSIZE=BLOCKINSERT

Block locking is done for INSERTs on MDC tables when LOCKSIZE = BLOCKINSERT, which is a great benefit for memory usage, and allow to parallelize treatments for different dimensions. However, this is unsufficient, because treatments do also Update/...

almost 6 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY