??: [DB2-L] MERGECOPY uses too many VTS drives at once

Rohn Solecki

??: [DB2-L] MERGECOPY uses too many VTS drives at once
Hoa
Thanks for the info, it may help for other issues, unfortunately it doesn't apply to MERGECOPY (I checked in the web version of the Utility manual, and then realized our local copy is 4 updates of of date, oops)


Rohn Solecki
Software Developer


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of William Huang
Sent: Friday, January 14, 2005 5:26 AM
To: [login to unmask email]
Subject: [DB2-L] ??: [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]>
¡¤¡é1/4t¨¨?¡êo DB2 Data Base Discussion List <[login to unmask email]>


2005-01-12 06:31
??¡äe?¡ä ?? DB2 Database Discussion list at IDUG


¨º?1/4t¨¨?¡êo [login to unmask email]
3-?¨ª¡êo
?¡Â¨¬a¡êo [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