Db2

Showing 1341

Poor performance on DB2 V11.1 due to changes in build process

Some customers are noticing performance degradations moving from v105 ESE to v111 ESE on the same hardware.These degradations are most pronounced in OLTP workloads, with an emphasis on INSERT and UPDATE operations. Db2 Support has confirmed that t...

about 5 years ago in Db2 / Serviceability 0 Not under consideration

10 VOTE

Monitor activities by the user

Regarding DMC capabilities, I would like to know if there is a possibility to monitor activities by the user. This is very important for our Db2 environment, whether qualified or unqualified table names are used (in case of unqualified names would...

over 1 year ago in Db2 / Data Management Console 3 Functionality already exists

7 VOTE

DMC DB2 Authorization for depricated SNAP Views

To use all monitor functions from the DMC the user that connected to the database that will be monitored, must have a lot of grants to funktions , views and tables. That is totaly managed in the DB2 System. But additionaly some functions such as S...

almost 1 year ago in Db2 / Security 0 Not under consideration

33 VOTE

Online BAR from pureScale to non-purescale

There are many cases that a database on the purescale cluster is needed to move on non-purescale instance. for example,backup, development or DR system . However, oracle does support this.

over 4 years ago in Db2 / pureScale 0 Not under consideration

25 VOTE

Allow a WHERE clause for ADMIN_MOVE_TABLE to delete data while moving a table

One of the most painful things to do is to delete a huge amount of data. One workaround for this is to export the data needed and then LOAD/REPLACE back into the same table, but this requires an outage of the table to accomplish. If a WHERE clause...

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

40 VOTE

Parallel log file archival and retrieval

Log archival / retrieval is performed by a single thread. This can lead to log archival stuck e.g. if log file need to be retrieved to be added to online backup include logs. This is also problematic if multiple log files need to be retrieved duri...

almost 6 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 1 Future consideration

31 VOTE

Primary Keys should allow NOT TRUSTED

Currently you can create NOT ENFORCED primary keys but the optimizer will then always treat these as trusted. This causes problems when the constraint is violated but a filter includes all PK columns since the engine will return only one row even ...

over 4 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 5 Not under consideration

20 VOTE

Integrity Validation of SW and Updates

In order to complain with the Security Framework Controls of a product which uses Db2 connect SW the following requirement should be fullfilled: "Before applying the software and security updates, their legitimate source should be validated and in...

almost 3 years ago in Db2 / Db2 Connect and Drivers 2 Planned for future release

6 VOTE

Logical Files in QPFRDATA should be secured with AUTL QPMCCDATA

Hi, on IBMi Collection services you have several file in QPFRDATA. Mostly all PF are secured with the AUTL QPMCCDATA. There are also some LF like: QAPMJOBL, QAPMSYSL, and QAPMPOOLL which are secured by AUTL: *NONE. Normally we add our user to the ...

11 months ago in Db2 / Monitoring 0 Not under consideration

37 VOTE

Allow DBM CFG FEDERATED YES ONLINE configurable

Allow DBM CFG FEDERATED YES ONLINE configurable Db2 federation is activated by: UPDATE DATABASE MANAGER CONFIGURATION USING FEDERATED YES To use federation it is necessary to stop/start database manager. Please make it possible to activate federat...

over 5 years ago in Db2 / Federation 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY