db2 os/390 v8 utility unload template parms
Hi,
We are switching to use the unload utility from the unload program (dsntiaul). I would like to know how to use the template feature to allow multiple volumes to be used in the output. Since we use SMS to manage our storage devices and we want the output on dasd not tape, we normally can code UNIT=(SYSDA,10). I can't seem to see how we can do this using template?
When using dsntiaul we code the output jcl as follows:
//SYSREC DD DSN=DB.Z1OVMT.ZMX1E.S3INTXT.ETL.F000.DATA,
// DISP=(NEW,CATLG,DELETE),
// UNIT=(SYSDA,10),
// SPACE=(CYL,(150,50),RLSE)
When using the template feature, we can only code UNIT SYSDA.
TEMPLATE UNLDDS DSN
'DB.&DB(6,1).&DB(8).&DB(2,4)..&DB(6,1).&JO(5)..&TS..ETL.F000.DATA'
UNIT SYSDA DISP(NEW,CATLG,CATLG)
SPACE (250,250) CYL
Software/Hardware used:
Software/Hardware used:
ASKED:
August 26, 2008 3:56 PM
UPDATED:
September 23, 2009 4:50 PM
RELATED QUESTIONS
- Exchange can't receive external mail into my exchange server
- performance tunning
- Performance degraded after changing optimizer mode
- difference between QSTGLOWLMT and Threshold in dsk capabilty
- Want to use flashcopy to get source volume to target volume then later backup the target volume to tape, my job fails with ADR316W msg
Answer Wiki:
UNIT=(SYSDA,10) means that up to 10 volumes will be searched for additional space if needed.
So, if the template does not support it I guess you cannot use it.
However, I would think your SMS would be setup by storage groups and the searching of additional volumes should be automagic.
To test if SMS is setup that way, you might try running your job without specifying ",10" and see if indeed SMS will spread your data across multiple packs... you also might ask your storage admin
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
