Db2

Showing 86

Ability to flush or clean up catalog cache

Larger catalog-related changes, like revoking privileges from many users at the same time, are also updating the catalog cache. The cache may hold invalidated or "orphaned" entries. Those entries are only removed in an asynchronous fashion. Until ...

7 days ago in Db2 / Serviceability 0 Submitted

6 VOTE

Add a "CREATE TENANT LIKE" functionality

The new Db2 release 12.1 provides the namespace isolation via tenant feature. Default is the SYSTEM tenant. For ease of use and the ability to spin up seperate tenants fast, a statement like "CREATE TENANT <new tenant name> LIKE <existin...

3 days ago in Db2 / Statements (DDL and DML) 0 Submitted

6 VOTE

Make SET TENANT available in connect procedure

The new Db2 release 12.1 provides the namespace isolation via tenant feature. Default is the SYSTEM tenant. The tenant feature is ideal to replace small personal databases for developers where many may have the same sets of tables and also in the ...

3 days ago in Db2 / Configuration Parameters 0 Submitted

17 VOTE

Integrated Cluster solution on AIX: Move from TSA to PowerHA

DB2 has moved from TSA (Tivoli System Automation for Multiplatforms) to Pacemaker as integrated clustering solution on Linux. We use TSA in production, and we think this is a wise move, as TSA is not robust and manageable enough for a dependable s...

14 days ago in Db2 / pureScale 5 Submitted

16 VOTE

Option to avoid sampling for the distribution statistics without creating an index

Because of a misleading distribution statistic the Db2 optimizer can in some situations choose a very bad execution plan.The reason for this is, that Db2 internally samples data to faster create his distribution statistics. To create an index to a...

about 1 month ago in Db2 / BLU Acceleration 0 Submitted

19 VOTE

dmctop should be able to work with pseudo-terminal

dmctop has the limitation that it does not work with pseudo-terminal In new sudo versions the default in /etc/sudores is „use_pty“. This setting is because of a security issue and should not be changed. This means that dmctop does not work togethe...

3 months ago in Db2 / DMCtop 0 Submitted

5 VOTE

I'd like to be able to push alerts from DMC to my central monitoring teams and tool (SquaredUp in my case). Or get an API to get alerts.

I'm running Data Management Console 3.1.12 to monitor and manage 125 database in our production environment. Today, the only way I found to get database alerts is to schedule a script that reads the alerts from my repository database and puts the ...

26 days ago in Db2 / Data Management Console 2 Submitted

13 VOTE

Simplify Database Migration for Clients Migrating from DB2z to LUW

Background: Clients who are migrating their databases from DB2 on mainframes to LUW, commonly use the ISO8859-1 code set. These clients need to maintain the exact sorting order they had on the mainframe, which utilizes the EBCDIC collating sequenc...

3 months ago in Db2 / Configuration Parameters 0 Submitted

2 VOTE

Pacemaker on Db2 Linux HADR - ability to add more than 1 network interface as a resource

We use 2 network interfaces in our Db2 server setup: one public and a private used by the HADR-traffic. Other servers even have more interfaces. I'd like to be able to add them as a pacemaker resource.

13 days ago in Db2 / High Availability and/or Disaster Recovery 0 Submitted

9 VOTE

CPD Backup with Storage Fusion for Db2 in HADR mode

Right now it is not possible to use Storage Fusion Software to backup Db2 on CPD, when Db2 is operating in HADR mode. We need to be able to backup Db2 on CPD with Storage Fusion, even when Db2 is running in HADR mode

about 2 months ago in Db2 2 Submitted

Please enter your email address

FILTER BY CATEGORY