Utilities (Export Import Load db2look etc)

Showing 144

EXPORT to local (not server) using the ADMIN_CMD

The export calle from admin_cmd can only export to the server. There should be a way to export in the client when called the SP,

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

3 VOTE

LOAD utility, which run towards to a partition table, should allow other query processing insert/update to other partitions.

The requests for the enhancement of DB2 LOAD utilities so as to run LOAD utility in a specific partition table during the other query processing like select/update/insert/delete on the other partitions in one partition table.

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

2 VOTE

Export should have nocoldel or coldelx20

Db2 should allow an export without characters for columns not characters, or space as column delimiter. Something like: export to myfile.csv of del modified by nochardel nocoldel select * from mytable There is something to change the column de...

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

2 VOTE

Multiple index creation in parallel in the AMT

AMT procedure is used for online reorg. At index build phase, parallel multiple index creation is needed for faster completion of job.

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

2 VOTE

db2caem should support 'SET CURRENT QUERY OPTIMIZATION = N'

For diagnostic of Db2 performance problems the tool db2caem can be very helpful. Especially if a particular query plan should be compared using different optimization levels. Using db2caem the optimization level must be specified by embedded optim...

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

1 VOTE

Db2 Templates should support defered tape Mounts

We use a VTL for our Tape Environment. For a VTL it is recommended by IBM to use UNIT=(TAPE,,DEFER) in all Jobs. DB2 uses templates to generate JCL. In this templates it is not possible to code a DEFER parameter. Is there a way to solve this dilemma?

almost 3 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Future consideration

3 VOTE

Enhance db2exfmt

Please enhance db2exfmt to support querytag and queryno so that db2exfmt can format a previous explain when the timestamp of the explain is not known (and -w -1 will not work since it's not the last explain). This would allow scripting of multiple...

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

3 VOTE

Start bufferpool command

New db2 commands to start / reallocate the bufferpool : start bufferpool bp32k ;

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

3 VOTE

Reorg timeout parameter

Set a new parameter to specify a reorg timeout limit.

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

3 VOTE

Add a database option for force application

Add the following options : force applications all for database dbalex;

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

Please enter your email address

FILTER BY CATEGORY