Db2

Showing 1401

Allow Wildcards in ADMIN_GET_TAB_% functions

Example: if one uses a query like this:SELECT ... FROM TABLE(SYSPROC.ADMIN_GET_TAB_COMPRESS_INFO('SCHEMA1', '')) WHERE TABNAME LIKE 'ABC%' The Function will run for all tables in the given schema and after that will filter the output for predicate...

over 8 years ago in Db2 / Analytical Functions 0 Not under consideration

4 VOTE

Job Management Functionality

The job management and scheduling component in the DB2 Data Management Console does not have the same functionality as it had in the Data Server Manager. A person can't edit a job that someone else created which makes it very difficult for a team ...

over 3 years ago in Db2 / Data Management Console 1 Planned for future release

2 VOTE

Work identification based on number of subsections in a statement.

Work identification can currently be done based on Estimated cost, Estimated cardinality, Estimated data accessed. Ref: "Work identification by type, cost, or data accessed with work classes - IBM Documentation" This allows for identification of c...

over 1 year ago in Db2 / Workload Management 0 Future consideration

7 VOTE

Online db encryption at rest

To implement encryption at rest - we have to do backup - restore i.e. outage to application. OUtage can only be avoided in case of HADR setup which is not always the case. This RFE is to bring feature of online db encryption without any outage to ...

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

9 VOTE

Provide checksums for Fixpacks

From a security perspective it would be very helpful to be able to validate that the code downloaded from FixCentral is correct and has not been tampered with (or corrupted during download). Please publish md5 or sha2 checksums for Fixpack downloa...

over 7 years ago in Db2 / Installation & Upgrade 0 Not under consideration

4 VOTE

Create a feature to DB2 11.5 Compatibility of online backup and other utilities

Request a feature on DB2 11.5 so online is backup is compatible with DDLs that require a Z lock (such as ALTER TABLE, DROP TABLE, and DROP INDEX). We have a daily eligibility and customer extract jobs that is running on a nightly basis that requir...

over 3 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 0 Future consideration

3 VOTE

Backup retention up-to 7 years

For databases that require long-term retention of backups for audit purposes, allow for 7 years of retention for database backups. In terms of restore, we expect to restore only from the same Db2 version and the older files are only for audit purp...

over 2 years ago in Db2 / Db2 on Cloud 0 Future consideration

7 VOTE

Lock access plan for a query. Prevent the optimizer from changing a plan, once a "good" plan has been determined.

We see cases where a large query runs fine, and something changes the stats, which causes the optimizer to choose a really bad plan. We would like to be able to lock an individual query, and tell the optimizer: "Just use this plan".

about 6 years ago in Db2 / Other/Unknown 0 Not under consideration

3 VOTE

provide Container and storage paths info when asking for tablespace details

In monitor views related to tablespces monitoring, when asking for detail for a specific TAblespace, DMC could provide Containers and Storage-Path informations. Storage -> Tablespace Performance - > Details Storage -> TableSpace Utilizati...

over 2 years ago in Db2 / Data Management Console 0 Not under consideration

5 VOTE

Add Smartcard certificate support for ibm_db (Python) client driver

Python is the most popular language in the area of data science and widely used in combination with Db2 - especially in environments with IAS accelerators. At the same time, many large and/or security-concious environments in general no longer acc...

over 4 years ago in Db2 / Db2 Connect and Drivers 0 Planned for future release

Please enter your email address

FILTER BY CATEGORY