CA IDMS IUA EIUA

Re: [IDMSVENDOR-L] Specifying DBname for SQL-defined databases

  • 1.  Re: [IDMSVENDOR-L] Specifying DBname for SQL-defined databases

    Posted 12-22-2006 05:15 AM
    Kay, how about a default DICTNAME in your SYSIDMS load module?


    Chris Hoelscher
    IDMS & DB2 Database Administrator
    Humana Inc
    502-476-2538
    choelscher@humana.com




    The information transmitted is intended only for the person or entity to
    which it is addressed and may contain CONFIDENTIAL material. If you
    receive this material/information in error, please contact the sender
    and delete or destroy the material/information.
    "
    IDMS Public Discussion Forum
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    Re: [IDMSVENDOR-L] Specifying DBname for SQL-defined databases
    "Kay, how about a default DICTNAME in your SYSIDMS load module?


    Chris Hoelscher
    IDMS & DB2 Database Administrator
    Humana Inc
    502-476-2538
    choelscher@humana.com




    The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
    "
    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
    "We use sort exit reuse on small and medium unload/reloadss

    for large unload/reloads we use tape and stepped reloads:

    we sort each cartridge separately and then sort merge them
    together for the next phase - 20-40% reduced sort time

    we sort the output from DBL3 by area page range and feed the
    various output file to concurrent area level DBL4 jobs - this cuts the
    dbl4 step up to 80%. We have also sorted the dbl3 output for very large
    areas by file page range - care must be used - no relocated records and
    each file level (except the first file) dbl4 needs a 1 pg temp dataset
    to lock - we also turn off dynamic allocation to prevent a file outside
    the designated page range from being allocated ( we use culprit to
    generate the sort commands and dd statements )