IDMS

  • 1.  CA-1 and Unload/Reload

    Posted Dec 31, 2006 07:44 PM
    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