1 IDUGDB2-L.ORG /home/listserv/home/db2-l May 2010, week 3 2 150 59_Re: Determining the RUNLIB LOAD library for a bound program0_17_jtonchick@AOL.COM31_Sat, 15 May 2010 01:51:45 -0400663_us-ascii Yes, use the conectifity token from the DBRMs in the catalog and search the possible Runlibs for a match.

Jim Tonchick

-----Original Message-----
From: Mark Kerner
To: DB2-L@IDUGDB2-L.ORG
Sent: Fri, May 14, 2010 2:53 pm
Subject: [DB2-L] Determining the RUNLIB LOAD library for a bound program

We were getting -818's after we erroneously bound DSNTIAUL over an existing
UNLIB that was being shared by a second DB2 subsystem. We wound up rebinding
he current version of DSNTIAUL from DSNTEJ2A. This led me to think that I might
ave been able to use a previous version of plan DSNTIB*1 if [...]52_8CCC209D5BCAA0D-758-3EBE@webmail-d076.sysops.aol.com 153 1411 20_Re: db2 ver.9.1, zos37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Sat, 15 May 2010 09:10:02 +0200578_iso-8859-2 Thank you very much for your suggestions
dusan

________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Rao, Diwakar
Sent: Friday, May 14, 2010 6:40 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] db2 ver.9.1, zos

If "clustering on this TS has little meaning "

Try using the APPEND option on the table, DB2 will ignore the clustering and eliminate the search to insert on a preferred page, there by reducing number of lock/unlock requests, and rows are appended to the end of the table. [...]58_0675446363E09A4EBE4CCF8D3AD7814F05D8493D@MAIL1.cen.csin.cz 1565 1442 32_Re: FW: [DB2-L] db2 ver.9.1, zos11_Mike Turner19_mike.turner@GMX.COM31_Sat, 15 May 2010 16:20:23 +0100439_iso-8859-2 [DB2-L] db2 ver.9.1, zosHi Dusan

As you say, the locks are marked XES PROP=Y and XES ASYN=N, which shows that the locks are propagated synchronously to the CF LOCK1 structure. The main CPU will wait for a response from the CF for each request. I am not sure whether these waits would show in the Accounting Trace as Class 3 Lock Wait or as Non-Accounted time, but it is possible that it could show as Non-Accounted. [...]44_6DBA5FE626BE46D5868D7367975551E4@ToshibaA300 3008 48 68_Re: DB2 for z/OS V8 - problems running test UDF calling Java program14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 16 May 2010 18:24:40 +1000330_US-ASCII My reading is that it is a usable value that needs to be provided if running
the type 2 or type 4 driver. Which is slightly different from saying that the
parameter does not need to be supplied. Try adding
JCC_HOME=.
and see what happens. Of course this won't work if you actually try to
execute SQL. [...]49_4BF03868.17116.671328DA@jacampbell.acslink.net.au 3057 130 36_Re: rules of engagement for UDF Z/os14_Peter Schwarcz23_schwarcz@BIGPOND.NET.AU31_Sun, 16 May 2010 06:48:40 -0400781_UTF-8 The following code should do what you are looking for. I have done some testing, but as always please test that it works in your environment and gives you the answers that you expect.

Regards
Peter Schwarcz

DROP FUNCTION DEC2DATE ;

DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0

CREATE FUNCTION DEC2DATE
( DATEDEC DECIMAL(8, 0) )
RETURNS DATE
SPECIFIC DEC2DATE
LANGUAGE SQL
NOT DETERMINISTIC
CALLED ON NULL INPUT
CONTAINS SQL
NO EXTERNAL ACTION
RETURN
CASE
WHEN SUBSTR(DIGITS(DATEDEC),1,4) BETWEEN '0001' AND '9999'
THEN SUBSTR(DIGITS(DATEDEC),1,4)
ELSE NULL
END
|| '-' ||
CASE
WHEN SUBSTR(DIGITS(DATEDEC),5,2) BETWEEN '01' AND '12'
THEN SUBSTR(DIGITS(DATEDEC),5,2)
ELSE [...]55_9229792981196196.WA.schwarczbigpond.net.au@www.idug.org 3188 63 28_Re: List of views on aliases13_Steve Runtsch26_steve.runtsch@ASSURANT.COM31_Sun, 16 May 2010 07:57:37 -05000_70_OFA84A066D.7AA1E1A5-ON86257725.0046D2ED-86257725.00472297@assurant.com 3252 82 59_Re: Determining the RUNLIB LOAD library for a bound program11_Enrico Haak21_eh@INSOFT-SOFTWARE.DE31_Mon, 17 May 2010 10:07:59 +0200707_UTF-8 Good morning Mark,

have a look at our product site.

Maybe you are interested in our PackMan product.
http://www.insoft-software.de/index.php?lang=en&cont=3&PHPSESSID=p2sp84e4tlm0ujqq89fva8v2m0

In short: we will check Loadlibs vs. DBRMLIBs vs. Catalog and vice versa.

Regards

Enrico

Am 14.05.2010 21:53, schrieb Mark Kerner:
> We were getting -818's after we erroneously bound DSNTIAUL over an existing RUNLIB that was being shared by a second DB2 subsystem. We wound up rebinding the current version of DSNTIAUL from DSNTEJ2A. This led me to think that I might have been able to use a previous version of plan DSNTIB*1 if I knew what RUNLIB it was [...]35_4BF0F95F.7000909@insoft-software.de 3335 62 23_DB2 V8 z/OS SPT01 Reorg15_Eugene R Renico28_eugene.r.renico@JPMCHASE.COM31_Mon, 17 May 2010 09:16:32 -0400352_us-ascii Hello List,

I am putting together reorgs of the DB2 for z/OS V8 catalog and directory to prepare for release migration. This is a 6-way test DB2 system and I have been given permission for an outage so I will have a window all to myself. We ran the reorgs on our sandbox systems but the situation I am running into didn't come up. [...]75_BAA9B699DFB94E4BACCDFAEB9D18E16236FB7B9853@EMARC124VS01.exchad.jpmchase.net 3398 88 22_Re: IDUG Radio Silence16_Robert Catterall21_rfcatterall@GMAIL.COM31_Mon, 17 May 2010 09:41:07 -0400659_ISO-8859-1 OK, I put something out there (
http://catterallconsulting.blogspot.com/2010/05/nuggets-from-db2-by-bay-part-1.html).
More to come in days ahead. Thanks for the prod, Ed.

Robert

On Thu, May 13, 2010 at 6:52 PM, Ed Long wrote:

> So About IDUG?
>
>
> Edward Long
> ------------------------------
>
> [image: IDUG Mentors - A rewarding experience for everyone!]
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
> not already an IDUG member, please register here.
>60_AANLkTimsvxAvBXGYm8i9baYfIgoYkPCdHGa1nKTGtTKD@mail.gmail.com 3487 37 27_Re: DB2 V8 z/OS SPT01 Reorg11_Martin Maes22_martin.maes@HELSANA.CH31_Mon, 17 May 2010 12:29:50 -0400533_UTF-8 Hi Gene,

I don't know whether DB2 automatically allocates the necessary VSAM files if you only allocate 1 shadow dataset.
We had that same situation before and the problem is that you can't tell how many VSAM files are actually needed after the reorg.

The solution was that we allocated exactly the same number of shadow datasets as there a datasets in use, did the reorg and then deleted the unneeded VSAM datasets (you can see which ones are unneeded doing a listcat of the datasets, and hi-used is 0). [...]54_2749334432119710.WA.martin.maeshelsana.ch@www.idug.org 3525 38 22_Re: IDUG Radio Silence12_Martin Hubel17_Martin@MHUBEL.COM31_Mon, 17 May 2010 17:50:00 -04000_43_DB2-L%201005171750103031.0962@IDUGDB2-L.ORG 3564 118 22_Re: IDUG Radio Silence7_Ed Long19_rdhm99a@PRODIGY.NET31_Mon, 17 May 2010 15:31:10 -0700358_us-ascii The radio silence, with the exception of a single blog, has continued well past the end of the conference. Perhaps the hangovers have not yet abated.

An alternative, or complementary, explanation to the busy signal might be that there were no material announcements or big changes.

Most of the V10 stuff has been out for a while. [...]42_53415.89036.qm@web80208.mail.mud.yahoo.com 3683 123 22_Re: IDUG Radio Silence12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 17 May 2010 17:57:57 -0700480_us-ascii What is anyone looking for? Lots of presentations on V10 and other things. Nothing new other than more details about V10?

________________________________
From: Ed Long
To: DB2-L@IDUGDB2-L.ORG
Sent: Mon, May 17, 2010 6:31:10 PM
Subject: Re: [DB2-L] IDUG Radio Silence

The radio silence, with the exception of a single blog, has continued well past the end of the conference. Perhaps the hangovers have not yet abated. [...]44_302508.13900.qm@web112108.mail.gq1.yahoo.com 3807 63 25_Use of BOOLEAN in UDB 9.714_Peter Schwarcz23_schwarcz@BIGPOND.NET.AU31_Tue, 18 May 2010 01:36:53 -0400349_UTF-8 Hello list,

I am tryoing to get a handle on converting an ORACLE SQL function that users a BOOLEAN data type. DB2 9.7 introduced the BOOLEAN and there are examples in the documentation.

My question are:

Has anyone successfully used a BOOLEAN data type?

Can anyone see and tell me why the function below fails? [...]55_6199838566388339.WA.schwarczbigpond.net.au@www.idug.org 3871 105 27_SV: DB2 V8 z/OS SPT01 Reorg13_Olle Brostrom25_olle.brostrom@SWEDBANK.SE31_Tue, 18 May 2010 07:40:13 +0200363_iso-8859-1 Hello Gene,
Since the DB2 catalog & Directory is user managed you need to supply all VSAM datasets that the reorg will need.
Create same number of "J" datasets as you have "I" datasets today. After REORG SHRLEVEL REFERENCE/CHANGE you can delete the "J" datasets since DB2 did the rename of the old "I" datasets into "J" in the switch phase. [...]70_B0000573F0F67C438DC58043C06F4CAB49D3A99849@FSPAS01EV011.fspa.myntet.se 3977 31 44_AUTO: Angelo Corridori is out of the office.16_Angelo Corridori27_Angelo.Corridori@MARIST.EDU31_Tue, 18 May 2010 04:00:44 -0400396_US-ASCII I am out of the office until 05/24/2010.

I am out of the office. I will respond to your message when I return;
limited access to e-mail/phonemail. Please send an e-mail if you need to
get in touch with me.

Note: This is an automated response to your message "[SUSPECTED SPAM]
DB2-L Digest - 17 May 2010 to 18 May 2010 (#2010-139)" sent on 5/18/10
1:00:00. [...]68_OFD65D4488.1B84B900-ON85257727.002C0357-85257727.002C0358@marist.edu 4009 377 22_Re: IDUG Radio Silence13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Tue, 18 May 2010 06:59:54 -0400598_us-ascii Or perhaps some of us have only just arrived home!

Stupid *!*!*!* volcano :(
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 Ed Long
Sent: 17 May 2010 23:31
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] IDUG Radio Silence [...]60_4440F5DA00E3F3459BBCB97431B91B6612B61387A9@MAILR004.mail.lan 4387 327 22_Re: IDUG Radio Silence10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 18 May 2010 13:31:49 +0200505_US-ASCII Hi Ed

Did you see this brief report ?

http://www.idug.org/planet-db2/idug-tampa-2010-day-one.html

From what I heard many people was very interested in DB2 10 even if I saw
in the program 5 presentations about this topic. I think the sentence '
Most of the V10 stuff has been out for a while' is true for *now* but at
IDUG EU we'll have at least twice (if not more) the number of
presentations we saw in NA IDUG (including a somewhat 'user'
presentation). [...]66_OFC5AD18FF.03EF62CE-ONC1257727.002742B2-C1257727.003F53F7@cesve.it 4715 486 22_Re: IDUG Radio Silence10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 18 May 2010 08:38:00 -0400394_us-ascii Visit our website at http://www.ubs.com

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system. [...]62_1A700EEF49343148A08879B1E3CA5BA614E581A8@NSTMC101PEX1.ubsw.net 5202 277 27_Re: DB2 V8 z/OS SPT01 Reorg28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Tue, 18 May 2010 18:21:11 +0530380_US-ASCII Hi Gene,

As far as I know, in DB2 Version 8, you will have to create all the
necessary shadow datasets for the user managed tablespaces (even for the
Catalog or Directory TS). Suppose you get to find that the last
piece/dataset is nearing brim, you may also have to allocate the 'n+1'
dataset anticipating that the data might spill into the next. [...]68_OFF1CA7570.62CBCA4B-ON65257727.004641B3-65257727.004657BC@in.ibm.com 5480 411 22_Re: IDUG Radio Silence10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 18 May 2010 14:51:54 +0200784_US-ASCII Never quarrel with someone bigger (by far) than you........

Max Scarpa

Certified 'Trust geologists' club Platinum member

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

Roger Hecq
Sent by: IDUG DB2-L
18/05/2010 14.39
Please respond to
IDUG DB2-L

To
DB2-L@IDUGDB2-L.ORG
cc

Subject
Re: [DB2-L] IDUG Radio Silence

Remind me never to travel with your or Aurora. You both seem to attract
the plume! [...]66_OF9A965CCF.9F186AE3-ONC1257727.00459FDF-C1257727.0046A91B@cesve.it 5892 229 35_[AD] DB2 for LUW DBA Need in Boston7_Kim May28_kim.may@THEFILLMOREGROUP.COM31_Tue, 18 May 2010 09:37:04 -0400425_us-ascii The Fillmore Group is looking for DB2 for LUW DBA contractors to staff an
engagement in the Boston area. I need local candidates only (sorry!) with
experience with DB2 on LUW. Experience with Performance Expert and/or
Workload Manager a plus. If you are interested please email your resume to
me off-list at kim.may@thefillmoregroup.com and include your hourly rate
requirement and availability. [...]45_4bf2980c.9753f10a.3774.ffffc047@mx.google.com 6122 621 22_Re: IDUG Radio Silence10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 18 May 2010 10:33:50 -0400394_us-ascii Visit our website at http://www.ubs.com

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system. [...]62_1A700EEF49343148A08879B1E3CA5BA614E58261@NSTMC101PEX1.ubsw.net 6744 215 22_Re: IDUG Radio Silence7_Ed Long19_rdhm99a@PRODIGY.NET31_Tue, 18 May 2010 08:01:08 -0700534_iso-8859-1 Who won the various best speaker awards?
Which OEM had the best V10 readiness story?
How was the food?
So about V10, so what?

Edward Long

--- On Mon, 5/17/10, Myron Miller wrote:

From: Myron Miller
Subject: Re: [DB2-L] IDUG Radio Silence
To: DB2-L@IDUGDB2-L.ORG
Date: Monday, May 17, 2010, 8:57 PM

What is anyone looking for?  Lots of presentations on V10 and other things.  Nothing new other than more details about V10? [...]43_441552.57483.qm@web80207.mail.mud.yahoo.com 6960 764 22_Re: IDUG Radio Silence16_Daniel Luksetich18_danl@DB2EXPERT.COM31_Tue, 18 May 2010 10:20:41 -0500334_us-ascii I thought it was the best IDUG in several years. Good quality presentations
and great networking. A real heads down group this year with many first time
attendees.

Speed-SIG is a great idea. Lots of good v9 migration information for z. Lots
of v10 stuff, but a lot was redundant. Even IBM admitted that. [...]35_01fb01caf69d$ae3ad4f0$0ab07ed0$@com 7725 886 22_Re: IDUG Radio Silence13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Tue, 18 May 2010 12:53:39 -0400336_us-ascii Actually, Dan reminds me of something I need to have a small rant about

ALL of the Dine Arounds were oversubscribed, which meant quite a few people did not get to go to their chosen dining event

THEN, we found that a number of people (in mine and Judy Ruby-Browns case around 4 or 5 people) did not show up. [...]60_4440F5DA00E3F3459BBCB97431B91B6612B61387C9@MAILR004.mail.lan 8612 48 19_Question on LISTCAT13_Sekhar Mekala23_SEKHAR.MEKALA@GMAIL.COM31_Tue, 18 May 2010 15:46:56 -0400474_UTF-8 Hi all,
Is there any accurate method to find whether the PRIQTY of a Table Space / Index Space is 90% full without running RUNSTATS or making use of DB2 Catalog tables? I am using the following method, but I am not sure whether my method is correct or not.

Step1: From the LISTCAT ALL output, I am getting the PRIQTY as follows:
If SPACE-TYPE = TRACK Then
Multiply SPACE-PRI with 48
If SPACE-TYPE = CYLINDER Then
Multiply SPACE-PRI with 720 [...]55_8331891892792466.WA.SEKHAR.MEKALAGMAIL.COM@www.idug.org 8661 271 22_Re: IDUG Radio Silence10_Mark Labby21_mlabby@AESSUCCESS.ORG31_Tue, 18 May 2010 18:20:07 -04000_67_OF8368052E.394EB07F-ON85257727.007663C2-85257727.007AB029@pheaa.org 8933 348 29_Re: Use of BOOLEAN in UDB 9.716_Gregory Palgrave28_gpalgrave@STAFF.IINET.NET.AU31_Wed, 19 May 2010 09:19:56 +0800413_utf-8 Hi Peter,

It appears to be the way you are trying to use the BOOLEAN data type. I just had a quick play around with it:

CREATE FUNCTION fb1(p1 BOOLEAN, p2 INT) RETURNS BOOLEAN BEGIN
IF p1 = TRUE AND p2=1 THEN
RETURN p1;
ELSE
RETURN FALSE;
END IF;
END;
completed successfully.

SELECT * from sysibm.sysdummy1 where fb1(TRUE,1) = TRUE;
completed successfully. [...]73_8522673947DF7D4394C962BFE441CD27050925E67B@PER-EXCHMBX.win2k.iinet.net.au 9282 90 35_IDUG Better than Ever with Hot News11_Dave Beulke19_dave@DAVEBEULKE.COM31_Tue, 18 May 2010 22:06:35 -0400834_UTF-8 I have a new post on my DB2 Blog....

IDUG Better than Ever with Hot News

The 2010 North American IDUG Conference was last week and all the great volunteers and speakers helped the IDUG community produce a great learning and networking experience. The user’s point of view from the speakers, tool vendors and many IBMers provided great information on DB2 10, latest performance techniques and strategies for getting the most out your DB2 LUW and z/OS environments along with the latest innovations.

Users and IBMers alike gave great detailed information on the DB2 technology landscape. One of the exciting things within the Data Warehousing realm was the new IBM Smart Analytical Optimizer (ISAO).

To read the entire article, please visit my blog at www.davebeulke.com

Thank you!

Dave51_8428733705260413.WA.davedavebeulke.com@www.idug.org 9373 403 27_Re: DB2 V8 z/OS SPT01 Reorg0_17_jtonchick@AOL.COM31_Wed, 19 May 2010 00:30:52 -0400501_us-ascii There is another alternative... You could consolidate all the datasets before you perform the REORG. You have to clean up all those multiple datasets any way, so why not now?

Since you have time for the outage, you could take and image copy of SPT01 then immediately shutdown the subsystem. Use the output of the COPY to calculate the size of the new consolidated dataset. Then using DSN1COPY, taken the image copy dataset and copy it back into the newly allocated SPT01 dataset. [...]53_8CCC52332EDA6C0-1464-60D6@webmail-d013.sysops.aol.com 9777 207 23_Re: Question on LISTCAT0_17_jtonchick@AOL.COM31_Wed, 19 May 2010 00:41:30 -0400395_us-ascii You can use the high used RBA / high allocated RBA from LISTCAT to get a percentage of allocated use. Unfortunately, this only shows space used vs. allocated. It says nothing about any possible fragmentation within the used space. But you also need to remember that LISTCAT statistics are not updated in a timely manner. Data statistics may have changed while the dataset is open. [...]53_8CCC524AFA4FE94-1464-619C@webmail-d013.sysops.aol.com 9985 916 27_Re: DB2 V8 z/OS SPT01 Reorg12_Kirk Hampton37_kirk.hampton@ENERGYFUTUREHOLDINGS.COM31_Wed, 19 May 2010 10:49:37 -0500560_iso-8859-1 Jim,

Aren't you thinking of consolidating *extents*, not multiple datasets. I believe there would only be multiple datasets for SPT01 if each one had hit the 4GB vsam limit...

J Kirk Hampton

Sr. Specialist - Mainframe

HCL Technologies America

Mesquite Data Center

972-216-3119

________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of jtonchick@AOL.COM
Sent: Tuesday, May 18, 2010 11:31 PM
To: Hampton, Kirk
Subject: Re: DB2 V8 z/OS SPT01 Reorg [...]71_31F1BA84DF370A4C825F6E64D59DAF5404112343@MDCTXUEXCL01N4.corptxu.txu.com 10902 38 23_Re: Question on LISTCAT13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Wed, 19 May 2010 12:46:38 -0400386_UTF-8 I would caution against using LISTCAT as the sole determing factor for a REORG. LISTCAT does not provide DB2 level info, which identify tables which need to be REORG'd for other reasons than just space reclaimation, for example:

1) Relocated rows within the table

2) Poor clustering of the data

3) Poor index organization (keys not in physical sequence) [...]55_7949674033814364.WA.jackrcampbellyahoo.com@www.idug.org 10941 130 39_ADMIN: reminder from the administrators16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Wed, 19 May 2010 13:00:12 -0400511_utf-8 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@www.idugdb2-l.org [...]70_551C24F0D5EA4E47BA9B76E14D016DD508A2397B@nasa-dtw-ex005.nasa.cpwr.corp 11072 40 39_Re: IDUG Better than Ever with Hot News10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 19 May 2010 16:27:49 -0400496_UTF-8 Hi David

....dedicated servers for ISAO....

So do we have to wait for new z11 machine for using it ? Rumors say z11 (forecasted for second half of 2010, maybe October) will have "special purpose analytic optimizers" running on Power or x64 dedicated blade servers inside z11, so it seems ISAO could use these 'special servers' ('special engines' evolution ?). It sounds interesting and with a lot of possibilities, but this means a machine change to use DB2 10 and ISAO. [...]48_8018871279261768.WA.mscarpacesve.it@www.idug.org 11113 64 39_Re: IDUG Better than Ever with Hot News13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 19 May 2010 16:46:17 -0500623_UTF-8 A z10, DB2 9, z/OS 1.9, Data Studio (the no charge download), plus
service are the proposed prerequisite for Smart Analytics Optimizer.

Please keep in mind this is still an announced product and any
presentation you see is just a technical preview.

Willie

On 5/19/2010 3:27 PM, Max Scarpa wrote:
> Hi David
>
> ....dedicated servers for ISAO....
>
> So do we have to wait for new z11 machine for using it ? Rumors say z11 (forecasted for second half of 2010, maybe October) will have "special purpose analytic optimizers" running on Power or x64 dedicated blade servers [...]28_4BF45C29.60206@attglobal.net 11178 817 27_Re: DB2 V8 z/OS SPT01 Reorg0_17_jtonchick@AOL.COM31_Thu, 20 May 2010 00:01:25 -0400354_utf-8 In the past, I've inherited subsystems with multiple small SPT01 datasets that collectively were under the 2GB limit but that each had reached their individual limit of extents. My predecessor just allocated another dataset to forestall the immediate problem and never went back to consolidate the multiple small datasets.

Jim Tonchick [...]52_8CCC5E8400512FF-7D0-BF7C@webmail-m076.sysops.aol.com 11996 624 35_SV: [DB2-L] DB2 V8 z/OS SPT01 Reorg13_Olle Brostrom25_olle.brostrom@SWEDBANK.SE31_Thu, 20 May 2010 07:13:05 +0200439_utf-8 There are no way to consolidate “small” datasets for SPT01 into larger ones. SPT01 can consist of up to 32 datasets where each one can be 2GB.
This is why IBM introduced APAR PK52523 (DB2 9) to enable compression on SPT01.

Olle

Från: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] För jtonchick@AOL.COM
Skickat: den 20 maj 2010 06:01
Till: DB2-L@IDUGDB2-L.ORG
Ă„mne: Re: [DB2-L] DB2 V8 z/OS SPT01 Reorg [...]70_B0000573F0F67C438DC58043C06F4CAB49D3A9985B@FSPAS01EV011.fspa.myntet.se 12621 836 27_Re: DB2 V8 z/OS SPT01 Reorg0_17_jtonchick@AOL.COM31_Thu, 20 May 2010 00:01:25 -0400354_utf-8 In the past, I've inherited subsystems with multiple small SPT01 datasets that collectively were under the 2GB limit but that each had reached their individual limit of extents. My predecessor just allocated another dataset to forestall the immediate problem and never went back to consolidate the multiple small datasets.

Jim Tonchick [...]52_8CCC5E8400512FF-7D0-BF7C@webmail-m076.sysops.aol.com 13458 74 39_Re: IDUG Better than Ever with Hot News13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Thu, 20 May 2010 04:01:00 -0400571_utf-8 I think Willie means " still an UN-announced product "

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

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero
Sent: 19 May 2010 22:46
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] IDUG Better than Ever with Hot News [...]60_4440F5DA00E3F3459BBCB97431B91B6612B6138846@MAILR004.mail.lan 13533 55 39_Re: IDUG Better than Ever with Hot News10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 20 May 2010 05:30:03 -0400540_UTF-8 Hi Willie and Phil

Thank you for your replies.

I was doing some considerations about ISAO after I read Dave's blog, the excellent Robert Catterall's blog (where he says that ISAO is a query-acceleration system which is connected to the mainframe where DB2 runs via network. So it's a different piece of hw you must have, outside for now (blade servers) maybe inside mainframe in the future (z11 ?), something vaguely remembering 'parallel computing') and some notes about new z11 machine, which sounds interesting. [...]48_7462465634126476.WA.mscarpacesve.it@www.idug.org 13589 33 23_Re: Question on LISTCAT13_Sekhar Mekala23_SEKHAR.MEKALA@GMAIL.COM31_Thu, 20 May 2010 07:50:23 -0400796_UTF-8 Thanks for your prompt responses!!

Question: Is there any way to determine the CLUSTERRATIO, LEAFNEAR, LEAFFAR etc without running RUNSTATS. In other words, how DB2 or CA Tools or BMC Tools determine these factors and help us to determine whether the REORG is required?

Thanks in advance!!

Regards,
Sekhar

_____________________________________________________________________

* 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 [...]55_5775276458847357.WA.SEKHAR.MEKALAGMAIL.COM@www.idug.org 13623 186 39_Re: IDUG Better than Ever with Hot News11_Dirk Johann20_dirkjohann@GMAIL.COM31_Thu, 20 May 2010 14:22:49 +0200365_ISO-8859-1 Max,,

you should not focus too much on the separate HW, which is for the current
plan blade server technology - but might change in the future.

The main idea is DB2 z/OS is under control of the data and queries are using
the same interface as before, but might be routed by the DB2 Optimizer to
the Smart Analytics Optimizer. [...]60_AANLkTimO6kqdkNwLcOsDc1xnskgHLiPenQSCSyfT4yNj@mail.gmail.com 13810 45 23_Re: Question on LISTCAT10_Todd Burch17_toddburch@MAC.COM31_Thu, 20 May 2010 07:26:36 -0500605_US-ASCII Those products actually read the index, just like RUNSTATS would, to
determine those stats. (Or, they use Runtime Stats).

So, yes, you could read the index too and figure them out yourself,
but that's a lot of work.

Todd

On May 20, 2010, at 6:50 AM, Sekhar Mekala wrote:

Thanks for your prompt responses!!

Question: Is there any way to determine the CLUSTERRATIO, LEAFNEAR,
LEAFFAR etc without running RUNSTATS. In other words, how DB2 or CA
Tools or BMC Tools determine these factors and help us to determine
whether the REORG is required? [...]44_C207C1CA-10FF-42F3-83C2-915D87BA08FB@mac.com 13856 55 23_Re: Question on LISTCAT13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Thu, 20 May 2010 08:31:32 -0400338_utf-8 " Is there any way to determine the CLUSTERRATIO, LEAFNEAR, LEAFFAR etc without running RUNSTATS "??

Yes - You read all the data and apply the requisite algorithms. Not all calculations though are documented by IBM so you'd have to guess at how to work out some of them. Clusterratio changed fairly recently for example [...]60_4440F5DA00E3F3459BBCB97431B91B6612B613885C@MAILR004.mail.lan 13912 358 28_Re: [AD?] IDUG Radio Silence13_David Simpson22_dsimpson@THEMISINC.COM31_Thu, 20 May 2010 09:35:03 -0400530_us-ascii Linda Claussen and I have recorded a few of our thoughts on the
conference. They are available front and center on the Themis web site.

http://www.themisinc.com

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ed Long
Sent: Monday, May 17, 2010 5:31 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] IDUG Radio Silence

The radio silence, with the exception of a single blog, has continued
well past the end of the conference. Perhaps the hangovers have not yet
abated. [...]67_7EC87535E7581C4C890F5BF1CF9A93740293D7E2@THEMISSRV1.themisinc.local 14271 51 50_Re: ISAO (Was IDUG Better than Ever with Hot News)10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 20 May 2010 09:51:28 -0400678_UTF-8 Hi Dirk

Thank you so much for your reply.

Yes you're right (of course) this is the current status, as we can read on

http://www-05.ibm.com/dk/news/events/lsu2009/pdf/10_Handout_LSU2009_Smart_Analytics_Optimizer.pdf

But I'm not focusing on it too much as according rumors I heard z11 will be the next step, using internal dedicated data server(s) to eliminate potential problems (network problems, server problems). For sure a lot of work was done on optimizer to manage it.
I presume all is done via 'DB2 Ministry of Foreign Affairs' i.e. DDF as optimizer itself has no way to trigger something similar and some 'layer' has to be added [...]48_9693542419728593.WA.mscarpacesve.it@www.idug.org 14323 461 28_Re: [AD?] IDUG Radio Silence14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 20 May 2010 10:14:04 -0400527_us-ascii David,

Hey! Linda claimed she was going to retire after DB2V8. Tell her I said "Hi!", please?

--Phil Sevetson, late of Wakefern
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of David Simpson
Sent: Thursday, May 20, 2010 9:35 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [AD?] IDUG Radio Silence

Linda Claussen and I have recorded a few of our thoughts on the conference. They are available front and center on the Themis web site. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46973@MAIL02.fisalan.nycnet 14785 27 46_Log Records Difference Between Insert and Load10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Thu, 20 May 2010 10:39:50 -0400735_UTF-8 Hi all,

Does anyoen know if the log records for an insert look different than the log records for a load resume?
We have a tool that isn't picking up the latter.

_____________________________________________________________________

* 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!
_____________________________________________________________________ [...]53_0033258618710476.WA.jorghluekebcbsmn.com@www.idug.org 14813 44 50_Re: Log Records Difference Between Insert and Load13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Thu, 20 May 2010 09:43:43 -0500453_utf-8 Jorg,

The load's not LOG NO, is it? ;o)

For a Load Resume Shrlevel Change it's effectively SQL insert statements, so they should look the same in the Log.

Cheers,

Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jorg Lueke
Sent: 20 May 2010 15:40
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Log Records Difference Between Insert and Load

Hi all, [...]67_78B3EFE2C0C5D74E9E7777D1D669D5420CE09756@PHXCCRPRD04.adprod.bmc.com 14858 135 28_Re: [AD?] IDUG Radio Silence13_David Simpson22_dsimpson@THEMISINC.COM31_Thu, 20 May 2010 10:16:08 -0500397_iso-8859-1 I will tell her. Linda did retire a few yers ago, but Themis is thrilled to have her back now. She was at IDUG this year and was quickly put to work there too.

-----Original Message-----
From: Sevetson, Phil
Sent: Thursday, May 20, 2010 9:55 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [AD?] IDUG Radio Silence [...]46_004d01caf82f$607a3b2e$0a0b010a@themisinc.local 14994 94 39_Re: IDUG Better than Ever with Hot News13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 20 May 2010 10:21:46 -0500703_UTF-8 Thanks Phil, you are absolutely correct... it is still an unannounced
product...

Someday I will learn to type and/or re-read my notes before hitting
send....(smile)

Willie

On 5/20/2010 3:01 AM, Phil Grainger wrote:
> I think Willie means " still an UN-announced product "
>
> 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
>
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] [...]30_4BF5538A.4060105@attglobal.net 15089 71 50_Re: ISAO (Was IDUG Better than Ever with Hot News)13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 20 May 2010 10:30:32 -0500809_UTF-8 Here are a couple of pretty good articles written by IBMers about Smart
Analytics Optimizer that I think you might find interesting.

http://www.ibmsystemsmag.com/mainframe/novemberdecember09/coverstory/27483p1.aspx?ht=

http://www.ibmsystemsmag.com/mainframe/enewsletterexclusive/27681p1.aspx?ht=

I will be blogging about it as soon as we get closer to GA.

Willie

On 5/20/2010 8:51 AM, Max Scarpa wrote:
> Hi Dirk
>
> Thank you so much for your reply.
>
> Yes you're right (of course) this is the current status, as we can read on
>
> http://www-05.ibm.com/dk/news/events/lsu2009/pdf/10_Handout_LSU2009_Smart_Analytics_Optimizer.pdf
>
> But I'm not focusing on it too much as according rumors I heard z11 will be the next step, using [...]30_4BF55598.6090602@attglobal.net 15161 161 28_Re: [AD?] IDUG Radio Silence14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 20 May 2010 11:50:22 -0400407_us-ascii Linda is an excellent instructor -- Please feel free to call on me if you want a reference for her in that capacity, not (I'm sure) that you're short on such.
-ps

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of David Simpson
Sent: Thursday, May 20, 2010 11:16 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [AD?] IDUG Radio Silence [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46974@MAIL02.fisalan.nycnet 15323 68 50_Re: Log Records Difference Between Insert and Load13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Thu, 20 May 2010 11:57:11 -0400516_utf-8 Except, that LOAD RESUME SHRLEVEL CHANGE formats each individual page before externalising them (so far as I remember) so the log records may indeed look different from a normal INSERT

What does your tool vendor say?

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 [...]60_4440F5DA00E3F3459BBCB97431B91B6612B613887F@MAILR004.mail.lan 15392 28 23_Re: Question on LISTCAT11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Thu, 20 May 2010 16:11:12 +0000777_- >Is there any way to determine the CLUSTERRATIO, LEAFNEAR, LEAFFAR etc without running RUNSTATS

Why do you not want to run RUNSTATS?
That's what the tool is for.

-
Too busy driving to stop for gas!

_____________________________________________________________________

* 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!
_____________________________________________________________________ [...]104_156413265-1274371865-cardhu_decombobulator_blackberry.rim.net-1720670397-@bda026.bisx.prod.on.blackberry 15421 25 50_Re: Log Records Difference Between Insert and Load10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Thu, 20 May 2010 11:24:51 -0400731_UTF-8 Haha, no they did indeed specify Log Yes! I did print it with DSN1LOGP and I figured they were the same since the type is just undo redo. It's the vendor's problem now

_____________________________________________________________________

* 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!
_____________________________________________________________________ [...]53_8408305417685558.WA.jorghluekebcbsmn.com@www.idug.org 15447 42 37_Dataset size for Partition Tablespace15_Steve Schuering31_steven.schuering@EXELONCORP.COM31_Thu, 20 May 2010 12:02:30 -0400309_UTF-8 We are v8 NFM and have a Tablespace in 254 partitions, pagesize of 32K. The DSSIZE is 0 in SYSIBM.SYSTABLESPACE. The datasets are growing and nearing the 4G limit. I'm investigating ways to increase the number of partitions and spread the data over the additional partitions with a minimal outage. [...]63_7178294739184477.WA.steven.schueringexeloncorp.com@www.idug.org 15490 100 41_Re: Dataset size for Partition Tablespace16_Daniel Luksetich18_danl@DB2EXPERT.COM31_Thu, 20 May 2010 12:15:15 -0500341_UTF-8 Steve,
If your dssize=0 and you have 254 parts then you are LARGE if I am not mistaken. So you are stuck at 4GB and will have to drop and recreate if you want a larger dssize.

Try it in a test environment to see.

Spreading the data is possible, but I've never done that myself so maybe someone else can chime in. [...]35_040c01caf840$059c5f90$10d51eb0$@com 15591 92 50_Re: Log Records Difference Between Insert and Load13_David Simpson22_dsimpson@THEMISINC.COM31_Thu, 20 May 2010 13:23:04 -0400424_utf-8 Rich Fazio and I did some experimentation with DSN1LOGP a few years ago because of a similar problem. LOAD RESUME SHRLEVEL CHANGE turns the load records into a low level insert. LOG YES is required and the log records looked identical to a regular insert with the exception of 1 byte (presumably the "I was inserted via LOAD SHRLEVEL CHANGE" byte). One of our tools was ignoring anything where this byte was set. [...]67_7EC87535E7581C4C890F5BF1CF9A93740293D841@THEMISSRV1.themisinc.local 15684 188 28_Re: [AD?] IDUG Radio Silence10_Roger Hecq18_Roger.Hecq@UBS.COM31_Thu, 20 May 2010 13:39:13 -0400467_US-ASCII I think that any of us who have had the opportunity to know Linda would
share your high regard for her. Always knowledgable, helpful, and
pleasant.

Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of David Simpson
Sent: Thursday, May 20, 2010 11:16 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [AD?] IDUG Radio Silence [...]62_1A700EEF49343148A08879B1E3CA5BA614F729EA@NSTMC101PEX1.ubsw.net 15873 207 28_Re: [AD?] IDUG Radio Silence12_Phil Gunning19_pkgunning@GMAIL.COM31_Thu, 20 May 2010 13:50:33 -0400482_US-ASCII Likewse....

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roger Hecq
Sent: Thursday, May 20, 2010 1:39 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [AD?] IDUG Radio Silence

I think that any of us who have had the opportunity to know Linda would
share your high regard for her. Always knowledgable, helpful, and
pleasant.

Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492 [...]35_01ec01caf844$f49fd320$dddf7960$@com 16081 38 50_Re: ISAO (Was IDUG Better than Ever with Hot News)10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 20 May 2010 14:35:23 -0400830_UTF-8 Hi Willie

Thank you so much for links.

I printed articles and I'll read them soon.

I'm curious to understand performance (DB2 and non-DB2) of this new feature as it seems to me many sw and hw partes are involved.

Regards

Max Scarpa

_____________________________________________________________________

* 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!
_____________________________________________________________________ [...]48_6911883161999636.WA.mscarpacesve.it@www.idug.org 16120 33 23_Re: Question on LISTCAT13_Sekhar Mekala23_SEKHAR.MEKALA@GMAIL.COM31_Thu, 20 May 2010 15:39:04 -0400458_UTF-8 I do not want to run the RUNSTATS because I do not want to distrub the existing statistics. I work in PeopleSoft environment and I cannot run the RUNSTATS on all the table spaces, because we have huge amounts of cutomized statistics loaded into the catalog tables for perfromance.

Also I am curious to know how third party tools like CA etc generates the information (and hence advises us to run REORG) without really running the RUNSTATS. [...]55_8830368934594732.WA.SEKHAR.MEKALAGMAIL.COM@www.idug.org 16154 62 23_Re: Question on LISTCAT13_George Toolan19_gtoolan@COMCAST.NET31_Thu, 20 May 2010 16:05:45 -0400460_UTF-8 CA's database analyzer runs its own stats collection program and populates its own stats tables. I used to run PDA stats weekly and based on the results compared to the catalog, determined which real stats to run.

George

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sekhar Mekala
Sent: Thursday, May 20, 2010 3:39 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Question on LISTCAT [...]35_01a801caf857$d590a4b0$80b1ee10$@net 16217 148 23_Re: Question on LISTCAT0_24_carol.sutfin@REGIONS.COM31_Thu, 20 May 2010 15:10:43 -0500501_US-ASCII You could do RUNSTATs with REPORT YES and UPDATE NONE

It would generate a report that you could parse with REXX, or COBOL or
Assembler to determine if you want to REORG.

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
carol.sutfin@regions.com

From: Sekhar Mekala
To: DB2-L@IDUGDB2-L.ORG
Date: 05/20/2010 02:40 PM
Subject: Re: [DB2-L] Question on LISTCAT
Sent by: IDUG DB2-L [...]71_OF8C848C84.6C936DD7-ON86257729.006D5EEA-86257729.006ED873@corp.rgbk.com 16366 31 23_Re: Question on LISTCAT11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Thu, 20 May 2010 20:18:26 +0000341_- >I cannot run the RUNSTATS on all the table spaces, because we have huge amounts of cutomized statistics loaded into the catalog tables for perfromance.

I sort of understand, but (like any other form of benchmarking) don't the characteristics of the data change?
Any automated tool reacts faster than any hand built thingy! [...]103_604943484-1274386699-cardhu_decombobulator_blackberry.rim.net-767808846-@bda026.bisx.prod.on.blackberry 16398 64 23_Re: Question on LISTCAT16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Thu, 20 May 2010 16:19:18 -0400540_utf-8 Hello Sekhar, If you want to discuss all the details how CA Database Analyzer works, let's do that off the list. For now, PDA collects all the details be reading the VSAM datasets. The collected information is inserted into a number of tables upon which user actions/conditions can be generated based on the thresholds you define.
If you're afraid of RUNSTATS and the catalog update process, you could execute RUNSTATS REPORT ONLY so you at least can see the current health conditions without impacting access path selection. [...]56_0A18F096E689AC43BB2F52DAE5674D60086DC517@USILMS14.ca.com 16463 61 23_Re: Question on LISTCAT10_Mir, Sally15_SMir@BBANDT.COM31_Thu, 20 May 2010 16:26:55 -0400662_us-ascii You could run RUNSTATS REPORT YES UPDATE NONE (or whatever the syntax
is, I forget!) and parse the output....

Sally Mir

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sekhar Mekala
Sent: Thursday, May 20, 2010 3:39 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Question on LISTCAT

I do not want to run the RUNSTATS because I do not want to distrub the
existing statistics. I work in PeopleSoft environment and I cannot run
the RUNSTATS on all the table spaces, because we have huge amounts of
cutomized statistics loaded into the catalog tables for perfromance. [...]62_994039AECC75DF4CAFE407FA0F32CDD00DA09882@wil-exmb01.bbtnet.com 16525 90 23_Re: Question on LISTCAT13_Campbell, Jim26_Jim.Campbell@COURTS.WA.GOV31_Thu, 20 May 2010 13:48:39 -0700588_us-ascii You could also use the Real-time Statistic tables to get all necessary info for reorgs etc...

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 Mir, Sally
Sent: Thursday, May 20, 2010 1:27 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Question on LISTCAT

You could run RUNSTATS REPORT YES UPDATE NONE (or whatever the syntax
is, I forget!) and parse the output.... [...]66_2A1B28C5CC983C4F8253CF1FA121853214C515A4B8@EXCHMAIL1.courts.wa.gov 16616 75 23_Re: Question on LISTCAT0_24_carol.sutfin@REGIONS.COM31_Thu, 20 May 2010 16:21:51 -0500614_US-ASCII I am not discounting the value of automated tools.

However, sometimes the powers that control the money will not allow you to
have the tools.
In that case you may be able to provide your own.
Sometimes this also provides you with additional knowledge about DB2, also
a good thing.

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
carol.sutfin@regions.com

From: Ted MacNEIL
To: DB2-L@IDUGDB2-L.ORG
Date: 05/20/2010 04:16 PM
Subject: Re: [DB2-L] Question on LISTCAT
Sent by: IDUG DB2-L [...]71_OF423A34F2.97300096-ON86257729.00751383-86257729.00755B69@corp.rgbk.com 16692 38 53_Connection method from DB2 z/OS to Windows SQL Server12_Mark Vickers26_markvickers@GROCERYBIZ.COM31_Thu, 20 May 2010 17:43:17 -0400307_UTF-8 We are installing a package on Windows that will be using SQL Server (I think compatible with 2005 Enterprise).

We need to exchange data (in and out) from DB2 v8 on z/OS (table to table).
The package also allows flat file FTP, but I would like to explore the direct connection further. [...]58_1204313917978056.WA.markvickersgrocerybiz.com@www.idug.org 16731 27 23_Re: Question on LISTCAT11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Thu, 20 May 2010 22:59:12 +0000742_- >However, sometimes the powers that control the money will not allow you to
have the tools.

Since when was RUNSTATS a cost add-on?
-
Too busy driving to stop for gas!

_____________________________________________________________________

* 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!
_____________________________________________________________________ [...]104_366112718-1274396344-cardhu_decombobulator_blackberry.rim.net-2031491407-@bda026.bisx.prod.on.blackberry 16759 97 23_Re: Question on LISTCAT7_Ed Long19_rdhm99a@PRODIGY.NET31_Thu, 20 May 2010 16:21:48 -0700505_iso-8859-1 Technically it is; remember the 'suite' of utilities.

Edward Long

--- On Thu, 5/20/10, Ted MacNEIL wrote:

From: Ted MacNEIL
Subject: Re: [DB2-L] Question on LISTCAT
To: DB2-L@IDUGDB2-L.ORG
Date: Thursday, May 20, 2010, 6:59 PM

>However, sometimes the powers that control the money will not allow you to
have the tools.

Since when was RUNSTATS a cost add-on?
-
Too busy driving to stop for gas! [...]43_495502.59806.qm@web80204.mail.mud.yahoo.com 16857 191 41_Re: Dataset size for Partition Tablespace0_24_hhuang@DCCSH.ICBC.COM.CN31_Fri, 21 May 2010 09:51:52 +0800465_GB2312 Steve,

DSSIZE=0 indicates that when you created this tablespace, you omitted
DSSIZE parameter,
which was so common before DB2 V8 era.
Your change plan to add more partitions is generally correct, with some
exceptions:
1.The SQL statement is "ALTER TABLE ADD PARTITION ENDING AT x", not ALTER
TABLESPACE ...
2.Before you add new partitions, please check the original highest limit
key, and change
it lower if necessary. [...]69_OF6B44D7AD.C55C69C2-ON4825772A.00060F93-4825772A.000A3E0A@icbc.com.cn 17049 122 23_Re: Question on LISTCAT11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Fri, 21 May 2010 08:49:04 +0000423_Windows-1252 Okay, but since I've never worked in a shop without it, and that's since 1984, I've never considered it a cost item.

-
Too busy driving to stop for gas!

-----Original Message-----
From: Ed Long
Date: Thu, 20 May 2010 16:21:48
To:
Subject: Re: [DB2-L] Question on LISTCAT

Technically it is; remember the 'suite' of utilities. [...]104_1404495881-1274431737-cardhu_decombobulator_blackberry.rim.net-392554652-@bda026.bisx.prod.on.blackberry 17172 420 23_Re: Question on LISTCAT13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 21 May 2010 07:14:09 -0400494_us-ascii Perhaps that's because in 1984 it WASN'T an additional-cost item, it was part of DB2 itself

That changed with V6 (I think it was) in 1999 or so
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 [...]60_4440F5DA00E3F3459BBCB97431B91B6612B61388B6@MAILR004.mail.lan 17593 281 23_Re: Question on LISTCAT11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 21 May 2010 14:40:36 +0200711_ISO-8859-1 this will still kill the DSC and as peoplesoft was mentioned I think
that's a no no !!

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: R.Boxwell@seg.de
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert

carol.sutfin@REGIONS.COM
Gesendet von: IDUG DB2-L
20.05.2010 22:10
Bitte antworten an
IDUG DB2-L

An
DB2-L@IDUGDB2-L.ORG
Kopie

Thema
Re: [DB2-L] Question on LISTCAT [...]64_OFA2E0E3A4.A0933E37-ONC125772A.004592DC-C125772A.0045A2F4@seg.de 17875 683 23_Re: Question on LISTCAT16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Fri, 21 May 2010 09:50:56 -0400508_us-ascii Hey Phil - DB2 Utilities started to be charged for in DB2 V7. Remember
all the interesting talks we had J

Steen Rasmussen
CA

Sr Engineering Services Architect

IBM Certified Database Associate - DB2 9 Fundamentals

IBM Certified Database Administrator - DB2 9 DBA for z/OS

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: Friday, May 21, 2010 6:14 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Question on LISTCAT [...]56_0A18F096E689AC43BB2F52DAE5674D60086DC66C@USILMS14.ca.com 18559 24 23_Re: Question on LISTCAT13_Sekhar Mekala23_SEKHAR.MEKALA@GMAIL.COM31_Fri, 21 May 2010 10:58:54 -0400603_UTF-8 Thanks for all your responses and suggestions!!

Best regards,
Sekhar

_____________________________________________________________________

* 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
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L55_4766020138243001.WA.SEKHAR.MEKALAGMAIL.COM@www.idug.org 18584 188 19_IBM support toolbar13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 21 May 2010 11:05:53 -0400360_us-ascii Is anyone else using the IBM Support toolbar for Explorer and noticed that the IBM support portal has been "enhanced"?

In my case, it's been enhanced to the point that it doesn't work any more

When I search through the toolbar all I see is the support portal home page

VERY irritating - that toolbar was soooo easy to use :( [...]60_4440F5DA00E3F3459BBCB97431B91B6612B61388F9@MAILR004.mail.lan 18773 197 27_Re: DB2 V8 z/OS SPT01 Reorg15_Eugene R Renico28_eugene.r.renico@JPMCHASE.COM31_Fri, 21 May 2010 11:11:10 -0400560_utf-8 Thank you to everyone who responded for your advice and suggestions.

This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of JPMorgan Chase & Co., its subsidiaries and affiliates. [...]75_BAA9B699DFB94E4BACCDFAEB9D18E16236FCA47F68@EMARC124VS01.exchad.jpmchase.net 18971 750 23_Re: Question on LISTCAT13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 21 May 2010 11:42:33 -0400596_us-ascii OK, so my memory isn't what it was :(

When did V7 go GA then????
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 Rasmussen, Steen
Sent: 21 May 2010 14:51
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Question on LISTCAT [...]60_4440F5DA00E3F3459BBCB97431B91B6612B6138908@MAILR004.mail.lan 19722 55 22_Re: IDUG Radio Silence7_Ed Long19_rdhm99a@PRODIGY.NET31_Fri, 21 May 2010 08:51:31 -0700658_iso-8859-1 One reason for my Original inquiry relates to my favorite RUG, the New England DB2 User's Group.
 
We are always looking for good presentations. Who would you recommend of of those who presented at Tampa.
 
 

 

_____________________________________________________________________

* 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
_____________________________________________________________________ [...]42_49720.18100.qm@web80204.mail.mud.yahoo.com 19778 43 50_Re: Log Records Difference Between Insert and Load15_Campbell, Wayne28_Wayne.Campbell@COURTS.WA.GOV31_Fri, 21 May 2010 09:11:27 -0700519_utf-8 Yes, the log record for a load is different than for an insert. For us, it affects our Log analysis tool and our replication tool, IBM's CDC.

Wayne Campbell
DB2 DBA
Administrative Office of the Courts
(360) 705-5268
Email: wayne.campbell@courts.wa.gov
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jorg Lueke
Sent: Thursday, May 20, 2010 7:40 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Log Records Difference Between Insert and Load [...]66_2A1B28C5CC983C4F8253CF1FA121853214C56BC799@EXCHMAIL1.courts.wa.gov 19822 1107 23_Re: Question on LISTCAT12_Kirk Hampton37_kirk.hampton@ENERGYFUTUREHOLDINGS.COM31_Fri, 21 May 2010 11:17:44 -0500537_us-ascii According to IBMLink, 2001-03-30.

But there was a lot of discussion about the utilities packaging before
it came out, so that may indeed have gone back to 1999.

J Kirk Hampton

Sr. Specialist - Mainframe

HCL Technologies America

Mesquite Data Center

972-216-3119

________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: Friday, May 21, 2010 10:43 AM
To: Hampton, Kirk
Subject: Re: Question on LISTCAT [...]71_31F1BA84DF370A4C825F6E64D59DAF5404112B63@MDCTXUEXCL01N4.corptxu.txu.com 20930 38 23_Re: IBM support toolbar13_Steve Runtsch26_steve.runtsch@ASSURANT.COM31_Fri, 21 May 2010 14:43:12 -05000_70_OF6FE8BF63.0962F068-ON8625772A.006BB2E8-8625772A.006C538A@assurant.com 20969 42 57_Re: Connection method from DB2 z/OS to Windows SQL Server9_Tony Saul30_generalemaillists@YAHOO.COM.AU31_Fri, 21 May 2010 17:06:10 -0700632_iso-8859-1 I think there were some articles on the Microsoft Knowledge base about connectivity between SQLServer and DB2 on z/OS  Regards, Tony ----- Original Message ---- From: Mark Vickers To: DB2-L@IDUGDB2-L.ORG Sent: Fri, 21 May, 2010 7:13:17 AM Subject: [DB2-L] Connection method from DB2 z/OS to Windows SQL Server We are installing a package on Windows that will be using SQL Server (I think compatible with 2005 Enterprise). We need to exchange data (in and out) from DB2 v8 on z/OS (table to table). The package also allows flat file FTP, but I would like to explore the direct connection [...]42_291661.2775.qm@web34406.mail.mud.yahoo.com 21012 76 31_Can we create a trigger on RTS?13_Jose de Bedos20_josedebedos@LIVE.COM31_Fri, 21 May 2010 22:04:53 -0300774_Windows-1252 Hi list,

trying to have a kind of historical capability in RTS, I though we could create triggers in RTS.
Is this possible?

TIA,

Jose

_________________________________________________________________
Hotmail: Trusted email with Microsoft’s powerful SPAM protection.
https://signup.live.com/signup.aspx?id=60969
_____________________________________________________________________

* 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
_____________________________________________________________________ [...]43_BLU130-W16DCF2FCF761796E049B01CEE50@phx.gbl 21089 39 21_SAP to Acquire Sybase12_Martin Hubel17_Martin@MHUBEL.COM31_Fri, 21 May 2010 21:17:05 -04000_43_DB2-L%201005212117224020.0B27@IDUGDB2-L.ORG