Db2

Showing 1342

db2pd command to report exact operation that causes HADR replay only window

Currently only "Replay only window is active" is reported in db2diag.log, but not the detailed information about the operation that causes the replay only window, such as exact DDL, reorg, runstats, and etc. statements.

almost 7 years ago in Db2 / High Availability and/or Disaster Recovery 0 Not under consideration

10 VOTE

Include a comment in the backup

It will be great to include a comment each time a backup is executed. The comment value is included in the history file, it only needs to be used by the backup command.

almost 7 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 3 Not under consideration

2 VOTE

Database activation should carry separate security authority

ACTIVATE DATABASE should be a separate GRANTed authority.

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

2 VOTE

Catalog command with comment string length 30 chars is too short

Catalog command with comment string limit of 30 chars is too short. The examples in the knowledge center document use longer strings.We use the string to contain our FQDN server names and often the limit enforces us to short names.

almost 7 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

12 VOTE

DBA needs control over Jobs from Automatic Maintenance

We recently had an outage due to automatic maintenance - reorg on a table to reclaim extents. Application A (db2hmon) was running a reorg reclaim on a table and Application B which was already connected to the database and was running a job, as a ...

almost 7 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

8 VOTE

calling sql procedure in triggers in DB2 DPF

in db2 luw with the dpf feature enabled, we're facing with 2 problems when using some statements or calling procedures in triggers : calling a sql compiled procedure (containing DDL statements) doesn't work ; executing DDL statements inside the tr...

almost 7 years ago in Db2 / Application Development 0 Not under consideration

2 VOTE

Rename table does not execute a drop-create of the foreign keys.

If there are constraints on table, "rename" table results SQL0750. There is no easy way to rename table like other DBMS in Db2.

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

3 VOTE

/tmp space requirement

We've run into stuff like this before. I think a lot of these requirements are from the purescale side, but they are being applied to all systems We address the /tmp space requirement a while back so that it is a warning now (although it still cau...

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

16 VOTE

DB2 CLI connect to remote database with encrypted password file

The DB2 CLI command line does not provide a way to use an encrypted credentials file to connect remote DB2 databases.The idea is to have a similar solution like the encryped password file for SQL/Q-Replication.The replication tool asnpwd can creat...

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

5 VOTE

Provide SYSTEM / UNIQUE collation sequence support for column organized tables when codepage is 819

The lack of support for anything other than IDENTITY collation sequence for codepage 819 makes migration to BLU very difficult for customers who use it.

almost 7 years ago in Db2 / BLU Acceleration 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY