Db2

Showing 983

Prompts for all db2 utility cancellations

I have faced this issue at the beginning of my career. When we ran into some issue with utility hung or ran some utility accidentally don’t know when it will be finished and when can we kill that process. If we give a prompt with some information ...

about 1 month ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

1 VOTE

The customer want db2 product match the new standard of GB 18030-2022, which will come into effect on August 1, 2023.

The customer will have to match GB 18030-2022 standard.

5 months ago in Db2 / Application Development 0 Not under consideration

1 VOTE

Monitor DB2 Client

Setup: Currently we have a db2 client installed on the NFS and mounted on all of our app servers. A soft link created from app server home path to the db2profile NFA to access the client from app servers. Pain point: More than 800+ Nodes and 2000+...

5 months ago in Db2 / Monitoring 0 Not under consideration

1 VOTE

Data Management Console UI Changes and refresh frequency for real time monitor

The following UI changes will help users to monitor the real time data: a). Add 'rows return' column under Monitor-> Statements-> in-flight executions page as an option column b). to be able to shrink column less than the length of header na...

5 months ago in Db2 / Data Management Console 0 Not under consideration

1 VOTE

Allow creating allow/deny list of system calls possible by fenced external routines

This will secure the database further from malicious users trying to break out into the host running managed Db2 services on Cloud. This can be done using:1. seccomp() before spawning the db2fmp process and 2. Making more secure SELinux policies f...

5 months ago in Db2 / Security 0 Not under consideration

1 VOTE

Allow native support of user-defined collation such as EBCDIC in CREATE DATABASE command

This will allow easy creation of databases on LUW supporting EBCDIC collations which will in-turn allow easy migration for Db2 on z/OS to Db2 LUW. Currently, this is only supported via the user-defined option of sqlecrea() api and a C program has ...

5 months ago in Db2 / Serviceability 0 Not under consideration

1 VOTE

Simple Configuration & Health script that reports high-level database metrics

The purpose of a simple Configuration & Health script is to provide DBAs with a high-level view of macro database metrics that could suggest specific areas worthy of further investigation. The report would include these components as follows: ...

5 months ago in Db2 / Monitoring 0 Not under consideration

3 VOTE

dmctop - add interval and samples for background data collection

Like db2top, dmctop needs the capability to collect data using -i (interval in seconds) and -s (number of samples) when collecting data in background mode (-b).

5 months ago in Db2 / DMCtop 0 Not under consideration

1 VOTE

Expand db2 autoconfig to identify configuration settings less than default value

Db2 autoconfig is one way to identify configuration settings that are less than the current default of the current release. Since in-place upgrades preserve the configuration settings from the previous release, DBAs must manually find and determin...

5 months ago in Db2 / Configuration Parameters 0 Not under consideration

2 VOTE

"delete cascade" does not work with "not enforced"

The option "not enforced" on a foreign key invalidates an already set "on delete cascade" option, although this is not visible anywhere within the data model or documentation. In my opinion, setting one of these options should prohibit the other o...

6 months ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY