Db2

Showing 84

Tenant level recoverability : The ability to take backups and restore at the tenant level

If Namespace Separation is going to be used for lots of test/dev databases, people would need to be able to do backup/restore of their own tenants.

2 days ago in Db2 / Backup/Restore/ Rollforward/ Recover 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...

26 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 2 months ago in Db2 / BLU Acceleration 0 Submitted

1 VOTE

DB2 12.1 support for rhel8

As the vendor for both database and RHEL OS, I would really expect the customary support for RHEL8 and RHEL9 for db2 LUW 12.1. This is a huge inconvenience for those of us not on 11.5.9. If we need to upgrade we need to go across all of our server...

4 days ago in Db2 / Installation & Upgrade 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

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

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 ...

about 1 month ago in Db2 / Data Management Console 2 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

2 months ago in Db2 2 Submitted

6 VOTE

Have option to stop and start the VIP on specific db node when Pacemaker instance is in maintenance mode

We have a customer which uses VIP extensively for in their current environment (TSA/HADR) and have ability to stop, start and move VIP at will.This helps them extensively with near zero downtime during the database refresh process (very frequent p...

2 months ago in Db2 / High Availability and/or Disaster Recovery 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.

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

Please enter your email address

FILTER BY CATEGORY