Hello All:
When performing a very large unload and reload we are having to use work
tapes as DASD in unavailable. We are also using sort exit and reuse work
files but CA-1 will not allow this to happen when it tries to write on
the work tape a second time.
Is anyone aware of a work around for this situation?
Bill Allen
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
CA-1 and Unload/Reload
"Hello All:
When performing a very large unload and reload we are having to use work
tapes as DASD in unavailable. We are also using sort exit and reuse work files
but CA-1 will not allow this to happen when it tries to write on the work tape
a second time.
Is anyone aware of a work around for this situation?
Bill Allen
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
Re: CA-1 and Unload/Reload
"Hello All:
Thank you Chris Hoelscher, this confirms the information that I found on
Google, and that it actually works using temporary data set names.
Has anyone used the new features of 'Express REORG' from IDMS 16.0 SP4 yet?
From what I read it seems like this might eliminate the need for stepped
reloads and greatly speed up the process for larger unloads and reloads?
Bill Allen
In a message dated 1/2/2007 8:53:52 A.M. Eastern Standard Time,
choelscher@HUMANA.COM writes:
sorry to jump in late on this one .. i definitely have had this problem in
the past, and we circumvented as follows: (relevant JCL for reload)
//SYS001 DD DSN=IDMS.UNLOAD.SYSPCH,DISP=SHR
//SYS002 DD DSN=IDMS.UNLOAD.SYS002(0),DISP=SHR
//SYS003 DD DSN=IDMS.UNLOAD.SYS003(0),DISP=SHR
//SYS005 DD DSN=&&DBL005,DISP=(NEW,PASS),UNIT=(TAPE,,DEFER),
// VOL=(,,,35),
// DCB=(RECFM=VB,LRECL=32756,BLKSIZE=32760)
//SYS006 DD DSN=&&DBL006,DISP=(NEW,PASS),UNIT=(TAPE,,DEFER),
// VOL=(,,,35),
// DCB=(RECFM=VB,LRECL=32756,BLKSIZE=32760)
//SYSPCH DD DSN=&&SORTRELD,DISP=(NEW,PASS),UNIT=3390,
// SPACE=(TRK,1),DCB=BLKSIZE=80
//RELDCTL DD DSN=IDMS.UNLOAD.RELDCTL,DISP=SHR
and the parms for the reload are:
RELOAD NOTIFY 100000 AS SORTEXIT REUSE WORKFILES;
Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com (mailTo:
choelscher@humana.com)
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP
Normal
Normal
Re: CA-1 and Unload/Reload
"Bill,
CA has released some fixes for SP4 for the Express REORG. You would
probably do best to have these installed too.
Chris