1 IDUGDB2-L.ORG /home/listserv/home/db2-l July 2010, week 4 2 165 74_Re: Betr: Re: [DB2-L] Betr: Re: [DB2-L] Betr: [DB2-L] archive log size....15_Smartcurl Zhang19_smartcurl@GMAIL.COM31_Thu, 22 Jul 2010 12:48:31 +0800539_ISO-8859-1 Thank you,Marcel
Thank you,Gregory
Thank you,Adam
Thank you,Roger
Thank you,Mike
Thank you,Max

So I got 4 conclusion:
1.DB2 allocate archive log datasets according to how many log records need
to be wrote out.
2.ARCHIVE LOG FREQ does not evently take effect for archive ,just
participate in calculation of active log size.
3.TRANCATE status certainly means some one issue ARCHIVE LOG command.
4.INSTALL CLIST calculate active log datasets size by some parameter which i
typed in. [...]60_AANLkTing0JRGGV6NAOr8xkBbYMMxOy47y4xAW22iTc1_@mail.gmail.com 168 36 52_Is there a way to bind a V7 DBRM on V9 or vice versa15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Thu, 22 Jul 2010 14:23:40 +030091_US-ASCII Need one really compile twice in order to have the same program run on V7 &
V9?42_qfag46dtk5ovpbr9t2hojr20bnvjvf125k@4ax.com 205 570 74_Re: Betr: Re: [DB2-L] Betr: Re: [DB2-L] Betr: [DB2-L] archive log size....12_Isaac Yassin20_yassini@BEZEQINT.NET31_Thu, 22 Jul 2010 16:09:17 +0300469_us-ascii Hi,

As for item 2 - it's The CHECKPOINT FREQ field on panel DSNTIPL and it is
measured either in minutes 1-60 or in log records.

I suggest no more than 5 in busy system.

Isaac Yassin

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Smartcurl Zhang
Sent: Thursday, July 22, 2010 7:49 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Betr: Re: [DB2-L] Betr: Re: [DB2-L] Betr: [DB2-L]
archive log size.... [...]35_005701cb299f$1752c3b0$45f84b10$@net 776 39 56_IBM announces their new zEnterprise 196 (z196) processor13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 22 Jul 2010 10:19:00 -0500386_ISO-8859-1 This is huge.. it's the fastest mainframe processor so far...

5.2 GHz quad-core processor

up to 3 TB of memory

and lots more all discussed in the blog post I published today...

http://bit.ly/cIe5VL (tiny url)

or

http://it.toolbox.com/blogs/db2zos/the-ibm-mainframe-has-just-raised-the-bar-introducing-the-ibm-zenterprise-system-4010630_4C486164.8000403@attglobal.net 816 51 52_What is your experience with the REOPT(AUTO) option?5_Larry34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Thu, 22 Jul 2010 12:24:08 -0400631_UTF-8 I was wondering if anyone out there has had some experience (either good or
bad) with the REOPT(AUTO) option.

More specifically, we have just recently run into a query that was
submitted by one of our applications running on "Websphere Application
Server" (so the application was Java) that was performing poorly because it
was using a parameter marker in a predicate. The column that the parameter
marker was being compared against had 26 distinct values. The table that
this predicate was applied to had over two million rows. Of the 26 values
that were possible for this column, more than [...]65_0206173061221922.WA.LIS.KirkpatrickMutualofOmaha.com@www.idug.org 868 93 17_Compressing SPT0114_Heckman, Carol23_carol_heckman@MEDCO.COM31_Thu, 22 Jul 2010 14:43:02 -0400729_us-ascii Has anyone had any negative experiences with implementing compression
for SPT01 (COMPRESS_SPT01=YES with the appropriate apar PK80375) in V9?

Carol Heckman
Medco DB2 Systems Group
201 703 7365

email: Carol_Heckman@Medco.com

This e-mail message and any attachments contain confidential information from Medco. If you are not the intended recipient, you are hereby notified that disclosure, printing, copying, distribution, or the taking of any action in reliance on the contents of this electronic information is strictly prohibited. If you have received this e-mail message in error, please immediately notify the sender by reply message and then delete the electronic message and any [...]64_BDCF28CC3A7F9F4AB5E2BB2F46EC4D930B85CAFA@fr1-mx-usr03p.medco.com 962 329 21_Re: Compressing SPT0113_Walters, Paul28_Paul.A.Walters@SALLIEMAE.COM31_Thu, 22 Jul 2010 15:37:20 -0400444_us-ascii We are doing this in V8 with no negative experiences. We are getting a 70% compression ratio.

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Heckman, Carol
Sent: Thursday, July 22, 2010 2:43 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Compressing SPT01

Has anyone had any negative experiences with implementing compression for SPT01 (COMPRESS_SPT01=YES with the appropriate apar PK80375) in V9? [...]70_EBC218E23BF7B5468DC64F2ED8547F4277E545F207@VREEXMBX01.us.ad.usa-ed.net 1292 34 73_AUTO: Paul P Packham/GIS/CSC is out of the office. (returning 29/07/2010)14_Paul P Packham16_ppackham@CSC.COM31_Thu, 22 Jul 2010 20:53:11 +0100350_US-ASCII I am out of the office until 29/07/2010.

I am out of the office until Thursday 29th.
For urgent queries please contact Mick Graley on +44(0)1246214871,
otherwise I will respond when I return.
For a Union query please contact Colin W Walker or any
of the other reps. Colin's number is 01246 21 4699

Thanks Paul [...]65_OFB0930D31.20CE9058-ON80257768.006D3D4A-80257768.006D3D4B@csc.com 1327 215 21_Re: Compressing SPT010_17_jtonchick@AOL.COM31_Thu, 22 Jul 2010 21:11:27 -0400388_us-ascii No problems so far. I've been using COMPRESS_SPT01=YES in the two subsystems that had multiple DSNDB01.SPT01 datasets. When I applied the latest round of RSU maintenaance, I recompiled the zparm with the the parm set to YES. After the "burn in" period for the maintenance, I scheduled the SPT01 reorgs for each subsystem. I achieved over 70% compression in both subsystems. [...]53_8CCF81B1C1EE9DF-2008-95CA@webmail-d036.sysops.aol.com 1543 655 74_Re: Betr: Re: [DB2-L] Betr: Re: [DB2-L] Betr: [DB2-L] archive log size....15_Smartcurl Zhang19_smartcurl@GMAIL.COM31_Fri, 23 Jul 2010 12:15:46 +0800489_windows-1252 Hi,Yassin

What i am talking about is item 3:

UPDATE DB2 - ACTIVE LOG DATA SET PARAMETERS

===>

Enter data below:

1 NUMBER OF LOGS ===> 8 Data sets per active log copy (2-93)

2 OUTPUT BUFFER ===> 102400000 Size in bytes (40K-400000K)

3 ARCHIVE LOG FREQ ===> 24 Hours per archive run

4 UPDATE RATE ===> 3600 Updates, inserts, and deletes per
hour
5 LOG APPLY STORAGE ===> 100M Maximum ssnmDBM1 storage in MB for [...]60_AANLkTikAK1rQxM+1az2AizS_nY50=m2arVZvm2k+bS=7@mail.gmail.com 2199 284 39_[AD] DB2 Listdef Automation Enhancement13_Edward Benoit29_db2tech@RECOVERYKNOWLEDGE.COM31_Thu, 22 Jul 2010 21:30:07 -0700701_iso-8859-1 Enhancement: With this enhancement the customer may generate Listdef jobs to be implemented into production status.  Once the Listdef jobs are in production status the customer may update the Listdef, Template, and Groupentries online without interfering with the production jobs.  This process eliminates the need of paper work and management signatures when updating these entries.   GOOD NEWS: A customer may obtain a freecopy of theListdef Manager forDB2with the purchase of any of the other software products.  Customer pay only yearly maintenance fee after the first year.   LISTDEF MANAGER forDB2automates the LISTDEF (Grouping of DB2 Objects) and TEMPLATE (Dynamic Allocation) [...]46_461725.53760.qm@web1209.biz.mail.gq1.yahoo.com 2484 127 15_Re: HIGH VDWQT?16_Robert Catterall21_rfcatterall@GMAIL.COM31_Fri, 23 Jul 2010 00:59:33 -0400588_ISO-8859-1 In fact, you will see "other wait time" in a DB2 monitor accounting report
when a process has to wait on a page that is being written to disk by
another thread (could be a synchronous or an asynchronous write). Now, while
I am accustomed to seeing non-zero values for "other wait time" in DB2
monitor accounting reports (or online displays of thread detail activity),
the values I see are usually VERY small (like less than a tenth of a percent
of average total wait time for an application process). The chances of a
program wanting to access a page [...]60_AANLkTikKyDOcxpqBwN8_f988tdD_4nxO0pGOOTq8TQKV@mail.gmail.com 2612 113 56_Re: Is there a way to bind a V7 DBRM on V9 or vice versa15_Itschak Mugzach18_imugzach@GMAIL.COM31_Fri, 23 Jul 2010 09:30:05 +0300364_ISO-8859-1 Don;t think so. Bewer version of DB@ no longer include a pe-compiler, but
you can use the old precompiler from older versions. You might not be able
to use newer functions, but then you'll have problems running the program on
a DB2 7 region. So, my understanding is that there is no problem using a
DBRM created by the V7 pre-compiler. [...]60_AANLkTimKAT+FzETdPb72_zuJ=+xi+CPaqL4gFMTnH4LL@mail.gmail.com 2726 38 56_Re: Is there a way to bind a V7 DBRM on V9 or vice versa14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 23 Jul 2010 22:03:40 +1000776_US-ASCII Have you tried binding the V7 DBRMs in V9?

James Campbell

On 22 Jul 2010 at 14:23, Binyamin Dissen wrote:

> Need one really compile twice in order to have the same program run on V7 &
> V9?
>
> --
> Binyamin Dissen
> http://www.dissensoftware.com
>
> Director, Dissen Software, Bar & Grill - Israel
>
>

_____________________________________________________________________
* IDUG Australasia * Sydney, Australia * 1-3 September 2010 * http://IDUG.ORG/AU *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do [...]48_4C4A11BC.24981.A6F6AB0@jacampbell.acslink.net.au 2765 60 16_Recylced TSO ids4_Anil21_alisha_kale@YAHOO.COM31_Fri, 23 Jul 2010 08:13:48 -0400536_UTF-8 Hi All !

Env: DB2 V9 for z/os

Let me ask my questions by giving the following steps:
1. ACF2 creates a TSO id, PQR
2. DBA grants PQR SYSADM access
3. PQR creates DB2 objects
4. PQR leaves the company
5. ACF2 terminates id PQR

Question1:
What's the impact from a DBA stand point ?

6. A year later new person joins the company
7. ACF2 chooses to recylce the id, PQR
8. This time PQR is intendend to be applicaton id
9. PQR was granted SYSADM the previous time (in step 2) [...]52_3211198145967649.WA.alishakaleyahoo.com@www.idug.org 2826 111 28_AW: [DB2-L] Recylced TSO ids35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Fri, 23 Jul 2010 15:01:04 +0200421_iso-8859-1 Hi

Although I've no experience with ACF2, I think it will be the same with RACF. From a DBA-standpoint there is no impact, when PQR leaves the company, because all the privileges connected with that authid remain. So if a new person get this authid, how should anybody know, that this authid is somebody else? So if nobody has revoked these privileges, the new person will posess these privileges. [...]43_DB2-L%201007230901150656.2649@IDUGDB2-L.ORG 2938 117 20_Re: Recylced TSO ids10_Dave Nance16_dav1mo@YAHOO.COM31_Fri, 23 Jul 2010 06:40:44 -0700559_iso-8859-1 Anil,    In the scenario you described PQR would have sysadm access through all of the users. The only way to take away sysadm would be to manually REVOKE it in DB2. Though you must be careful when doing this as you would lose all grants that were issued by this id if not taking extra steps.    In the future, you should either use role based security or secondary auth groups. With secondary auth groups the sysadm privilege should be granted to the group and not the individual. All users of the group should set their SQLID = to the group [...]42_28108.66735.qm@web57806.mail.re3.yahoo.com 3056 346 15_Re: HIGH VDWQT?35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Fri, 23 Jul 2010 10:31:02 -0400488_iso-8859-1 Buffer Pool Tool shows avg and max write times at the object level, so this information is easily available.

While Robert is right for most systems, I have a few I'm looking at that exhibit very high write I/O elapsed times,
and this may be more of an indication of poor dasd performance than application delay impacts.
I also agree that write delay is (usually) an insignificant amount for any given execution, some large batch updaters might be exceptions. [...]46_2A52AFE974FE4C07A6C4D024301DD0F2@DellNotebook3 3403 1272 74_Re: Betr: Re: [DB2-L] Betr: Re: [DB2-L] Betr: [DB2-L] archive log size....12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 23 Jul 2010 17:50:08 +0300435_us-ascii Hi

Yes - that one (3) is for calculation only.

Usually what I do is manually change active log size to be in accord with
the archive method used

Isaac

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Smartcurl Zhang
Sent: Friday, July 23, 2010 7:16 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Betr: Re: [DB2-L] Betr: Re: [DB2-L] Betr: [DB2-L]
archive log size.... [...]35_004a01cb2a76$58880d90$099828b0$@net 4676 60 56_Re: Is there a way to bind a V7 DBRM on V9 or vice versa13_Rhodes, Frank20_Frank_Rhodes@BMC.COM31_Fri, 23 Jul 2010 10:59:44 -0500371_us-ascii Stuff precompiled of DB2 V7 should be able to be bound on DB2 V9, the reverse is not true.

Frank

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Binyamin Dissen
Sent: Thursday, July 22, 2010 6:24 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Is there a way to bind a V7 DBRM on V9 or vice versa [...]69_476996CBBE9AF14285E09E63C370072A148A3556E5@PHXCCRPRD01.adprod.bmc.com 4737 554 37_Dallas DB2 Forum meeting next Tuesday9_Bob Brock28_brock@KRYPTON-CONSULTING.COM31_Fri, 23 Jul 2010 12:25:01 -0500585_iso-8859-1 DB2 FORUM DB2 User Group

Quarterly Meeting

Tuesday, July 27, 2010

8:30 AM - 12:00 PM

Location: CA Technologies Corporate Office

5465 Legacy Drive

Plano, TX 75024

800-225-5224

Breakfast Sponsor: CA Technologies

08:30 - 09:00 Registration and Breakfast

09:00 - 09:05 Business and Announcements

09:05 - 10:05 Using DB2 9 Native SQL Stored Procedures

Bob Andresen, CA Technologies

10:05 - 10:20 Break

10:20 - 10:50 Overview of CA Mainframe Chorus for DB2 Database Management [...]38_F7700D23930A4304B8D7B47C62DA1C7E@RHINO 5292 71 52_Re: real-time replication DB2 zOS to SQLServer 2005?15_Campbell, Wayne28_Wayne.Campbell@COURTS.WA.GOV31_Fri, 23 Jul 2010 15:17:48 -0700557_utf-8 We're currently replicating between DB2 zOS V9 to SQLServer 2008. We're currently using IBMs InfoSphere Change Data Capture V6 (formerly Datamirror' transformation server). We just migrated from V5 to V6. V6 seems to be quite a bit faster than V5. The volume that can be replicate seems to be dependent on the size of the unit of work. Most of ours are small with only a few row being committed at a time (<10). With V5 we would process approximately 10,000 to 15,000 rows per 5 minute interval, with V6, we have seen in the range of 50,000 in a [...]66_2A1B28C5CC983C4F8253CF1FA1218532159A38D907@EXCHMAIL1.courts.wa.gov 5364 169 54_zEnterprise Announcement - Reaction and Interpretation12_Kimberly May28_kim.may@THEFILLMOREGROUP.COM31_Fri, 23 Jul 2010 18:48:09 -0400438_us-ascii Frank attended the zEnterprise announcement presentation in New York
yesterday and returned really jazzed about the possibilities. He spent this
afternoon blogging on it.

If you want to get a better sense of what this announcement means beyond,
"hey, IBM has a new mainframe for sale", I recommend you take a few minutes
to read his reaction to the announcement. It's at:
www.thefillmoregroup.com/blog [...]41_4c4a1c3c.922ddc0a.79d0.14eb@mx.google.com 5534 24 65_Auto Reply: DB2-L Digest - 23 Jul 2010 to 24 Jul 2010 (#2010-200)13_Chris Economy28_christine.economy@ORACLE.COM31_Fri, 23 Jul 2010 22:02:44 -0700676_utf-8 This is an auto-replied message. I am out of the office.
I will respond to your E-mail when I return.
Thank you.

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________ [...]44_f0ed4e84-f82b-4364-a5c5-2b5903b9e491@default 5559 90 59_AUTO: Jim Rohal is out of the office (returning 08/02/2010)0_24_Jim.Rohal@HUNTINGTON.COM31_Sat, 24 Jul 2010 04:01:06 -0400334_us-ascii I am out of the office until 08/02/2010.

I will reply to your message when I return. I will have not have any
access to email during this time.

Note: This is an automated response to your message "[DB2-L] Auto Reply:
DB2-L Digest - 23 Jul 2010 to 24 Jul 2010 (#2010-200)" sent on 7/24/10
1:02:44. [...]69_OF303DF82E.605C847A-ON8525776A.002C0C0C-8525776A.002C0C0C@LocalDomain 5650 33 74_AUTO: Mike Dupuis/Ontario/IBM is out of the office. (returning 08/03/2010)11_Mike Dupuis18_mdupuis@CA.IBM.COM31_Sat, 24 Jul 2010 04:04:24 -0400467_US-ASCII I am out of the office until 08/03/2010.

I will respond to your message when I return. If this is an urgent matter
please contact the Heldesk and ask that an IGS DB2 support person be paged.
For less urgent matters pls email SLCDB2 for Sun Life issues or
celdb2mf@ca.ibm.com for Celero issues.

Note: This is an automated response to your message "DB2-L Digest - 23 Jul
2010 to 24 Jul 2010 (#2010-200)" sent on 7/24/10 1:00:00. [...]68_OF77B0AECE.2422E62F-ON8525776A.002C595A-8525776A.002C595A@ca.ibm.com 5684 69 65_AUTO: John Iczkovits is out of the office. (returning 08/09/2010)14_John Iczkovits19_iczkovit@US.IBM.COM31_Sat, 24 Jul 2010 04:03:33 -0600822_US-ASCII I am out of the office until 08/09/2010.

Note: This is an automated response to your message "DB2-L Digest - 23 Jul
2010 to 24 Jul 2010 (#2010-200)" sent on 7/23/10 23:00:00.

This is the only notification you will receive while this person is away.
_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________ [...]68_OFE16011CF.4FE24E63-ON8725776A.003741BA-8725776A.003741BA@us.ibm.com 5754 79 101_AUTO: Keiko Fukushima/Silicon Valley/IBM is out of the office until July 26th. (returning 07/26/2010)15_Keiko Fukushima18_kfukush@US.IBM.COM31_Sat, 24 Jul 2010 04:16:24 -0600347_US-ASCII I am out of the office until 07/26/2010.

I am on vaction. I will check an E-mail when I return. Please contact my
back up Min M Tang, Ron Lobodzinski or Gina Skelton for DS issue, Carl
Dittrich for IRLM issue. and Stephanie Lee for SAT issue. Please contact my
manager's back up Mike Woo for any other urgent issues. [...]68_OFF035F275.EDA8EB51-ON8725776A.00386F40-8725776A.00386F41@us.ibm.com 5834 295 20_Re: Recylced TSO ids11_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 26 Jul 2010 12:09:43 +0200529_ISO-8859-1 Hi!

If using ACF2 then go Role Based (Not the DB2 "new" Role based I mean
using the ACF2 luid to go role based) in that way all your auth checking
is in ACF2 and not in DB2
SYSADM would then only be Granted on a "need to use" basis .In my last
firm to a single userid with a password kept in a secure place (a safe in
the ops room!) and to be used only
in emergencies...
Failing that when a SYSADM goes if you REVOKE the Id then the awaiting
cascade delete of grants and views will [...]64_OF2EEF8919.6333C2CB-ONC125776C.003773F5-C125776C.0037D21E@seg.de 6130 52 62_DB2 LUW : Job Opportunity: 3 month contract remote DBA support12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Mon, 26 Jul 2010 12:17:59 -0400581_UTF-8 I have an opening for a full time 3 month contract for remote DB2 LUW database administration support. This is a temporary position but could lead to further work. Work consists of providing remote DB2 DBA support for remote clients on Linux, UNIX (AIX or Solaris) and Windows 8 hrs per day, 5 days a week with some off hrs work required. Position requires 2 yrs of full time DB2 LUW DBA experience on 8.2, 9.1, or 9.5. DB2 9.7 experience a plus. Position requires experience with Korn shell, DB2 backup and recovery, DB2 utilities ( runstats, import, load), automation [...]54_0417710342337860.WA.pgunninggunningts.com@www.idug.org 6183 39 11_COPY Status4_Anil21_alisha_kale@YAHOO.COM31_Mon, 26 Jul 2010 14:32:17 -0400396_UTF-8 Env: DB2 V9 for z/os

Hi All !

How would you track when did a tablespace go into COPY pending status ?

Lets say,
1. You perform a -DIS DB(*) SPACE(*) RESTRICT
2. you see a tablespace TS1 in COPY pending status

Question:
You want to determine when did TS1 become COPY pending ?
if possible,
You want to determine the jobname/user that did it ? [...]52_1725729860317470.WA.alishakaleyahoo.com@www.idug.org 6223 86 15_Re: COPY Status10_Sudhir Raj26_sudhir.raj@REALTIMEDBA.COM31_Mon, 26 Jul 2010 15:32:37 -0400598_UTF-8 It's all in the SYSCOPY. Your tablespace can go into copy pending status due to a non-logged event (like LOAD with LOG NO) or when MODIFY utility gets rid of all imagecopy records.

Sample query to find the event and the jobname.

SELECT A.DBNAME,A.TSNAME,DSNUM, CASE ICTYPE
WHEN 'A' THEN 'ALTER '
WHEN 'B' THEN 'REBUILD INDEX '
WHEN 'D' THEN 'CHECK DATA LOG(NO) '
WHEN 'F' THEN 'COPY FULL YES '
WHEN 'I' THEN 'COPY FULL NO '
WHEN 'P' THEN 'RECOVER TOCOPY/TORBA '
WHEN 'Q' THEN 'QUIESCE '
WHEN 'R' THEN 'LOAD REPLACE LOG(YES) '
WHEN 'S' THEN 'LOAD [...]32_4C4DE2D5.6080008@realtimedba.com 6310 424 20_Re: Recylced TSO ids17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Mon, 26 Jul 2010 22:05:04 +0100649_iso-8859-1 If you go to the SQLAdria website, you can look for an interesting presentation about implementing a SYSADM-free DB2 environment at Unicredit, by Mirna Kos, from last year's lot of presentations.

It's in the page for last year's seminar in June, the link is http://www.ctk-rijeka.hr/SQLAdria/6-2009/default.htm

Thanks.

Aurora

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

CA Limited
Ditton Park, Riding Court Road, Datchet, SL3 9LL, UK [...]56_3D02E8610514C04F991CF832BA154C6613E1E42F@UKSLMS11.ca.com 6735 65 66_Tom Glaser is at the IBM Hazelwood Campus with no access to email.10_Tom Glaser25_tom_glaser@MASTERCARD.COM31_Tue, 27 Jul 2010 07:36:21 -0500657_US-ASCII I will be out of the office starting 07/27/2010 and will not return until
07/29/2010.

I'll pick up email in the evenings and return to the office on Thursday.

CONFIDENTIALITY NOTICE
This e-mail message and any attachments are only for the use of the intended recipient and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient, any disclosure, distribution or other use of this e-mail message or attachments is prohibited. If you have received this e-mail message in error, please delete and notify the sender immediately. Thank you. [...]72_OFAEED0CA6.E85CC50F-ON8625776D.00453F0A-8625776D.00453F0A@mastercard.com 6801 63 15_Re: COPY Status14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Tue, 27 Jul 2010 09:06:11 -0400403_utf-8 Anil,

I believe there may be occasions where a TS is in Copy Pending status but there is no corresponding non-logged event entry in SYSCOPY.

One case is when a LOAD REPLACE LOG NO abends in the Reload phase. The TS is placed in Copy Pending status (as well as Recover Pending) but there is no corresponding SYSCOPY entry (it gets added at the end of the Reload phase, I think). [...]72_4C9F8982DB3D124695B6B4621DA3700C2B26C7@SCCINDCE2K301-B.dm0001.info53.com 6865 132 15_Re: COPY Status13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Tue, 27 Jul 2010 08:16:28 -0500636_iso-8859-1 Sorry, didn't see the original post.
Could one scan for updates to DSNDB01 using one's favourite method?

Cheers,

Raymond

________________________________________
Raymond Bell
Senior Software Consultant
BMC Software

Phone: +44 (0) 1784 478 558
Mobile: +44 (0) 7894 608 214
Fax: +44 (0) 1784 478 753

Assurance House
Vicarage Road, Egham
Surrey TW20 9JY, United Kingdom

----- Original Message -----
From: IDUG DB2-L
To: DB2-L@IDUGDB2-L.ORG
Sent: Tue Jul 27 08:06:11 2010 Subject: Re: [DB2-L] COPY Status [...]67_78B3EFE2C0C5D74E9E7777D1D669D54211C8C98D@PHXCCRPRD04.adprod.bmc.com 6998 112 15_Re: COPY Status13_McDonald, Ken20_Ken_McDonald@BMC.COM31_Tue, 27 Jul 2010 09:50:55 -0500295_utf-8 You can look for the DBET (DataBase Exception Table) changes using DSN1LOGP using the SUBTYPE keyword to look for the DBET logs records. I thought you could use an OFFSET/VALUES pair to only report on the tablespace you care about, but it seemed to be ignored in my test. An example: [...]69_476996CBBE9AF14285E09E63C370072A148C1E9873@PHXCCRPRD01.adprod.bmc.com 7111 37 28_Rotate partition efficiently11_Sameer Rana21_sameerdrana@GMAIL.COM31_Tue, 27 Jul 2010 11:39:13 -0400421_UTF-8 Hello ,
I have been using rotate partition feature on one of our TB controlled tablespaces.
Although it has been serving the purpose it was meant for, the cost of running a ROTATE partition is too much. Moreover it runs for a long time ( 20 - 25mins for the humungous partition sizes we have ).
I have the RESET keyword in the ROTATE command meaning I am deleting the records in the oldest partition. [...]53_7850605334954371.WA.sameerdranagmail.com@www.idug.org 7149 58 32_Re: Rotate partition efficiently13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Tue, 27 Jul 2010 11:48:48 -0400352_utf-8 If you really don't want the data then, yes, LOAD REPLACE before you rotate IS going to speed things up

Most of the rotation time wil be deleting the rows from the partition (in case you issue a ROLLBACK instead of a COMMIT!)

BE WARNED though

Make sure you do LOAD REPLACE the RIGHT partition (it's not always "PART 1") [...]60_4440F5DA00E3F3459BBCB97431B91B6612B8FDBA0F@MAILR004.mail.lan 7208 46 9_Question.10_Bruce Cain13_cainb@GAO.GOV31_Tue, 27 Jul 2010 15:19:49 -0400575_ISO-8859-1 Hi All,

I'm new to this group as I have just been assigned a new responsibility:
I have been tasked with giving our auditors info on how to list DB2
authorizations on databases that are NOT externally controlled. I worked
with DB2 a number of years ago (almost as many as the gray hairs on my
head) and I seem to remember that there is a SELECT statement one can
use against (I believe, correct mt if I'm wrong) a table called
SYSDBAUTH. What they want is to be able list all GRANTs against tables,
views, whatever but exclude the [...]24_4C4F3155.5050107@gao.gov 7255 251 37_InfoSphere Change Data Capture - Beta12_Kimberly May28_kim.may@THEFILLMOREGROUP.COM31_Tue, 27 Jul 2010 16:51:16 -0400446_us-ascii IBM is working on a new version of InfoSphere Change Data Capture (ICDC).
The beta is being released this September. As The Fillmore Group sells ICDC
and provides implementation and support services, as well as ICDC training,
I am trying to identify an organization that uses replication and wants to
work with us to test the beta software to confirm its functionality for
replication between Oracle and DB2 for LUW. [...]41_4c4f46ca.9f59e60a.7c60.7efd@mx.google.com 7507 90 13_Re: Question.14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 27 Jul 2010 16:51:46 -0400481_us-ascii Bruce,
I believe that what you're looking for is the contents of several tables:
1) SYSIBM.SYSTABAUTH (assuming this is the mainframe we're discussing here) for explicit table/view-level grants. You would be concerned with the columns:
a) GRANTEE,
b) GRANTEETYPE ("P" here means the GRANTEE is a PLAN or PACKAGE, so you might not be interested in it.
c) TCREATOR.TTNAME for the name of the resource
d) DELETEAUTH, INSERTAUTH, SELECTAUTH, UPDATEAUTH [...]64_1BA00CBB414DA34AA25ED82F4647CDE2036225E432@MAIL02.fisalan.nycnet 7598 40 43_True Performance within the New zEnterprise11_Dave Beulke19_dave@DAVEBEULKE.COM31_Tue, 27 Jul 2010 20:27:08 -04000_51_3258359730167025.WA.davedavebeulke.com@www.idug.org 7639 158 32_Re: Rotate partition efficiently0_24_hhuang@DCCSH.ICBC.COM.CN31_Wed, 28 Jul 2010 15:34:02 +0800651_GB2312 Sameer,

If you really do NOT want the data in the partition to be ROTATEd online
any more,
I highly recommand you to unload/download the data from the partition
first and then,
LOAD REPLACE with DUMMY, before you ROTATE. This definitely will speed up.
And more, dig deeper, you can REORG your SYSLGRNX, make your MODIFY done
properly,
check some specific PTF applied (which I can't recall exactly, but you can
look up for
"NOTIFY") before ROTATE.
And some "extreme" actions includes, enlarge your index SYSIBM.DSNDPX03
PCTFREE and REBUILD
it, get rid of GBPD interest on DSNPDX03, even shut down [...]69_OF3F6DB8A0.4E034059-ON4825776E.00278AF6-4825776E.002991AF@icbc.com.cn 7798 32 54_Re: DB2 z/OS V9 Reorg Shrlevel Change/Reference Build214_Amardeep Singh19_techgoldy@YAHOO.COM31_Wed, 28 Jul 2010 08:10:42 -0400798_- Hi,

You had mentioned about putting the partitions in the AREO status by running undocumented REPAIR syntax can you please advise or give more details on this REPAIR syntax, we have similar situation and I want to try your solution

Thanks in advance

Regards,
Amardeep Singh

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* 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 [...]51_3500328048144586.WA.techgoldyyahoo.com@www.idug.org 7831 211 39_DB2 Managed Flashcopy on Z/os Version 915_Schade, Jeffrey15_JSchade@ISO.COM31_Wed, 28 Jul 2010 08:19:15 -0400418_us-ascii Does anyone have any experience with implementing/supporting IBM DB2
Managed Flashcopy in DB2 Z/OS version 9. My company is thinking about
using this approach to take a daily backup of our DB2 data in order to
replace our current bi-weekly process which uses LOG SUSPEND. I would
appreciate any information regarding implementation, ease of use and of
course any gotchas to watch out for. [...]59_DB138660B6B01D458B16F9205C0C263418476280@ISOEMAILP3.iso.com 8043 137 13_Re: Question.13_Joehlin, Gary26_Gary.Joehlin@SALLIEMAE.COM31_Wed, 28 Jul 2010 08:34:06 -0400617_us-ascii Bruce,

If you have the DB2-RACF security exit active then the answer to the question may require additional research above the queries against the DB2 "AUTH" tables.

When a DB2 object is being accessed, this exit is driven and the external security is checked by RACF with what resources have been defined as being protected by it, which may not necessarily be all of them. This, then makes the entries in the DB2 "AUTH" tables superfluous and not relevant in the security checking. The "AUTH" entries can remain even after the external interface is installed. So, to properly answer your [...]70_13D67285E468EF43A05E85E9A9AE8AA98F1AD24760@VFIEXMBX01.us.ad.usa-ed.net 8181 217 54_Re: DB2 z/OS V9 Reorg Shrlevel Change/Reference Build211_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 28 Jul 2010 14:40:48 +0200495_ISO-8859-1 not me! Undocumented REPAIR syntax and/or other tricks are pretty
dangerous as IBM can release an APAR or RSU and it will be *gone* and as
it was undocumented there will not even be a little HOLD to warn
you....very dangerous thing to use!

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 [...]64_OFB115334E.5D1AF69B-ONC125776E.00458A7E-C125776E.0045A748@seg.de 8399 350 54_Re: DB2 z/OS V9 Reorg Shrlevel Change/Reference Build216_Christian Michel18_cmichel@DE.IBM.COM31_Wed, 28 Jul 2010 14:49:28 +0200425_ISO-8859-1 If you're looking for a way to REORG multiple non-contiguous partitions in
one run, you can subscribe to PTFs UK59095 for PK87762 and UK59096 for
PM13259 which should hit the street in about two weeks. These will provide
support for multiple partition ranges specified in one REORG statement,
e.g. REORG ... PART(2,7:12,18,20:24).

Mit freundlichen Grüßen / Kind regards
Christian Michel [...]68_OFA3C0661C.1290709E-ONC125776E.0045F7D8-C125776E.0046716C@de.ibm.com 8750 141 53_Betr: [DB2-L] DB2 Managed Flashcopy on Z/os Version 915_Marcel Harleman31_mam.harleman@BELASTINGDIENST.NL31_Wed, 28 Jul 2010 15:14:33 +0200604_us-ascii Hi,

we are currently using it to backup a production system.

There were a couple of problems implementing it. Right at this moment I
can't find the complete overview, but I'll look for it. For now the things
that I remember...

The first issue we ran into was our use of PPRC. In order to use flashcopy
you towards a PPRC primary volume you have to set parameter FCTOPPRCPRIMARY
to YES. However, our storagebox at that time did not support it, we had to
wait for a new microcode level. When that microcodelevel was installed we
(or better: the support [...]76_OFABB5C205.894A213C-ONC125776E.00466C6E-C125776E.0048BE6C@belastingdienst.nl 8892 27 32_Re: Rotate partition efficiently11_Sameer Rana21_sameerdrana@GMAIL.COM31_Wed, 28 Jul 2010 09:55:35 -0400678_UTF-8 Thanks a lot Huang!

I will keep this considerations in mind.

Regards,
Sameer

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* 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_8100168963624950.WA.sameerdranagmail.com@www.idug.org 8920 148 35_DB2 for z/OS V8 - abend in DSNTIAUL12_Jim McAlpine22_jim.mcalpine@GMAIL.COM31_Wed, 28 Jul 2010 15:07:54 +0100764_ISO-8859-1 I'm just about to upgrade a DB2 subsystem from V8 to V9 so I'm running
DSNTIJPM but it abends like so -

READY
DSN SYSTEM(DB2D)
DSN
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB81) PARMS('SQL')
LIB('DSN810.RUNLIB.LOAD')
IKJ56641I DSN ENDED DUE TO ERROR+
IKJ56641I SYSTEM ABEND CODE 0C4 REASON CODE 00000010
I've reassembled it but to no avail. The abned looks like this -

RTM2WA SUMMARY
--------------
+001C COMPLETION CODE 840C4000
+008C ABENDING PROGRAM NAME/SVRB ADDRESS DSNTIAUL
+0094 ABENDING PROGRAM ADDR 0005D0A0
GPRS AT TIME OF ERROR
0-3 00068158 00068158 0064FFFC 001FFFB8
4-7 00000000 0000004C 000093E3 00067F88
8-11 0000D310 00070A7B 00067C18 0005E0A0
12-15 0005D0A0 00067C18 5005D9F8 [...]60_AANLkTimePrzjDhmKRSQiFwPNHxqEdRxo2RH1xYfR9hLS@mail.gmail.com 9069 285 39_Re: DB2 for z/OS V8 - abend in DSNTIAUL0_14_cowletw@NU.COM31_Wed, 28 Jul 2010 10:08:45 -0400561_US-ASCII Try increasing the REGION parameter for the job.

Theodore W. Cowles
Northeast Utilities - ITMVS
107 Selden Street
Berlin, CT 06037-1616
phone: (860) 665-2738
fax: (860) 665-3318
email: cowletw@nu.com

From: Jim McAlpine
To: DB2-L@IDUGDB2-L.ORG
Date: 07/28/2010 10:06 AM
Subject: [DB2-L] DB2 for z/OS V8 - abend in DSNTIAUL
Sent by: IDUG DB2-L

I'm just about to upgrade a DB2 subsystem from V8 to V9 so I'm running
DSNTIJPM but it abends like so - [...]64_OFFED14E4B.704C6FCA-ON8525776E.004DA544-8525776E.004DEDEE@NU.COM 9355 488 57_Re: Betr: [DB2-L] DB2 Managed Flashcopy on Z/os Version 915_Schade, Jeffrey15_JSchade@ISO.COM31_Wed, 28 Jul 2010 10:16:19 -0400699_us-ascii Hi Marcel,

This is great information. It is always a good idea to talk with the
people who support these solutions before jumping right in.

Thank You.

Jeff

_________________________________________
Jeffrey Schade

Systems Consultant, Technology Engineering

ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738

FAX: (201) 748-1500
jschade@iso.com

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Marcel
Harleman
Sent: Wednesday, July 28, 2010 9:15 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Betr: [DB2-L] DB2 Managed Flashcopy on Z/os Version 9 [...]59_DB138660B6B01D458B16F9205C0C263418476284@ISOEMAILP3.iso.com 9844 119 39_Re: DB2 for z/OS V8 - abend in DSNTIAUL14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Wed, 28 Jul 2010 10:25:36 -0400450_iso-8859-1 Jim,

Call me crazy, but ... the code looks like it's doing a GET for input. What have you got in the JCL for //SYSIN ? Is it a valid dataset that's got content, and is not migrated?

Lock Lyon
Fifth Third Bancorp

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jim McAlpine
Sent: Wednesday, July 28, 2010 10:08 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] DB2 for z/OS V8 - abend in DSNTIAUL [...]72_4C9F8982DB3D124695B6B4621DA3700C2B26D9@SCCINDCE2K301-B.dm0001.info53.com 9964 71 39_Re: DB2 for z/OS V8 - abend in DSNTIAUL12_Jim McAlpine22_jim.mcalpine@GMAIL.COM31_Wed, 28 Jul 2010 15:37:57 +0100365_ISO-8859-1 On Wed, Jul 28, 2010 at 3:25 PM, Lyon, Lockwood wrote:

> Jim,
>
> Call me crazy, but ... the code looks like it's doing a GET for input.
> What have you got in the JCL for //SYSIN ? Is it a valid dataset that's
> got content, and is not migrated?
>
> Lock Lyon
> Fifth Third Bancorp
>
> Lyon, [...]60_AANLkTimX137obHwfsVqxH7TzfYTXJ-Jj9GqNmY7NYjsH@mail.gmail.com 10036 34 18_Recovery Scenarios4_Anil21_alisha_kale@YAHOO.COM31_Wed, 28 Jul 2010 11:39:50 -0400408_UTF-8 Hi All !

I am looking for a redbook/redpaper/whitepaper/manual/document that describes the various recovery scenarios for an application DBA for DB2 on z/os. The idea is to create some recovery examples/scenarios for a junior DBA.
Please share with me if you know of any good redbook/redpaper/whitepaper/manual/document that can be used to get a comprehensive list of recovery examples. [...]52_5004117720468295.WA.alishakaleyahoo.com@www.idug.org 10071 156 71_What role does JES play in DB2 z/OS Connections from CICS, TSO and CAF?23_ANDERSON Margaret * SDC29_margaret.anderson@STATE.OR.US31_Wed, 28 Jul 2010 10:41:39 -0700551_us-ascii Greetings all,
We are DB2 V8 NFM with no Data Sharing. We just did a z/OS upgrade on
one of our Production LPARs Sunday and ran into something that has us
all curious. When the z/OS guys copied the entries from the previous
z/OS PARMLIB to the new one for the IEFSSNxx (Subsystem Name Table)
members, they decided to set up a new member scheme and concatenation of
three members. In doing so they accidentally caused two situations that
gave DB2 heartburn and we almost backed out the z/OS upgrade because of
it. [...]66_4BD752C728FD8C43A7940818DD4A1E9B0654526F@exchnode02.ad.state.or.us 10228 216 21_DB2 V9 NFM, z/os 1.1016_Proctor, William25_William.Proctor@TGSLC.ORG31_Wed, 28 Jul 2010 12:49:08 -0500562_us-ascii Thanks for all replies in advance. I am using the Optimization Service Center to try and tune several queries. After explaining the query and running all advisors it shows that I need to run statistics on several of the tables. I took the suggestions and ran the statistics just like it suggested. I then reran the explain and advisors. Several of the suggestions did clear up but most of them did not and it keeps suggesting that I run the same ones over and over. Is there something that I should be resetting prior to doing the runstats? Why is [...]65_550D0016ABCA22488AD932ACA94AC56836495ACE87@CORPEXCHMBOX.tgslc.org 10445 121 22_Re: Recovery Scenarios4_Rods19_custodior@GMAIL.COM31_Wed, 28 Jul 2010 15:25:33 -0300828_ISO-8859-1 Try out this redbook:

http://www.redbooks.ibm.com/abstracts/sg246370.html

__________________________________________________________
Rodolfo Custodio

On Wed, Jul 28, 2010 at 12:39 PM, Anil wrote:

> Hi All !
>
> I am looking for a redbook/redpaper/whitepaper/manual/document that
> describes the various recovery scenarios for an application DBA for DB2 on
> z/os. The idea is to create some recovery examples/scenarios for a junior
> DBA.
> Please share with me if you know of any good
> redbook/redpaper/whitepaper/manual/document that can be used to get a
> comprehensive list of recovery examples.
>
> Thanks.
>
> Anil
>
> _____________________________________________________________________
> * IDUG EMEA * [...]60_AANLkTimwe0WN-OGvfX2nTbNNrB5+10=OtNXsgN7ZDU9x@mail.gmail.com 10567 88 25_Re: DB2 V9 NFM, z/os 1.1012_Martin Hubel17_Martin@MHUBEL.COM31_Wed, 28 Jul 2010 14:38:18 -04000_43_DB2-L%201007281438276732.27D1@IDUGDB2-L.ORG 10656 120 25_Re: DB2 V9 NFM, z/os 1.1013_David Simpson22_dsimpson@THEMISINC.COM31_Wed, 28 Jul 2010 14:04:42 -0500509_iso-8859-1 I would also distinguish between the high priority recommendations anld the low priority ones. I have started ignoring the low priority since they seem to be the most flakey.

-----Original Message-----
From: Martin Hubel
Sent: Wednesday, July 28, 2010 2:01 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] DB2 V9 NFM, z/os 1.10

Hi Bill,
I had a similar experience with the V9 OSC. Some recommendations would never go away. [...]46_000a01cb2e87$b0e3d7cb$0a0b010a@themisinc.local 10777 215 20_Removing runstats ??9_Dee Reins21_rcwingman@COMCAST.NET31_Wed, 28 Jul 2010 20:16:11 +0000523_utf-8 I am doing runstats for my database.

LISTDEF DBMRG2STAT

INCLUDE TABLESPACE DBMRG2.*

INCLUDE TABLESPACE DBTRG2.*

RUNSTATS TABLESPACE LIST DBMRG2STAT TABLE ALL

INDEX (ALL KEYCARD FREQVAL NUMCOLS 1 COUNT 10)

HISTOGRAM NUMCOLS 8

RUNSTATS TABLESPACE DBMRG2.TSMR112 TABLE(CTMRG2.VMR112LE_FACS)

COLUMN(SW_SITE_CD , LE_SW_ID , LE_FRMT_CD , LE_ID)

REPORT YES SHRLEVEL CHANGE

I would like to remove the column group runstats, and keep the other stats. [...]84_2144025941.504347.1280348171821.JavaMail.root@sz0025a.emeryville.ca.mail.comcast.net 10993 70 25_Re: DB2 V9 NFM, z/os 1.1010_Joe Geller21_joerg6666@HOTMAIL.COM31_Wed, 28 Jul 2010 16:18:41 -0400327_UTF-8 The list of recommendations is often for more than is needed to solve the
query you are working on. I had one performance problem where OSC
recommended about 6 different colgroups / columns to gather distribution stats
on. It turned out that only one of the columns was needed to get a good
access path. [...]53_5679257043506099.WA.joerg6666hotmail.com@www.idug.org 11064 501 25_Re: DB2 V9 NFM, z/os 1.1018_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM31_Wed, 28 Jul 2010 15:11:15 -0700466_us-ascii Hello Bill,

We are using Data Studio (the tool that is replacing/replaced OSC). We see the same kind of behavior in this tool as well. Even after running the stats recommended by the tool, we still see the same recommendations/suggestions coming up again.

I can tell you that high and medium recommendations are getting cleared up after running the stats based on the recommendations but the low maintenance ones are not getting cleared. [...]55_D42E68651088914B9B327A4EEA8433ACAE56362E@VM251.apsc.com 11566 55 4_Test10_Mark Labby21_mlabby.idug@GMAIL.COM31_Wed, 28 Jul 2010 19:39:31 -0400700_UTF-8 I apologize for the test message. I just had to verify that a setting change did not disrupt the list distribution.

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* 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_9356420300207341.WA.mlabby.iduggmail.com@www.idug.org 11622 286 25_Re: DB2 V9 NFM, z/os 1.1012_myron miller22_myronwmiller@YAHOO.COM31_Wed, 28 Jul 2010 19:53:04 -0400608_iso-8859-1 I've had an open PMR with IBM about the repeating stats for well over two years now. They've improved it substantially with OSC 1.1.7 and several index fixes, but I still get sometimes high priority recommendations that repeat them selves over and over again. Its better but not there yet. I've generally found that except for the repetitions that adding all the recommended stats sooner or later makes a difference on queries I'm tuning. So I do as a standard practice all recommended (HIGH ONLY) stats. More stats is not badness generally (usually). Not having enough is almost always bad. [...]43_E23ADFF54D8E451FA12A1ECBAE2A07CA@premierhp2 11909 526 25_Re: DB2 V9 NFM, z/os 1.1012_myron miller22_myronwmiller@YAHOO.COM31_Wed, 28 Jul 2010 19:55:38 -0400312_iso-8859-1 IBM has told me that they keep the low priority recommendations all the time no matter what because that's considered a baseline complete set. At least that was their comments when I asked about it. My practice is do the high and medium and ignore the low. They're a waste of time and resources. [...]43_79F594785A324F3F91E6DEC2A2103BF3@premierhp2