On Sat, 4 Aug 2007 09:42:03 -0500, Kenneth E Tomiak <[EMAIL PROTECTED]> wrote:
>It seemed to me that UNICODE on DEMAND and having DB2 load a monster >table for me is not really on DEMAND, that is letting something else way more >than I need. I have > >ADD,FROM=37,TO=1208,TECH=R > >in a PARMLIB(CUNUNIxx) member. After running for a week I issue > >d uni,all > >and there are very few entries listed. This stops DB2 from loading a monster >table with entries I never use. There must be something bad about doing it >this simply. A delay for the first use of a new entry when I have at most 12 >entries loaded at the end of a week is not that painful. Starting three DB2 >subsystems at the same time does not cause a problem. If you want to >mitigate load time, start with one, see what you really use, then add them to >your CUNUNIxx member or issue SETUNI commands to load them. > Dynamic loading is what IBM recommends now (although there is nothing wrong with doing it "the old way" if it is working). Having only a couple of entries in your system is not the norm. Even if you followed the initial DB2 recommendations from years ago (II3048/II3049) there were a lot more (about 20). Also, in my experience, "the old way" has needed maintenance now and then (additions). Prior to z/OS 1.8 I had over 60 entries in my table. Even with no additions, we had to re-build the image for each new OS release because images built from lower levels of the OS were not always compatible with the higher level OS. One less migration consideration now. So even if the old way works, there are some good reasons to migrate to the new dynamic support. Mark -- Mark Zelden Sr. Software and Systems Architect - z/OS Team Lead Zurich North America / Farmers Insurance Group - ZFUS G-ITO mailto:[EMAIL PROTECTED] z/OS and OS390 expert at http://searchDataCenter.com/ateExperts/ Systems Programming expert at http://expertanswercenter.techtarget.com/ Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
