1 IDUGDB2-L.ORG /home/listserv/home/db2-l March 2010, week 2 2 193 55_Re: IDUG 2010 Europe - 8-12 November in Vienna, Austria10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 8 Mar 2010 08:11:54 +0100432_US-ASCII Well we try to find the best news/informations/presentations/seminars for
all DB2 experts attending conference. We have a lot of experts in Planning
Committee doing a careful work (excluding myself,

who's in CPC purely by chance ) as this year , so why have we to
choose a city less than beautiful ? And this year with DB2 V10 appearing
on the horizon, a well-known hotel and Vienna's chocolate (in [...]66_OFF4BBB7B9.396F197E-ONC12576E0.002589B8-C12576E0.00273223@cesve.it 196 100 21_Re: z/IS DB2 V8.8 NFM10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 8 Mar 2010 09:44:56 +0100480_US-ASCII Hi Joe

Yes you're correct of course.

What I meant was there are ZPARM parameters affecting optimizer's
decisions like NPGTHRSH and if you leave default value '0' and if you
never run RUNSTATS (you have no statistics) optimizer is

'influenced' by taking default statistics to evaluate access path (in
that case it takes NPAGES = 501 this value was the same since V4 I think)
causing tablespace scan even if real values could be quite [...]66_OF5D922AEC.B7A67168-ONC12576E0.0027A8A7-C12576E0.002FB674@cesve.it 297 66 62_z/DB2 V8 Workload balance across multiple members in same LPAR0_24_hhuang@DCCSH.ICBC.COM.CN30_Mon, 8 Mar 2010 16:51:09 +0800752_US-ASCII Hi Gurus,

I am looking for the PTF/Usermod, that makes the group access acrossing
mulitple members in the same LPAR balanced.
I know there is it somewhere, but find nothing with GOOGLE.
Any APAR or document? We want to have a test.
Thanks!

Huang Hao
Senior Manager, Dept. System
ICBC Data Center(Shanghai)
Tel :(+86)021-28989825
Mail:hhuang@dccsh.icbc.com.cn

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional [...]69_OF991E4DEB.025045FE-ON482576E0.002FF6CE-482576E0.0030A283@icbc.com.cn 364 100 66_Re: z/DB2 V8 Workload balance across multiple members in same LPAR11_Roy Boxwell16_R.Boxwell@SEG.DE30_Mon, 8 Mar 2010 11:24:38 +0100400_ISO-8859-1 Hi!

In V9 Random attach is the delivered standard however there is this apar
out there

PK79228: NEW FUNCTION SET MEMBER INELIGIBLE FOR RANDOMIZED GROUP ATTACH.

which goes back to how it was in V8 *plus* it fixed a little bug in hte
random attach when there were more than two members in the group (ie
Normal!). This is nothing to do with "workload" tho' [...]64_OFA114D9BD.E0940079-ONC12576E0.00392EEB-C12576E0.0039302E@seg.de 465 494 28_Re: Significance of DSNDB04!7_DB2 DBA21_the.db2.dba@GMAIL.COM30_Mon, 8 Mar 2010 08:13:01 -0500664_windows-1252 Thank you all who helped me on this one.

For now, as I am left with no other choice but to let the user create (thru
his tool) his tables in DSNDB04 - WITH CAUTION.

-Josh Wawzynzak

On Wed, Mar 3, 2010 at 3:59 PM, Sevetson, Phil wrote:

> Beg pardon? I thought dropping a tablespace (which should happen when
> you drop the table, if you’ve created the tablespace implicitly) cleaned up
> the DBD?
>
>
> ------------------------------
>
> *From:* IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] *On Behalf Of *Phil
> Grainger
> *Sent:* Wednesday, March 03, 2010 3:11 PM
[...]59_85726c9d1003080513o3797ef3foa080094b32393b6c@mail.gmail.com 960 64 21_Re: z/IS DB2 V8.8 NFM10_Joe Geller21_joerg6666@HOTMAIL.COM30_Mon, 8 Mar 2010 14:42:21 +0000373_UTF-8 The best option overall is to seed the stats with (fairly) accurate stats. Volatile has
2 limitations:
1) It disables list prefetch
2) While it will get index access to the table, it doesn't help the optimizer decide on
join methods (and inner/outer table) when joining; or making the best choice of index
if there are more than one on the table. [...]53_3603927840430950.WA.joerg6666hotmail.com@www.idug.org 1025 36 21_Re: z/IS DB2 V8.8 NFM10_Joe Geller21_joerg6666@HOTMAIL.COM30_Mon, 8 Mar 2010 15:01:42 +0000332_UTF-8 I meant to say that I got a tablespace scan if the predicates were on the first
column of the index. I did get matching index access if I used all the columns
of a unique index. DB2 used the default filter factor of .04 for each predicate,
but knew when it had a unique index and only one row would be returned. [...]53_5272180170597968.WA.joerg6666hotmail.com@www.idug.org 1062 34 45_Re: z/OS DB2 V8 ZOS 1.11 USEZOSV1R9RULES(NO).13_Walters, Paul28_Paul.A.Walters@SALLIEMAE.COM30_Mon, 8 Mar 2010 10:58:53 -0500474_utf-8 Does anyone have any experience with USEZOSV1R9RULES(no).

The documentation (http://www-01.ibm.com/support/docview.wss?uid=isg1OA27291) says
"Despite possible problems due to incorrect application code as a
result of this change, all properly coded programs may benefit
from these changes. Some, such as DB2, may get a significant
performance and storage fragmentation benefit from this change.
For others the benefit may be insignificant." [...]70_EBC218E23BF7B5468DC64F2ED8547F4276FF5E7EA0@VREEXMBX01.us.ad.usa-ed.net 1097 451 21_Re: z/IS DB2 V8.8 NFM12_Hepp Shery C21_Shery.Hepp@SRPNET.COM30_Mon, 8 Mar 2010 10:15:50 -0700431_us-ascii We have not used the VOLATILE setting on any tables here. I seem to
recall that back in V7 there was an option on RUNSTATS called
FORCEROLLUP that fixed this issue. My question is does that still work
and is it still valid? Or did IBM replace that functionality with the
table setting of VOLATILE? The v9 utility guide still has FORCEROLLUP
listed as an option. Here's the description from the manual: [...]55_4B518F9CD247DA458840B9A5B9435D1602F5BC00@EXCV25.srp.gov 1549 57 45_Re: z/OS DB2 V8 ZOS 1.11 USEZOSV1R9RULES(NO).13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Mon, 8 Mar 2010 10:20:04 -0800424_utf-8 We specify USEZOSV1R9RULES(NO) in one of the three LPAR's in our prod sysplex, although we very rarely run any production work over there. I haven't seen any problems due to this parameter, and have not looked to see whether there was any difference in performance. I did ask our z/OS guy whether he was going to roll it out to the other LPAR's, but it will probably be months before I have any performance data. [...]64_927FE8790B320742927BCF9ADF7AE48A18ECDE7581@PDXMAIL.pacificorp.us 1607 28 25_Days in a month using SQL11_Akash Pilot13_akash@USA.COM30_Mon, 8 Mar 2010 20:43:06 +0000263_UTF-8 Esteemed Listers,
Given just the year and month, is there a way I can find the number of days for the given month? For example if I have 2009 for year and 02(February) for month - is there a way (in SQL) to find the number of days in February 2009? [...]45_7012102145924982.WA.akashusa.com@www.idug.org 1636 79 29_Re: Days in a month using SQL18_B. L. "Tink" Tysor16_Tink@BLTYSOR.COM30_Mon, 8 Mar 2010 15:54:44 -0500776_UTF-8 Hi Akash,

Try finding the difference between the first of the desired month and
the following month using the DAYS function constructing the dates
from your inputs of the desired year and month as follows:

SELECT DAYS('3/1/2010') - DAYS('2/1/2010') AS DAYS_IN_2010_02 FROM
SYSIBM.SYSDUMMY1

DAYS_IN_2010_02
---------------
28

1 record(s) selected.

SELECT DAYS('3/1/2008') - DAYS('2/1/2008') AS DAYS_IN_2008_02 FROM
SYSIBM.SYSDUMMY1

DAYS_IN_2008_02
---------------
29

1 record(s) selected.

Tink

On Mon, Mar 8, 2010 at 3:43 PM, Akash Pilot wrote:
> Esteemed Listers,
> Given just the year and month, is there a way I can find the number of days for the given [...]59_105fd0281003081254k49f30e5dl8a110ffcdf430a25@mail.gmail.com 1716 48 29_Re: Days in a month using SQL13_David Simpson22_dsimpson@THEMISINC.COM30_Mon, 8 Mar 2010 16:24:19 -0500569_UTF-8 LAST_DAY function takes in a date and returns the last day of that month...

LAST_DAY('2009-02-01') returns '2009-02-28'

If you want just the number of days in the month, you could say:

SELECT DAY(LAST_DAY(date))
FROM SYSIBM.SYSDUMMY1

______________________________________________________________________________
David Simpson | Senior Technical Advisor | Themis Education
123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 | dsimpson@themisinc.com
For more information about Themis, visit www.themisinc.com [...]67_7EC87535E7581C4C890F5BF1CF9A9374028A9E65@THEMISSRV1.themisinc.local 1765 93 29_Re: Days in a month using SQL10_Mark Stone17_mastone@GMAIL.COM30_Mon, 8 Mar 2010 13:26:34 -0800613_ISO-8859-1 select day(date('02' || '/01/' || '2010') + 1 month - 1 day) from
sysibm.sysdummy1;

On Mon, Mar 8, 2010 at 12:43 PM, Akash Pilot wrote:

> Esteemed Listers,
> Given just the year and month, is there a way I can find the number of days
> for the given month? For example if I have 2009 for year and 02(February)
> for month - is there a way (in SQL) to find the number of days in February
> 2009?
>
> TIA
> -Akash
>
> _____________________________________________________________________
>
> * IDUG North America * Tampa, Florida, * [...]59_b73ec4021003081326v57cc2b85k8ea317e74f6cecaf@mail.gmail.com 1859 96 29_Re: Days in a month using SQL18_B. L. "Tink" Tysor16_Tink@BLTYSOR.COM30_Mon, 8 Mar 2010 16:27:33 -0500769_UTF-8 Hi david,

Much better.

Tink

On Mon, Mar 8, 2010 at 4:24 PM, David Simpson wrote:
> LAST_DAY function takes in a date and returns the last day of that month...
>
> LAST_DAY('2009-02-01') returns '2009-02-28'
>
> If you want just the number of days in the month, you could say:
>
> SELECT DAY(LAST_DAY(date))
> FROM SYSIBM.SYSDUMMY1
>
> ______________________________________________________________________________
> David Simpson | Senior Technical Advisor | Themis Education
> 123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 | dsimpson@themisinc.com
> For more information about Themis, visit www.themisinc.com
>
> -----Original Message-----
> From: [...]59_105fd0281003081327n6a13a54bv40405ec80d477122@mail.gmail.com 1956 23 29_Re: Days in a month using SQL11_Akash Pilot13_akash@USA.COM30_Mon, 8 Mar 2010 21:43:52 +0000601_UTF-8 I did consider the LAST_DAY function but my understanding of how it worked was not correct. Your example clarified it for me. Just what I was looking for. Thanks a lot!

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________ [...]45_8477212732168158.WA.akashusa.com@www.idug.org 1980 50 29_Re: Days in a month using SQL10_Teldb2kals22_teldb2kals@TELSTRA.COM30_Mon, 8 Mar 2010 21:16:05 +0000641_UTF-8 Hi Akash,

Try

SELECT DAY(DATE('yyyy'||'-'||'mm'||'-01') +1 MONTH -1 DAY) FROM SYSIBM.SYSDUMMY1;

For example :

SELECT DAY(DATE('2012'||'-'||'02'||'-01') +1 MONTH -1 DAY) FROM SYSIBM.SYSDUMMY1;

returns 29.

Regards,
Kals

On Mon, 8 Mar 2010 20:43:06 +0000, Akash Pilot wrote:

>Esteemed Listers,
>Given just the year and month, is there a way I can find the number of days for the given month? For example if I have 2009 for year and 02(February) for month - is there a way (in SQL) to find the number of days in February 2009?
>
>TIA
>-Akash
> [...]54_2196269787177802.WA.teldb2kalstelstra.com@www.idug.org 2031 55 29_Re: Days in a month using SQL14_Chris Zampogna34_Chris.Zampogna@STERLINGSAVINGS.COM30_Mon, 8 Mar 2010 14:11:58 -0800432_utf-8 Akash,

You might have seen this, but there is a sample FUNCTION in the "DATE FUNCTIONS" section of this article http://www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html which determines leap years. (Though I have not tested this). This will get you one step closer since February is the only month that varies between leap-/non-leap years.

Best Regards,

Chris Zampogna, PMP® [...]70_439D775FB76C6C41A8FC90D4382D84BE7827043AAE@SSBMAIL.sterlingsavings.com 2087 331 156_Upcoming IDUG Webcast - "The DB2Night Show Episode #14 - "CRUNCHING THE NUMBERS", with Scott Hayes, DBI Software" - Friday 12 March 2010 at 10:00 am USA CST13_David Chapman24_David.Chapman@IAG.COM.AU30_Tue, 9 Mar 2010 11:28:14 +1100751_us-ascii _______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________

Hello DB2 List,

The DB2Night Show Episode #14 - 12 Mar 2010 - "CRUNCHING THE NUMBERS", with Scott Hayes, DBI Software

The International DB2 Users Group (IDUG) is pleased to partner with DBI to deliver a free Webcast by renowned presenter Scott Hayes, President & CEO, DBI. This live event will run approximately 60 minutes and participants will have the opportunity to pose questions to the presenter. Capacity is limited, so register early. [...]43_DB2-L%201003090028280398.032B@IDUGDB2-L.ORG 2419 297 49_JOB POSTING - BMC Software Lead Product Developer12_Estrada, Amy19_Amy_Estrada@BMC.COM30_Mon, 8 Mar 2010 18:09:47 -0700684_us-ascii This position is for a Lead Product Developer for the BMC Software MainView for DB2 product (a part of the BMC System Performance for DB2 Solution). Candidate must be able to work closely with management, team architect, Quality Assurance Reps, technical publications and other team members to design, develop, troubleshoot and debug features and functions for the product/solution mentioned above. Lead Product Developer needs to be able to work with minimum supervision and provide technical leadership for other lower level developers. Must have strong decision-making skills; take-charge personality, and the ability to drive a plan to completion combined with good [...]69_71FB16E4C059674FA97BC3AD1EBE8F1B13A2A2FBD6@PHXCCRPRD01.adprod.bmc.com 2717 128 66_Re: z/DB2 V8 Workload balance across multiple members in same LPAR0_24_hhuang@DCCSH.ICBC.COM.CN30_Tue, 9 Mar 2010 09:19:42 +0800538_UTF-8 Thank you, Roy.
This PTF is on DB2 9, and the objective is to "disable" randomized group
attach.
But this time, my issue is to "enable" radomized group attach, at least
for batch
jobs, and the version is DB2 V8 NFM.

Huang Hao
Senior Manager, Dept. System
ICBC Data Center(Shanghai)
Tel :(+86)021-28989825
Mail:hhuang@dccsh.icbc.com.cn

Roy Boxwell
å‘件人: IDUG DB2-L
2010-03-08 18:24
è¯·ç­”å¤ ç»™
IDUG DB2-L [...]69_OFC1A9504F.60A7EAFA-ON482576E1.00070C38-482576E1.00074CB5@icbc.com.cn 2846 50 66_Re: z/DB2 V8 Workload balance across multiple members in same LPAR12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 9 Mar 2010 02:09:25 +0000376_UTF-8 DB2 for z/OS V8 does not have a PTF for the new function, but if you call or send a note to service, they have a usermod for this function. DB2 for z/OS is 6 years old, and does not have many items that are 2 or 3 years old, but less than 4 or 5 years old. A usermod means more testing for you, but avoids possible impact to customers who do not want the function. [...]51_9333980788383234.WA.millerrlus.ibm.com@www.idug.org 2897 142 66_Re: z/DB2 V8 Workload balance across multiple members in same LPAR0_24_hhuang@DCCSH.ICBC.COM.CN30_Tue, 9 Mar 2010 10:57:59 +0800547_GB2312 Thank you, Roger.

Your reply is always clear and valuable.
I will send a request to my service support. :)
I just want to find some documents and have a rough browse right now,
and before triggerting a formal service request.

Huang Hao
Senior Manager, Dept. System
ICBC Data Center(Shanghai)
Tel :(+86)021-28989825
Mail:hhuang@dccsh.icbc.com.cn

Roger Miller
·¢¼þÈË: IDUG DB2-L
2010-03-09 10:09
Çë´ð¸´ ¸ø
IDUG DB2-L [...]69_OF5EDAC194.FCC2B6D0-ON482576E1.000FE824-482576E1.00104BEC@icbc.com.cn 3040 106 45_Re: z/OS DB2 V8 ZOS 1.11 USEZOSV1R9RULES(NO).12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 9 Mar 2010 03:04:21 +0000565_UTF-8 If you are a large DB2 customer, then you want the 1.10 rules, not the old ones.

Greg Dyck's Share presentation from Austin notes, "DB2 performance measurements show the z/OS 1.10 storage allocation
logic can provide a significant and measurable reduction in DBM1 CPU usage and storage fragmentation."
http://ew.share.org/client_files/callpapers/attach/SHARE_in_Austin/S1322GD084533.pdf

There is a good note from Cheryl Walker on the web. She's one of the best consultants for performance.
http://www.watsonwalker.com/PR090306.pdf [...]51_0136242007126280.WA.millerrlus.ibm.com@www.idug.org 3147 250 53_Re: JOB POSTING - BMC Software Lead Product Developer10_John Bolas18_BolasJ@COMCAST.NET30_Tue, 9 Mar 2010 02:56:40 +0000463_utf-8 Hi Amy,

  I am interested in this position.  Can you use my resume from the last interview or do you need a updated one?  Please contact me at 517-281-5056.

Take Care,

John Bolas

----- Original Message -----
From: "Amy Estrada"
To: DB2-L@IDUGDB2-L.ORG
Sent: Monday, March 8, 2010 8:09:47 PM GMT -05:00 US/Canada Eastern
Subject: [DB2-L] JOB POSTING - BMC Software Lead Product Developer [...]82_206725558.1695531268103400067.JavaMail.root@sz0018a.emeryville.ca.mail.comcast.net 3398 272 43_AD: Register for CA's May Mainframe Madness17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM30_Tue, 9 Mar 2010 12:18:56 -0000316_iso-8859-1 Hello there,

I hope you will not hate me (or ban me from the list) for this once-off advert for a CA-lead FREE AND OPEN event to all Mainframe users.

Some of you will be already familiar with our May Mainframe Madness from last year, for those who are not, here is the marketing blurb: [...]56_3D02E8610514C04F991CF832BA154C6610D1BE7E@UKSLMS11.ca.com 3671 24 45_Is there a last date to order DB2 9 for z/OS?16_Sharon Zitterman24_sharon.zitterman@NGC.COM30_Tue, 9 Mar 2010 15:31:33 +0000537_UTF-8 Hi,
Is anyone aware of an existing "last date to order" on DB2 9 for z/OS software?
Thanks in advance.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]56_5233029256351499.WA.sharon.zittermanngc.com@www.idug.org 3696 48 44_SORTKEYS with Parallel LOAD- DB2 v8 for z/OS16_Mark Labby - AES21_mlabby@AESSUCCESS.ORG30_Tue, 9 Mar 2010 10:51:09 -05000_67_OF20C1418E.EAB24D36-ON852576E1.00562D8A-852576E1.00570662@pheaa.org 3745 43 49_Re: Is there a last date to order DB2 9 for z/OS?13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Tue, 9 Mar 2010 10:51:52 -0500472_utf-8 Hi Sharon

DB2 10 is not GA yet, and neither has a date for GA been announced

Until that time, there is not likely to be any announcement of an end to marketing DB2 9

Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk

Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org [...]58_4440F5DA00E3F3459BBCB97431B91B660F26AB7E@MAILR004.mail.lan 3789 61 49_Re: Is there a last date to order DB2 9 for z/OS?13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Tue, 9 Mar 2010 11:16:06 -0500583_utf-8 Hi Sharon.

No. That hasn't been published.
Here's the place to check:

http://www-111.ibm.com/software/support/lifecycle/PLCDetail.wss?psynkey=Z736916P90323T50&synkey=O720420C40253K34&synkey=M164003R29014P61&from=spf

Dave

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...]70_E814208E0983274198870632E8697D5B0E3B50BE@nasa-dtw-ex001.nasa.cpwr.corp 3851 67 32_Select Count(*) > Rows in Table?10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 9 Mar 2010 17:32:23 +0000565_UTF-8 I'm trying to deduce what is wrong here. A plain select count(*) gives 10mil+ rows and conditional select count on a non-indexed date column gives 3.5mil rows in total (see below). Even if the developers screwd up the purge why would the unqualified select count be so high? It doesn't just go and use a unqiue index does it?
Unload also comes up with 3.5 mil rows, Check Index does show the 10mil+ entries. If select count(*) does use unique indexes then it is possible that just the indexes are bad though check index did not show any errors.
Is [...]53_3186743855315682.WA.jorghluekebcbsmn.com@www.idug.org 3919 98 36_Re: Select Count(*) > Rows in Table?13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Tue, 9 Mar 2010 13:15:16 -0500602_utf-8 Hello Jorg,

I think we'd seen something like this years ago.
The symptoms, if I recall, were that the count using predicates used an index and the unqualified one did a tablespace scan.
The index had been broken.

Try running CHECK INDEX. Use explain to see which index it might be using.

Dave

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in [...]70_E814208E0983274198870632E8697D5B0E3B50C3@nasa-dtw-ex001.nasa.cpwr.corp 4018 27 49_Re: Is there a last date to order DB2 9 for z/OS?11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Tue, 9 Mar 2010 18:19:27 +0000351_- >Is anyone aware of an existing "last date to order" on DB2 9 for z/OS software?

Check the IBM Software Life Cycle Site.

I don't recall the exact URL, but you can go to the main page (IBM for your region) and search it.
IIRC, it"ll be the first hit, if you search: software life cycle
-
Too busy driving to stop for gas! [...]104_314108383-1268158750-cardhu_decombobulator_blackberry.rim.net-1259742960-@bda026.bisx.prod.on.blackberry 4046 64 36_Re: Select Count(*) > Rows in Table?10_Max Scarpa16_mscarpa@CESVE.IT30_Tue, 9 Mar 2010 19:28:21 +0100309_US-ASCII I saw it in the past as well. I built another index using a column not
in the 'offending' index (or with a different order) ,this should shows
the real number (3.5 million rows if the first index is corrupt, in your
case). I did upon programmers' request because they had some 'doubt'. [...]66_OF8DF86719.B96A4132-ONC12576E1.0064D270-C12576E1.00652030@cesve.it 4111 1232 55_DB2 Connect V8 - Development Tools - Stored Procedure ?16_Wolters, Jeff B.24_Jeff.Wolters@PGNMAIL.COM30_Tue, 9 Mar 2010 13:28:00 -0500393_us-ascii (not sure this came across the first time - don't see it in LISTSERV on the IDUG site - so I'm sending it again)

Good Afternoon All:

I have a DB2 V8 NFM z/os stored procedure working. It has two INOUT parameters and 1 result set.
I get "runs successfully" in DB2 CONNECT V8 FP7a, and can see the input/output parameter values but I don't receive the result set. [...]81_7FD614EFA33B03448166AF44364F42AE0CB1B850F8@WN000075.oak.zone1.progress-energy.com 5344 26 59_Re: DB2 Connect V8 - Development Tools - Stored Procedure ?10_Joe Geller21_joerg6666@HOTMAIL.COM30_Tue, 9 Mar 2010 18:59:05 +0000633_UTF-8 Jeff,
To get back a result set from a stored procedure, you open the cursor,
but do not fetch the rows or close the cursor.
The calling program will fetch the rows from the result set.

Joe

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]53_5036702170556726.WA.joerg6666hotmail.com@www.idug.org 5371 58 59_Re: DB2 Connect V8 - Development Tools - Stored Procedure ?13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Tue, 9 Mar 2010 14:02:12 -0500446_utf-8 And you'll get a +644 SQLCode back from the SP telling you there are cursor rows to be fetched.

Dave

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...]70_E814208E0983274198870632E8697D5B0E3B50CC@nasa-dtw-ex001.nasa.cpwr.corp 5430 303 36_Re: Select Count(*) > Rows in Table?15_Gaston, Raymond17_GastonRay@ORU.COM30_Tue, 9 Mar 2010 14:07:58 -0500699_us-ascii Are "NULL" and "NOT NULL" the only possible values for REC_UPDT_TS?
Could 6,000,000+ rows have some other value in REC_UPDT_TS (ie...
"spaces")?

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jorg Lueke
Sent: Tuesday, March 09, 2010 12:32 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Select Count(*) > Rows in Table?

I'm trying to deduce what is wrong here. A plain select count(*) gives
10mil+ rows and conditional select count on a non-indexed date column
gives 3.5mil rows in total (see below). Even if the developers screwd
up the purge why would the unqualified select count be so high? It
doesn't [...]63_0A69F3794ED5F842B1A75AEF1D59EC430858FD9D@exchmbir.conedison.net 5734 243 36_Re: Select Count(*) > Rows in Table?15_Blaicher, Chris22_Chris_Blaicher@BMC.COM30_Tue, 9 Mar 2010 12:24:07 -0700340_us-ascii A column can either be NULL or NOT NULL. A nullable column has a leading byte that is either X'00' if it is NOT NULL or X'FF' if it is NULL. The contents of the data portion of the column is ignored when performing that test. If the null indicator byte is a value other than X'00' or X'FF', then the data object is corrupted. [...]69_476996CBBE9AF14285E09E63C370072A13CD9F7A64@PHXCCRPRD01.adprod.bmc.com 5978 577 36_Re: Select Count(*) > Rows in Table?13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Tue, 9 Mar 2010 14:26:08 -0500307_utf-8 The answer to your question Raymond is No.

Perhaps you're confused by the DDL Clause NOT NULL.

As far as I know, a column which is nullable will either have the null
value or have a non-null value. All rows would qualify for one of the
2 predicates (is Null) or (is not null) [...]70_E814208E0983274198870632E8697D5B0E3B50CE@nasa-dtw-ex001.nasa.cpwr.corp 6556 165 32_Re: web link for db2 replication18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM30_Tue, 9 Mar 2010 14:37:38 -0500550_us-ascii This is a test...

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L81_7FD614EFA33B03448166AF44364F42AE0CB21586C3@WN000075.oak.zone1.progress-energy.com 6722 25 36_Re: Select Count(*) > Rows in Table?10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 9 Mar 2010 19:47:10 +0000677_UTF-8 I ran the explain so see what index select count(*) without a predicate uses.
Since it does use an index I think we can just rebuild the indexes.
It would be nice to know that the data is correct and how the indexes could've become corrupted.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]53_0265003783617360.WA.jorghluekebcbsmn.com@www.idug.org 6748 27 36_Re: Select Count(*) > Rows in Table?10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 9 Mar 2010 19:38:26 +0000373_UTF-8 Does this mean Select COUNT(*) from TBL will use a unique index if one exists?
Because the unqualified select count is wrong, and if it is the indexes that are bad, this would also have to be true.
I hope it is because rebuilding the indexes is relatively simple.
Check index shows no errors but it does show 10.5 million entries instead of 3.5 million [...]53_0748702966852385.WA.jorghluekebcbsmn.com@www.idug.org 6776 38 40_Using the IBM Data Server Driver Package13_William Frank13_brnfo@AOL.COM30_Tue, 9 Mar 2010 19:39:50 +0000581_UTF-8 I would like to know who is using the IBM Data Server Driver Package coding in .net to access z O/S external or native stored procedures.

If you are using the .net Data server driver package I would be interested in talking to you about:

1) How did you deploy the applications? Did you use merge modules?
2) How you roll out new versions of the driver?
3) Any concerns or outages experienced?
4) How many transactions per second go thru the DS driver?
5) How are you monitoring and providing diagnostics on the driver?
6) How you keep track [...]45_7149681045619845.WA.brnfoaol.com@www.idug.org 6815 65 36_Re: Select Count(*) > Rows in Table?9_Mike Bell21_mbell11a1@VERIZON.NET30_Tue, 9 Mar 2010 14:41:42 -0600572_us-ascii SELECT COUNT(*) will usually use the smallest index in terms of page count.
If you want to force a tablespace scan, then you can use something like

SELECT
SUM (CASE
WHEN QUERYNO = 0 THEN 1
ELSE 1
END ) AS COUNT_VALUE
FROM PLAN_TABLE
;

Because DB2 doesn't expect the case to be a consistent value, it will force
the tablespace scan and give you a 'true' tablespace record count. And the
SQL will run a lot faster than the check index. I am not suggesting you
don't need to run a CHECK INDEX, just it is nice to get [...]43_16CBCBB6DC3A48E4A5EFD55D2B23EFF2@mikelaptop 6881 29 36_Re: Select Count(*) > Rows in Table?10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 9 Mar 2010 20:28:03 +0000436_UTF-8 Drat, it's not as simple. When verifying previous claims I have discovered that the unload actually finds 10.5 million rows.
So the select count via indexes, unload, and check index are all in sync.
Select count against the tablespace is the only thing with a differing value.

Time to load this into test and to see if the problem exists there, or if there's just something wrong with the production tablespace. [...]53_0596125873032042.WA.jorghluekebcbsmn.com@www.idug.org 6911 492 40_runstats forcerollup option- db2 z/os v912_Hepp Shery C21_Shery.Hepp@SRPNET.COM30_Tue, 9 Mar 2010 14:08:33 -0700616_us-ascii I was hoping that someone could clarify if this option is still valid
for seeding stats on empty partitions. Please? Thanks!

From: Hepp Shery C
Sent: Monday, March 08, 2010 10:16 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: RE: [DB2-L] z/IS DB2 V8.8 NFM

We have not used the VOLATILE setting on any tables here. I seem to
recall that back in V7 there was an option on RUNSTATS called
FORCEROLLUP that fixed this issue. My question is does that still work
and is it still valid? Or did IBM replace that functionality with the
table setting of VOLATILE? The v9 utility guide [...]55_4B518F9CD247DA458840B9A5B9435D1602F5BC26@EXCV25.srp.gov 7404 33 44_Re: runstats forcerollup option- db2 z/os v910_Joe Geller21_joerg6666@HOTMAIL.COM30_Tue, 9 Mar 2010 21:23:17 +0000406_UTF-8 Shery,
I don't think Forcerollup will seed partitions. It is used to update the
tablespace (as a whole) statistics if you run Runstats on only some
partitions (in the case where there are partitions without statistics).

Joe

Shery Hepp wrote
I was hoping that someone could clarify if this option is still valid for
seeding stats on empty partitions. Please? Thanks! [...]53_2079633369210909.WA.joerg6666hotmail.com@www.idug.org 7438 29 100_Many New Index Options in DB2 =?UTF-8?Q?=E2=80=93_Version_9_Performance_Features_=E2=80=93_?=Part 1911_Dave Beulke19_dave@DAVEBEULKE.COM30_Tue, 9 Mar 2010 21:08:52 +0000633_UTF-8 I have a new post on my DB2 blog series -"Many New Index Options in DB2 – Version 9 Performance Features – Part 19"

You may view it at http://www.davebeulke.com

Thank you!
Dave Beulke

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]51_6630603362090387.WA.davedavebeulke.com@www.idug.org 7468 63 36_Re: Select Count(*) > Rows in Table?9_Mike Bell21_mbell11a1@VERIZON.NET30_Tue, 9 Mar 2010 15:46:34 -0600532_us-ascii It is past time to talk to IBM support.

1. DB2 doesn't need a unique index - it can count each rid entry in a
non-unique index as a row just as easily. Usually it will pick the smallest
index in number of pages for SELECT COUNT (*) so that would be the most not
unique index.
2. Did you do a check index (all) TABLESPACE xxx? The unload count will
include a record for each index - 3 indexes for a table with 3.5M rows will
unload 10.5M records.
3. If you didn't do a check index (all) and [...]43_22727F5E26B24ED98ADFFB8E1880082C@mikelaptop 7532 29 36_Re: Select Count(*) > Rows in Table?10_Joe Geller21_joerg6666@HOTMAIL.COM30_Tue, 9 Mar 2010 21:32:15 +0000717_UTF-8 If you ran the two counts against the tablespace (null and not null) separately,
is there a possibility that a process ran in between that updated that column
(e.g. change the null dates to a real date)?

Try running the queries again, or combine them into 1 query.

Joe

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]53_5428344981851567.WA.joerg6666hotmail.com@www.idug.org 7562 23 52_Cross-loader function of LOAD utility for query only5_David17_mairecj@YAHOO.COM30_Tue, 9 Mar 2010 21:28:10 +0000576_UTF-8 Can a CROSS LOADER query(cursor) be used to produce a SQL report only (without LOADing any data)? If so, to what DSNTILB DD is the report directed?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]49_0340796207991185.WA.mairecjyahoo.com@www.idug.org 7586 29 36_Re: Select Count(*) > Rows in Table?10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 9 Mar 2010 22:11:00 +0000411_UTF-8 No, there's nothing going to add or delete 6.5 mil rows in a few seconds :-)
The SQL count using the tablespace is clearly off. The unload, check index, and index counts all are correct.

One more step before calling support. Going to load the data into another version of the table.
If the issue persists then it'll be a supoprt call, if not, we'll probably just replace the tablespace. [...]53_1369055543438982.WA.jorghluekebcbsmn.com@www.idug.org 7616 25 36_Re: Select Count(*) > Rows in Table?10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Wed, 10 Mar 2010 00:31:29 +0000803_UTF-8 Well loading the unload file into another tablespace has the SQL working correctly, so somehow the tablespace must have gotten fried. At least we should be able to fix this with a load replace then. Weird issue.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]53_2316104240022401.WA.jorghluekebcbsmn.com@www.idug.org 7642 32 56_Re: Cross-loader function of LOAD utility for query only10_Joe Geller21_joerg6666@HOTMAIL.COM31_Wed, 10 Mar 2010 02:49:00 +0000787_UTF-8 Why not just use DSNTEP4 or DSNTIUAL?

Can a CROSS LOADER query(cursor) be used to produce a SQL report only
(without LOADing any data)? If so, to what DSNTILB DD is the report directed?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]53_6652996220046602.WA.joerg6666hotmail.com@www.idug.org 7675 27 104_Re: Many New Index Options in DB2 =?UTF-8?Q?=E2=80=93_Version_9_Performance_Features_=E2=80=93_?=Part 197_Top Gun17_topgun-1@LIVE.COM31_Wed, 10 Mar 2010 04:27:58 +0000782_UTF-8 Since this is obviously self-promotion, this should have had AD in the subject line. It was not simply a reference to an article on DB2 but a reference to a personal log of a DB2 Consultant.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]48_1072173957976701.WA.topgun1live.com@www.idug.org 7703 94 44_Re: runstats forcerollup option- db2 z/os v911_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 10 Mar 2010 07:16:51 +0100572_ISO-8859-1 nope - this option does no seeding whatsoever. There used to be a great
bug in DB2 V8 which simply copied the stats from the last partition when
you ALTER ADDed a new one! This caused hilarious results when dynamic SQL
was accessing the data.....best is to monitor RTS and when you see a new
part for an object which has never been runstatted - fire of a runstats
nice and quick! Then wait a whiles and after the partition has "matured"
fire off another one.../AD of course you could always use our software
which does all of this for [...]64_OFD7DF9BC9.C2784963-ONC12576E2.00227EDE-C12576E2.0022805E@seg.de 7798 934 59_Re: DB2 Connect V8 - Development Tools - Stored Procedure ?28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Wed, 10 Mar 2010 13:11:28 +0530355_UTF-8 Hi Jeff,

As others have already pointed out, do not fetch or close the cursor in
the stored procedure. If you like to read, I may suggest SG24-7083-00 "DB2
for z/OS Stored Procedures: Through the CALL and Beyond". Precisely the
unit 10.2.8 has lot of information that may be useful.

Bala.
A fan of redbooks as of now. [...]68_OFAD2AA8D2.E7897530-ON652576E2.002A3398-652576E2.002A54CB@in.ibm.com 8733 55 76_Re: Many New Index Options in DB2 - Version 9 Performance Features - Part 1914_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 10 Mar 2010 08:56:39 -0500528_us-ascii By that standard, every statement by any vendor which provides information or links elsewhere would be an ad, which has clearly not been the custom on DB2-L. Please reconsider your position on this.
--Phil Sevetson, NOT a list administrator

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Top Gun
Sent: Tuesday, March 09, 2010 11:28 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Many New Index Options in DB2 - Version 9 Performance Features - Part 19 [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC466B1@MAIL02.fisalan.nycnet 8789 114 76_Re: Many New Index Options in DB2 - Version 9 Performance Features - Part 1916_Daniel Luksetich18_danl@DB2EXPERT.COM31_Wed, 10 Mar 2010 08:23:03 -0600417_us-ascii It has always been my understanding that if you are not directly selling
something then it's OK. I believe Dave's blog does not require you to buy
his services, nor does he ask for an email address to get to his
information.

I think if you can follow a link without having to give anything then OK. If
you have to sign-up then probably an AD is required, or at least a
disclaimer. [...]35_01a501cac05d$33984870$9ac8d950$@com 8904 36 56_Re: Cross-loader function of LOAD utility for query only25_SUBSCRIBE DB2-L Anonymous17_mairecj@YAHOO.COM31_Wed, 10 Mar 2010 14:02:38 +0000349_UTF-8 Good question. I was looking to produce reports that would not echo back the SQL statement or add special formatting like DSNTEP but could also handle large, complex SQL statements. Tried DSNTIAUL and it inserted colons before every column and displayed no headers. Also every SQL statement's resultset has to map to unique SYSRECnn DDs. [...]49_0493394229094594.WA.mairecjyahoo.com@www.idug.org 8941 39 56_Re: Cross-loader function of LOAD utility for query only10_Joe Geller21_joerg6666@HOTMAIL.COM31_Wed, 10 Mar 2010 14:58:35 +0000423_UTF-8 Cross-loader is for loading tables. It doesn't produce a report. DSNTIAUL is an
unload program, not a report writer, so the data returned contains what is necessary
for a subsequent load. For columns that are nullable, there would be a null indicator byte.

If you want headers, no extra bytes and only the formatting you want,
it sounds like you want a report writer like QMF or another product. [...]53_3696658618559363.WA.joerg6666hotmail.com@www.idug.org 8981 457 31_ADMIN: code of conduct reminder15_ROBERT GALAMBOS19_galambos@ROGERS.COM31_Wed, 10 Mar 2010 06:59:09 -0800622_iso-8859-1 Hello DB2-L Subscribers,   This posting is something we (the list owners) are sending out about every couple of months. The purpose is to highlight information about DB2-L and also remind subscribers about certain information. Some information will be repeated to benefit new subscribers. We hope you will find the information useful, and save it for future reference. If you have feedback or suggestions, please contact us (the list owners) at DB2-L-Request@idugdb2-l.org   Topics:   1) Reminder - The Code Place 2) Reminder - Set NOMAIL when you are out 3) Reminder - Location of FAQ 4) Reminder - DB2-L [...]43_110633.44005.qm@web88108.mail.re2.yahoo.com 9439 61 36_Re: Select Count(*) > Rows in Table?13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Wed, 10 Mar 2010 10:16:19 -0500308_utf-8 If I were you, I would still pursue with IBM support. Something could have happened that may happen again -- in circumstances less convenient to diagnose and resolve. I'm sure if you ask IBM to look into this, their response will be along the lines of "Nothing would give us greater pleasure...." [...]70_E814208E0983274198870632E8697D5B0E3B50DE@nasa-dtw-ex001.nasa.cpwr.corp 9501 54 104_Re: Many New Index Options in DB2 =?UTF-8?Q?=E2=80=93_Version_9_Performance_Features_=E2=80=93_?=Part 1913_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 10 Mar 2010 09:44:59 -0600305_UTF-8 I'm pretty sure you do not want everyone who blogs about DB2 to stop
letting people on the list know of new information in there blog.
Specifically, in the case of Dave's post, there is only information that
would be of benefit to a DB2 person in this post and almost all of his post. [...]30_4B97BE7B.9080709@attglobal.net 9556 33 45_Re: z/OS DB2 V8 ZOS 1.11 USEZOSV1R9RULES(NO).18_Sandra Lakenburger27_sandra.lakenburger@USDA.GOV31_Wed, 10 Mar 2010 16:54:20 +0000378_UTF-8 Roger,

Can you provide a little more information about what vendors had problems if USEZOSV1R9RULES is set to NO? Also, is there anything specifice in the application world that needs to be reviewed before going with NO? We're getting ready to go to z/OS 1.10 and I'd like to get a little more information before I ask my MVS guys to change the setting to NO. [...]59_0254663594563070.WA.sandra.lakenburgerusda.gov@www.idug.org 9590 87 24_Stored procedure STEPLIB11_Krnic, Ivan23_Ivan.Krnic@ALLSTATE.COM31_Wed, 10 Mar 2010 10:55:57 -0600787_US-ASCII What are some of the pros and cons of having DSNLOAD and RUNLIB.LOAD
libraries
as part of STEPLIB for DB2 stored procedure, versus having them in
LINKLIST?

Regards,

Ivan

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]77_499EA82EB489B04D8728FE77EC02DD710697BFB7@a0116-xpo0113-s.swdc.ad.allstate.com 9678 206 57_{MVS} unexplained cpu increase in DB2 mstr and Top Secret18_GRESHAM, DEBORAH B18_DGRESHAM@SCANA.COM31_Wed, 10 Mar 2010 12:02:57 -0500379_us-ascii During a 2-minute period on 12/17/09, the CPU usage (TCB time) of the mstr address space increased by a factor of 2 or 3 in our production subsystems. We did also see an increase in the CPU usage of our security software (Top Secret. These two tasks have continued using the higher amount of cpu. The busiest modules are DSNVEUS3 in mstr and TSSSFSC in Top Secret. [...]68_F09314F091D75449B06E71AB45CBBAD826FFEE56B4@EXCHANGE01.CORP.SCANA.COM 9885 233 28_Re: Stored procedure STEPLIB14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 10 Mar 2010 12:29:52 -0500366_us-ascii Do you ever need to have multiple versions of the DB2 product code running in the same LPAR (like: code fixes migrated to one SSID but not another)? That's a lot easier if your STEPLIB points to subsystem-specific executables.

Also, in all the shops I've ever worked in, the z/OS sysadm/sysprogs grumble about adding anything to the linklist... [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC466B7@MAIL02.fisalan.nycnet 10119 25 36_Re: Select Count(*) > Rows in Table?10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Wed, 10 Mar 2010 17:31:00 +0000778_UTF-8 Yeah, the ticket is open. We're also going to rerun the app conversion process in test with the production data and see if this happens again. It would be very nice to see the root cause

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]53_3226614884280083.WA.jorghluekebcbsmn.com@www.idug.org 10145 34 59_Re: DB2 Connect V8 - Development Tools - Stored Procedure ?12_Jeff Wolters24_jeff.wolters@PGNMAIL.COM31_Wed, 10 Mar 2010 18:31:34 +0000321_UTF-8 Thanks for the replies.

I have commented out the FETCH and the CLOSE CURSOR and recompiled.
I then attempt to RUN it in DB2 CONNECT DEVELOPMENT TOOLS and it comes back and says its started.
the Status says IN PROGRESS, but the PARAMETERS tab and RESULTS tab are greyed out.
It just sits there. [...]56_1064948447957231.WA.jeff.wolterspgnmail.com@www.idug.org 10180 177 38_More information about DB2 10 for z/OS10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Wed, 10 Mar 2010 14:44:48 -0500414_iso-8859-1 Hi DB2 user,

Here is a non-profit Blog about DB2 for z/OS (IBM mainframes):
http://db2usa.blogspot.com

Last update on Monday, March 8th 2010

Here are several presentations and technical documents about DB2 10 for z/OS

(formally known as DB2 X) available on several IBM websites:

- DB2 10 for z/OS: How can it help you? (70 pages with notes)
by Roger Miller [...]43_SNT118-W21EC126CE4DFEC57DDD6BDAF330@phx.gbl 10358 33 31_Renamed indexes versus datasets4_Mike30_ockenfelsmichael@JOHNDEERE.COM31_Wed, 10 Mar 2010 20:15:52 +0000345_UTF-8 When does a renamed index name become part of the underlying dataset name? I'm referring to index names that are 8 characters or less.

I've tried renaming the indexes followed by a rebuild index job. I've also tried reorging the index. Both times, the underling dataset name (4th node) remained the same as the old index name. [...]62_4350660993335119.WA.ockenfelsmichaeljohndeere.com@www.idug.org 10392 27 54_Re: Oracle Transparent Gateway for DB2 under z/OS 1.1113_Terry Banicki19_tbanicki@AMEREN.COM31_Wed, 10 Mar 2010 20:19:42 +0000838_UTF-8 FYI, Last weekend we Upgraded to 1.11 and applied maintenance to the production DB2's and CICS's. The Oracle Transparent Gateway had no issues. Actually we had only a few issues. Hopefully the OTG4DB2 will be gone by this time next year.
Terry

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]51_4656907636754887.WA.tbanickiameren.com@www.idug.org 10420 36 25_Log Analysis Tool: TVFILE13_Terry Banicki19_tbanicki@AMEREN.COM31_Wed, 10 Mar 2010 21:15:26 +0000552_UTF-8 In the Log Analysis Tool, IBM created a TVFILE to keep track of table changes which result in a new table version. The TVFILE has to be maintained manually. That means each time a DBA makes a change to a table that results in a new table version, I have to manually update the TVFILE. This allows the Log Analysis Tool to compensate for table changes when building reports that span the change. That makes sense to me. The TVFILE entry is required for any table that has a non-zero version number. This doesn't make as much sense... even if [...]51_0023504949524008.WA.tbanickiameren.com@www.idug.org 10457 80 36_Re: Select Count(*) > Rows in Table?13_Nigel Lemaire14_nlemaire@Q.COM31_Wed, 10 Mar 2010 17:44:57 -0800556_ISO-8859-1 I have seen this when a load RESUME was terminated and rerun. A bunch of
non indexed rows remained in the tablespace.

To check what is going on -
Run a select count on a Column NOT in the index (this should do a TS Scan)
Run a Select Count on a Column IN the index (this should only access
the index)
If the counts are the same all is well, if not Unload the Table, sort to
eliminate dups, and LOAD REPLACE making sure that the index build completes.
Hopefully you have one ONE table defined in this Tablespace. [...]44_BLU0-SMTP900532EAB93D867E452138D1320@phx.gbl 10538 64 38_Prashant K Kalal is out of the office.16_Prashant K Kalal25_Prashant.K.Kalal@AEXP.COM31_Wed, 10 Mar 2010 19:36:45 -0700752_us-ascii I will be out of the office starting 03/11/2010 and will not return until
03/15/2010.

I will respond to your message when I return. Please contact my Lead Louis
Ippolito for any urgent issues.

American Express made the following annotations on Wed Mar 10 2010 19:36:47

******************************************************************************

"This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify [...]66_OF66344A1F.484CDA25-ON072576E3.000E59EF-072576E3.000E59EF@aexp.com 10603 512 19_Re: PAGE LATCH high16_Robert Catterall21_rfcatterall@GMAIL.COM31_Wed, 10 Mar 2010 21:43:20 -0500418_windows-1252 Jose,

Sorry about the delayed response.

I noticed a reference in this thread to the priority of IRLM in the system.
Yes, IRLM should have highest priority (the WLM SYSSTC service class), but
the page latching with which you're concerned does not involve IRLM.
Latching of pages in the DB2 buffer pools is handled by DBM1 (the DB2
database services address space), not IRLM. [...]59_de7260f31003101843h6d1ad9b8t8bc80ac44f817391@mail.gmail.com 11116 55 54_Creating Unit of work for WLM based on Plan/Package...15_Itschak Mugzach18_imugzach@GMAIL.COM31_Thu, 11 Mar 2010 08:43:59 +0200419_ISO-8859-1 We would like to prioritize DB2 tasks based on CICS transaction importance.
How ever, we use SAG Natural under CICS so we have only one CICS defined
transaction. I wonder if the unit of work can be priorities by WLM based on
plan name or even package. Enclave is not a must, but if Natural can
create one for each transaction it will be even better. So, to my
question, is this possible? [...]58_6a4538f31003102243l743bc02paac8f81972c018eb@mail.gmail.com 11172 77 43_AW: [DB2-L] Renamed indexes versus datasets35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Thu, 11 Mar 2010 09:10:22 +0100679_iso-8859-1 I believe, the new name will never become part of the underlying VSAM-dataset, because this name is stored in column INDEXSPACE, which will not be changed by a rename or by anything else.

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Victoriaplatz 2
40477 Düsseldorf
mailto:walter.janissen@itergo.com

Vorsitzender des Aufsichtsrates: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996 [...]43_DB2-L%201003110810317473.045D@IDUGDB2-L.ORG 11250 20 25_SUBSCRIBE DB2-L Anonymous10_M R Dallal16_mrd@CHRYSLER.COM31_Thu, 11 Mar 2010 08:37:34 -05000_86_OF17BC9394.E4D7B4AD-ON852576E3.004ADA03-852576E3.004ADA06@wkamerica.notes.chrysler.com 11271 203 40_Fluff: [DB2-L] SUBSCRIBE DB2-L Anonymous13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Thu, 11 Mar 2010 09:15:47 -0500595_utf-8 Sorry, but I can’t resist – but this wasn’t very anonymous was it ☺
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk

Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of M R Dallal
Sent: 11 March 2010 13:38
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] SUBSCRIBE DB2-L Anonymous [...]58_4440F5DA00E3F3459BBCB97431B91B660F26AC53@MAILR004.mail.lan 11475 29 58_ADMIN Re: [DB2-L] Fluff: [DB2-L] SUBSCRIBE DB2-L Anonymous0_19_galambos@ROGERS.COM31_Thu, 11 Mar 2010 14:34:24 +0000317_- Anonymous/nick names are NOT allowed on the listserv. Anyone with such will have that account unable to post questions (enough of the mr hyde stuff)

The reasoning is that this is a professional list and such the expectation is whatever you post is something that you can respond to, defend, and answer. [...]105_1399180729-1268318063-cardhu_decombobulator_blackberry.rim.net-1568423775-@bda271.bisx.prod.on.blackberry 11505 25 47_Re: AW: [DB2-L] Renamed indexes versus datasets4_Mike30_ockenfelsmichael@JOHNDEERE.COM31_Thu, 11 Mar 2010 14:46:16 +0000671_UTF-8 Thanks for the reply, Walter.

I guess I'm just not understanding what benefit rename index gives us.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to $1600 off when you both come to the conference!
_____________________________________________________________________ [...]62_1941422596087405.WA.ockenfelsmichaeljohndeere.com@www.idug.org 11531 56 47_Re: AW: [DB2-L] Renamed indexes versus datasets13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Thu, 11 Mar 2010 10:03:36 -0500296_utf-8 Just the question I asked IBM a while back (can't say I've ever wanted to rename an index myself) BUT....

You know how most DB2 questions have "it depends" as the answer - well, it seems that the questions for which "it depends" doesn't make sense, the answer is probably "SAP" [...]58_4440F5DA00E3F3459BBCB97431B91B660F26AC62@MAILR004.mail.lan 11588 102 47_Re: AW: [DB2-L] Renamed indexes versus datasets14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 11 Mar 2010 10:21:56 -0500519_iso-8859-1 Given that some REORGs and COPYs are done with explicitly named indexes, renaming an index needs to go along with renaming a table -- both are needed if you're going to version your production tables, and "swap" the new in for the old.
--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: Thursday, March 11, 2010 10:04 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] AW: [DB2-L] Renamed indexes versus datasets [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC466C2@MAIL02.fisalan.nycnet 11691 90 47_Re: AW: [DB2-L] Renamed indexes versus datasets19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Thu, 11 Mar 2010 10:23:07 -0500553_iso-8859-1 I can think of a good reason to rename an index. If making major changes to a table that (typically) would require dropping it and recreating it, you may want to instead create a new version of the table (which can be done in advance) and cross-load the data in order to minimize the impact to the application. You may then want to rename the "new" version of the table to the "existing" name. Similarly, the indexes on the new version of the table would have different names that you may want to rename to the existing version. Why? So [...]70_C7DCA78FAF334147B2FD39A220A4C500019EDB0927@HFDPMSGCMS02.aeth.aetna.com 11782 280 35_Re: Renamed indexes versus datasets13_Michael Ebert18_mebert@AMADEUS.COM31_Thu, 11 Mar 2010 15:34:01 +0000606_ISO-8859-1 You might just as well ask why there is a RENAME TABLE. Just yesterday I
renamed a constraint and an index (in Oracle) to sync them between Prod
and a test system. You might have naming conventions, and these do tend to
change.

Saying that the user shouldn't care because he doesn't need index names
(unlike table names) is jumping too short. First, he might need them for
hinting; then the DBA of course _does_ work with indexes, and it's nice to
be able to give them speaking names instead of random letter combinations
even if it's not required functionally. [...]69_OF5201CF88.6D72AA51-ON002576E3.00545FE1-C12576E3.0055831C@amadeus.com 12063 82 55_AW: [DB2-L] AW: [DB2-L] Renamed indexes versus datasets35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Thu, 11 Mar 2010 16:38:07 +0100504_iso-8859-1 Mike

We have naming conventions for databases, tablespaces, tables, indexes and so on. And for clustering indexes we use a special suffix. e.g. the table is named ISTB0001, then the clustering index is ISIX0001, an additional index is named ISIX1001.

Sometimes, when we have to change table-structures of very big tables, which is only possible by drop and recreate, we use the rename table option as a safety. But we weren't able to rename the indexes, but with V9 we can. [...]43_DB2-L%201003111539027151.047E@IDUGDB2-L.ORG 12146 625 43_FW: [DB2-L] Renamed indexes versus datasets13_David Simpson22_dsimpson@THEMISINC.COM31_Thu, 11 Mar 2010 11:27:42 -0500579_iso-8859-1 I think the confusion comes in because in DB2 on z/OS, the logical index name usually corresponds to the physical indexspace name and therefore a physical VSAM dataset (provided of course that you keep the names under 8 characters with no duplicates within a database). In DB2 9 the logical index may be renamed but the indexspace may not. One of the biggest reasons a DBA may want to rename an index is to reposition the underlying VSAM file which still cannot be done without a drop / recreate. If you rename indexes in an environment where the index [...]67_7EC87535E7581C4C890F5BF1CF9A9374028A9FF1@THEMISSRV1.themisinc.local 12772 60 29_Re: Log Analysis Tool: TVFILE16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Thu, 11 Mar 2010 11:47:11 -0500310_UTF-8 I can't help doing a little ad here.
CA Log Analyzer looks into the catalog as well as the log to find table changes, so it is automated out-of-the-box. Remember that Online Schema Changes result in UPDATE/INSERT into the catalog, so CA Log Analyzer does pick up these during the log processing. [...]56_0A18F096E689AC43BB2F52DAE5674D6007E697B5@USILMS14.ca.com 12833 96 29_Re: Log Analysis Tool: TVFILE12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Thu, 11 Mar 2010 12:48:43 -0600666_utf-8 Well - I was holding up ok but Steen pushed me over the edge.



For 'Versioning' (both ALTERED or DROPPED and re-CREATED) BMC Log Master for DB2 automatically normalizes log records to the current version of a versioned tablespace without customer intervention. This is accomplished by getting necessary mapping from system pages in the current tablespace, image copies, and (if necessary) the log. No manual intervention to input alternative schema mapping is required. Similarly, Log Master can be directed to track and record information on prior schema incarnations of dropped objects and map log records to table schema [...]69_B04A515BCAE7C34D90FEE204B055E3B24A419E1640@PHXCCRPRD02.adprod.bmc.com 12930 153 29_Re: Log Analysis Tool: TVFILE14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 11 Mar 2010 14:09:43 -0500467_us-ascii I hate to be the one to go rules-y on y'all, but everybody's gone to touting their products; I think you folks need to put the [AD] pseudo-tag in your titles for this thread hereafter.

--Phil Sevetson, apologetically.

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Weaver, Rick
Sent: Thursday, March 11, 2010 1:49 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Log Analysis Tool: TVFILE [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC466C6@MAIL02.fisalan.nycnet 13084 186 29_Re: Log Analysis Tool: TVFILE16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Thu, 11 Mar 2010 14:13:12 -0500521_US-ASCII I'm deeply sorry - forgot the [AD] in the subject. MY BAD !!!!

Steen

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson,
Phil
Sent: Thursday, March 11, 2010 1:10 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Log Analysis Tool: TVFILE

I hate to be the one to go rules-y on y'all, but everybody's gone to
touting their products; I think you folks need to put the [AD]
pseudo-tag in your titles for this thread hereafter. [...]56_0A18F096E689AC43BB2F52DAE5674D6007E69885@USILMS14.ca.com 13271 569 47_[AD]RE: [DB2-L] Renamed indexes versus datasets12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Thu, 11 Mar 2010 13:17:51 -0600330_iso-8859-1 BMC has a product feature and process that exploits the RENAME feature to reduce the downtime for many types of U/D/C/L structure changes to the duration of the rename process plus a little.

If you would like more information and a whitepaper describing the feature and process, please contact me off-list. [...]69_B04A515BCAE7C34D90FEE204B055E3B24A419E16ED@PHXCCRPRD02.adprod.bmc.com 13841 135 29_Re: Log Analysis Tool: TVFILE17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Thu, 11 Mar 2010 19:47:03 -0000602_us-ascii "Well - I was holding up ok but Steen pushed me over the edge. "

mwhahahahaha

Thanks.

Aurora

Aurora Emanuela Dell'Anno
CA MSC
Sr. Engineering Services Architect
Tel: +44 (0)1753 577 733
Mobile: +44 (0)7768 235 339
Aurora.Dellanno@ca.com

http://www.ca.com/

P please don't print this e-mail unless you really need to!

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Weaver, Rick
Sent: 11 March 2010 18:49
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Log Analysis Tool: TVFILE [...]56_3D02E8610514C04F991CF832BA154C6610566ECF@UKSLMS11.ca.com 13977 31 30_GetPages and SELECT statements5_anand19_mahadea@LABCORP.COM31_Thu, 11 Mar 2010 22:37:26 +0000393_UTF-8 I'm working on DB2 v8 on z/OS. I was wondering once we add columns to an Index to make a SELECT statement Index Only, would the number of Get Pages associated with that statement halve?

If not, is there some metric I can look at in Omegamon that would show the impact of this? I can't use execution time since my program doesn't process the same number of records every day. [...]51_7996980932363851.WA.mahadealabcorp.com@www.idug.org 14009 39 34_Re: GetPages and SELECT statements12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Fri, 12 Mar 2010 11:26:22 +0000494_UTF-8 In answer to your first question - no, the number of getpages wont halve. You will certainly "save" all of the getpages related to the tablespace access but your number of getpages related to the index may increase as a result of the larger index size.
The percentage save of the total number number of getpages related to the SELECT will depend on numerous factors.
You would normally expect to see a significant reduction. If you can keep your index in buffer, better still. [...]54_0746502956971910.WA.adambaldwines.ibm.com@www.idug.org 14049 26 34_Re: GetPages and SELECT statements11_Nenad Vidak21_nenad.vidak@GMAIL.COM31_Fri, 12 Mar 2010 11:34:21 +0000722_UTF-8 You can generate an accounting report and check the average getpage/CPU/elapsed values for that statement/program/plan ...
The number of getpages would halve only if you had (a bit over) 50% of getpages issued against the tablespace before the index only access was introduced.
Regards, Nenad

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]53_7810430030111129.WA.nenad.vidakgmail.com@www.idug.org 14076 33 26_Summarizing DB2 messages ?11_Nenad Vidak21_nenad.vidak@GMAIL.COM31_Fri, 12 Mar 2010 11:39:05 +0000546_UTF-8 Hello,
I'm looking for a way do display syslog messages from different DB2 members of the same data sharing group in a single view/panel. Something like OPERLOG but only for DB2 messages.

From time to time we encounter a situation where requests against different DB2 members start to fail due to timeout/deadlocks. In such situation it is difficult to find a point where the problem started among all other messages on the operlog. SQLCA also doesn't provide much help since it doesn't identify the holder for the resource. [...]53_1829976014477149.WA.nenad.vidakgmail.com@www.idug.org 14110 58 38_AW: [DB2-L] Summarizing DB2 messages ?12_PUSCH Othmar27_Othmar.Pusch@IT-AUSTRIA.COM31_Fri, 12 Mar 2010 13:54:57 +0100648_utf-8 Hi dear Nenad !

Maybe a tricky for ya: I use (relatively new) sdsf-interface /* it exists up from z/OS-1.9 */ -->

/* Rexx */ ;
Local House-Keeping for REXX_IN ff ;
rc=isfcalls('ON') ;
address SDSF "ISFEXEC 'mvs/jes2/jes3-commands' ";
/* E.g.: address SDSF "ISFEXEC '/ DISPLAY WLM,APPLENV="db2_wlm_env_only_sample" ' "; .... */
/* Of course ya need rights in TSS, or ACF/2 or RACF to run the submitted commands successfully */ ;
/* Stem isfulog has now all ya need */ ;
/* Do your work with isfulog.1 until isfulog.isfulog.0 */ ;
rc=isfcalls('OFF') ;
Local House-Keeping for REXX_OUT ff ;
Exit [...]63_81BB61A7ECD28B40BC5E4701B9998608943C3492AE@A2XMXS1V1.A2X.LAN.AT 14169 28 20_Update Catalog Stats4_Anil21_alisha_kale@YAHOO.COM31_Fri, 12 Mar 2010 16:36:42 +0000608_UTF-8 Hi All !

Does anyone have the SQL statements to update the DB2 (DB2 V8 on z/os) catalog statistics ? I would appreciate if you could share it with me.

Thanks.

Anil

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]52_4322424780447952.WA.alishakaleyahoo.com@www.idug.org 14198 32 24_Re: Update Catalog Stats4_Anil21_alisha_kale@YAHOO.COM31_Fri, 12 Mar 2010 16:45:43 +0000517_UTF-8 I forgot to mention this in my previous note:

I see that DB2 program choosing is one access path in a region and a different path in some other region. I tried the standard stuff (reorg, runstats, etc). But I am unable to influence the choice of the index to the one that is better. I figured I might copy all the catalog stats from the place where it work and update the catalog stats in the target region (the place where its bad access path). What's the most effective way to migrate the stats ? [...]52_8309144404648789.WA.alishakaleyahoo.com@www.idug.org 14231 52 24_Re: Update Catalog Stats13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Fri, 12 Mar 2010 11:01:27 -0600668_UTF-8 Have you tried the section in the DB2 Performance Monitoring and Tuning
Guide (SC18-9851) titled "Updating catalog statistics"?

Willie

Anil wrote:
> Hi All !
>
> Does anyone have the SQL statements to update the DB2 (DB2 V8 on z/os) catalog statistics ? I would appreciate if you could share it with me.
>
> Thanks.
>
> Anil
>
> _____________________________________________________________________
>
> * IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2 information. *
> ** The most DB2 technical sessions of [...]30_4B9A7367.1040402@attglobal.net 14284 52 24_Re: Update Catalog Stats13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Fri, 12 Mar 2010 11:03:00 -0600638_UTF-8 Oops... I just noticed you are still on DB2 V8... the same stuff can be
found in the DB2 V8 Administration Guide, same section heading.

Willie

Anil wrote:
> Hi All !
>
> Does anyone have the SQL statements to update the DB2 (DB2 V8 on z/os) catalog statistics ? I would appreciate if you could share it with me.
>
> Thanks.
>
> Anil
>
> _____________________________________________________________________
>
> * IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2 information. *
> [...]30_4B9A73C4.3030404@attglobal.net 14337 54 24_Re: Update Catalog Stats13_Campbell, Jim26_Jim.Campbell@COURTS.WA.GOV31_Fri, 12 Mar 2010 09:03:50 -0800615_utf-8 Or you could look it up here http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/

Jim Campbell
Sr. Database Administrator
360-704-4015 (voice plus voice-mail)
360-586-8869 (fax)
Jim.Campbell@courts.wa.gov

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero
Sent: Friday, March 12, 2010 9:01 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Update Catalog Stats

Have you tried the section in the DB2 Performance Monitoring and Tuning
Guide (SC18-9851) titled "Updating catalog statistics"? [...]66_2A1B28C5CC983C4F8253CF1FA121853214C2C413B2@EXCHMAIL1.courts.wa.gov 14392 77 10_-805 erorr9_Arun shan20_arunshan04@GMAIL.COM31_Fri, 12 Mar 2010 22:24:27 +0530526_ISO-8859-1 Hi Users,
i am using cobol-db2 program i am getting -805 error.
the code is,
*

main program:
exec cics syncpoint end-exec
** exec sql dummy query end-exec**
** exec cics link program(sub) end-exec
exec sql call stored procedure end-exec

**at the time of calling the stored procedure i am getting -805(
location.collid.main.contoken is not found in plan sub).

if i remove the syncpoint** or if i placed one dummy query(marked in red)
the program is working fine. [...]59_29d583c11003120854i6031acc6ka00f0c3368533b10@mail.gmail.com 14470 31 33_Values used in triggers DB29 z/OS17_Darren Kilpatrick31_darren.kilpatrick@WELLPOINT.COM31_Fri, 12 Mar 2010 17:37:43 +0000570_UTF-8 Does anyone have experience using triggers and getting values such as the updating program or transaction name? I would like to put a before update or delete trigger on a table, and the previous version of the row put into an audit table. The audit table has the same columns as the base table with the addition of 4 or 5 columns. I can get the current timestamp, user, and i can hard the type of change (delete or update), but i cannot get the updating/deleting program or transaction name. The special registers for these, like current wrkstname, cannot be [...]63_7449248237222314.WA.darren.kilpatrickwellpoint.com@www.idug.org 14502 190 37_Re: Values used in triggers DB29 z/OS0_20_Mark.Doyle@WPSIC.COM31_Fri, 12 Mar 2010 12:52:53 -0600537_US-ASCII I'm assuming you are inserting into the audit table from the base table.
The basic template of the trigger will look something like this:

CREATE TRIGGER ZPLQ020D AFTER DELETE ON XXXX.PLQ_XXXX_XXX_XXX
REFERENCING OLD AS OROW FOR EACH ROW
MODE DB2SQL INSERT INTO XXXXA.XXX_XXXX_XXX_XXX VALUES (
OROW.U_ADDL_INT_TYP, NULL
,CURRENT SQLID, CURRENT TIMESTAMP );

Notice the CURRENT SQLID on the last line. You don't need to SET the
value, you just need to use it in the insert part of the trigger. [...]67_OFA994D0CC.96312DC4-ON862576E4.006594E7-862576E4.0067B81A@wpsic.com 14693 25 104_Re: Many New Index Options in DB2 =?UTF-8?Q?=E2=80=93_Version_9_Performance_Features_=E2=80=93_?=Part 1917_Darren Kilpatrick31_darren.kilpatrick@WELLPOINT.COM31_Fri, 12 Mar 2010 21:28:01 +0000555_UTF-8 Are there any recommendations for using the 8K, 16K, 32K index page sizes? Should the tablespace page size and segsize also change?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]63_0917260201211136.WA.darren.kilpatrickwellpoint.com@www.idug.org 14719 65 43_[MVS] Measuring DB2 IBM utility performance9_DB2DBAzOS21_bala.db2dba@GMAIL.COM31_Sat, 13 Mar 2010 11:59:35 +0530424_ISO-8859-1 Dear List,

The environment is DB2 v8 for z/OS 1.7.

After moving to version 8, I changed our scheduled reorgs to enable parallel
index build since SORTKEYS become the default. In particular, we've got few
partitioned tables with a long list of relations and as much as 6 NPIs. I
tried to compare the utility performance in DB2 v8 before and after enabling
the parallel index builds. [...]59_35e6ff9a1003122229h6312df04rc628e32e55c6c827@mail.gmail.com 14785 94 24_Re: Update Catalog Stats10_Dave Nance16_dav1mo@YAHOO.COM31_Sat, 13 Mar 2010 02:54:09 -0800620_iso-8859-1    Is this target region a test or production environment? If test, then by all means copy the production statistics into it. Aside from the poitners to the manual that you've been given there are even tools that will do it for you.    If, however, this is a production region, then I would suggest you take a look at OPTHINTs rather than modeling the stats.   David Nance   ________________________________ From: Anil To: DB2-L@IDUGDB2-L.ORG Sent: Fri, March 12, 2010 11:45:43 AM Subject: Re: [DB2-L] Update Catalog Stats I forgot to mention this in my previous note: I see that [...]43_193847.50381.qm@web57801.mail.re3.yahoo.com 14880 92 92_FYI - Consolidation of IDUG groups on LinkedIn - IDUG Europe 2009 group closing on March 16.10_Max Scarpa16_mscarpa@CESVE.IT31_Sat, 13 Mar 2010 13:21:49 +0100394_US-ASCII Esteemed listers

Some weeks ago IDUG started groups consolidation in LinkedIn with a main
group "IDUG: The World Wide DB2 User Community ". Beneath this, there
are now various subgroups and one, namely "IDUG Europe Conference ", will
replace the old group IDUG Europe 2009 and all informations about IDUG
European events will be posted in this brand new group. [...]66_OF293CC51F.DCCEE163-ONC12576E5.004382FC-C12576E5.0043919B@cesve.it 14973 24 24_Re: Update Catalog Stats15_Sharad D. Pawar17_sdpawar@GMAIL.COM31_Sat, 13 Mar 2010 14:17:39 +0000517_UTF-8 Anil,
db2look will be helpful in the migrating the stats.

-- Sharad D. Pawar.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________ [...]49_0090322615304764.WA.sdpawargmail.com@www.idug.org 14998 55 63_AW: [DB2-L] IDUG 2010 Europe - 8-12 November in Vienna, Austria12_Peter, Georg15_G.Peter@DZBW.DE31_Sat, 13 Mar 2010 15:48:13 +0100569_iso-8859-1 Jörg, these cities are NOT the best ones in Europe.....

With kind regards - mit freundlichen Gruessen,
Georg
----------------------------------------------------------------------
In nature, nothing is ever right. Therefore, if everything is going right ... something is wrong.

-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Jorg Lueke
Gesendet: Freitag, 5. März 2010 16:52
An: DB2-L@IDUGDB2-L.ORG
Betreff: Re: [DB2-L] IDUG 2010 Europe - 8-12 November in Vienna, Austria [...]58_99E58D5AC1BE6D4CBF492AF72B942C3D061ADB6B@dzstus010.dzbw.de 15054 79 34_Re: GetPages and SELECT statements15_Coleman, Troy L19_Troy.Coleman@CA.COM31_Sat, 13 Mar 2010 15:10:24 -0500508_utf-8 How do you look at getpages today? Using your favorite performance monitoring tool you can focus in on your SPUFI session.
When using isolation CS the plan is DSNESPCS. Below for example I see that I have 168 getpages.
Now when I prototyping SQL I usually run the statement 3 times and take an average.
The first time usually takes a hit pulling the data into the bufferpool.
I recommend test, test, test with any physical changes like partition and indexes as well as any SQL change. [...]56_F9576E62032243419E097FED5F0E75F308359A99@USILMS12.ca.com 15134 75 74_AUTO: Mike Dupuis/Ontario/IBM is out of the office. (returning 03/22/2010)11_Mike Dupuis18_mdupuis@CA.IBM.COM31_Sat, 13 Mar 2010 22:04:32 -0500400_US-ASCII I am out of the office until 03/22/2010.

I will respond to your message when I return. If this is an urgent matter
please call the Heldesk and ask that an IGS DB2 support person be paged.
For less urgent matters pls email SLCDB2.

Note: This is an automated response to your message "DB2-L Digest - 13 Mar
2010 to 14 Mar 2010 (#2010-72)" sent on 3/13/10 20:00:01. [...]68_OF61155079.01AE02E2-ON852576E6.0010E538-852576E6.0010E538@ca.ibm.com