1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2006, week 5
2 65 41_Re: Replace DSNTIAUL with UNLOAD utility?12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 29 Apr 2006 10:56:40 -0500394_- When are you moving to V8? DSNTIAUL changed to use multirow fetch and cuts the cpu time a lot. Check Acrobat page 380 and following in SG24- 6465 V8 Performance Topics. The examples we used cut the cpu time 30% to 50%. http://www.redbooks.ibm.com/redbooks/pdfs/sg246465.pdf<br><br>Roger Miller<br><br>On Fri, 28 Apr 2006 18:21:52 +0200, Michael Kaplan <micaelkp@NETVISION.NET.IL> wrote: [...]
68 84 32_Re: IRLM storage high water mark12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 29 Apr 2006 11:06:40 -0500368_- If you are running into a hard maximum for IRLM lock space, then the best change to make is generally to switch to PC=YES. This will happen when you move to V8, and most large customers are running PC=YES now. Then you won't have to worry about the health of the rats, the exact amount of storage for various uses, or monitor the long running tasks so closely. [...]
153 68 33_Re: DB2/z V8 DBD Format Expansion12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 29 Apr 2006 11:28:41 -0500413_- Here are some places to find the information. DBDs, plans, packages, and stack storage all grow as you migrate to V8. Most concerns have been about the memory. There are many places that note the major changes in DBDs, plans and packages to handle Unicode, 64 bit pointers, long names, and much more complex SQL. There is a lot of variation in the amount of growth, no reasonable way to document how much. [...]
222 61 20_Re: Stage Predicates12_Tech Account20_mytechacct@YAHOO.COM31_Sat, 29 Apr 2006 20:31:03 -0700304_iso-8859-1 I have not been able to locate one yet. I keep forgetting that they did not put one in the V8 manuals and I check about every 6 months(when the need arises). I will search again and post if I find one! (BUMMMMMER).<br><br>SUBSCRIBE DB2-L Anil Kale <alisha_kale@YAHOO.COM> wrote: Hi All ! [...]
284 335 19_Re: FTE calculation12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Sun, 30 Apr 2006 13:14:53 -0400393_us-ascii This topic has come up in the past. Some key items to consider are number of production subsystems, number of applications, number of application programmers, number of test subsystems, whether or not ERP is involved or not (complexity and number of objects) , tools available , SLAs, number of ongoing projects, frequency of database changes, maintenance and upgrades. HTH Phil [...]
620 402 20_Re: Stage Predicates12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Sun, 30 Apr 2006 13:19:37 -0400433_us-ascii I did a presentation on this last year at IDUG NA and Europe, entitled "SQL Predicate Coding Best Practices". If you don't have access to it, let me know. There is quite a bit of material in the Performance Guide and in the Redbook I co-authored (High Performance Design for DB2 UDB ESE V8 for OLTP and BI). OF course, stage 1 and stage 2 are not used with LUW. Think in terms of index sargable and data sargable. Phil [...]