Utilities (Export Import Load db2look etc)

Showing 144

DB2 to add support for alter table without going on need for reorg immediately and allow full access (read,write,alter...etc)

After setting compatibility vector to ORA, we expect alter table to not affect read/write access. In our test, we see that after dropping even a single column, table goes in reorg_pending = Y status and we can not use reorg inplace to continue ins...

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

4 VOTE

LOAD utility should allow huge loads to run with out blocking transactional log files

Please let me explain more about how i look at LOAD utility.LOAD utility is a way to write data into database quickly by ignoring the traditional route into the system, like query processing insert/update/delete.LOAD utility will by pass many perf...

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

1 VOTE

autoexplain

Hi, With postreSQL, it is possible to have execution plans of slow statements automatically, without having to run EXPLAIN by hand. Wtih differents formats : text, xml, json, yaml. These plans are generated when a query exceeds a duration, the val...

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

2 VOTE

In db2look, for mimic stats, option to include commit each X sentences

In order to mimic an environment, the stats are extracted via db2look, and then inserted a regular execution of the generate file. The problem is that the generated updates could be easily more than 15000 sentences and it has two issues: If execut...

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

4 VOTE

Add support for XML and LOB in the ingest utility

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

3 VOTE

Enhance CLPPlus to be more equivalent to CLP in terms of functionality

Would like to see CLPPlus enhanced to the equivalent of CLP for at least the following capabilities: - full create database support, including remote client support - update for DB and DBM configuration - CLP equivalency in terms of XSR maintenanc...

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

2 VOTE

db2val should allow to receive credencial as parameters

The db2val command cannot check databases when using a external security plugin like Centrify. In this case, this command should allow to specify the user and password to connect to a database.

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

4 VOTE

DB2 LUW RFE for concurrent LOAD on the same table (vote for 68667)

DB2 LUW does not allow multiple concurrent LOAD on the same range partitioned table or any table. For example, if I have 100 partitions. I can not load all partitions using separate partition files concurrently. [Suggesting load and attaching part...

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

4 VOTE

Remove the restriction SQL1407N

When loading a table using a remote cursor on a table containing an XML colum, the load failed with the SQLCODE SQL1407N.

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

4 VOTE

Incremental Runstats (modify existing statistics based on delta from previous statistics).(RIMS)

Customer requests an incremental runstats support. Specifically the ability for runstats to modify existing statistics based on the new data that came in or was modified after the previous runstats was invoked.

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

Please enter your email address

FILTER BY CATEGORY