1 IDUGDB2-L.ORG /home/listserv/home/db2-l August 2010, week 4 2 409 54_Re: DB2 Z/os V8 - 10 jump experiences, recommendations6_Leslie21_db2dba@BTINTERNET.COM31_Sun, 22 Aug 2010 19:46:06 +0100474_us-ascii Hi Missy

you've had some really good points put by the guys here.

However, If it were me running the five way data sharing system I'd be
recommending to my management stability and as such I'd not want to jump the
two steps.

Version 10 looks to be a good version, however, so is version 9 and unless
I'm missing something two jumps in release just causes a huge amount of pain
in deprecated items and double the optimizer hit. [...]41_2781A13DC7194C93B7E4EE8677AC4CAA@OfficePC 412 38 54_Re: DB2 Z/os V8 - 10 jump experiences, recommendations11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Sun, 22 Aug 2010 20:32:27 +0000328_Windows-1252 >What worries me more is that people just start assuming and telling management that version 8 to 10 is no great deal and "others" are doing it ...

I'd do it, only if I don't care about potential outages and the effect on the business.

Taking short-cuts like that can be severly career limiting. [...]103_53521281-1282509142-cardhu_decombobulator_blackberry.rim.net-1465661174-@bda026.bisx.prod.on.blackberry 451 231 37_Re: IBM Reorg with Switch Phase Issue11_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 23 Aug 2010 06:59:16 +0200710_ISO-8859-1 sounds kinda like REORG time for the catalog here...1 minute for 64
updates sounds a bit excessive...mind you if its doing the physical rename
then it could be a IO problem...

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: Gerhard Schubert

Tom Glaser
Gesendet von: IDUG DB2-L
20.08.2010 18:23
Bitte antworten an
IDUG DB2-L [...]64_OF100B9E97.55881134-ONC1257788.001B4DE7-C1257788.001B66A1@seg.de 683 99 54_Re: DB2 Z/os V8 - 10 jump experiences, recommendations6_Leslie21_db2dba@BTINTERNET.COM31_Mon, 23 Aug 2010 08:09:38 +0100507_iso-8859-1 Ted
Now that;s what I'm talking about ... Having the whole meal in one sitting
... Just wories the bejeebers out of me .. I've seen enopug "controlled"
issues from v3 through DB2 9 to make me re-think any move over two releases.

One spin I would like to put on things is that we still have (one of) the
best migration system out there, when I see UDB, SQL Server and the other
thing they call a database (oh Oracle) I just laugh at the "wing it"
approach they have. [...]41_872ACC59B20E419FB619905DA31D6428@OfficePC 783 126 48_DB2 z/OS Explain - strange cardinality with SORT12_Marc vd Valk34_mw.van.der.valk@BELASTINGDIENST.NL31_Mon, 23 Aug 2010 10:12:13 +0200581_us-ascii Hello list,

With Visual Explain I do an explain of a relative simple query and see
something strange with the input and output cardinality of a sort (sort
for join, NO distinct/group by/order by in the query):

Input Cardinality 1.26972E9
Output Cardinality 7.567133E7

How can a sort "delete" so many rows in a sort for a join (I repeat: NO
distinct/group by/order by in the query)? The three sort-columns together
have a much higher cardinality then the 75 million, so it is no't
duplicate removal. The basic statistics are ok. [...]76_OFE1BFD0A5.60BBB9DA-ONC1257788.002AB9B4-C1257788.002D1128@belastingdienst.nl 910 269 52_Re: DB2 z/OS Explain - strange cardinality with SORT11_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 23 Aug 2010 10:35:13 +0200520_ISO-8859-1 hi!
You say "sort for join" so DB2 takes its best guess at how many rows will
qualify in the join. It thinks 7.56 E7 - reality is different and 100%
qualify hence the BOOM on the sort work..
It would be interesting to see the full EXPLAIN output just to try and
figure out why it thinks only 5.9% qualify...
You also mention "the basic stats" - What about all the others??? I would
guess that skewed filter factors are the root cause... (Timestamps or
decimal fields are common!) [...]64_OF7242BA00.13735DBE-ONC1257788.002EB51E-C1257788.002F2B79@seg.de 1180 422 66_Betr: Re: [DB2-L] DB2 z/OS Explain - strange cardinality with SORT12_Marc vd Valk34_mw.van.der.valk@BELASTINGDIENST.NL31_Mon, 23 Aug 2010 10:49:55 +0200369_iso-8859-1 Hello Roy,

thanks for your quick response.

The sort is after the first nested loop join (which returns 1.2 billion
rows) and before the join with the third table, so in my opinion NO
predicates are evaluated in the sort.

What is the most common way to share Explain output on the list?

Thanks!

Marc van der Valk [...]76_OF600D1439.DD21EE60-ONC1257788.00300528-C1257788.003084C6@belastingdienst.nl 1603 692 70_Re: Betr: Re: [DB2-L] DB2 z/OS Explain - strange cardinality with SORT11_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 23 Aug 2010 11:20:02 +0200732_ISO-8859-1 Just a cut-and-paste from the "best of" columns from PLAN_TABLE in some
non-proportional font (Courier New et al)
I use

SELECT SUBSTR(A.PROGNAME, 1 , 8 ) AS PROGNAME,
SUBSTR(DIGITS(A.QUERYNO), 6, 5) AS LINE,
SUBSTR(DIGITS(A.QBLOCKNO), 4, 2) AS QNO,
SUBSTR(DIGITS(A.PLANNO), 4, 2) AS PNO,
SUBSTR(DIGITS(A.MIXOPSEQ), 4, 2) AS SQ,
SUBSTR(DIGITS(A.METHOD), 5, 1) AS M,
SUBSTR(A.TNAME, 1, 12) AS TABLE_NAME,
A.ACCESSTYPE AS A,
SUBSTR(DIGITS(A.MATCHCOLS), 4, 2) AS CS,
SUBSTR(A.ACCESSNAME, 1, 14) AS INDEX,
A.INDEXONLY AS IO,
SUBSTR(CASE SORTN_UNIQ WHEN 'N' THEN '-' ELSE 'Y' END ||
CASE SORTN_JOIN WHEN 'N' THEN '-' ELSE 'Y' END ||
CASE SORTN_ORDERBY WHEN 'N' THEN '-' [...]64_OF726AFC27.FE6B5D2A-ONC1257788.0033435A-C1257788.003345D9@seg.de 2296 161 45_Redbook DB2 9 for z/OS and Storage Management10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 23 Aug 2010 08:43:58 -0400688_Windows-1252 Hi DB2 user,

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

Last update on Monday, August 23rd 2010

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS and Storage Management, SG24-7823-00".

Abstract
This IBM Redbooks publication will help you tailor and configure DFSMS constructs to be used in a DB2 9 for z/OS environment. In addition, it provides a broad understanding of new disk architectures and their impact in DB2 data set management for large installations.
This book addresses both the storage administrator and the DB2 administrator. The DB2 administrator will [...]43_SNT118-W59AD0D5ADB731D5E624853AF820@phx.gbl 2458 408 54_Re: DB2 Z/os V8 - 10 jump experiences, recommendations10_Roger Hecq18_roger.hecq@UBS.COM31_Mon, 23 Aug 2010 09:36:24 -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_1A700EEF49343148A08879B1E3CA5BA615FE1924@NSTMC101PEX1.ubsw.net 2867 73 53_Re: performance of VARCHAR columns as part of IN LIST13_Terry Purcell18_tpurcel@US.IBM.COM31_Mon, 23 Aug 2010 10:09:28 -0400619_UTF-8 Hi Larry,

I cannot speak with authority for non-z/OS platforms.

As for DB2 for z/OS, non-matching is non-matching. So when I refer to the sort only occurring for matching, then all other cases such as non-matching index predicate evaluation (index screening with index-only or index+data) or stage 1 or 2 predicate evaluation all do not sort the IN-lists. This provides you the opportunity to code your IN-lists to have the most frequently occurring values early in the IN-list so that a match can be found quicker in those situations - although I agree there is opportunity for DB2 to enhance [...]50_4105965255875775.WA.tpurcelus.ibm.com@www.idug.org 2941 42 17_Dynamic SQL Issue21_Devyani Sahasrabuddhe30_devyanisahasrabuddhe@GMAIL.COM31_Mon, 23 Aug 2010 11:21:28 -0400616_UTF-8 Hello List,

I am working on dynamic SQL after a long time. Actually coding a rexx to fetch the last run image copy on the tablespaces. I have been coding and testing simeltaneously. Below is my query

SELECT MAX(DATE(TIMESTAMP))
FROM SYSIBM.SYSCOPY
WHERE DBNAME =vdbname
AND TSNAME=vtsname
with UR"

Initially timestamp column was spelled wrong due to which I was getting -206 but now I have coded it right and when I rerun the REXX, getting same -206 again. Is this something related to caching of SQL but if the SQL is not prepared successfully, how will it pick up wrong [...]62_1922732554582700.WA.devyanisahasrabuddhegmail.com@www.idug.org 2984 61 21_Re: Dynamic SQL Issue14_Steurs Patrick21_Patrick.Steurs@NBB.BE31_Mon, 23 Aug 2010 17:33:09 +0200522_utf-8 Is this a rexx-stored-procedure ?

greetings,

Patrick Steurs

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Devyani Sahasrabuddhe
Sent: maandag 23 augustus 2010 17:21
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Dynamic SQL Issue

Hello List,

I am working on dynamic SQL after a long time. Actually coding a rexx to fetch the last run image copy on the tablespaces. I have been coding and testing simeltaneously. Below is my query [...]60_96DBEA7143ECD048905FAAA27D86E0D212E407E2@VSRBEX10.LANPRD.NBB 3046 78 21_Re: Dynamic SQL Issue14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 23 Aug 2010 11:57:50 -0400586_us-ascii Devyani,

This works fine for me in QMF:
SELECT MAX(DATE(TIMESTAMP))
FROM SYSIBM.SYSCOPY
WHERE DBNAME ='dddddddd'
AND TSNAME='ssssssss'
WITH UR

With real values substituted for the d's and s'es. Could this be a problem with your REXX code's translation of the SQL? (Have you tried your code in SPUFI or QMF?)
--Phil

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Devyani Sahasrabuddhe
Sent: Monday, August 23, 2010 11:21 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Dynamic SQL Issue [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF956@MAIL02.fisalan.nycnet 3125 26 21_Re: Dynamic SQL Issue21_Devyani Sahasrabuddhe30_devyanisahasrabuddhe@GMAIL.COM31_Mon, 23 Aug 2010 12:20:32 -0400680_UTF-8 yeah! it runs perfectly fine in spufi. I am wondered to see how come it fails in REXX though....

Thanks,
Devyani

_____________________________________________________________________
* 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!
_____________________________________________________________________ [...]62_1594448511486179.WA.devyanisahasrabuddhegmail.com@www.idug.org 3152 73 21_Re: Dynamic SQL Issue14_Fazio, Richard21_RFAZIO@TRANSUNION.COM31_Mon, 23 Aug 2010 11:29:37 -0500483_us-ascii That trailing quote makes me think the set-up of the SQL-STMT may be in
error.

Can you reply back with the raw syntax for your SQL Stmt as well as the
full output from dsntiar? Hint: which column is having the issue.

faz

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@idugdb2-l.org] On Behalf Of Devyani
Sahasrabuddhe
Sent: Monday, August 23, 2010 10:21 AM
To: DB2-L@idugdb2-l.org
Subject: [DB2-L] Dynamic SQL Issue [...]70_0CF187805D9C924DAFF59A877104C36A04C0D586@CHI4EVS04.corp.transunion.com 3226 23 21_Re: Dynamic SQL Issue21_Devyani Sahasrabuddhe30_devyanisahasrabuddhe@GMAIL.COM31_Mon, 23 Aug 2010 12:21:53 -0400634_UTF-8 This is not a stored procedure. I am running this in the batch using IRXJCL.

_____________________________________________________________________
* 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!
_____________________________________________________________________ [...]62_4562153453321972.WA.devyanisahasrabuddhegmail.com@www.idug.org 3250 481 39_Re: [AD] IDUG EMEA - City Airport Train14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 23 Aug 2010 13:14:29 -0400299_iso-8859-1 Jeez, Cathy, you got me all hopeful. But... my parents live in the NE quadrant of Portland, and if I want to get there by Trimet, I have to be out of the airport by 6:35 PM. Which isn't good if I'm trying to get there after work on Friday. Oh, well, they still have taxis.
--Phil [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF957@MAIL02.fisalan.nycnet 3732 175 21_Re: Dynamic SQL Issue7_Ed Long19_rdhm99a@PRODIGY.NET31_Mon, 23 Aug 2010 10:16:58 -0700505_iso-8859-1 I was curious about the right side values in the where clause equates.
Should they not be prefixed with a colon as in :vdbname not vdbname?

Edward Long

--- On Mon, 8/23/10, Fazio, Richard wrote:

From: Fazio, Richard
Subject: Re: [DB2-L] Dynamic SQL Issue
To: DB2-L@IDUGDB2-L.ORG
Date: Monday, August 23, 2010, 12:29 PM

That trailing quote makes me think the set-up of the SQL-STMT may be in
error. [...]43_683477.43549.qm@web80208.mail.mud.yahoo.com 3908 49 21_Re: Dynamic SQL Issue9_Sam Baugh24_Sam.Baugh@MOTION-IND.COM31_Mon, 23 Aug 2010 12:47:24 -0500570_utf-8 Pay attention to use of quote marks and continuation in REXX.

Sqlstmt = "SELECT MAX(DATE(TIMESTAMP))ā€ˇ",
"FROM SYSIBM.SYSCOPY", ā€ˇ
"WHERE DBNAME = '"vdbname"'", ā€ˇ
"AND TSNAME='"vtsname"'", ā€ˇ
"with UR"

or ā€ˇ

Sqlstmt = 'SELECT MAX(DATE(TIMESTAMP))',ā€ˇ
ā€ˇ'FROM SYSIBM.SYSCOPY', ā€ˇ
ā€ˇ'WHERE DBNAME = '''vdbname''', ā€ˇ
ā€ˇ'AND TSNAME='''vtsname''', ā€ˇ
ā€ˇ'with UR'ā€ˇ

If this will be executed often, use parameter markers instead of host variable names so that the SQL only has to be prepared once. [...]73_1A20EF32A1A1CA44B36AF5D69203972216465315FE@MIHQPEXMB1.corp.motion-ind.com 3958 53 33_Read and update of uncommited row12_Amlan Prasad16_amlan_pd@MSN.COM31_Mon, 23 Aug 2010 13:55:21 -0400364_UTF-8 Hi, I will request suggestion and recommendation to handle below scenario.

Program A - main driver COBOL without any DB2 statement invoked in JCL.
Program B - COBOL-DB2 program called by A which inserts new rows in a table (lets say T1)
Program C - another COBOL-DB2 program called by A which has to read table T1 and also update the rows. [...]47_1243748483843982.WA.amlanpdmsn.com@www.idug.org 4012 53 33_Read and update of uncommited row12_Amlan Prasad16_amlan_pd@MSN.COM31_Mon, 23 Aug 2010 13:48:57 -0400364_UTF-8 Hi, I will request suggestion and recommendation to handle below scenario.

Program A - main driver COBOL without any DB2 statement invoked in JCL.
Program B - COBOL-DB2 program called by A which inserts new rows in a table (lets say T1)
Program C - another COBOL-DB2 program called by A which has to read table T1 and also update the rows. [...]47_6021384877730025.WA.amlanpdmsn.com@www.idug.org 4066 72 37_Re: Read and update of uncommited row12_Tony Andrews22_tandrews@THEMISINC.COM31_Mon, 23 Aug 2010 14:39:49 -0400339_UTF-8 Amlan,

All programs will be part of the same logical unit of work, and thus will see each other's inserts and updates
whether program A, B, or C does commits or not.

Other programs running under a different thread will not see the newly inserted until a commit is done (unless they are
querying using 'UR'). [...]67_7EC87535E7581C4C890F5BF1CF9A9374029FC51C@THEMISSRV1.themisinc.local 4139 61 38_Re: Read and update of uncommitted row14_Doyle, Mark M223_mark.m2.doyle@CHASE.COM31_Mon, 23 Aug 2010 14:48:40 -0400548_utf-8 Amlan,
All my responses are theoretical, as I haven't tried to do any of these things, but they are based on a thorough knowledge of what constitutes "working as designed".

1) My question is that since B does not COMMIT, will the new rows inserted by it in T1 be available in the cursor of program C?
I doubt it (except as part of an UR cursor).
2) If available will it is also be possible to update the new row even the past insert is still not committed?
I doubt it. Your scenario would require each program to have [...]75_0BF6D36E311EAB4BA3F891660E254C363C2DDB7348@EMARC124VS01.exchad.jpmchase.net 4201 80 54_Re: DB2 Z/os V8 - 10 jump experiences, recommendations12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 23 Aug 2010 19:48:14 -0400539_UTF-8 Early code needs to be updated. In DB2 9, we added a REFRESH command, but you're not running that level yet. So you'll need an IPL to get the code up to level. The process is usually a bounce, one member at a time, where customers need to keep the group running. The early code update with an IPL has been needed for every prior release of DB2, but can be avoided where customers are running DB2 9. Info APAR II14474 notes the service for V8. II14477 is for DB2 9. As Max notes, you won't see customer experiences presentations [...]51_9038509039453620.WA.millerrlus.ibm.com@www.idug.org 4282 826 84_Betr: Re: [DB2-L] Betr: Re: [DB2-L] DB2 z/OS Explain - strange cardinality with SORT12_Marc vd Valk34_mw.van.der.valk@BELASTINGDIENST.NL31_Tue, 24 Aug 2010 07:12:55 +0200322_iso-8859-1 Hello Roy,

at this time a new explain is not possible: the guys at production have
manipulated some statistics to get a better access path. The only thing I
have is an xml file, saved from Visual Explain (tab "Access Plan" => "Save
XML File". I can send you that offline if you would like. [...]76_OFEC8BFF95.3E03331E-ONC1257789.001C2C35-C1257789.001CAD6D@belastingdienst.nl 5109 383 128_The DB2Night Show Episode #27 - "DB2 in the Cloud - Tech Details Part 2", with Mark Wilding, IBM - Friday 27 August 10 am US CDT13_David Chapman24_David.Chapman@IAG.COM.AU31_Tue, 24 Aug 2010 18:08:18 +1000574_us-ascii _______________________________________________________________________________________

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

Hi DB2 List,

The DB2Night Show Episode #27 - "DB2 in the Cloud - Tech Details Part 2", with Mark Wilding, IBM

The International DB2 Users Group (IDUG) is pleased to partner with DBI to deliver a free Webcast by renowned presenter Scott Hayes, President & CEO, DBI. [...]43_DB2-L%201008240408408534.33CF@IDUGDB2-L.ORG 5493 210 54_Re: DB2 Z/os V8 - 10 jump experiences, recommendations10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 24 Aug 2010 10:42:49 +0200662_UTF-8 Hi Roger

Is it requested a particular CF level for DB2 10 ? I found no reference
about minimum CF level in your presentation. For V9 I read suggested
CFLEVEL is 12,13,14,15 or 16.

Max Scarpa

IDUG DB2-L wrote on 24/08/2010 01.48.14:

> From: Roger Miller
> To: DB2-L@IDUGDB2-L.ORG
> Date: 24/08/2010 01.49
> Subject: Re: [DB2-L] DB2 Z/os V8 - 10 jump experiences, recommendations
> Sent by: IDUG DB2-L
>
> Early code needs to be updated. In DB2 9, we added a REFRESH
> command, but you're not running that level yet. So you'll need [...]66_OF297C4159.A9503B3F-ONC1257789.002C4269-C1257789.002FDA7B@cesve.it 5704 96 45_AW: [DB2-L] Read and update of uncommited row35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Tue, 24 Aug 2010 12:34:02 +0200824_iso-8859-1 Hi

To answer your questions in short:

1.) yes
2.) yes
3.) no
4.) no

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Systeme Laufzeitarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
walter.janissen@itergo.com

Vorsitzender des Aufsichtsrats: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996

-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Amlan Prasad
Gesendet: Montag, 23. August 2010 19:55
An: DB2-L@IDUGDB2-L.ORG
Betreff: [DB2-L] Read and update of uncommited row [...]43_DB2-L%201008240634111566.341A@IDUGDB2-L.ORG 5801 62 88_Re: Betr: Re: [DB2-L] Betr: Re: [DB2-L] DB2 z/OS Explain - strange cardinality with SORT13_Terry Purcell18_tpurcel@US.IBM.COM31_Tue, 24 Aug 2010 09:37:56 -0400382_UTF-8 Hi Marc,

As you have said, a sort should not reduce the number of rows unless it is supposed to remove duplicates. You mentioned GROUP BY, DISTINCT, but there is also when a correlated subquery is transformed to a join (all other subquery types will appear as a separate QB).

Since it doesn't appear to be one of the above, then you may have hit a problem. [...]50_4946359306697768.WA.tpurcelus.ibm.com@www.idug.org 5864 52 4_MQTs10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Tue, 24 Aug 2010 10:57:33 -0400347_UTF-8 Hi,

We have a situation where a table has got lots of months worth data.This table is updated by a nightly job. There is a 24x7 application that needs to query this table continuously, using some statistical functions like AVG, COUNT, etc. When the application was written to directly access the table, it was performing poorly. [...]54_7800552035384064.WA.teldb2kalstelstra.com@www.idug.org 5917 68 8_Re: MQTs13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Tue, 24 Aug 2010 11:26:54 -0400333_utf-8 Hi Kals

Yes - the MQT will be locked until the REFRESH is complete - so other queries will have to wait....

When you say " But I am unable to put a "WHERE DATE > current date - 90 days " clause as part of my MQT definition " - what error do you get? The syntax for an MQT ought to allow ANY valid fullselect [...]60_4440F5DA00E3F3459BBCB97431B91B6612B902CE51@MAILR004.mail.lan 5986 155 8_Re: MQTs13_Brian Stewart23_briankstewart@GMAIL.COM31_Tue, 24 Aug 2010 09:43:13 -0600348_ISO-8859-1 Hi -

You might want to look into the 'allow read access' clause of the refresh
command. Also, as a side note - you might also want to look into doing
incremental refreshes as these can save you a lot of time.

fwiw -

Brian

On Tue, Aug 24, 2010 at 8:57 AM, Teldb2kals wrote: [...]60_AANLkTin4KNTn+CS139xvnNizR4jS1T8bKwrDEPPg0SdA@mail.gmail.com 6142 24 42_How automated is your SAP Homogeneous copy10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Tue, 24 Aug 2010 10:59:31 -0400341_UTF-8 If you are running SAP on DB2 z/os and you do the homogeneous copy how automated is the process and do you use any tools?
It seems to me that we have too many manual steps that change from copy to copy and too many people involved with manually running jobs. So I am curious to see ho other people handle this fun filled task. [...]53_5454996652567644.WA.jorghluekebcbsmn.com@www.idug.org 6167 510 8_Re: MQTs16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Tue, 24 Aug 2010 11:48:13 -0400544_us-ascii Have you considered looking into using a CLONE TABLE so the load process
won't impact the processes until you do the actual EXCHANGE command ?

Steen Rasmussen
CA Technologies
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 Brian Stewart
Sent: Tuesday, August 24, 2010 10:43 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] MQTs [...]56_0A18F096E689AC43BB2F52DAE5674D6009153198@USILMS14.ca.com 6678 26 54_Re: DB2 Z/os V8 - 10 jump experiences, recommendations12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 24 Aug 2010 12:27:05 -0400670_UTF-8 The CF level depends upon the processor. You need one in service for yours.
See the latest Coupling Facility (CF) level recommended for your processor at:
http://www.ibm.com/systems/z/advantages/pso/cftable.html

Roger Miller, DB2 for z/OS

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]51_7831339626009361.WA.millerrlus.ibm.com@www.idug.org 6705 108 54_Re: DB2 Z/os V8 - 10 jump experiences, recommendations10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 24 Aug 2010 18:36:50 +0200789_US-ASCII Hi Roger

Thank you so much

Max Scarpa

IDUG DB2-L wrote on 24/08/2010 18.27.05:

> From: Roger Miller
> To: DB2-L@IDUGDB2-L.ORG
> Date: 24/08/2010 18.28
> Subject: Re: [DB2-L] DB2 Z/os V8 - 10 jump experiences, recommendations
> Sent by: IDUG DB2-L
>
> The CF level depends upon the processor. You need one in service for
yours.
> See the latest Coupling Facility (CF) level recommended for your
> processor at:
> http://www.ibm.com/systems/z/advantages/pso/cftable.html
>
> Roger Miller, DB2 for z/OS
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * [...]66_OF652213AE.14B47EBA-ONC1257789.005AC668-C1257789.005B40A1@cesve.it 6814 435 46_Tampa Bay DB2 Users Group Tools Fair 9/17/201014_Nelia Gonzalez28_nelia.gonzalez@SYNIVERSE.COM31_Tue, 24 Aug 2010 14:37:44 -0400502_- Tampa Bay Relational Users Group
Vendor Product Fair
Friday, September 17, 2010

TBRUG is proud to announce the following companies are participating in
our Vendor Product Fair.
• IBM
• Compuware
• CA Technologies
• BMC
• ESAi

These presentations are focused on exploring Performance and Tuning,
Writing Efficient SQL, and DB2 related DBA products. Please come and
join us in a fun filled interesting day to network, learn and meet
the DB2 experts! [...]60_4911041005183243.WA.nelia.gonzalezsyniverse.com@www.idug.org 7250 28 50_[AD] LUW interfacing with Websphere Process Server14_Larry Kintisch17_LKint@VERIZON.NET31_Tue, 24 Aug 2010 14:40:10 -0400415_us-ascii Hi List,
RE: DB2 LUW interfacing with Websphere Process Server

I'm looking for someone who has a training course in this
environment, or is a consultant or has used and can recommend a
consultant in North America or UK that can mentor a team of DBA's.

Please contact me off-list LKint[ at ]verizon.net Thanks!

Larry kintisch, Pres. ABLE Information Services 845-353-0885 [...]40_0L7O003RC6J5V8I0@vms173019.mailsrvcs.net 7279 179 21_Re: Dynamic SQL Issue9_Don Leahy19_don.leahy@LEACOM.CA31_Tue, 24 Aug 2010 18:21:22 -0400693_UTF-8 If quotes are the problem, and they often are, use the HILITE REXX command
of the ISPF Editor. It makes it very easy to spot mismatched or missing
quotes.

On Mon, Aug 23, 2010 at 13:47, Sam Baugh wrote:

> Pay attention to use of quote marks and continuation in REXX.
>
> Sqlstmt = "SELECT MAX(DATE(TIMESTAMP))ā€ˇ",
> "FROM SYSIBM.SYSCOPY", ā€ˇ
> "WHERE DBNAME = '"vdbname"'", ā€ˇ
> "AND TSNAME='"vtsname"'", ā€ˇ
> "with UR"
>
> or ā€ˇ
>
> Sqlstmt = 'SELECT MAX(DATE(TIMESTAMP))',ā€ˇ
> ā€ˇ'FROM SYSIBM.SYSCOPY', ā€ˇ
> ā€ˇ'WHERE DBNAME = '''vdbname''', ā€ˇ
> ā€ˇ'AND TSNAME='''vtsname''', ā€ˇ
> [...]60_AANLkTiko5jiYsW4CSHXZL6m9gFfqGwCNojz4VKgooNU8@mail.gmail.com 7459 126 37_* Please Read * IDUG Survey and DB2-L10_Mark Labby21_mlabby.idug@GMAIL.COM31_Tue, 24 Aug 2010 19:32:39 -0400613_US-ASCII IDUG has been conducting a survey on how members of the DB2 community
communicate with each other. The survey takes less than 5 minutes to
complete and asks a few simple questions about how you interact with other
DB2 professionals using the various social media tools such as LinkedIn,
Facebook, Twitter, etc.

One aspect of this survey that is extremely important is that we get the
feedback of users of IDUG hosted listservs such as DB2-L. Over the years it
has come up numerous times that an e-mail list is 'old fashioned' and 'no
one uses e-mail anymore'. There have [...]36_C899CED7.207AF%mlabby.idug@gmail.com 7586 330 78_Re: z/OS db2 v9 datasharing two members; strange consequence of PCTFREE change16_Robert Catterall21_rfcatterall@GMAIL.COM31_Tue, 24 Aug 2010 22:30:44 -0400630_ISO-8859-2 Hello, Dusan -- sorry about the late response.

With PCTFREE 0 and inserts of index key values into the "middle" of the
index, you're probably getting (as has been pointed out) a large number of
index leaf page splits. That will certainly slow things down. As Adam noted,
the page splits are driving log writes. The monitor data you included showed
a very high synchronous I/O wait time. Depending on the DB2 monitor product
you're using and the report you've generated (if you generated a report;
maybe an online display otherwise), this synchronous I/O wait time is
further broken out [...]60_AANLkTim4V+vzRDpewPpJODVfhs8RAudqGsMLkUAsernq@mail.gmail.com 7917 226 41_Re: * Please Read * IDUG Survey and DB2-L15_Abe F. Kornelis13_abe@BIXOFT.NL31_Wed, 25 Aug 2010 07:05:43 +0200463_iso-8859-1 * Please Read * IDUG Survey and DB2-LMark,

Isn't it a pity the survey does not ask how
content we are with DB2-L?

I daresay I love my daily batch of DB2-L emails!

Kind regards,
Abe Kornelis.
==========
----- Original Message -----
From: Mark Labby
Newsgroups: bit.listserv.db2-l
To: DB2-L@IDUGDB2-L.ORG
Sent: Wednesday, August 25, 2010 1:32 AM
Subject: [DB2-L] * Please Read * IDUG Survey and DB2-L [...]47_07AD11778B994CF39C8E8A8C0D7E1B7F@your10f19f641c 8144 465 78_Re: z/OS db2 v9 datasharing two members; strange consequence of PCTFREE change37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Wed, 25 Aug 2010 09:22:11 +0200737_iso-8859-2 Hello, Robert

thank you for your detailed explanation
non-zero PCTFREE with reorg really solved the problem.
Regargs
dusan

________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Robert Catterall
Sent: Wednesday, August 25, 2010 4:31 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] z/OS db2 v9 datasharing two members; strange consequence of PCTFREE change

Hello, Dusan -- sorry about the late response.

With PCTFREE 0 and inserts of index key values into the "middle" of the index, you're probably getting (as has been pointed out) a large number of index leaf page splits. That will certainly slow things down. As Adam noted, the [...]58_0675446363E09A4EBE4CCF8D3AD7814F04548144@MAIL1.cen.csin.cz 8610 46 20_MAXRBLK and QW0225RP10_Andy Smith30_andrew.smith@COMPUTACENTER.COM31_Wed, 25 Aug 2010 06:46:08 -0400573_UTF-8 I am conducting some DB2 system tuning on our main Production DB2 subsystem. I am currently looking at RID tuning and have a query that I hope someone might be able to answer for me.

Currently we have MAXRBLK=12000 (12MB). I understand that the size of each RID block under DB2 V8 is 32K. So this gives us approximately 375 RID blocks. I am seeing QISTRHIG (MAX RID BLOCKS ALLOCATED) reported as 381, which suggests to me that weā€™ve hit the maximum number of RID blocks available at some point. I do see the occasional occurrence of QISTRMAX being hit. [...]62_2506812704209284.WA.andrew.smithcomputacenter.com@www.idug.org 8657 87 24_Re: MAXRBLK and QW0225RP11_Mike Turner19_mike.turner@GMX.COM31_Wed, 25 Aug 2010 14:13:05 +0100579_UTF-8 Hi Andy

I am not sure whether this will help. The V8 Performance Redbook (SG24-6465)
gives a figure of 10% below the Bar for the RID pool. More importantly, it
indicates that this is a guestimate and will vary depending on the workload.
There are two parts to the RID Pool: the RID Maps and the RID Lists. It is
the RID Maps that go below the Bar and the RID Lists above. The Redbook
states that the relationship between RID Map and RID List storage varies
from 1:1 to 1:many! My interpretation of the limited information available
is that [...]44_7DCB9DE7471C4A02AA91DE1032F9B10A@ToshibaA300 8745 141 41_Re: * Please Read * IDUG Survey and DB2-L10_Mark Labby21_mlabby@AESSUCCESS.ORG31_Wed, 25 Aug 2010 12:31:25 -0400487_us-ascii It is indeed a long day without a grin (or a groan) as I read Max's
messages...

Not to mention the insightful information provided by Phil, Roger, Joel,
Terry, Robert, Jorg, Dan, Steen, ...

LOL - I knew I was in trouble when I started putting in names because no
matter how many I list I'm going to hit send and think of more names. All
due apologies to everyone, but I believe the saying is 'when you realize
you are in a hole, STOP DIGGING'. [...]67_OF617FC375.5AEB4B58-ON8525778A.004D492E-8525778A.005AC446@pheaa.org 8887 394 41_Re: * Please Read * IDUG Survey and DB2-L13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 25 Aug 2010 09:44:03 -0700373_us-ascii Mark, they can't be seriously considering doing away with the email list, can they? If it's so old-fashioned and useless, why is everyone still here, instead of chatting away on LinkedIn? I'd like to remind everyone that DB2-L was originally independent from IDUG. If IDUG wants to gut it, maybe DB2-L should just find different hosting, thank you very much. [...]64_927FE8790B320742927BCF9ADF7AE48A19A5919366@PDXMAIL.pacificorp.us 9282 284 41_Re: * Please Read * IDUG Survey and DB2-L18_B. L. "Tink" Tysor16_Tink@BLTYSOR.COM31_Wed, 25 Aug 2010 12:54:40 -0400558_UTF-8 I agree. I like DB2-L. That probably makes me old fashioned, a fact my kids
never let me forget.

Tink

On Wed, Aug 25, 2010 at 12:31 PM, Mark Labby wrote:

> It is indeed a long day without a grin (or a groan) as I read Max's
> messages...
>
> Not to mention the insightful information provided by Phil, Roger, Joel,
> Terry, Robert, Jorg, Dan, Steen, ...
>
> LOL - I knew I was in trouble when I started putting in names because no
> matter how many I list I'm going to hit send [...]60_AANLkTin8883VSpOg=JF1ZWHeps9X0RkrNxd05NMM6RkH@mail.gmail.com 9567 86 41_Re: * Please Read * IDUG Survey and DB2-L15_Chris Hoelscher21_choelscher@HUMANA.COM31_Wed, 25 Aug 2010 13:09:01 -0400386_US-ASCII not to pile on, but I will ....

the survey more or less assumed that you are using linkedin - questions 8
and 9 require an answer - even after i specified in question 3 that I do
not use LinkedIn .....

to the IDUG folks - please keep in mind that many companies block access
to social networking sites - while email is not blocked as much (if ever) [...]68_OF893CBF07.64F07580-ON8525778A.005DAC5D-8525778A.005E3845@humana.com 9654 223 52_Re: [SPAM] Re: * Please Read * IDUG Survey and DB2-L13_Dan Luksetich18_danl@DB2EXPERT.COM31_Wed, 25 Aug 2010 10:32:31 -0700383_UTF-8 OK, I have just filled out the survey, but also want to make the point
here that linked-in and facebook are blocked at many of the places I have
worked. Email is not. I also find the information from the various
networking sites difficult to read, redundant, and almost all of the time
you need to go to the site (which is blocked) to get all the information. [...]42_be58910bc8c0304fde79e11e9f7902f2@127.0.0.1 9878 256 25_A Little History of DB2-L12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Wed, 25 Aug 2010 13:35:14 -0400398_us-ascii DB2-L is the longest continuous single source for DB2 information of all
time. I have been on DB2-L for going on 14 years, having gotten involved in
1996.

1996 - DB2-L hosted by American University, list owner was Ron can't
remember his last name. Willie Favero might, he was on DB2-L before American
University. I became associate list admin in around 1999 or so. [...]35_005501cb447b$e171d130$a4557390$@com 10135 55 49_AW: [DB2-L] * Please Read * IDUG Survey and DB2-L12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 25 Aug 2010 20:03:46 +0200364_us-ascii IDUG EMEA and their now-conference-people (greetings to Max) should
think about the fact, that Twitter / Facebook / and all the other very
hype things are usually not allowed in European companies. Okay, your
young folks do not know a simple list - like DB2-L.

So your youngster, stay cool and let us please have the DB2-L alive !!!. [...]58_99E58D5AC1BE6D4CBF492AF72B942C3D078F1503@dzstus010.dzbw.de 10191 149 41_Re: * Please Read * IDUG Survey and DB2-L10_Mark Labby21_mlabby@AESSUCCESS.ORG31_Wed, 25 Aug 2010 14:28:15 -0400552_utf-8 Let me be clear - there are no nefarious plans! There is NOT, I repeat,
NOT any plan to have the listserv go away.

It is not a survey of web access vs e-mail access, but trying to identify
all the ways you may want to receive information and stay in touch with the
DB2 community. I noticed that it was heavily geared toward the assumption
that people were using web based social sites and wanted to make sure there
is a question to measure of how many people cannot get to the social media
websites. That is where I [...]67_OF31D6FA0A.B8CBF248-ON8525778A.0061F2E2-8525778A.00657675@pheaa.org 10341 43 49_AW: [DB2-L] * Please Read * IDUG Survey and DB2-L12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 25 Aug 2010 20:46:27 +0200443_UTF-8 Let me be clear - there are no nefarious plans! There is NOT, I repeat,
NOT any plan to have the listserv go away.
-----------------------------------------------------------------------------------

Okay, this is what I want to see. IDUG EMEA and their now-conference-people should please think about the fact, that Twitter / Facebook / and all the other very hype things are usually not allowed in European companies. [...]58_99E58D5AC1BE6D4CBF492AF72B942C3D078F1506@dzstus010.dzbw.de 10385 46 37_* Please Read * IDUG Survey and DB2-L12_Martin Hubel17_Martin@MHUBEL.COM31_Wed, 25 Aug 2010 15:36:01 -04000_43_DB2-L%201008251536128091.3506@IDUGDB2-L.ORG 10432 210 41_Re: * Please Read * IDUG Survey and DB2-L15_Leon Katsnelson15_leon@CA.IBM.COM31_Wed, 25 Aug 2010 16:08:12 -0400532_US-ASCII For somebody who's job it is to do social media, I find this whole
discussion a little bewildering. The first rule of social media is to
broaden the reach not replace one thing with another. Facebook is not a
replacement for listserv, and twitter is not a replacement for facebook,
and blog is not a replacement for a website, and a website is not a
replacement for IRC channel .... I think you catch the drift. They are all
useful really valuable tools and a good practitioner will use ALL of them. [...]68_OF89CFD096.AB2ECD8A-ON8525778A.006C7025-8525778A.006E9EA5@ca.ibm.com 10643 26 13_DB2 ERROR +9817_Trembacki, Robert26_robert.trembacki@BCBSA.COM31_Wed, 25 Aug 2010 16:26:49 -0500724_us-ascii We are trying to create a native SQL stored procedure and getting a +98. 'Dynamic statement ends with a ;'. We have a similar stored procedure and it creates OK. Has any one had this issue?

Bob Trembacki
Performance Engineer Team Lead
Blue Cross Blue Shield Association

_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________ [...]59_50BA2F81CF76F7438BD87069FCFD4135CF351B64@cexchmb1.bcbsa.com 10670 49 17_Re: DB2 ERROR +9814_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 25 Aug 2010 17:30:48 -0400550_us-ascii Can you clip the text? And are you using a different terminator for the internal SQL vs. the end of the procedure text?

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Trembacki, Robert
Sent: Wednesday, August 25, 2010 5:27 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] DB2 ERROR +98

We are trying to create a native SQL stored procedure and getting a +98. 'Dynamic statement ends with a ;'. We have a similar stored procedure and it creates OK. Has any one had this issue? [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF969@MAIL02.fisalan.nycnet 10720 258 45_Windows Job Scheduler Software Recommendation22_Frank C. Fillmore, Jr.19_tfgpublic@GMAIL.COM31_Wed, 25 Aug 2010 17:42:19 -0400580_us-ascii Listers,

I am looking for a recommendation for Windows job scheduling software to run
DataStage Jobs. I am looking at ActiveBatch, JAMS, and Vinzant. Any
experiences? Any other alternatives.

TIA,

Frank

+-------------------------------------+-------------------------------------
--------+

| Frank C. Fillmore, Jr. | Office: 410.465.6335 Mobile:
410.963.0416 |

| The Fillmore Group, Inc. (TFG) | Facsimile: 888.828.4717
|

| 8501 LaSalle Road; Suite 318 | IBM Training: 800-TFG-RDBMs
(800.834.7326) | [...]35_003501cb449e$65074d50$2f15e7f0$@com 10979 156 17_Re: DB2 ERROR +9813_Sunil Chennur17_SChennur@TSYS.COM31_Wed, 25 Aug 2010 18:07:49 -0400655_US-ASCII Robert,

You have set the Delimiter to Something other than ; (semi-colon) on the
top and trying to use the Semi-colon after commit or end statement, that
is the reason you get this error message.

Thanks,
Sunil Chennur

From: "Trembacki, Robert"
To: DB2-L@IDUGDB2-L.ORG
Date: 08/25/2010 05:58 PM
Subject: [DB2-L] DB2 ERROR +98
Sent by: IDUG DB2-L

We are trying to create a native SQL stored procedure and getting a +98.
'Dynamic statement ends with a ;'. We have a similar stored procedure and
it creates OK. Has any one had this issue? [...]66_OF648D0176.441779A8-ON8525778A.00795954-8525778A.00799087@tsys.com 11136 168 49_Re: Windows Job Scheduler Software Recommendation15_Leon Katsnelson15_leon@CA.IBM.COM31_Wed, 25 Aug 2010 18:40:41 -0400619_US-ASCII Would roll your own Windows PowerShell scripts and Windows new Task
Scheduler 2.0 be an option? PowerShell has grown up to be quite powerful
just like LINUX/UNIX. And Task Scheduler 2.0 has become quite
sophisticated where you can schedule execution of a task not just based on
time but also based on custom developed conditions that can be quite
complex. You can also do task chaining and you can write your own very
sophisticated scheduling using .NET languages. They also added some much
needed security features. All of that is built in to the base Windows
Server 2008. So, no [...]68_OFD67A2CA0.17DA8456-ON8525778A.007AD2BC-8525778A.007C946C@ca.ibm.com 11305 41 50_DB2 Version 10 and DB2 LUW: Redefining Performance11_Dave Beulke19_dave@DAVEBEULKE.COM31_Wed, 25 Aug 2010 21:55:11 -04000_51_2941081822568395.WA.davedavebeulke.com@www.idug.org 11347 29 65_AUTO: Roopa Mahendra is out of the office. (returning 30/08/2010)14_Roopa Mahendra25_roopa.mahendra@IN.IBM.COM31_Thu, 26 Aug 2010 08:29:45 +0530467_US-ASCII I am out of the office until 30/08/2010.

Please contact jdominic@in.ibm.com for any urgent PMR/APAR issues or my
manager Hemant Kumar5/India/IBM for management related issues.

Note: This is an automated response to your message "[DB2-L] Betr: Re:
[DB2-L] Betr: Re: [DB2-L] DB2 z/OS Explain - strange cardinality with SORT"
sent on 24/8/10 10:42:55.

This is the only notification you will receive while this person is away. [...]68_OFF09D4627.9A15CA35-ON6525778B.00107544-6525778B.00107545@in.ibm.com 11377 133 8_Re: MQTs10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 25 Aug 2010 23:01:18 -0400471_UTF-8 Thank for your replies.

Steen, CLONE TABLE is currently ruled out as we are just migrating to v9, and would be a few months before NFM comes along. But thanks for the idea..that definitely sounds a useful one (still haven't come to grips with things new with v9).

Brian, sorry, we are on z/OS (v8 NFM). Incremental refreshes and allow read access seem restricted to LUW space. But again, something to think of where we use MQTs in our LUW envts. [...]54_6705075233691639.WA.teldb2kalstelstra.com@www.idug.org 11511 105 8_Re: MQTs16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Wed, 25 Aug 2010 23:55:39 -0400352_UTF-8 I understand Kals - once you're closer to DB2 9 NFM, you can download my IDUG presentation (Watch Out - The Clones Have landed) from the IDUG 2008 website. It describes all the details as well as the limitations when you cannot use CLONE's and which features are not available.
If you have any specific questions - please ask me offline. [...]56_0A18F096E689AC43BB2F52DAE5674D60091539F6@USILMS14.ca.com 11617 303 41_Re: * Please Read * IDUG Survey and DB2-L0_17_jtonchick@AOL.COM31_Thu, 26 Aug 2010 00:42:16 -0400433_us-ascii I totally agree, Abe.

On DB2-L , you're not limited to 140 characters. With email, you can use the features of software like Outlook to filter messages, place them in folders and do so much more than the social networking sites. It's bad enough I have my personal life interrupted by work, so I don't need Twitter or Facebook interruptions. Besides, these sites are not secure and are blocked by many employers. [...]52_8CD12F031A2E715-B8C-6211@webmail-d055.sysops.aol.com 11921 32 29_Re: A Little History of DB2-L12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Thu, 26 Aug 2010 02:51:23 -0400379_UTF-8 Phil, I couldn't agree more with your comment that DB2-L "continues to be the best single source for DB2 help and info".

It is rarely that information and/or solutions to problems can't be found on the list or in the list archives. When I go for a Google search regarding some odd aspect of DB2 a large number of the hits invariably point to the list archives. [...]54_2187152301718343.WA.adambaldwines.ibm.com@www.idug.org 11954 401 49_Re: Windows Job Scheduler Software Recommendation13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Thu, 26 Aug 2010 03:25:56 -0500328_us-ascii Frank,

Woop! Woop! Woop! That's my [AD] alert, by the way. A certain vendor I may or may not have an affiliation with may or may not peddle a job scheduler that may or may not work in a Windoze environment. You may or may not want to take a look at a product starting with 'C' and ending in 'oltrol-M'. ;o) [...]67_78B3EFE2C0C5D74E9E7777D1D669D542124939E4@PHXCCRPRD04.adprod.bmc.com 12356 216 53_Re: AW: [DB2-L] * Please Read * IDUG Survey and DB2-L10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 26 Aug 2010 11:00:25 +0200646_US-ASCII Hi all esteemed listers



I read with interest all replies to Mark's post and the first thing I'd
like to say is: >> complete this survey ! <<< :-)))))) This is one
(among others) way to say you use/don't use Twitter,Facebook and all
social forums on the Internet. Looking at final results and seeing 90% of
DB2 folks don't use/like/prefere (or use/like/prefere ?) these new
internet resources will provide good indications to people managing DB2
informations like Mark for the future. Yes this is what is needed,
indications for future planning even if there's no intention [...]66_OFF375496B.2D5D4FA4-ONC125778B.0025F749-C125778B.003171DE@cesve.it 12573 35 46_Re: How automated is your SAP Homogeneous copy29_SUBSCRIBE DB2-L Rainer Schulz26_Rainer.Schulz@TK-ONLINE.DE31_Thu, 26 Aug 2010 05:51:03 -0400563_UTF-8 Hello

We are homogeneous copiing our SAP-DB2 with the tool "BCV4" from UBS-Hainer (UBS-Hainer.com).
With this tool, the cloning can be automated via an internal submission-service (we use it for "low sequence" cloning).
For the more frequently cloning, we use this tool with CONTROL/M as job submitter. Here we defined the jobs one-time and the BCV4 regenerates these jobs everytime we start the clone-process.
So we fully automated the clone process on the DB2-side. Only some SAP internal rework had to be done by our SAP-colleagues. [...]57_8361604948856122.WA.Rainer.Schulztkonline.de@www.idug.org 12609 556 49_Re: Windows Job Scheduler Software Recommendation15_Lizette Koehler23_starsoul@MINDSPRING.COM31_Thu, 26 Aug 2010 07:10:33 -0400650_US-ASCII If you are going to talk about C-ontrolM then you should also look at
CA-ESP. It handles both Mainframe and server environments.

Lizette

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bell, Raymond
Sent: Thursday, August 26, 2010 4:26 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Windows Job Scheduler Software Recommendation

Frank,

Woop! Woop! Woop! That's my [AD] alert, by the way. A certain vendor I
may or may not have an affiliation with may or may not peddle a job
scheduler that may or may not work in a Windoze environment. You may or may
not want to take a look [...]35_006a01cb450f$4de10690$e9a313b0$@com 13166 67 54_AW: [DB2-L] How automated is your SAP Homogeneous copy12_Thomas Weber22_Thomas.Weber@IT.NRW.DE31_Thu, 26 Aug 2010 15:40:02 +0200514_iso-8859-1 Hi Jorg,

because of some special demands by the project management we decided to use HCopy from InfoDesign.
From my little cloning experience I'd strongly recommend implementing this process completely into your job scheduler even (or particularly) if you have to do it very rarely. Then the whole process doesn't have to be painful for DB2 people.
Unfortunately I can't tell you how my successors finally implemented this as I left this area when the project went over to production. [...]72_C129734D873435418B3C3C91E9CBF3A369166546BB@LDSXS01EVS.service.lds.nrw.de 13234 48 43_TCO news: Optimizer in DB2 10 for z/OS Beta14_Surekha Parekh20_surekha21@UK.IBM.COM31_Thu, 26 Aug 2010 10:08:44 -0400413_UTF-8 Reducing the total cost of ownership is everyoneā€™s challenge, and itā€™s one of the key benefits of query optimization. Since its initial inception in DB2Ā® for z/OSĀ®, the cost-based Optimizer has continually evolved to deliver expert-based query and workload analysis and many other performance-enhancing functions. Based on the latest use by customers, the Optimizer delivers even more in DB2 10. [...]52_8423573625167933.WA.surekha21uk.ibm.com@www.idug.org 13283 635 49_Re: Windows Job Scheduler Software Recommendation13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Thu, 26 Aug 2010 09:44:35 -0700489_us-ascii We use Control-M on both mainframe and open systems. It's very robust, and may be overkill for Frank's requirements.

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lizette Koehler
Sent: Thursday, August 26, 2010 4:11 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Windows Job Scheduler Software Recommendation

If you are going to talk about C-ontrolM then you should also look at CA-ESP. It handles both Mainframe and server environments. [...]64_927FE8790B320742927BCF9ADF7AE48A19A5919D30@PDXMAIL.pacificorp.us 13919 38 8_Re: MQTs13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Thu, 26 Aug 2010 13:00:46 -0400565_UTF-8 One option which does not require application code or a real MQT would be to "build your own MQT"

1) Create a SUMMARY table, and use SQl to generate the initial rows
2) Add Insert/update/delete triggers to the table
(*this would require not I/U/D activity whilist the 2 steps are completed)

By using the trigger you can maintain the values in you psuedo-mqt, at the row-level - if you insert a row add to the values, if you delete subtract, update would be "net effect" - I have used this in the past in the days before MQT's to good [...]55_5222691593256903.WA.jackrcampbellyahoo.com@www.idug.org 13958 59 8_Re: MQTs14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 26 Aug 2010 13:05:23 -0400448_us-ascii You can do that, yeah, but then it won't participate in query optimization for other queries against the base table(s).

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jack Campbell
Sent: Thursday, August 26, 2010 1:01 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] MQTs

One option which does not require application code or a real MQT would be to "build your own MQT" [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF96B@MAIL02.fisalan.nycnet 14018 48 49_Re: Windows Job Scheduler Software Recommendation15_Cristian Molaro18_cristian@MOLARO.BE31_Thu, 26 Aug 2010 14:19:43 -0400612_- Hi Frank,

May be an alternative: some time ago we introduced DataStage on Unix into a company where the main business runs on z/OS.

Of course they have a scheduling system in the mainframe, TWS, and soon we faced the need to scheduled DataStage jobs. The ideal situation would be to use the mainframe existing infrastructure because it was already there and it also would provide compliance with existing job dependencies, scheduling, alerting and so on.
We achieved this by executing the DataStage jobs from TWS using ssh: we have a JCL that executes synchronously a DS jobs using ssh's [...]50_9082026954195906.WA.cristianmolaro.be@www.idug.org 14067 89 8_Re: MQTs12_Isaac Yassin20_yassini@BEZEQINT.NET31_Thu, 26 Aug 2010 21:26:27 +0300635_us-ascii I think you wanted to write "Other dynamic sql queries"
Isaac Yassin

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil
Sent: Thursday, August 26, 2010 8:05 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] MQTs

You can do that, yeah, but then it won't participate in query optimization
for other queries against the base table(s).

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jack Campbell
Sent: Thursday, August 26, 2010 1:01 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] MQTs [...]35_005001cb454c$3299ea90$97cdbfb0$@net 14157 256 29_Re: A Little History of DB2-L13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 26 Aug 2010 13:47:31 -0500621_ISO-8859-1 Does anyone remember the "DB2 Forum"? It's the DB2-L predecessor...
this was pre 1996...

Willie

On 8/25/2010 12:35 PM, Phil Gunning wrote:
>
> DB2-L is the longest continuous single source for DB2 information of
> all time. I have been on DB2-L for going on 14 years, having gotten
> involved in 1996.
>
> 1996 -- DB2-L hosted by American University, list owner was Ron can't
> remember his last name. Willie Favero might, he was on DB2-L before
> American University. I became associate list admin in around 1999 or so.
>
> Around 1999, American University [...]30_4C76B6C3.7010806@attglobal.net 14414 118 8_Re: MQTs14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 26 Aug 2010 15:16:04 -0400438_us-ascii Isaac,

What I meant was that automatic query rewrite only considers real MQT's that have rewrite enabled. I believe that applies to both static and dynamic SQL -- am I wrong about that?

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Isaac Yassin
Sent: Thursday, August 26, 2010 2:26 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] MQTs [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF96C@MAIL02.fisalan.nycnet 14533 154 8_Re: MQTs14_Peter Backlund21_BacklundDB2@TELIA.COM31_Thu, 26 Aug 2010 21:52:11 +02000_26_4C76C5EB.5090706@telia.com 14688 385 41_Re: * Please Read * IDUG Survey and DB2-L12_myron miller22_myronwmiller@YAHOO.COM31_Thu, 26 Aug 2010 21:09:19 -0400529_iso-8859-1 To be honest, if I had to use Twitter or Facebook, then I wouldn't be involved. Period. Facebook has serious privacy issues. And twitter has character restrictions that make it impossible to really do anything productive.

DB2-L works, and is available at lots of shops since it's email based. As many have mentioned, the others are blocked. And even if they were not, I'm afraid that I'm too much of an old fogey and totally uninterested with the others, especially considering the privacy issues as well. [...]43_3F04A0D7B5544344A3FC16458E0A34FA@premierhp2 15074 268 46_[AD] IDUG EMEA, Chocolate and the Hotel Sacher13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 27 Aug 2010 07:35:51 -0400449_us-ascii Well, it's Friday again so time for one of Phils IDUG EMEA "what else is there to do?" messages

You can't visit Vienna without trying a slice of Sacher Torte (or perhaps share a WHOLE one with a friend) - see http://www.sacher.com/en-original-sacher-tart.htm

The Original Sacher-Torte has been the most famous cake in the world for more than 175 years, since 1832 and the original recipe a well-kept secret of the hotel. [...]60_4440F5DA00E3F3459BBCB97431B91B6612B902CFEA@MAILR004.mail.lan 15343 25 41_Re: * Please Read * IDUG Survey and DB2-L34_Luiz Cesar Vinhaes da Costa Junior17_vinhaes@BB.COM.BR31_Fri, 27 Aug 2010 07:46:10 -0300690_US-ASCII I agree with Myron and Jim

Keep DB2-L as the prime method of communication.

Luiz Vinhaes

_____________________________________________________________________
* 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!
_____________________________________________________________________ [...]76_OF21BD0452.B58B0E1B-ON8325778C.003AD138-8325778C.003B28E0@bancobrasil.com.br 15369 230 30_Best IBM url for APAR searches13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 27 Aug 2010 08:00:37 -0400358_us-ascii A while back someone asked for the best (read easiest) place at ibm.com to do APAR research, and I smugly answered - "Use the Explorer toolbar - it's simple"

Well, since the toolbar was "removed" by IBM I am now in the same boat as the OP

Where DO people start when researching something like a spurious SQLCODE -582 for example? [...]60_4440F5DA00E3F3459BBCB97431B91B6612B902CFED@MAILR004.mail.lan 15600 514 29_Re: A Little History of DB2-L13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 27 Aug 2010 08:02:04 -0400434_us-ascii Vaguely - I certainly remember something before American.edu, when the closest thing we had to an internet was dialling in to Compuserve and looking at bulletin boards! (and I DO mean DIALLING in - we only had ONE pc with a modem)

God I feel old :(
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk [...]60_4440F5DA00E3F3459BBCB97431B91B6612B902CFEE@MAILR004.mail.lan 16115 346 34_Re: Best IBM url for APAR searches11_Mike Turner19_mike.turner@GMX.COM31_Fri, 27 Aug 2010 13:41:34 +0100698_iso-8859-1 Hi Phil

I use www-01.ibm.com/support/search.wss?rs=64&tc=SSEPEK&dc=DB550+D100&dtm. There are other ways in but this one avoids all the irrelevant bs. So it will probably stop working soon!

Regards
Mike Turner
Email: mike.turner@gmx.com
Tel: +44 (0)1565-873702
Web: www.michael-turner.ltd.uk
Michael Turner Ltd. Registered in England & Wales No. 1433722. Registered Office: 131 King Street, Knutsford, Cheshire, WA16 6EJ. VAT No. GB 338 4159 44.
----- Original Message -----
From: Phil Grainger
Newsgroups: bit.listserv.db2-l
To: DB2-L@IDUGDB2-L.ORG
Sent: Friday, August 27, 2010 1:00 PM
Subject: [DB2-L] Best IBM url for APAR searches [...]44_C35C52606F5F45AC857CFB851528E6F9@ToshibaA300 16462 626 34_Re: Best IBM url for APAR searches14_Fazio, Richard21_RFAZIO@TRANSUNION.COM31_Fri, 27 Aug 2010 07:52:31 -0500501_utf-8 Short of IBMLINK you can try this website: http://www.ibm.com/support/us/en/

Or someone may email it to you ; - D

faz

Compare the two:

Using the link above (SQLCODE582) as the query input

1 - 7 of 7 items found*Modified date

5 column nested results data table Number Key Space Headline Date

1.

PK64442: SQLCODE582 IS ISSUED INCORRECTLY WHEN THE SEARCH CONDITION OF A SEARCHED-WHEN CLAUSE IN CASE EXPRESSION CONTAINS OR EXPRESSIONSā€‹ [...]70_0CF187805D9C924DAFF59A877104C36A04CC18C8@CHI4EVS04.corp.transunion.com 17089 403 50_Re: [AD] IDUG EMEA, Chocolate and the Hotel Sacher10_Roger Hecq18_roger.hecq@UBS.COM31_Fri, 27 Aug 2010 09:00:21 -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_1A700EEF49343148A08879B1E3CA5BA616132BC5@NSTMC101PEX1.ubsw.net 17493 584 34_Re: Best IBM url for APAR searches13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 27 Aug 2010 09:08:57 -0400577_us-ascii Perfect

Thanks Mike

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 - EMEA, 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 Mike Turner
Sent: 27 August 2010 13:42
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Best IBM url for APAR searches

Hi Phil [...]60_4440F5DA00E3F3459BBCB97431B91B6612B902D009@MAILR004.mail.lan 18078 561 34_Re: Best IBM url for APAR searches17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Fri, 27 Aug 2010 08:24:54 -0500424_us-ascii Phil. I'm not sure what you mean by the toolbar being removed by IBM, I just updated the toolbar to the latest version and the toolbar search is working like it used too.

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: Friday, August 27, 2010 8:09 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Best IBM url for APAR searches [...]79_3A61DE20404B9D41A954E5380147DD2801749462D980@MEWMAD0PC02G02.accounts.wistate.us 18640 813 34_Re: Best IBM url for APAR searches13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 27 Aug 2010 09:59:50 -0400429_us-ascii Really?

When I updated it, it just disappeared completely (and when it WAS installed, it always took me to the IBM support portal no matter what I asked of it

Do you have a link so I can try and install the latest version?

Thanks
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk [...]60_4440F5DA00E3F3459BBCB97431B91B6612B902D01C@MAILR004.mail.lan 19454 756 34_Re: Best IBM url for APAR searches17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Fri, 27 Aug 2010 09:13:44 -0500462_us-ascii I just pulled down the the toolbar update from the option tool bar and clicked on it. I had to shut down all my exploroer windows. But once I had the latest version it fixed the going to the IBM portal issue.

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: Friday, August 27, 2010 9:00 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Best IBM url for APAR searches [...]79_3A61DE20404B9D41A954E5380147DD2801749462D981@MEWMAD0PC02G02.accounts.wistate.us 20211 803 34_Re: Best IBM url for APAR searches17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Fri, 27 Aug 2010 09:19:31 -0500537_us-ascii The one I updated too is 6.0, I think the old one was version 5

________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gugel, Rich - DOA
Sent: Friday, August 27, 2010 9:14 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Best IBM url for APAR searches

I just pulled down the the toolbar update from the option tool bar and clicked on it. I had to shut down all my exploroer windows. But once I had the latest version it fixed the going to the IBM portal issue. [...]79_3A61DE20404B9D41A954E5380147DD2801749462D982@MEWMAD0PC02G02.accounts.wistate.us 21015 1077 34_Re: Best IBM url for APAR searches13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 27 Aug 2010 09:22:01 -0500415_us-ascii Wot, you mean this?: http://www-01.ibm.com/software/support/toolbar/

Not tried it yet meself but am about to...

Raymond

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gugel, Rich - DOA
Sent: 27 August 2010 15:20
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Best IBM url for APAR searches

The one I updated too is 6.0, I think the old one was version 5 [...]67_78B3EFE2C0C5D74E9E7777D1D669D54212525325@PHXCCRPRD04.adprod.bmc.com 22093 1113 34_Re: Best IBM url for APAR searches13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 27 Aug 2010 10:40:18 -0400677_us-ascii OK - I'm up and toolbar-ing again

Thanks all

(BUT where do you find out which version of the toolbar you have installed?)

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 - EMEA, 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 Gugel, Rich - DOA
Sent: 27 August 2010 15:20
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Best IBM url for APAR searches [...]60_4440F5DA00E3F3459BBCB97431B91B6612B902D02D@MAILR004.mail.lan 23207 1209 34_Re: Best IBM url for APAR searches13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 27 Aug 2010 09:44:38 -0500381_us-ascii Firefox told me when I installed it. IE doesn't say, and I can't seem to see a 'About'-type option anywhere. Er... Windows Installer?

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: 27 August 2010 15:40
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Best IBM url for APAR searches

OK - I'm up and toolbar-ing again [...]67_78B3EFE2C0C5D74E9E7777D1D669D54212525371@PHXCCRPRD04.adprod.bmc.com 24417 1032 34_Re: Best IBM url for APAR searches17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Fri, 27 Aug 2010 09:51:05 -0500329_us-ascii Yippee!

Did you do the update or uninstall/reinstall?

Firefox told me there was a newer plug-in available and it said it was the 6.0 version replacing the 5.0.3. I was not able to find the version in IE, but when I now ask to do the options--> toolbar update, it says I have the most current version. [...]79_3A61DE20404B9D41A954E5380147DD2801749462D983@MEWMAD0PC02G02.accounts.wistate.us 25450 33 50_Re: [AD] IDUG EMEA, Chocolate and the Hotel Sacher14_Linda Billings30_linda.billings@DOT.STATE.WI.US31_Fri, 27 Aug 2010 11:09:46 -0400797_UTF-8 Hi, Phil,

I have heard from a very reliable Austrian source that Sacher Torte must be ordered mit schlag (with whipped cream).
It is de rigeur.

Also, if you have time go on a tour of Schƶnbrunn Palace. It is easily accessible from the metro. Quite impressive!

Regards,

Linda Billings

_____________________________________________________________________
* 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 [...]62_9095100111381108.WA.linda.billingsdot.state.wi.us@www.idug.org 25484 84 50_Re: [AD] IDUG EMEA, Chocolate and the Hotel Sacher10_Roger Hecq18_roger.hecq@UBS.COM31_Fri, 27 Aug 2010 11:38:07 -0400480_iso-8859-1 And the whipped cream is made from real cream skimmed from real milk, unlike the imitations that we have here (except Wisconsin, of course).

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 Linda Billings
Sent: Friday, August 27, 2010 11:10 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [AD] IDUG EMEA, Chocolate and the Hotel Sacher [...]62_1A700EEF49343148A08879B1E3CA5BA616132C7B@NSTMC101PEX1.ubsw.net 25569 33 68_DB2 version 10 for Z - what release of DB2 connect will be supported5_Larry34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Fri, 27 Aug 2010 11:51:06 -0400387_UTF-8 It may be too soon to ask this question but I need to ask it anyway.

We are about to upgrade our version of DB2 connect across the enterprise and we would like to actually position ourselves for installing V10 of DB2 (as far as DB2 connect is concerned).

Does anyone know if IBM has released what level of DB2 connect would be needed to support V10 of DB2 on Z? [...]65_2692302986976180.WA.LIS.KirkpatrickMutualofOmaha.com@www.idug.org 25603 24 29_Re: A Little History of DB2-L12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 27 Aug 2010 12:03:06 -0400716_UTF-8 I remember DB2 FORUM, when the only color on the screen was green.

Roger Miller, DB2 for z/OS senior programmer at that time

_____________________________________________________________________
* 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!
_____________________________________________________________________ [...]51_9909235178675466.WA.millerrlus.ibm.com@www.idug.org 25628 143 72_Re: DB2 version 10 for Z - what release of DB2 connect will be supported10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 27 Aug 2010 18:11:06 +0200492_US-ASCII From public papers (Miller, SHARE 2010) it seems you'd have DB2 Connect
9 FP1 or 9.7 FP3 for many 10 functions or FP2 beta.

HTH

Max Scarpa

From: Larry
To: DB2-L@IDUGDB2-L.ORG
Date: 27/08/2010 17.51
Subject: [DB2-L] DB2 version 10 for Z - what release of DB2 connect
will be supported
Sent by: IDUG DB2-L

It may be too soon to ask this question but I need to ask it anyway. [...]66_OFA73DE2B8.A9ECABC9-ONC125778C.0057EB65-C125778C.0058DFF1@cesve.it 25772 30 67_AUTO: Katherine A Wheat is out of the office (returning 08/30/2010)17_Katherine A Wheat17_kwheat@US.IBM.COM31_Fri, 27 Aug 2010 10:02:38 -0600853_US-ASCII I am out of the office until 08/30/2010.

Note: This is an automated response to your message "DB2-L Digest - 27 Aug
2010 - Special issue (#2010-233)" sent on 8/27/10 8:51:18.

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
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!
_____________________________________________________________________ [...]68_OF55650EE2.F8419A7A-ON8725778C.005821E2-8725778C.005821E2@us.ibm.com 25803 1282 34_Re: Best IBM url for APAR searches10_Martin Cox23_martin.cox@COGITO.CO.UK31_Fri, 27 Aug 2010 12:05:05 -0400434_us-ascii Version.txt in the install directory tells me my version is 6.

Cheers
Martin

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bell, Raymond
Sent: 27 August 2010 15:45
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Best IBM url for APAR searches

Firefox told me when I installed it. IE doesn't say, and I can't seem to see a 'About'-type option anywhere. Er... Windows Installer? [...]60_4440F5DA00E3F3459BBCB97431B91B6612B902D056@MAILR004.mail.lan 27086 95 41_CALL statement and DB2 command processors14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 27 Aug 2010 12:18:07 -0400762_us-ascii I can't get the CALL statement (for Stored Procedures) to work in SPUFI, QMF, or DB2 CLP from the workstation. Does anyone know where the documentation is on what environments support CALL? Do I have to have it inside a program for it to work?

_____________________________________________________________________
* 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!
[...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF976@MAIL02.fisalan.nycnet 27182 85 72_Re: DB2 version 10 for Z - what release of DB2 connect will be supported10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 27 Aug 2010 18:45:06 +0200472_US-ASCII See also in :

GUO, James - Key SQL Function in DB2 9 for z/OS & Beyond SHARE, August
2010

HTH

Max Scarpa
DB2 sysprog

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

'If you want to plow a field with 64 chickens instead of one mule, then
yes the unit cost per chicken is less but herding chickens becomes the new
frontier.' [...]66_OF7263D739.36A7B9ED-ONC125778C.005BABAE-C125778C.005BFC84@cesve.it 27268 106 52_Re: [SPAM] CALL statement and DB2 command processors13_Dan Luksetich18_danl@DB2EXPERT.COM31_Fri, 27 Aug 2010 17:09:24 +0000683_Windows-1252 You can call it from rexx. There are free download examples on db2expert.com
Sent via BlackBerry from T-Mobile

-----Original Message-----
From: "Sevetson, Phil"
Sender: IDUG DB2-L
Date: Fri, 27 Aug 2010 12:18:07
To:
Reply-To: IDUG DB2-L
Subject: [SPAM] CALL statement and DB2 command processors

I can't get the CALL statement (for Stored Procedures) to work in SPUFI, QMF, or DB2 CLP from the workstation. Does anyone know where the documentation is on what environments support CALL? Do I have to have it inside a program for it to work? [...]104_1573334108-1282929032-cardhu_decombobulator_blackberry.rim.net-262472857-@bda674.bisx.prod.on.blackberry 27375 230 34_Re: Best IBM url for APAR searches13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Fri, 27 Aug 2010 12:12:48 -0500674_ISO-8859-1 Hi Phil

Here's another link that I use...
http://www-947.ibm.com/support/entry/portal/Overview/Software/Information_Management/DB2_for_z~OS

BTW, if I am looking for a specific APAR, a Google search works just
fine if the APAR has closed... In fact, I use a Goggle search to verify
that the APARs I mention in my blog are accessible to all.

Willie

On 8/27/2010 7:00 AM, Phil Grainger wrote:
>
> A while back someone asked for the best (read easiest) place at
> ibm.com to do APAR research, and I smugly answered -- "Use the
> Explorer toolbar -- it's simple"
>
> Well, since the toolbar was "removed" by [...]28_4C77F210.30002@attglobal.net 27606 130 72_Re: DB2 version 10 for Z - what release of DB2 connect will be supported13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Fri, 27 Aug 2010 12:23:44 -0500700_UTF-8 Take a look at the prereq section of the announcement letter for the
beta ("IBM DB2 10 for z/OS launches beta program", IBM United States
Software Announcement 210-015, February 9, 2010). It will tell you the
minimum required at the time of the beta announcement...

http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?infotype=an&subtype=ca&appname=Demo&htmlfid=897/ENUS210-015

Willie

On 8/27/2010 10:51 AM, Larry wrote:
> It may be too soon to ask this question but I need to ask it anyway.
>
> We are about to upgrade our version of DB2 connect across the enterprise and we would like to actually position ourselves for installing V10 of DB2 (as far [...]30_4C77F4A0.3020905@attglobal.net 27737 404 52_Re: [SPAM] CALL statement and DB2 command processors14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 27 Aug 2010 13:28:35 -0400511_us-ascii I"ve done that, yes. I think I might have used your sample code as a basis. But I have a customer who's trying to make a stored-procedure call from COGNOS, and he's testing it with the Command-line processor, and it's not working. I've tried a number of variants which appear to be syntactically legal, but the CLP claims either that I'm submitting too few parameters (and then it asks for the number of parameters which I submitted), or it just blows up. Here's a sample from the Command Editor: [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF979@MAIL02.fisalan.nycnet 28142 241 45_Re: CALL statement and DB2 command processors13_David Simpson22_dsimpson@THEMISINC.COM31_Fri, 27 Aug 2010 13:37:18 -0400284_us-ascii Stored procedure calls are not supported in SPUFI. QMF can do them but
there is no way (that I know of) to receive out parms back.

I use CLP on the client all the time. You need to supply a value for
ever IN and INOUT parm and place a ? for every OUT parm. [...]67_7EC87535E7581C4C890F5BF1CF9A9374029FC758@THEMISSRV1.themisinc.local 28384 373 45_Re: CALL statement and DB2 command processors14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 27 Aug 2010 13:50:00 -0400343_us-ascii David,
I'm doing that. I reverse-engineered the DDL using IBM's Administration tool. The SP has four input parms (all VARCHAR(255)) and no output parms. I'm CALLing it with four parms, delimited by simple apostrophes and separated by commas, and it either blows up or refuses to acknowledge that I'm giving it any parameters. [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF97A@MAIL02.fisalan.nycnet 28758 465 45_Re: CALL statement and DB2 command processors13_David Simpson22_dsimpson@THEMISINC.COM31_Fri, 27 Aug 2010 14:15:33 -0400636_us-ascii Have you tried casting the input parms as VARCHAR?

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson,
Phil
Sent: Friday, August 27, 2010 12:50 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] CALL statement and DB2 command processors

David,

I'm doing that. I reverse-engineered the DDL using IBM's Administration
tool. The SP has four input parms (all VARCHAR(255)) and no output
parms. I'm CALLing it with four parms, delimited by simple apostrophes
and separated by commas, and it either blows up or refuses to
acknowledge that I'm giving it any parameters. [...]67_7EC87535E7581C4C890F5BF1CF9A9374029FC763@THEMISSRV1.themisinc.local 29224 28 45_Re: CALL statement and DB2 command processors14_Linda Claussen17_lindafc@GMTEL.NET31_Fri, 27 Aug 2010 14:21:37 -0400694_UTF-8 Hi Phil,

Using CLP have you tried

CALL schema.SPname (?,?,?,?)

That usually works for me

_____________________________________________________________________
* 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!
_____________________________________________________________________ [...]49_8658730396216791.WA.lindafcgmtel.net@www.idug.org 29253 25 45_Re: CALL statement and DB2 command processors14_Linda Claussen17_lindafc@GMTEL.NET31_Fri, 27 Aug 2010 14:25:05 -0400788_UTF-8 Sorry, those were output parms instead of input parms.
Try CALL schema.SPname ('DATA','DATA','DATA','DATA')
If there are not output parms that should work. schema is the collection id the SP is in.

_____________________________________________________________________
* 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!
_____________________________________________________________________ [...]49_0229647793642174.WA.lindafcgmtel.net@www.idug.org 29279 547 45_Re: CALL statement and DB2 command processors14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 27 Aug 2010 14:57:01 -0400924_us-ascii David,

This is what I"ve done:
CALL SYSPROC.WLM_SET_CLIENT_INFO('DHARMENDRA', 'USERCOMPNAME', 'PARAM','ApplicationName')
This results in a popup Windows error message.

CALL "SYSPROC.WLM_SET_CLIENT_INFO('DHARMENDRA','USERCOMPNAME','PARAM','ApplicationName')"
This doesn't work because the SQL processor apparently doesn't recognize the parameters:
------------------------------ Commands Entered ------------------------------
CALL "SYSPROC.WLM_SET_CLIENT_INFO('DHARMENDRA','USERCOMPNAME','PARAM','ApplicationName')";
------------------------------------------------------------------------------
CALL "SYSPROC.WLM_SET_CLIENT_INFO('DHARMENDRA','USERCOMPNAME','PARAM','ApplicationName')"
DB21101E Too few parameters were specified for stored procedure
"SYSPROC.WLM_SET_CLIENT_INFO" (expected 4).

SQL10007N Message "99999" could not be retrieved. Reason code: "4". [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF97B@MAIL02.fisalan.nycnet 29827 51 45_Re: CALL statement and DB2 command processors14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 27 Aug 2010 14:58:34 -0400414_us-ascii Linda,
See my response to David -- I've tried a variant of your call and the result is a Windows flag of the executable. Not sure what to make of that.

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Linda Claussen
Sent: Friday, August 27, 2010 2:25 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] CALL statement and DB2 command processors [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF97C@MAIL02.fisalan.nycnet 29879 82 45_Re: CALL statement and DB2 command processors13_David Simpson22_dsimpson@THEMISINC.COM31_Fri, 27 Aug 2010 15:52:33 -0400581_us-ascii Hmmm... I ran exactly the same CALL as you and got a successful
execution.

What level of the DB2 client are you running? Is it very current?

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson,
Phil
Sent: Friday, August 27, 2010 1:59 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] CALL statement and DB2 command processors

Linda,
See my response to David -- I've tried a variant of your call and the
result is a Windows flag of the executable. Not sure what to make of
that. [...]67_7EC87535E7581C4C890F5BF1CF9A9374029FC779@THEMISSRV1.themisinc.local 29962 105 45_Re: CALL statement and DB2 command processors14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 27 Aug 2010 17:54:52 -0400474_us-ascii Might be old. I'm working this with tech support in IBM Canada somewhere, as an ETR. This ... has been a productive day.
--Phil

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of David Simpson
Sent: Friday, August 27, 2010 3:53 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] CALL statement and DB2 command processors

Hmmm... I ran exactly the same CALL as you and got a successful
execution. [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF981@MAIL02.fisalan.nycnet 30068 148 72_Re: DB2 version 10 for Z - what release of DB2 connect will be supported12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 27 Aug 2010 18:39:23 -0700572_us-ascii The announcement says v9.1 fixpack 1. However, some of the presentations I've
seen are saying to use the features of 10, we'll need 9.7 fp3 ( which has not
even been released yet).

What features are going to require a fixpack that hasn't even been released?
That's my question.

Myron

________________________________
From: Willie Favero
To: DB2-L@IDUGDB2-L.ORG
Sent: Fri, August 27, 2010 1:23:44 PM
Subject: Re: [DB2-L] DB2 version 10 for Z - what release of DB2 connect will be
supported [...]44_458982.61437.qm@web112118.mail.gq1.yahoo.com 30217 233 34_Re: Best IBM url for APAR searches0_17_jtonchick@AOL.COM31_Sat, 28 Aug 2010 02:21:53 -0400347_utf-8 If I' looking for what seems to be an undocumented new error code, I use the SIS search on IBMLink. Most of the time you'll get a hit on the apar that created the new code. If that doesn't work, then any god search engine on the web is my next stop. If the web search come up empty, it's back to IBMLink where I open a question or PMR. [...]53_8CD149070EBA339-56FC-651C@Webmail-d108.sysops.aol.com 30451 293 72_Re: DB2 version 10 for Z - what release of DB2 connect will be supported0_17_jtonchick@AOL.COM31_Sat, 28 Aug 2010 02:34:55 -0400454_us-ascii Well, I'd put money down in Vegas that both DB2 LUW 9.7 fixpac3 and DB2 for z/OS version 10 will have simultanious general availability announcements. We'll just have to wait and see.

Jim Tonchick

-----Original Message-----
From: Myron Miller
To: DB2-L@IDUGDB2-L.ORG
Sent: Fri, Aug 27, 2010 8:39 pm
Subject: Re: [DB2-L] DB2 version 10 for Z - what release of DB2 connect will be supported [...]53_8CD1492437785D8-56FC-65B9@Webmail-d108.sysops.aol.com 30745 29 34_Re: Best IBM url for APAR searches14_Peter Vanroose17_pvanroose@ABIS.BE31_Sat, 28 Aug 2010 13:09:30 -0400840_UTF-8 Mike's URL can even be simplified to
http://www.ibm.com/support/search.wss?tc=SSEPEK
And it has (in its upper left corner) a link to the Support Portal page mentioned by Willie.

-- Peter Vanroose
ABIS Training & Consulting
http://www.abis.be/html/enindex.html

_____________________________________________________________________
* 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
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________ [...]49_1752401795054542.WA.pvanrooseabis.be@www.idug.org