Db2

Showing 1380 of 15128

Pause and Resume compute resources

Ability to pause and resume compute resources per the needs of the application.

over 2 years ago in Db2 / Db2 on Cloud 2 Planned for future release

Remove Group Based Access Limitation

Description of Limitation: IBM has defined a few limitations with role based access which include the following: A role cannot own database objects. Permissions and roles granted to groups are not considered when you create the following database ...

almost 2 years ago in Db2 / Security 2 Future consideration

56 VOTE

Restore database to another Db2 server with different endianness

My customer is using RHEL Big Endian Linux on PPC and Db2 10.5 which is end of support April 30, 2020. They have no option but to migrate to RHEL Little Endian. They cannot simply backup and restore the database and are looking at using Db2move wh...

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

4 VOTE

Pacemaker to support Multiple primary VIPs across different interfaces if needed

We have a requirement to isolate the public traffic and qreplication traffic, so we normally create two interfaces on servers , one for public and one for qrep, currently with TSA we create a floating VIP for public interface and one for qrep inte...

5 months ago in Db2 / Operating System/Virtualization 0 Submitted

33 VOTE

Full support for aggregate function with DISTINCT in OLAP SPECIFICATION

Use of DISTINCT with e.g. COUNT function in OLAP specification (PARTITION BY clause) returns error SQL0441N (SQLCODE -441). Due to the fact that Db2 does NOT support the use of DISTINCT option in such cases, we have a major impact with COGNOS gene...

over 3 years ago in Db2 / Statements (DDL and DML) 0 Future consideration

91 VOTE

Turn on reclaimable storage without dropping/recreating the tablespaces

After a migration from db2 9.5 to 10.1, several days passed, and we reached the maximum size of a DMS tablespace of 4K. We moved one table to a different tablespace, but still noticed that the free pages were equal to 0. We tried to execute the al...

over 9 years ago in Db2 / Serviceability 0 Future consideration

2 VOTE

BRMS Recovery Report - Missed Objects

We recently had an IBMi system that lost 2 disks in the same RAID set and lost the machine. We had to rebuild from BRMS tape and after the system was made available, users indicated data was incomplete. In researching, it appears there is no easy ...

3 months ago in Db2 1 Not under consideration

8 VOTE

DMC - Encryption of the AES128 key at rest

In IBM Db2 DMC, For the AES128 encryption key that is used to encrypt all the keystore pwd, DB2 and Service Account credentials, there is a security finding on the Insecure storage of data encryption keys – i.e. the AES128 DEK is stored unencrypte...

11 months ago in Db2 / Data Management Console 1 Planned for future release

4 VOTE

Request is to make WLM Effective only on primary, on STANDBY it should not be in effect

Why is it useful? It helps us restrict the access to users who has readonly access on standbys to accidentlally connect to primary and run some rogue commands. who would benefit from it? We as DBAs, This gives us confidence on how we can use the r...

5 months ago in Db2 / Workload Management 2 Submitted

68 VOTE

Enable classic reorg with "allow write access"

Many customers want to REORG their tables quickly and efficiently. The classic REORG is by far the fastest option but puts the table in read only mode. Inplace reorg allows write access but is much slower and not suitable for tables that have a hi...

over 7 years ago in Db2 / Utilities (Export Import Load db2look etc) 3 Future consideration

Please enter your email address

FILTER BY CATEGORY