Db2

Showing 1400 of 15460

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.

over 6 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

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

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

2 VOTE

Misleading Statement in Db2 documentation on CSBs of given Fixpack

The automated implementation of updates to the most recent CSB would be significantly easier, if one could rely on CSB number only. So, it would be helpful for customer's processing of CSBs and its implementation. In Description for CSBs, e.g., he...

5 months ago in Db2 / Installation & Upgrade 1 Submitted

23 VOTE

Allow Run SQL to handle host variables as Data Studio does

When executing a SQL query under DSM, there is no provision for host variables and an error results when you try to execute a query. A simple example such as: SELECT EMPNO, FIRSTNME, LASTNAME, WORKDEPT, HIREDATE, JOB, SEX, BIRTHDATE FROM SPEMP ...

about 5 years ago in Db2 / Data Management Console 0 Not under consideration

28 VOTE

Request for enhancement of ACR when one db2 member is in the progress of DB ACTIVATE.

If one member is failed , the applications heading to the failed member should be automatically rerouted to another member in any situation. But, when DB-ACTIVATE is in progress, automatic connection reroute function is not available. So, it shoul...

over 6 years ago in Db2 / pureScale 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...

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

40 VOTE

Asynchronous index rebuild on first access

Pain point: Index rebuild stops if user terminates the connection accessing the table with an index that is marked inconsistent and it starts over from the beginning again on next table access by another user. Scenario:An index object is marked in...

about 9 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration

8 VOTE

Display the prefetch wait time metrics in the monreport.dbsummary stored procedure .

The idea will be very useful in deciding the prefetcher performance in the database which helps in reducing the I/O usage in the system. What is this prefetch wait time and when it occurs?(DB2LUW performance) Prefetcheers are very important EDU's ...

almost 2 years ago in Db2 / Monitoring 2 Functionality already exists

25 VOTE

Reorg online on 24x7 applications

The reorg online process need to lock the table in order to conclude. This is not a problem when you dont have many transactions, but when you have a 24x7 intense workload you might have a huge impact on your application.

almost 6 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration

4 VOTE

Enhancements on JSON functionality

We would like to have further enhancements in JSON area like PostgreSQL and Oracle has. Is there any plans on more functions in this area? Db2's JSON support is quite basic.

12 months ago in Db2 / NoSQL 0 Submitted

Please enter your email address

FILTER BY CATEGORY