Db2

Showing 1389

parallel insert into row organized table

parallel insert is only supported on Column organized table. insert into row_table select * from souce_table is very slow

8 months ago in Db2 / Serviceability 0 Future consideration

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

1 VOTE

Build a mechanism to validate Database compliance as per Nestle Standards by using DMC (Data Management Console) tool.

Why is it useful? DMC tool will help to interconnect all DB2 Server's at single point which we can call as central/master server and help to monitor the Database Compliance and server resource's utilization. Who would benefit from it? Database tea...

3 months ago in Db2 / Data Management Console 0 Submitted

6 VOTE

Create a "RUNSTATS Check" report similar to the REORGCHK

Although there is an Automated RUNSTATS, some people prefer to execute RUNSTATS manually. Having some ability to run a report that "Recommends" that a table should have a RUNSTATS performed would assist in making decisions. with thousands of table...

over 1 year ago in Db2 / Utilities (Export Import Load db2look etc) 0 Future 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

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

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

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

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

Please enter your email address

FILTER BY CATEGORY