Db2

Showing 1216

page_age_trgt_mcr should be ONLINE configurable

page_age_trgt_mcr is a kind of successor of SOFTMAX and provides the possibility to control the flushing of modified buffer pool pages to table spaces based on time. Unfortunately page_age_trgt_mcr is just configurable, not configurable ONLINE. Th...

almost 5 years ago in Db2 / Configuration Parameters 0 Not under consideration

31 VOTE

Add session-level reset for monitoring metrics in the MON_GET* table functions

There is no way to reset the metrics reported in the MON_GET* table functions. Please add functionality for resetting these at the session level, much like "RESET MONITOR" does for snapshot monitoring. Yes, there are a dozen ways to code this your...

almost 6 years ago in Db2 / Monitoring 1 Not under consideration

30 VOTE

WLM threshold for used log space

We need an activity threshold to trigger an action whenever a specific activity consumes more than a given amount of transaction log space. I know that there is already some control mechanism by using DB CFG parameters MAX_LOG and NUM_LOG_SPAN , b...

over 4 years ago in Db2 / Workload Management 0 Not under consideration

30 VOTE

Inplace Reorg should be allowed on a table with an Expression Based Index

Expression Based Indexes (available since V10.5) are a great feature that can improve query performance without adding a new (generated) column and modifying existing code. But, you cannot do an Inplace Reorg on a table with an Expression Based In...

about 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

30 VOTE

LOAD / ADMIN_MOVE_TABLE COPY YES and LOB improvements

In an OLTP / TSA HADR environment .. When using the COPY YES on ADMIN_MOVE_TABLE it uses LOAD under the covers. When LOBs are involved howere it writes out the full buffer 64k up to several 100k is written out per column/per row to a file which is...

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

29 VOTE

Enabling Restrict on Drop clause logic in create table command for db2 LUW

There is a feature called "Restrict on Drop" that should be used by the database designers while creating a table for the db2 LUW database 1) If a database designer uses this "Restrict on Drop" clause for the creation of the table then the t...

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

29 VOTE

TRANSFER OWNERSHIP for entire schema

During SAP system migration all objects in a schema need TRANSFER OWNERSHIP. This takes quite long (many minutes) for > 100.000 objects.

almost 5 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

29 VOTE

Enable 2-Factor Authentication for Remote DB2 LUW Connections

Provide an option within DB2 LUW to require 2-factor authentication using a password composed of a personal PIN plus a token code, provided by a vendor such as RSA.

over 6 years ago in Db2 / Security 0 Not under consideration

29 VOTE

Ability to archive standby - backup and restore(RIMS)

Jill,Please consider this email as a formal request for enhancement to DB2.Verizon needs the capability to do a DB2 online backup of an HADR standby database, along with a subsequent restore of the database that maintains the database as an HADR s...

about 8 years ago in Db2 / High Availability and/or Disaster Recovery 0 Future consideration

28 VOTE

Include CTQ reason / details in db2exfmt advanced diagnostics

We need an "Extended Diagnostic Information" in Explain (db2exfmt) that details if and why the column organized tables had been (early) converted to the row format for processing it in the row engine. This is important to detect performance issues...

5 months ago in Db2 / BLU Acceleration 2 Submitted

Please enter your email address

FILTER BY CATEGORY