Db2

Showing 1398

To provide the option to filter the system objects metadata when audit policy enabled against db2instance user id for db2 luw database in audit captured data.

When native audit with execute category is enabled on db2instance user id , by filter options on system objects schema ex : SYSTOOLS reduces the huge amount of captured data when there is a huge number of tables in an OLTP database continuously up...

4 months ago in Db2 / Security 0 Submitted

13 VOTE

BACKUP command option: ALL TABLESPACES EXCEPT (tablespace-name)

Customer has a huge number of tablespaces (f.e. 10000) and wants to do a tablespace backup of all tablespaces except of for example 3 tablespaces. We would like to do the following: $ db2 BACKUP DB myDB ALL TABLESPACES EXCEPT (unnecessary_tab...

over 4 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 0 Not under consideration

9 VOTE

System Tables should come with STATISTIC PROFILE set from factory

We all know how important STATISTICS are, and more specially, how they are captured for each particular table ! Documentation says that DBA and application sholuld determine best options, based on usage.. but ibm is lacking to do the same for thei...

over 3 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Future consideration

8 VOTE

Lighter Weight db2fodc -hang

Db2 Support often asks customers to collect db2fodc -hang to investigate hang issues. This is an heavyweight command that causes severe impact to customers' workload. We need a lighter weight db2fodc -hang command that allows users to input an app...

almost 3 years ago in Db2 1 Future consideration

7 VOTE

As Db2 system / instance administrator, I need to retrieve instance data without connecting to a regular (tenant) database

Several of the in-memory monitoring table functions and views return data which is instance-related. Still, a database connection is needed just for the purpose of having authentication / authorization / connection handle. This requires administra...

over 2 years ago in Db2 / Monitoring 0 Future consideration

7 VOTE

Automated Re-creation of Select-Star Views

If a view is created by using a 'SELECT *' statement, the view is not updated when a new column is added to the base table. An example: create table dm_tab(N integer, M integer) organize by row; insert into dm_tab(N, M) values (1, 2); create view ...

over 2 years ago in Db2 / Statements (DDL and DML) 1 Future consideration

13 VOTE

EC2U 25 GE PCIE3 adapter for db2 purescale cluster interconnect

Consider certifying the PCIe3 2-port 25/10 Gb NIC & RoCE SFP28 Adapter (FC EC2U) for use with db2 purescale cluster for cluster interconnect

almost 5 years ago in Db2 / pureScale 0 Not under consideration

27 VOTE

need to provide a RENAME SCHEMA statement (other database products provide this)

Need RENAME SCHEMA other databases other than DB2 LUW (i.e. MaxDB from SAP) provide a statement RENAME SCHEMA to rename a schema like a RENAME TABLESPACE/TABLE/INDEX. Needed on all supported operating systems.

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

8 VOTE

An analog of LOG_HADR_WAIT_TIME monitor element is needed at the agent level

Sometimes it's very useful to understand HADR influence on the transaction performance. We do have a couple of related elements - LOG_WRITE_TIME and LOG_HADR_WAIT_TIME at the whole database level, but their values can't help us to understand, if H...

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

26 VOTE

Index for a subset of rows

Possibility to index only specific rows of one or more columns. This could be implemented with a WHERE clause in the index create statement and would rsult in a tiny index for exactly the rows you are interested in.

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

Please enter your email address

FILTER BY CATEGORY