Db2

Showing 1386 of 15167

Avoid the database, configured in HADR, on primary side experience an outage when the database on the standby side experience any problem.

We use Db2 pureScale in many environments using POWER System. For our disaster recovery strategy we use HADR for each database between sites. In a specific situation of when some standbys databases experienced HADR_FLAGS = STANDBY_RECV_BLOCKED, re...

over 5 years ago in Db2 / High Availability and/or Disaster Recovery 1 Not under consideration

5 VOTE

SELECT * FROM FINAL TABLE (MERGE ...)

SELECT * FROM FINAL TABLE (MERGE ...) - It would be very usefull to select records that were just merged. The same way like with DELETE / UPDATE and INSTERT: SELECT * FROM FINAL TABLE (DELETE / UPDATE / INSERT)

almost 9 years ago in Db2 / Application Development 1 Not under consideration

3 VOTE

A way can backup and restore pureScale instance

Currently an user is running a pureScale cluster, when all of the SAN disks(including the disk where instance path is on) were corrupted, he has to do the following to recovery the cluster: 1) replacing the corrupted disks 2) re-install and setup ...

over 5 years ago in Db2 / pureScale 2 Not under consideration

4 VOTE

db2pd command to report exact operation that causes HADR replay only window

Currently only "Replay only window is active" is reported in db2diag.log, but not the detailed information about the operation that causes the replay only window, such as exact DDL, reorg, runstats, and etc. statements.

about 7 years ago in Db2 / High Availability and/or Disaster Recovery 0 Not under consideration

1 VOTE

DB2 z .

Hello, At the present time CP4D does not support certificate based authentication to DB2z for replication on DB2 open databases. We are forced to use a generic user with password which is not secure and not recommanded. Could you please develop th...

almost 2 years ago in Db2 0 Not under consideration

2 VOTE

Support converting non-restricted databases to restricted databases in Db2

There can be legacy databases created with non-restricted mode. However as security policies get stringent there is need to convert these databases into restricted databases. The way to convert currently is to recreate the database from scratch. I...

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

5 VOTE

Real-time statistics with statistics profile can lead to deadlocks and lock timeouts

DB2 real-time statistics facility honors RUNSTATS options specified in the statistics profile, while performing synchronous statistics collection during statement compilation. If the statistics profile contains ALLOW READ ACCESS option, this can l...

about 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

2 VOTE

Support for UR requested with column organized tables

Actually we're preparing a new Warehouse on DB2 BLU 11.5.5 on AIX using column organized tables. In an early technical examination we found, that concurrent access under isolation level UR ( reporting application ) and updating the same rows will ...

over 3 years ago in Db2 0 Future consideration

1 VOTE

let db2adutl work cross-dbpartition on one LPAR, as it did before

Before DB2 11.5.8.0.1 db2adutl could work on different dbpartitions on the same LPAR.Now it throws an error that input database partition number/current database partition number are different, if DB2NODE is not explicitly set.db2adutl should be a...

almost 2 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 3 Is a defect

3 VOTE

Add NEWMIRRORLOGPATH option to the restore command

This should be a fairly simple change/addition and prevent the possibilty that the mirrorlogs end up in the old databases mirrorlogpath by misstake or during the time it takes for the administrator to do the change manually, since the change will ...

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

Please enter your email address

FILTER BY CATEGORY