´ð¸´: [DB2-L] MERGECOPY uses too many VTS drives at once

[login to unmask email]

´ð¸´: [DB2-L] MERGECOPY uses too many VTS drives at once
Rohn

You may try OPTION utility TAPEUNITS parameter, like this:

COPY LIST CPY1 COPYDDN (TMP1) PARALLEL (2) TAPEUNITS(2)

which specifies 2 parallel tasks and using 2 tape drivers.

I believe this can help you limit the number of tape drivers used ,if you
have PQ56293 installed on Version 7.

Detailed information in UTILITY GUIDE Chap 2.7.1.2, good luck!


----------------------------
Huang Hao
DB2 for z/OS DBA
Data Center(Shanghai),ICBC
Shanghai,China






"Solecki, Rohn" <[login to unmask email]>
·¢¼þÈË£º DB2 Data Base Discussion List <[login to unmask email]>
2005-01-12 06:31
Çë´ð¸´ ¸ø DB2 Database Discussion list at IDUG

ÊÕ¼þÈË£º [login to unmask email]
³­ËÍ£º
Ö÷Ì⣺ [DB2-L] MERGECOPY uses too many VTS drives at once


DB2 V7.1 z/OS 1.2

We are doing MERGECOPY using LISTDEF. We have had a contention problem
where each job takes as many VTS logical tape drives as it can, so that by
the time the 3rd job is running, all of the available tape drives have
been taken. This blocks other higher priority jobs.

There is no mention in the Utility manual of a parameter to limit number
of parallel processes, like there is in the IMAGE COPY utility. Other
than splitting up the single large job into smaller pieces, reducing the
number of tables in the MERGECOPY step can anyone suggest a way to limit
the number of VTS tapes a job uses (as I write this I realized I'll have
to check with our VTS expert and see if there is a VTS option that will
help).

TIA
Rohn Solecki

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm