Db2

Showing 1398

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

2 VOTE

IBM Database Management Console Migration

Hi All, We have learned that the IBM DMC(Database Management Console) doesn't have any inbuilt migration opportunities presented by itself. The migration that involves moving DMC from one host to another with minimal downtime and configuration...

5 months ago in Db2 / Data Management Console 0 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

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

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.

11 months ago in Db2 / NoSQL 0 Submitted

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

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

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

5 VOTE

Provide Db2 history of installs/updates including date

For auditing and compliance purposes, Db2 needs to easily make the following information available:- Database Version, Release, ModPack, FixPack (including security special builds)- Database Date/Time of the creation and subsequent updates- Databa...

about 1 year ago in Db2 / Installation & Upgrade 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY