ca.portal.admin

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

Discussion created by ca.portal.admin on Dec 22, 2006
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 )

Outcomes