Db2

Showing 1391

Manual HADR takeover should fail, if standby is in bad shape

Manual HADR takeover without FORCE should fail, if standby is in good shape.

over 5 years ago in Db2 / High Availability and/or Disaster Recovery 1 Not under consideration

Parallel Runstats collection on a partitioned-table(RIMS)

[JPMC EDW] Currently, when a Runstats is performed on a partitioned-table, each partition is processed sequentially. This can prolong the duration of Runstats operation, especially for very large tables where Runstats duration is concerning. Ideal...

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

4 VOTE

dmctop should provide an option to monitor the load and table move

The dmctop could include a tool to see the progress of: loads admin move table roll forward reorg

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

7 VOTE

Allow DB2 to export data from a base table in normal state even if index tablespace is in Rollforward pending state

DB2 should allow exporting data from a base table (tablespace) in normal state even if the index tablespace is in Rollforward pending state (or other abnormal state). This would allow us to rebuilt the table without losing data.DB2 should also alt...

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

5 VOTE

DB2LOOK schema flag adjustment

There are two useful DB2LOOK flags that are often used: "-z" for specific schemas and "-t" for specific tables. I can give a list of tables, but a SINGLE schema. There are use cases where I want to capture DDL for more than one schema (which break...

over 5 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

4 VOTE

Allow to access a database during a pause in a roll forward

During a roll forward, it will be helpful to access the database in read mode in order to identify the point where to open the database. If it is not the desired point, then apply more logs, until find the desired point.

over 4 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 2 Not under consideration

7 VOTE

The option ordinality is used in XML queries but the overall performance is very slow

We use the for ordinality option in our queries but the over all performance is very poor.There is a specific XSCAN needed when ordinality is specified which takes a long time. this XSCAN produces a sequence of XML ELEMENTS. This sequence is then ...

over 7 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration

3 VOTE

Allow called Programs in z/OS to execute SQL without requiring the main program to be started with a DB2 plan.

When it becomes necessary for a called program in z/OS to execute SQL statements it is only possible when the main program is alredy called with a DB2 connection (DSN and Plan). While the required modification seems minor, it is next to impossible...

over 3 years ago in Db2 / Application Development 0 Future consideration

1 VOTE

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 year ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

5 VOTE

API(or Utility) to display to native DLL and jdbc driver version of DB2 z/OS

Hi IBM,Can IBM provide Utility or API to determine the native DLL and jdbc version of JDBC drivers? websphere application server z/OS is able to throw error in case of any mismatch between native DLL and jdbc driver versions?. why can't this can b...

over 5 years ago in Db2 / Db2 Connect and Drivers 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY