Db2

Showing 1398

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

6 VOTE

Add MS SQL Server 2019 support in Federation & Q-Replication...

TSMC needs to replicate data from DB2 ESE to MS SQL Server 2019. As you know, MS SQL Server 2019 already been GA recently (2019/11/04 https://sqlserverbuilds.blogspot.com/2019/01/sql-server-2019-versions.html), they are requesting this new feature...

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

1 VOTE

I'd like you to consider to add new stored procedure ADMIN_TASK_CANCEL ( like in the DB2 z/OS version https://www.ibm.com/docs/en/db2-for-zos/12?topic=db2-admin-task-cancel) in the next fix/mod/main version of DB2?

Because now I can't stop the running procedure scheduled via ATS unless I stop the instance manager.

10 months ago in Db2 / Other/Unknown 1 Submitted

1 VOTE

import MON_GET_ROUTINE_DETAILS

Whereas having the MON_GET_ROUTINE data is nice, there are times where you need to get the detail data for the various time slices to truly understand the issue on a system. The biggest issue is seeind the data summarized at the database level in ...

10 months ago in Db2 / Data Management Console 0 Submitted

8 VOTE

Allow values > 100 for MAX_LOG

MAX_LOG specifies if there is a limit to the percentage of the primary log space that a transaction can consume, and what that limit is.The range of the parameter is 0-100 percent of the primary log space. However, there are cases when a value >...

over 6 years ago in Db2 / Configuration Parameters 0 Not under consideration

5 VOTE

Verify OVERFLOWLOGPATH is valid at the BEGINNING and allow override in RESTORE DATABASE command.

When restoring a DB2/LUW database Db2 currently restores the database and then abneds if the OVERFLOWLOGPATH is invalid. A restore can take many hours and having the restore fail at the end of the restore wastes all those hours.

about 4 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 5 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

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

5 VOTE

Add option in db2look to not extract LBAC every time

All of the LBAC definitions are extracted and printed every time the -e option is specified. If one just wants the DDL for a single table, all of the LBAC definitions are printed, even if that table has nothing to do with LBAC. A -nolbac option wo...

about 4 years ago in Db2 / Utilities (Export Import Load db2look etc) 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

Please enter your email address

FILTER BY CATEGORY