Db2

Showing 1399

Ability to append to a file when performing an export

When exporting data to files, every export should be in a different file. And it the business requirement is to have all data in the same file, then it is necessary to do that manually with something external to db2.

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

2 VOTE

Enhancements for SSV backup of a DPF database

This is a request from Wells Fargo Bank to enhance the SSV backup of DPF databases. 1. Throttle the execution of a SSV backup by specifying the number of database partitions to concurrently execute a backup on each physical server. 2. Being able t...

almost 10 years ago in Db2 0 Not under consideration

2 VOTE

Defaut DATA BUFFER value in LOAD.

Wells Fargo requested if it possible to come up with a lower default value for DATA BUFFER without specifying DATA BUFFER in the load command. For example a registry variable like LOAD_DEFAULT_DATA_BUFFER=1000 that would take effect whenever the l...

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

2 VOTE

New privilege for IMPORT into a restrictive database

Granting DATAACCESS authority works but is not a desirable option as the user would get access to all tables. Granting CONTROL or INSERT/SELECT, without DATAACCESS, returns SQL0551N. As a result customers are left on their own to pursue and figure...

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

2 VOTE

Create a storage group in a specific database partition group.

After discussing with Pavel Sustr & Quentin Presley there is current no plans to for this hence the request. I'm copied the initial e-mail request. Is there any plan to allow storage group definition, in DPF, to apply to a particular dbpart gr...

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

2 VOTE

Improve poor query compilation performance due to long lock list traversal in DB2 10.1 and later

Beginning with DB2 LUW 10.1 DGTT-referencing DML started to take catalog locks and therefore we have to free them and potentially traverse long lock chain if the DML is a part of a long-running transaction potentially holding millions of locks. Th...

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

1 VOTE

Solaris client in Db2 v11.5

Db2 dropped the support for Solaris in V11.5, which is fine for server. However, many clients who run in Solaris could connect to other server (Linux, windows, AIX).

almost 5 years ago in Db2 / Operating System/Virtualization 0 Not under consideration

2 VOTE

DB2 LUW to have option to ignore QUERYNO clause of SQL on DB2 z/OS

The client has many SQL for z/DB2 production environment with QUERYNO clause like the following sample. Â Â SELECT /* Comment */Â Â Â Â Â Â A_ID,Â Â Â Â Â Â A_NAMEÂ&n...

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

2 VOTE

DB2 Reorg: Improve Lock Contention

Enhance Reorg:--> Reorg ... allow read access with range partitioned tables--> Options to avoid lock timeouts ---> specify max time for swap phase, restart delay for non-succeeding swap phase, deadline for reorg completion ---> allow i...

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

2 VOTE

pureScale async duplexing to secondary CF

CMB is planning to use GDPC in 2 sites which distance is about 50km. The round-trip response time is about 400 microseconds, so the delay on transfer to 2nd CF is too expensive.

about 10 years ago in Db2 / pureScale 2 Not under consideration

Please enter your email address

FILTER BY CATEGORY