ca.portal.admin

CA-1 and Unload/Reload

Discussion created by ca.portal.admin on Jan 1, 2007
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

Outcomes