Db2

Showing 1401

COPY bind option to DB2 LUW.

The customer needed to copy packages from the Windows V9.7 database to the AIX V11.5 database. He used the db2move utility to copy the data and would like us to have a tool to copy the COBOL program packages that exist in the DB2 Z/os environment....

8 months ago in Db2 / Utilities (Export Import Load db2look etc) 2 Submitted

8 VOTE

Capture FODC when the db2 watchdog not able to start the daemons that died

At present when the db2passwd daemon gets terminated db2 watchdog is supposed to re-instantiate the process. But when its not able to start it for some reason we expect watchdog or the engine by itself should create an FODC and collect all the nec...

4 months ago in Db2 / Monitoring 0 Submitted

10 VOTE

Db2 LUW SQL Syntax Check

It would be good if Db2 LUW had a SQL, SQL/PL syntax check engine. You can check queries for correct syntax by using the explain facility, but this doesn't work with DDL statements, functions and stored procedures. An SQL syntax check engine would...

4 months ago in Db2 / Application Development 0 Submitted

4 VOTE

Rolling update when using hadr clusters in db2u container environment

When using a hadr cluster with a db2u operator in a container environment it would be nice when changes on the containers (like db cfg parameter updates) are done in a rolling fashion so that the downtime is minimized. For example when changing th...

about 2 months ago in Db2 / Configuration Parameters 0 Under review

17 VOTE

Command 'db2pd -reorgs index' does not show info about the progress of reorg index with 'cleanup all' or 'reclaim extents'

There is a limitation to show info with db2pd -reorgs index for command like reorg indexes all for table ... allow write access cleanup all reclaim extents. It is possibile to monitor progress of reorg offline and online but not for the above case...

9 months ago in Db2 / Other/Unknown 0 Under review

7 VOTE

TS016588496: MAX_LOG setting for User vs System Activities, 2003 (MQRC_BACKED_OUT)

As documented in PMR TS016588496, a QRep configuration may fail to apply a transaction to a target system due to exceeding the MQ Log configuration. At the DB layer, the configuration setting MAX_LOG manages how large a transaction may be in terms...

4 months ago in Db2 / Replication 0

20 VOTE

Optimize db2advis (recommend indexes) with machine learning (ML) models

Isn’t it possible to use the data model information from machine learning (ML) also for the db2advis (recommend indexes)? The idea is, that db2advis also can use the data model to get new recommended indexes.

11 months ago in Db2 / Utilities (Export Import Load db2look etc) 0 Under review

15 VOTE

Configure PaceMaker for Db2/HADR automation using "rsync" as an option for "db2crm" script.

Ability to configure the entire PaceMaker cluster for Db2 HADR without using ftp or scp. For security reasons, some client environments do not allow the use of "ftp" or "scp". The cluster creation option accepts "rsync" as an option instead of "sc...

9 months ago in Db2 / High Availability and/or Disaster Recovery 0 Future consideration

3 VOTE

Data Management Console: Configure the Web Access with SSO or OAUTH2

Security policies of customers require SSO or OAUTH2 support instead of just user/password for authentication at Data Management Console (DMC).

about 2 months ago in Db2 / Utilities (Export Import Load db2look etc) 0 Submitted

31 VOTE

Improved functionality for tablespace fast pre-allocation

My customer is experiencing huge performance problems due to Tablespace Pre-allocation (DB2_USE_FAST_PREALLOCATION).At this time, IOCP Timeout occurs in Db2 and many tossbuffers occur in GPFS.This customer has been struggling with this problem for...

over 1 year ago in Db2 / pureScale 6 Future consideration

Please enter your email address

FILTER BY CATEGORY