example of DB2 Load JCL

Munwar Malik

example of DB2 Load JCL


Hi all,



I am in need for DB2 LOAD jcl to load a number of partitions in parallel
using IBM utility.



Any help is appreciated!




_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Walter Janißen

AW: example of DB2 Load JCL
(in response to Munwar Malik)
Hi

I am not sure, what you exactly mean. Do you have an input dataset per partition or only one for all? Does it reside on disk or on tape?

If you have input datasets per partition or one residing on disk, you can of course, submit multiple jobs, one per partition.

If you have different inpit datasets, you can use multiple SYSREC-DDnames in one job, but I am not sure, if they are executed in parallel. I definitely know, that the indexes are built in parallel.

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Systeme Laufzeitarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

Vorsitzender des Aufsichtsrats: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996



________________________________
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von MALIK, MUNWAR (CTR)
Gesendet: Donnerstag, 16. Dezember 2010 17:12
An: [login to unmask email]
Betreff: [DB2-L] example of DB2 Load JCL


Hi all,

I am in need for DB2 LOAD jcl to load a number of partitions in parallel using IBM utility.

Any help is appreciated!


________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv