1 IDUGDB2-L.ORG /home/listserv/home/db2-l March 2010, week 4 2 63 26_ADMIN: call for volunteers15_ROBERT GALAMBOS19_galambos@ROGERS.COM31_Sun, 21 Mar 2010 20:38:49 -0700436_iso-8859-1 As some of you may know, or guess, it take a team of volunteers to maintain/run/'police' the various aspects of the IDUG organization.

Well this is a call for volunteers. if you don't care about money (), think that you have the time (and patience) to do various non glamorous tasks, and want to give back to the community (am i making this sound really reaaly tempting ), please drop me a note (OFF LINE). [...]43_286386.73932.qm@web88103.mail.re2.yahoo.com 66 83 41_Re: UNLOAD - Increase of temporary space?13_Sushanta Dash30_Sushanta.K.Dash@WELLSFARGO.COM31_Sun, 21 Mar 2010 22:38:35 -0500651_us-ascii Hi John,

Josh can get the same TIAUL output even tough he uses a single table in the sql.

With Thanks
Sushanta Dash
DARC Team

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of John Saunders
Sent: Saturday, March 20, 2010 4:54 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] UNLOAD - Increase of temporary space?

I suspect the SQL statement you quoted isn't the actual one being used ;-)
The TIAUL output gives us some clues -
1) there is more than one table involved
2) the output record length is 482 bytes (so we don't have to worry about huge [...]73_4524A782FDBC234089E413906B58E7222FE5B76B89@MSGCMSV21026.ent.wfb.bank.corp 150 31 65_AUTO: Roopa Mahendra is out of the office. (returning 25/03/2010)14_Roopa Mahendra25_roopa.mahendra@IN.IBM.COM31_Mon, 22 Mar 2010 11:11:25 +0530448_US-ASCII I am out of the office until 25/03/2010.

I have limited access to my mails during this period. I will respond to
your message when I return. 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 Digest - 15 Mar
2010 to 16 Mar 2010 (#2010-74)" sent on 16/3/10 6:30:00. [...]68_OF7543CB13.2BB6428E-ON652576EE.001F423F-652576EE.001F423F@in.ibm.com 182 60 10_sql puzzle10_Zhang Ming16_db2sub@YAHOO.COM31_Mon, 22 Mar 2010 04:12:20 -0700552_iso-8859-1 dear all,we had a old db2 applications with data defined with char. recently, we need to sum the data under some columns,by online transaction. exampl like this: select last_date, sum(decimal (substr(data_item,| 28,1) ||substr(data_item,11,14)||                                 '.'||substr(data_item,25,3),14,3)) from dbcs.actact where key_col1='xxx'  and    key_col2='yyy' and (colmx='x' or colmy='yy') group by key_col1,key_col2 order by key_col1,key_col2;  does anyone know other methods which had better performance than this. Tks. [...]44_931796.13154.qm@web113707.mail.gq1.yahoo.com 243 182 22_AW: [DB2-L] sql puzzle35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Mon, 22 Mar 2010 13:03:20 +0100476_iso-8859-1 You can create a new column and put these values (maybe using a before trigger) into this new column and then sum up using this column. Furthermore, I don't know of any other solution, because your values are spread over the whole char-column.

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Victoriaplatz 2
40477 Düsseldorf
mailto:walter.janissen@itergo.com [...]43_DB2-L%201003221203302328.08AD@IDUGDB2-L.ORG 426 104 74_IDUG Webcast TODAY - DB2 for z/OS Stored Procedures: Trends and Technology10_Mark Labby21_mlabby.idug@GMAIL.COM31_Mon, 22 Mar 2010 08:15:37 -0400430_ISO-8859-1 Quick reminder -

IDUG Webcast on DB2 For z/OS Stored Procedures: Trends And Technology"  IS
NOW available at http://www.idug.org/catterall.mp4

Since we have members in all time zones, we are making the webcast
available early. Please note that Robert Catterall will answer your
questions live from 2:10 pm - 2:30 pm  EST. The live chat session can be
accessed at http://www.idug.org/chat [...]36_C7CCD7A9.1B2AC%mlabby.idug@gmail.com 531 293 41_Re: UNLOAD - Increase of temporary space?7_DB2 DBA21_the.db2.dba@GMAIL.COM31_Mon, 22 Mar 2010 09:27:31 -0400632_ISO-8859-1 Hello David:

Yes, there is an ORDER BY, so SORT is being performed.

No, none of the columns is very long (482 is the record length).

-Josh Wawzynzak

On Fri, Mar 19, 2010 at 5:37 PM, Dave Nance wrote:

> It would seem that you have a fairly small sort work area. Is there
> an order by or due to something in the query a sort is being performed.
> Also, is one of the columns you are selecting very long?
>
> David Nance
>
>
>
> ------------------------------
> *From:* DB2 DBA
> *To:* DB2-L@IDUGDB2-L.ORG
[...]59_85726c9d1003220627s55a3d914od991f960938b51fd@mail.gmail.com 825 198 41_Re: UNLOAD - Increase of temporary space?7_DB2 DBA21_the.db2.dba@GMAIL.COM31_Mon, 22 Mar 2010 09:35:34 -0400644_ISO-8859-1 Hello Sushanta:

You are right. It is only one table that I am unloading data from and there
is an ORDER BY.

-Dinesh

On Sun, Mar 21, 2010 at 11:38 PM, Sushanta Dash <
Sushanta.K.Dash@wellsfargo.com> wrote:

> Hi John,
>
> Josh can get the same TIAUL output even tough he uses a single table in the
> sql.
>
> With Thanks
> Sushanta Dash
> DARC Team
>
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of John Saunders
> Sent: Saturday, March 20, 2010 4:54 AM
> To: DB2-L@IDUGDB2-L.ORG
> Subject: Re: [DB2-L] UNLOAD [...]59_85726c9d1003220635t648ffe17mdcd21f41336e33f5@mail.gmail.com 1024 300 41_Re: UNLOAD - Increase of temporary space?7_DB2 DBA21_the.db2.dba@GMAIL.COM31_Mon, 22 Mar 2010 09:53:51 -0400369_ISO-8859-1 Carol,

That's right, I ran out of 4K work space.

While I try fixing that, I was also wondering why did the other (very
similar with the same number of columns - SELECT *) did not fail and why did
SELECT COL2,COL3,COL4... COL1 FROM fail?

Josh Wawzynzak

On Fri, Mar 19, 2010 at 4:44 PM, wrote: [...]58_85726c9d1003220653wc24af89u9d0c438418aaf9f3@mail.gmail.com 1325 408 49_AW: [DB2-L] UNLOAD - Increase of temporary space?32_=?utf-8?B?S3VydHosIFLDvGRpZ2Vy?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Mon, 22 Mar 2010 15:32:43 +0100571_utf-8 Josh,

to put it in a nutshell:

You have only a limited amount of workspace, and once you run out of it, you run out of it.

If there is a high number of concurrent jobs, they share the workspace on a first-come, first-serve basis, and once there is nothing to be served any longer you get a -904.
If similar jobs run fine that just means that there was enough space in your workpools then with no guarantee whatsoever that there will be enough space next time.
Chances are that your failing job may actually finish correctly if there [...]69_31CF7002A1132E40BD5AD816A179C1588C917908F6@VMX00100.lan.huk-coburg.de 1734 195 41_Re: UNLOAD - Increase of temporary space?9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 22 Mar 2010 11:27:47 -0500379_US-ASCII I suppose it is a good time to mention that batch sort programs are an order
of magnitude faster than DB2 sort.

A DSNTIAUL without the order by followed by DFSORT/SYNCSORT or whatever the
local sort is almost always faster even with the overhead of reading/writing
the output file twice. This is expecially true once you get to millions of
rows. [...]43_DC08818BA5FC4AFB8A055A5FEBDAF713@mikelaptop 1930 731 41_Re: UNLOAD - Increase of temporary space?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 22 Mar 2010 13:59:17 -0400427_us-ascii Josh,
Two possible answers to your latest question:
First possibility is that there was much less 4K space being used by other processes when your formerly named SELECT (the SELECT *) ran, than when the column-specific select ran.
Second possibility is that a SELECT * was recognized by DB2 as not needing to "materialize" (create a work dataset) and the SELECT (specific columns) was not so recognized. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC4672B@MAIL02.fisalan.nycnet 2662 27 33_Re: AW: [DB2-L] Interesting Stats10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Mon, 22 Mar 2010 19:05:16 +0000378_UTF-8 Robert,

I'd have to see about the connection concentrator piece. Everything was set to defaults, which was bad. I had to get them to specify an isolation level since the default was Read Stability. The issue with workload balancing is that Capacity Planning Doesn't want adhoc work on two of the four Lpars so they may not let us use connection concentration. [...]53_9817073229917957.WA.jorghluekebcbsmn.com@www.idug.org 2690 558 41_Re: UNLOAD - Increase of temporary space?7_DB2 DBA21_the.db2.dba@GMAIL.COM31_Mon, 22 Mar 2010 16:20:22 -0400489_windows-1252 Phil,

Finally something close to what I am thinking...

- This is a kind of a 'sand box' SS and only I use it
- Your point about 'materializing', makes very good sense to me
- I have reproduced/retried the problem multiple times and the results have
been no different
- Usage of DFSORT/SYNCSORT, this is exactly the route which I thought of as
an alternative
- OPTION DYNALLOC is something I never used before. I shall surely try it
out [...]59_85726c9d1003221320k55c79090q26474e609802b6ce@mail.gmail.com 3249 779 39_NEDB2UG Meeting Notice - March 25, 20107_Ed Long19_rdhm99a@PRODIGY.NET31_Mon, 22 Mar 2010 13:52:02 -0700556_utf-8 The next meeting of the New England DB2 User's group will occur on Thursday March 25, 2010 in the Tap Room at the Publick House in Sturbridge Mass. As usual we will start at 0900 and wrap up by 4:00 pm.
Please pre-register by going to the web site NEDB2UG.ORG and click on the rotating "CLICK HERE TO REGISTER"   or send an email to NEDB2UG@gmail.com   The registration fee for this meeting is $50.00.   Payment is at the door by cash (preferred) or check.     Agenda:     0900-0915 - Opening Remarks   0915-1030 – Utilizing Views, [...]43_695369.66860.qm@web80201.mail.mud.yahoo.com 4029 95 10_Set NOMAIL11_Hardy, Dale14_DHardy@MIB.COM31_Mon, 22 Mar 2010 17:03:28 -0400822_us-ascii Set NOMAIL

________________________________

[http://www.idug.org/partners/www/images/4992e0ad2d01c9c12dd8a4e7a161cd08.gif]

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.

-----------------------------------------

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]60_C008965E3996AB4FA3A61A6AA4EF84ED1B471FE4@mibmailexch.mib.com 4125 187 3_sql10_Zhang Ming16_db2sub@YAHOO.COM31_Mon, 22 Mar 2010 19:20:34 -0700321_utf-8 Dear all,I need to do following: the contents of one table just like col1 data 1 2 1 8 1 18 2 2 2 8 2 20 3 2 3 8 3 18 3 999 and i want to get the result as: col1 data1 data2 1 8 18 2 8 null 3 8 18 that means for each data,if it equal 8 or 18,need to be see in one line. how can i using sql to acheve it. Tks. [...]43_62223.26475.qm@web113716.mail.gq1.yahoo.com 4313 249 7_Re: sql10_Dave Nance16_dav1mo@YAHOO.COM31_Mon, 22 Mar 2010 20:56:45 -0700587_utf-8 Ming,    You didn't really explain well enough for us to give you exact answer. For instance, what do you want done if 8 or 18 do not exist for the col1. Either of the following should work for you, with some more tweaking possibly. select col1    ,case when data = 8 then data else null end as data1    ,case when data = 18 then data else null end as data2    from your_table where data in (8,18) OR select col1, data1, data2    from (select col1, data as data1                     from your_table              where data = 8) as a [...]42_946508.4287.qm@web57806.mail.re3.yahoo.com 4563 62 7_Re: sql10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Tue, 23 Mar 2010 04:52:59 +0000576_UTF-8 Hi Zhang,

See if this meets your needs.

SELECT Col1, MAX(CASE WHEN data='8' THEN '8' ELSE NULL END) AS Data1,
MAX(CASE WHEN data='18' THEN '18' ELSE NULL END) AS Data2
FROM table1
GROUP BY Col1
WITH UR;

On Mon, 22 Mar 2010 19:20:34 -0700, Zhang Ming wrote:

>Dear all,I need to do following:

the contents of one table just like
col1 data
1 2
1 8
1 18
2 2
2 8
2 20
3 2
3 8
3 18
3 999
and i want to get the result as:
col1 data1 data2
1 8 18
2 8 null
3 [...]54_3537814800216179.WA.teldb2kalstelstra.com@www.idug.org 4626 44 34_DSNHDECP for precompile and NEWFUN10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Tue, 23 Mar 2010 05:43:00 +0000469_UTF-8 Hi,

How does the default value for NEWFUN change when we move to v8 NFM ? Is it because it updates our customised version of DSNHDECP, and is the expectation that we do have the customised version in the linklist or steplib ?

Due to some legacy process, some of our COBOL preparation jobs have SYS1.DB2.SDSNLOAD in the precompiler STEPLIB. And the precompile uses NEWFUN(NO). It didn't matter till now, as we were still on v8 CM all this time. [...]54_8923466352756733.WA.teldb2kalstelstra.com@www.idug.org 4671 426 15_AW: [DB2-L] sql35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Tue, 23 Mar 2010 10:15:09 +0100738_iso-8859-1 Hi

Select coalesce(a.col1, b.col1) as col1, a.data1, b.data2
from (select col1, data as data1
from t1
where data = 8) as A
full outer join
(select col1, data as data2
from t1
where data = 18) as b
on a.col1 = b.col1

Mit freundlichen Grüßen
Walter Janißen

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

Vorsitzender des Aufsichtsrates: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996 [...]43_DB2-L%201003230915205473.0947@IDUGDB2-L.ORG 5098 316 7_Re: sql18_B. L. "Tink" Tysor16_Tink@BLTYSOR.COM31_Tue, 23 Mar 2010 08:08:35 -0400440_UTF-8 Hi Zhang,

Try:

SELECT
COL1
, (SELECT CASE COL2
WHEN 8 THEN 8 ELSE NULL
END
FROM TEMPA
WHERE COL1 = DV.COL1
AND COL2 = 8) AS COL2
, (SELECT CASE COL2
WHEN 18 THEN 16 ELSE NULL
END
FROM TEMPA
WHERE COL1 = DV.COL1
AND COL2 = 18) AS COL3
FROM
(SELECT DISTINCT COL1 FROM TEMPA) AS DV;

Tink

On Mon, Mar 22, 2010 at 10:20 PM, Zhang Ming wrote: [...]59_105fd0281003230508q19fdebf1mf76ce11810a235c1@mail.gmail.com 5415 52 34_This wouldn' be indexable would it10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Tue, 23 Mar 2010 16:24:00 +0000382_UTF-8 The predicates used to all be on the A table but for illogical reasons some columns were moved to the B table.
Between the OR condition and the fact it needs to look at both tables to resolve some of the clauses
I don't see this being indexable. Anyone out there have a thought? DB2 9 z/os, tables are 10-12million, the B table record length is 32k (2k compressed) [...]53_8692468584906409.WA.jorghluekebcbsmn.com@www.idug.org 5468 224 49_Re: Stored Procedure nest level exceeded response11_Suresh Sane21_data_arch@HOTMAIL.COM31_Tue, 23 Mar 2010 12:08:47 -0500468_Windows-1252 Dave - I have done this for triggers (same rule applies for triggers/SP/UDF).

Reaching the the 17th level produces sqlcode -724, sqlstate 54038.

If SP's are not producing such a message, I would consider it a bug and follow up with IBM.

Thx

Suresh

Date: Wed, 17 Mar 2010 11:17:41 -0400
From: Dave.Seibert@COMPUWARE.COM
Subject: [DB2-L] Stored Procedure nest level exceeded response
To: DB2-L@IDUGDB2-L.ORG [...]43_COL104-W4372BB886EE4549B44689898260@phx.gbl 5693 125 38_Re: This wouldn' be indexable would it10_Dave Nance16_dav1mo@YAHOO.COM31_Tue, 23 Mar 2010 10:14:38 -0700608_iso-8859-1 I could see it getting multi-index access. If that is the case you might get a bit faster access by putting all of the AND/OR conditions in separate UNIONs.   David Nance   ________________________________ From: Jorg Lueke To: DB2-L@IDUGDB2-L.ORG Sent: Tue, March 23, 2010 12:24:00 PM Subject: [DB2-L] This wouldn' be indexable would it The predicates used to all be on the A table but for illogical reasons some columns were moved to the B table. Between the OR condition and the fact it needs to look at both tables to resolve some of the clauses I don't see this [...]43_822789.22220.qm@web57804.mail.re3.yahoo.com 5819 23 35_Alter DB2 sequence in COBOL program17_Trembacki, Robert26_robert.trembacki@BCBSA.COM31_Tue, 23 Mar 2010 14:09:07 -0500636_us-ascii We are having problems coding an alter of a DB2 Sequence in a COBOL program. When we execute the program the alter statement is not using the qualifier from the bind but is using the owner from the bind.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** NEW - IBM hands-on labs -> no additional charge
_____________________________________________________________________ [...]59_50BA2F81CF76F7438BD87069FCFD41358609A7FD@cexchmb1.bcbsa.com 5843 38 21_Non-persistent paging16_David J. Tkaczyk23_Tkaczyk.David@AOINS.COM31_Tue, 23 Mar 2010 20:11:42 +0000512_UTF-8 I want to display a potentially large amount of rows to the user and provide paging functionality. Instead of a cursor I used the following SQL using the Row_Number() function to only query the rows that need to be on that page.

select col1, col2
(
select
row_number() over() as StartPos,
col1, col2
from tableA
fetch first N rows only -- where N is the (rows/page * page number desired)
) as T1
where StartPos >= P -- where P is (rows/page * (page number desired - 1)) [...]55_4763667501627095.WA.Tkaczyk.Davidaoins.com@www.idug.org 5882 29 24_Monitor LOCK ESCALATIONS4_Anil21_alisha_kale@YAHOO.COM31_Wed, 24 Mar 2010 03:23:30 +0000659_UTF-8 Hi All !

I am looking forward to hear from fellow DBA's as to what are the various procedures/job streams they have set up in place to monitor lock escalations in DB2 land (on z/os).

Thanks in advance.

Anil

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]52_3446843378374108.WA.alishakaleyahoo.com@www.idug.org 5912 36 12_FREE PACKAGE4_Anil21_alisha_kale@YAHOO.COM31_Wed, 24 Mar 2010 03:28:54 +0000529_UTF-8 hi all !

Is there a way to get back a package that was freed using the FREE PACKAGE command (DB2 V9 CM on z/os) ?

Let me explain the context of this question:
We have implemented package versioning. So we have multiple versions of a package. We do run some free packages to clean up the SPT01.
Occasionally somebody comes back and says that we freed up a package that was in use. We find it hard to track the DBRM that was used to create the package. So I am looking at ways I could simply get the [...]52_4033511682071915.WA.alishakaleyahoo.com@www.idug.org 5949 68 50_AUTO: Bill Pigg/San Jose/IBM is out of the office.9_Bill Pigg16_wpigg@US.IBM.COM31_Tue, 23 Mar 2010 22:01:37 -0600757_US-ASCII I am out of the office until 03/31/2010.

I will be selectively available via wm_pigg@yahoo.com.

Note: This is an automated response to your message "DB2-L Digest - 23 Mar
2010 to 24 Mar 2010 (#2010-82)" sent on 3/23/10 19:00:00.

This is the only notification you will receive while this person is away.
_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]68_OFAE8F518D.E297D222-ON872576F0.00161F16-872576F0.00161F16@us.ibm.com 6018 128 36_Dummy LISTDEF with a REORG statement16_Laurens Zwanepol31_lbn.zwanepol@BELASTINGDIENST.NL31_Wed, 24 Mar 2010 09:22:24 +0100589_us-ascii Hoi,

I'm working on an REORG procedure that has to run every day/night but the
nummer of objects can be different every night.
As long as the number of objects are > 1 there is nog problem.
But when the objects are =0 then the listdef, quiesce or reorg will abend
with RC=8.
I have managed to produce an empty LIST bij include and exclude the same
object.
But then the quiesce gives
LISTDEF STATEMENT PROCESSED SUCCESSFULLY
QUIESCE LIST LISTIVO
- LISTDEF LISTIVO CONTAINS NO OBJECTS
UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8 [...]76_OF9DD94206.2A736328-ONC12576F0.002CBF41-C12576F0.002DFFA9@belastingdienst.nl 6147 418 40_Re: Dummy LISTDEF with a REORG statement13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Wed, 24 Mar 2010 04:04:47 -0500398_us-ascii Hi Laurens,

Could you not ensure the Listdef has at least one object by specifically adding an object you know will exist - say, the equivalent of Sysdummy1, but a TS of your own making? So rather than trying to go down a different processing path for different numbers of objects, you do the same processing path but guarantee to always have at least one object in your list. [...]67_78B3EFE2C0C5D74E9E7777D1D669D5420A4FA9C5@PHXCCRPRD04.adprod.bmc.com 6566 66 39_Re: Alter DB2 sequence in COBOL program13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Wed, 24 Mar 2010 07:04:32 -0400293_iso-8859-1 I think this may be due to the way authids are resolved for DML vs DDL

DML (SQL) uses the CURRENT authid - which in a PLAN I think is the qualifier

But DDL always uses the PRIMARY authid, which in a PLAN is the owner of the plan

Altering a sequence is DDL [...]58_4440F5DA00E3F3459BBCB97431B91B6611A59AE6@MAILR004.mail.lan 6633 53 16_Re: FREE PACKAGE13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Wed, 24 Mar 2010 07:05:55 -0400425_utf-8 ISV log analysis tools normally provide DROP RECOVERY functionality which would probably allow a FREE to be reversed as well

If not, then a log report would still enable you to determine which rows were removed when you did the FREE to enable you to recreate the package

Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk [...]58_4440F5DA00E3F3459BBCB97431B91B6611A59AE7@MAILR004.mail.lan 6687 596 40_Re: Dummy LISTDEF with a REORG statement13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Wed, 24 Mar 2010 07:12:31 -0400309_us-ascii But then he'd be reorging an object unnecessarily

I'm surprised that an empty LIST seems to be treated as an error

You might be able to use OPTIONS ITEMERROR to SKIP the error, but this seems to be a bit of a sledgehammer and there might be many errors that you don't want to skip [...]58_4440F5DA00E3F3459BBCB97431B91B6611A59AE8@MAILR004.mail.lan 7284 380 40_Re: Dummy LISTDEF with a REORG statement13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Wed, 24 Mar 2010 05:20:01 -0600360_us-ascii "...But then he'd be reorging an object unnecessarily..."

True, but at least his existing process would work. For the price of an otherwise worthless one-row table reorg, I'd buy that for a dollar (as a line from an old, old movie goes).

RC=8 does seem a bit harsh though. It might indeed be IBM RFE (Request For Enhancement) time. [...]67_78B3EFE2C0C5D74E9E7777D1D669D5420A590DC6@PHXCCRPRD04.adprod.bmc.com 7665 53 16_Re: FREE PACKAGE14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 24 Mar 2010 22:20:15 +1100402_US-ASCII Use DSN1LOGP to print the undo contents of SYSPACKSTMT when the FREE was issued.
Then use the REXX that was posted the other week (with appropriate modifications) to
rebuild the source DBRM.

Or use the REXX to rebuild, and archive, the source DBRM before the FREE; or BIND COPY
the package into a dummy collection. After a while you can assume it really isn't being used. [...]49_4BAA901F.29097.1A1FCA28@jacampbell.acslink.net.au 7719 80 28_Re: Monitor LOCK ESCALATIONS10_Dave Nance16_dav1mo@YAHOO.COM31_Wed, 24 Mar 2010 04:30:16 -0700687_iso-8859-1 I have always felt the best way to monitor them was not to allow them. Use LOCKMAX 0. This will force your application teams to use commits, which they should be doing anyway in batch processes.   David Nance ________________________________ From: Anil To: DB2-L@IDUGDB2-L.ORG Sent: Tue, March 23, 2010 11:23:30 PM Subject: [DB2-L] Monitor LOCK ESCALATIONS Hi All ! I am looking forward to hear from fellow DBA's as to what are the various procedures/job streams they have set up in place to monitor lock escalations in DB2 land (on z/os). Thanks in advance. Anil _____________________________________________________________________ * IDUG North [...]43_942905.32175.qm@web57804.mail.re3.yahoo.com 7800 262 16_Re: FREE PACKAGE14_Fazio, Richard21_RFAZIO@TRANSUNION.COM31_Wed, 24 Mar 2010 06:35:06 -0500459_iso-8859-1 Hmmm....



Seems to me that this is a preventable scenario. I love tools to get you out of a "bind" (oh yes, pun intended). But, you are discussing a flaw in your SDLC. Upon installing / de-installiing any code you should have appropriate backups taken. And that version tracked. As such, your DBRM member should be a dataset restore away at the very least. Best case is that you redeploy from your source control tool. [...]70_0CF187805D9C924DAFF59A877104C36A020EE3F3@CHI4EVS04.corp.transunion.com 8063 67 39_Re: Alter DB2 sequence in COBOL program14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 24 Mar 2010 22:39:35 +1100396_ISO-8859-1 Are you doing the alter by dynamic SQL or static SQL? If dynamic, what is
the DYNAMICRULES? Read the section which describes qualification.

Since V8, it is not current authid that qualifies dynamic sql with
DYNAMICRULES(RUN) - it is current schema. We all forget this, since a
SET CURRENT SQLID also sets the SCHEMA; but it is the SCHEMA that is
actually used. [...]48_4BAA94A7.9101.1A317ECF@jacampbell.acslink.net.au 8131 109 39_AW: Alter DB2 sequence in COBOL program35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Wed, 24 Mar 2010 12:57:26 +0100704_iso-8859-1 Hi

So, in our installation we wouldn't have any problems, because owner and qualifier are the same. We use bindagent, to make folks use that owner.

Maybe that could also a solution for your problem.

Mit freundlichen Grüßen
Walter Janißen

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

Vorsitzender des Aufsichtsrates: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996 [...]43_DB2-L%201003241157389293.0994@IDUGDB2-L.ORG 8241 111 16_Re: FREE PACKAGE12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Wed, 24 Mar 2010 07:46:57 -0500450_utf-8 Phil:

Since we are discussing ISV Tools, DBRM Check will create Free Commands only when there is no match between a load module and the package. It also allows you to create a backup of the DBRM being dropped. We do web meetings to discuss this functionality at no charge.

This Functionality is available from HLS Technologies, Inc. through its DBRM Check product or from IBM DB2 Tools as part of their Bind Manager product. [...]35_009b01cacb50$1755ed90$4601c8b0$@com 8353 348 49_AD: Next weeks DB2 Tech Talk from Cogito and HMNA13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Wed, 24 Mar 2010 09:10:12 -0400342_us-ascii Hi all,

I just wanted to remind you of next weeks DB2 Tech Talk

As those of you who were there will know, there were so many registrations for the first DB2 Tech Talk that we had to procure the services of a new Webinar platform at very short notice. Hopefully you all enjoyed my efforts to "learn on the hoof" :) [...]58_4440F5DA00E3F3459BBCB97431B91B6611A59AF7@MAILR004.mail.lan 8702 214 67_Applied maintenance on db2 9.1 recently , omegamon 410 - db2 status11_Diana Nagel16_dknagel@BEPC.COM31_Wed, 24 Mar 2010 09:29:56 -0500583_us-ascii See below I have lost my status for distributive threads no matter where it comes from access, etc. Any one have any thoughts. Is there a apar or something to fix this.

Test - applied maintenance
Elapsed Planname CPU Status GetPg Update Commit CORRID/JOBN
---------- -------- ----- ------------ ------ ------ ------ ------------
05-01:30 DISTSERV 00.0% N/A 3487 0 1458 db2jcc_appli
01-00:11 DISTSERV 00.0% N/A 174 0 10 db2jcc_appli
23:04:43.8 KO2PLAN 00.0% NOT-IN-DB2 22575 8194 4113 CANSO2
23:04:43.7 KO2PLAN 00.0% NOT-IN-DB2 4517 60 7 CANSO2 [...]54_6454C4DAE553484980557DB37B06BC03046E01@HDQ153.bepc.net 8917 175 71_Re: Applied maintenance on db2 9.1 recently , omegamon 410 - db2 status10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 24 Mar 2010 15:45:19 +0100711_UTF-8 Did you bounce your DB2 ?

Max Scarpa

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

The hitchhikers Galaxy Guide to IDUG EU 2010:

- DON'T PANIC
- DB2 for z/OS 9 and V......
- DB2 LUW 9.7 with Oracle Comp. Features..
- PureScale
- PureQuery
*********************************************************************************

Diana Nagel
Sent by: IDUG DB2-L
24/03/2010 15.35
Please respond to
IDUG DB2-L [...]66_OFB453306D.24E68E42-ONC12576F0.0050B621-C12576F0.0050B0EB@cesve.it 9093 58 40_Re: Dummy LISTDEF with a REORG statement10_Mark Labby21_mlabby@AESSUCCESS.ORG31_Wed, 24 Mar 2010 12:27:03 -0400457_iso-8859-1 You have a secure email message waiting for you from Mark Labby at AES/PHEAA with the subject: Re: [DB2-L] Dummy LISTDEF with a REORG statement.

How to Retrieve Your Message

To retrieve your message from Mark Labby with the subject: Re: [DB2-L] Dummy LISTDEF with a REORG statement, go to:
https://securemail.aessuccess.org/messenger/msg?x=d-32577535-6vBeulMFPhAMwvEB

This message will be available until 05/23/2010. [...]64_securemail.d-32577535-6vBeulMFPhAMwvEB@securemail.aessuccess.org 9152 148 32_Re: STOGROUP Reached Max Volumes15_Campbell, Wayne28_Wayne.Campbell@COURTS.WA.GOV31_Wed, 24 Mar 2010 09:58:31 -0700548_iso-8859-1 I would think that SMS would be the preferred way of managing the Storage. In our DB2 development SMS Storage Group, which has about 350 3390-3 volumes we run with about 2.4% free. I have never had any problems with REORGS or Loads.

Another option if you don't have SMS, and you have a SHARK or other Raid storage device, is define the storage to a larger Volume image such as a 3390-9 or 3390-27. I'm currently looking at going to 3390-9 images to reduce the number of volumes to manage, which leads me to another question. [...]66_2A1B28C5CC983C4F8253CF1FA121853214C2F9F7EF@EXCHMAIL1.courts.wa.gov 9301 394 69_[AD] Guaranteed to Run IBM Content Manager Class April 12th Baltimore7_Kim May28_kim.may@THEFILLMOREGROUP.COM31_Wed, 24 Mar 2010 13:42:11 -0400394_us-ascii The Fillmore Group will deliver the IM401 class, IBM DB2 Content Manager V8
Implementation and Administration, in our Towson classroom, just north of
Baltimore, starting April 12th. This is a hands-on, four-day class, The
Fillmore Group has successfully delivered on IBM's behalf several times.
The course instructor will be DB2 Gold Consultant Frank C. Fillmore, Jr. [...]41_4baa4ef9.9915f10a.2970.0afe@mx.google.com 9696 41 87_Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?12_Amlan Prasad16_amlan_pd@MSN.COM31_Wed, 24 Mar 2010 18:00:23 +0000604_UTF-8 Hello,

My understanding is that DB2 CAF for CICS and batch environments are different because of which two different load modules are needed to run in these environments even when the actual program may be same.

In my project there are many COBOL programs which have DB2 statements but no CICS and are needed for both batch and online. They are just service programs. Currently we have to create two different programs with almost identical code to get two different load modules.
If there is some way where we can have only one program load module work in both environments, [...]47_6677096868519412.WA.amlanpdmsn.com@www.idug.org 9738 27 12_Dual Logging11_Dale Miller33_dalemiller@NORTHWESTERNMUTUAL.COM31_Wed, 24 Mar 2010 18:47:34 +0000441_UTF-8 The DBAs are getting a lot of questions regarding the 'true need' for dual logging of DB2. There is push back from Storage Management specialists that hardware errors are a thing of the past. Dual logging is a waste of space and in an environment where DASD is mirrored to another location it is unecessary.
Is dual logging still the standard practice? Has anyone eliminated dual logging and if so, what was the justification? [...]65_4871874156518705.WA.dalemillernorthwesternmutual.com@www.idug.org 9766 210 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?15_Andrew Lawinger17_alawinger@MMM.COM31_Wed, 24 Mar 2010 14:22:55 -0500364_US-ASCII If I understand correctly this may only be a matter of doing a dynamic
call of the subroutine vs a static call of the subroutine.
Then pointing either the steplib or the DFHRPL to the correct library for
batch or CICS (respectively).

Static CALLs
In COBOL, you normally call a subroutine like this:

CALL 'A' USING arguments [...]65_OF21A61B5A.7A3D803D-ON862576F0.006A43E6-862576F0.006A7839@mmm.com 9977 32 22_7 Steps to Performance11_Dave Beulke19_dave@DAVEBEULKE.COM31_Wed, 24 Mar 2010 18:58:35 +0000416_UTF-8 I have posted a new entry on my DB2 Blog.

7 Steps to Performance

Performance is elusive and difficult to achieve in any type of application system these days. With so many options, servers, databases, application coding techniques and configuration parameters, it is sometimes amazing that things get done at all....(More)

You may read the entire article at http://www.davebeulke.com [...]51_7994812642025884.WA.davedavebeulke.com@www.idug.org 10010 103 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?0_33_armando.jorge.arranja@BANCOBPI.PT31_Wed, 24 Mar 2010 19:39:03 -0000330_iso-8859-1 We use that for years.

All the compile/link/bind is made under endevor control. Each program is linked to a processor group, depending of the program usage and name conventions and the load modules are generated with that. One or two, on distinct load libraries, one for batch usage and one for CICS usage. [...]69_12B88FB8BDDD354BB209A8DED63243730762A858@SCCSEXM01.scentrais.gbpi.loc 10114 247 28_Re: Monitor LOCK ESCALATIONS0_33_armando.jorge.arranja@BANCOBPI.PT31_Wed, 24 Mar 2010 19:52:41 -0000535_iso-8859-1 DSNI031I messages are written in a file for NEXT DAY study.

Armando

________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dave Nance
Sent: quarta-feira, 24 de Março de 2010 11:30
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Monitor LOCK ESCALATIONS

I have always felt the best way to monitor them was not to allow them. Use LOCKMAX 0. This will force your application teams to use commits, which they should be doing anyway in batch processes. [...]69_12B88FB8BDDD354BB209A8DED63243730762A872@SCCSEXM01.scentrais.gbpi.loc 10362 65 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?13_Johnny Wilder28_Johnny.Wilder@MOTION-IND.COM31_Wed, 24 Mar 2010 14:56:09 -0500403_us-ascii Would a DB2 stored procedure work for you? We had a similar situation and created a stored procedure.

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Amlan Prasad
Sent: Wednesday, March 24, 2010 1:00 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online? [...]73_1A20EF32A1A1CA44B36AF5D6920397221645D35F72@MIHQPEXMB1.corp.motion-ind.com 10428 50 16_Re: Dual Logging0_27_Jeff.D.Jerry@WELLSFARGO.COM31_Wed, 24 Mar 2010 15:10:28 -0500636_us-ascii Do not bow to the pressure. We went through this same issue. If you go to single logging you could be setting yourself up for a real disaster.

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dale Miller
Sent: Wednesday, March 24, 2010 1:48 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Dual Logging

The DBAs are getting a lot of questions regarding the 'true need' for dual logging of DB2. There is push back from Storage Management specialists that hardware errors are a thing of the past. Dual logging is a waste of space and in an environment where DASD is [...]73_0E26D05C12D90A479E2588CDC970AF43295C0A5363@MSGCMSV21014.ent.wfb.bank.corp 10479 49 16_Re: Dual Logging13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Wed, 24 Mar 2010 16:15:22 -0400502_utf-8 DB2 MUST have write access to a log

Dual logging removes a single point of failure

Turn dual logging off and have an I/O error on an active log, and DB2 WILL abend

Who is then responsible?

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

Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org [...]58_4440F5DA00E3F3459BBCB97431B91B6611A59B37@MAILR004.mail.lan 10529 81 16_Re: Dual Logging10_Roger Hecq18_Roger.Hecq@UBS.COM31_Wed, 24 Mar 2010 16:23:55 -0400481_US-ASCII I would agree that DASD is extraordinarily reliable and it has been a
number of years since I experienced a DASD failure. Unfortunately,
human error is not 'a thing of the past' and in the years since that
last DASD failure, I have experienced several DASD subsystem outages due
to human error. Given the relatively small size of the logs, compared to
the typical amount of data, I would not consider that a 'wise' way to
decrease DASD utilization. [...]62_1A700EEF49343148A08879B1E3CA5BA614516D8B@NSTMC101PEX1.ubsw.net 10611 26 28_Re: Monitor LOCK ESCALATIONS4_Anil21_alisha_kale@YAHOO.COM31_Wed, 24 Mar 2010 20:37:02 +0000598_UTF-8 That was the thought that crossed my mind as well (capture DSNI031I messages). But just wasn't sure if there was a better way to monitor it.

Thanks

Anil

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]52_4458620066387039.WA.alishakaleyahoo.com@www.idug.org 10638 78 16_Re: Dual Logging14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 24 Mar 2010 16:43:00 -0400574_us-ascii Dale,

1) Ask them if they can guarantee mirroring of the Log DASD. And if so, then why are they arguing about double logging?
2) Also, as Roger has pointed out, most logging is not large in comparison to the amount of data being stored. There are better places to seek DASD economies.
3) Seriously -- you only skip double logging of data you can easily restore from another source, or data which you don't care if you lose. In any database. (Oracle also double-logs, and I don't think they offer you the option of single logging.) It's _your_ job [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46750@MAIL02.fisalan.nycnet 10717 589 41_Re: UNLOAD - Increase of temporary space?7_DB2 DBA21_the.db2.dba@GMAIL.COM31_Wed, 24 Mar 2010 16:57:45 -0400606_windows-1252 Thank you all for your comments/suggestions/directions on this problem.

Tx,
Pete.

On Mon, Mar 22, 2010 at 4:20 PM, DB2 DBA wrote:

> Phil,
>
> Finally something close to what I am thinking...
>
> - This is a kind of a 'sand box' SS and only I use it
> - Your point about 'materializing', makes very good sense to me
> - I have reproduced/retried the problem multiple times and the results have
> been no different
> - Usage of DFSORT/SYNCSORT, this is exactly the route which I thought of as
> an alternative
> [...]59_85726c9d1003241357y61431b7ck5ffec4e2288c193c@mail.gmail.com 11307 95 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?16_Daniel Luksetich18_danl@DB2EXPERT.COM31_Wed, 24 Mar 2010 16:04:09 -0500611_UTF-8 Hello,
Try this.

http://www.zjournal.com/index.cfm?section=article&aid=790

let me know if the link works or if you need more advice.

Cheers,
Dan

Daniel L Luksetich
IBM Information Champion
IBM Certified Database Administrator - DB2 9 for z/OS
IBM Certified System Administrator - DB2 9 for z/OS
IBM Certified Solutions Expert - DB2 Universal Database V7.1 Database Administration for UNIX, Windows, and OS/2
IBM Certified Solutions Expert - DB2 UDB V7.1 Family Application Development
IBM Certified Advanced Technical Expert - DB2 Data Replication [...]35_029501cacb95$8c6f4af0$a54de0d0$@com 11403 33 8_DSN1COPY4_Anil21_alisha_kale@YAHOO.COM31_Wed, 24 Mar 2010 20:26:02 +0000433_UTF-8 Hi All !

I want to copy data from production to test. Since it could be data from a previous point in time, I want to use DSN1COPY to copy it from a PROD IMAGECOPY.
I presume there are many out there already doing it.
Can someone share with me a sample JCL to perform the DSN1COPY from PROD IMAGECOPY to DB2 datasets in the test environment.
Also, if you could mention what are some of the considerations. [...]52_8191166087084885.WA.alishakaleyahoo.com@www.idug.org 11437 49 16_Re: Dual Logging12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Wed, 24 Mar 2010 15:31:32 -0600400_utf-8 I have seen some customers do single logs in lower level test environment, but never in production. As Phil pointed out, DB2 will STOP if it can't write a log record. I saw one shop undersize the Actives in an earlier version of DB2, and they had a runaway update that caused the last Active to wrap before the first was done with ARCHIVE. DB2 froze solid. At least it stopped the update! [...]69_B04A515BCAE7C34D90FEE204B055E3B24A439285FC@PHXCCRPRD02.adprod.bmc.com 11487 155 16_Re: Dual Logging7_Ed Long19_rdhm99a@PRODIGY.NET31_Wed, 24 Mar 2010 14:36:56 -0700426_iso-8859-1 While physical media failures have become quite rare, the famous finger check can and does still occur and really ruins your day.
 
If someone has to delete two sets of archive logs to make a system unrecoverable its much more likely to be sabotage than just a bad day.
 
If its a production system then dual logging is cheap insurance.
 
For a test system, single logging is probabily fine. [...]43_876824.74416.qm@web80203.mail.mud.yahoo.com 11643 103 39_Re: Alter DB2 sequence in COBOL program13_David Simpson22_dsimpson@THEMISINC.COM31_Wed, 24 Mar 2010 20:57:48 -0400562_iso-8859-1 Is this behavior documented? I was playing around with this today (static SQL COBOL program) and I find that an ALTER TABLE will honor the QUALIFIER from my bind, ALTER SEQUENCE does not. The Command Reference notes that QUALIFIER applies to tables, views, indexes and aliases... makes no mention of sequences. When I use the sequence to get the next number, the qualifier is honored. The doc is not clear on why it would be honored when used but not altered when it is honored for both when a table is the target. Feels like a PMR if you really [...]67_7EC87535E7581C4C890F5BF1CF9A9374028AA775@THEMISSRV1.themisinc.local 11747 32 16_Re: Dual Logging11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Thu, 25 Mar 2010 05:51:53 +0000432_- >Storage Management specialists that hardware errors are a thing of the past. Dual logging is a waste of space and in an environment where DASD is mirrored to another location it is unecessary.

Define waste of space?
At pennies per gigabyte, which is cheaper the admin costs or the DASD?

>Is dual logging still the standard practice? Has anyone eliminated dual logging and if so, what was the justification? [...]104_865703557-1269496355-cardhu_decombobulator_blackberry.rim.net-1128865564-@bda026.bisx.prod.on.blackberry 11780 112 16_Re: Dual Logging10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 25 Mar 2010 08:47:02 +0100520_US-ASCII Hi Dale

Just few months ago I witnessed a problem with DASDs, not so bad but it
could become very bad (they were adding a new array). Then there's
microcode that can have problems. Someone somewhere lost many DASD in one
shot. It's since many years I didn't recover any DB2 object due to DASD
failure, but I faced (in the past) a recovery with a corrupted log due to
a DB2 problem. So don't listen to them as many esteemed listers said. Log
can be the last chance to recover data. [...]66_OF7A78B219.3FFD0A36-ONC12576F1.0028E640-C12576F1.002A6571@cesve.it 11893 62 12_Re: DSN1COPY13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Thu, 25 Mar 2010 04:42:58 -0400374_utf-8 Hi Anil

DSNB1COPY JCL is EASY

BUT, you do need to be aware that when you use DSN1COPY both sides of the copy must be defined in EXACTLY the same way

There can be NO differences (or practically no differences) otherwise, although the DSN1COPY may well complete with RC0, your data will be inaccessible (look out for SQL Code -904 rc 00C90101) [...]58_4440F5DA00E3F3459BBCB97431B91B6611A59B6C@MAILR004.mail.lan 11956 99 40_Re: Dummy LISTDEF with a REORG statement16_Laurens Zwanepol31_lbn.zwanepol@BELASTINGDIENST.NL31_Thu, 25 Mar 2010 10:17:12 +0100531_us-ascii Raymond/Phil,

Thanks for the reply.

The sulotion has become a REXX whitch generates the JCL.
The generated JCL consists of 4 parts. 1 the DSNUPROC part, 2 The TEMPLATE
part, 3 The LISTDEF part en 4 The REORG/QUIESCE part.
Whitin the rexx I look if the LISTDEF part is not empty then all 4 parts
are written to a JCL-member. When the LISTDEF part is empty the only part 1
en 2 are written to the JCL-member. Then DSNUPROC wil run only the template
statement and this wil end in a RC=0. [...]76_OF2E5FC945.744ADCA1-ONC12576F1.0032F420-C12576F1.00330442@belastingdienst.nl 12056 296 40_Re: Dummy LISTDEF with a REORG statement13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Thu, 25 Mar 2010 04:21:22 -0500665_us-ascii Nice one, Laurens. Thanks for the update.

Good luck!

Raymond

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Laurens Zwanepol
Sent: 25 March 2010 09:17
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Dummy LISTDEF with a REORG statement

Raymond/Phil,

Thanks for the reply.

The sulotion has become a REXX whitch generates the JCL.
The generated JCL consists of 4 parts. 1 the DSNUPROC part, 2 The TEMPLATE part, 3 The LISTDEF part en 4 The REORG/QUIESCE part.
Whitin the rexx I look if the LISTDEF part is not empty then all 4 parts are written to a JCL-member. When the LISTDEF part is [...]67_78B3EFE2C0C5D74E9E7777D1D669D5420A591A4A@PHXCCRPRD04.adprod.bmc.com 12353 252 12_Re: DSN1COPY16_Christian Michel18_cmichel@DE.IBM.COM31_Thu, 25 Mar 2010 10:40:09 +0100605_ISO-8859-1 Hi Anil,

also remember that DB2 keeps track of object information collected through
RUNSTATS and also in Real-Time Statistics (RTS). If you're replacing a
table space in your test system with a copy from production which is
significantly different with respect to size, data contents, you need to
make DB2 aware of that, as DSN1COPY has no connection into DB2. If you
have ZPARM UTSORTAL set to YES, we'll use RTS to estimate the sort work
data set size, so in that case you should invalidate some of the RTS
columns by setting them to NULL for the objects you [...]68_OFA82633CB.408197BA-ONC12576F1.003437C2-C12576F1.00351D7F@de.ibm.com 12606 210 22_Betr: [DB2-L] DSN1COPY16_Laurens Zwanepol31_lbn.zwanepol@BELASTINGDIENST.NL31_Thu, 25 Mar 2010 10:46:35 +01001096_us-ascii Anil,

we use te following JCL:

First we stop the tablespace:

//*-------------------------------------------------------------------*
//STOPTS EXEC PGM=IKJEFT1A,DYNAMNBR=20
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB0T)
-STA DB(CSRDB99) ACCESS(UT)
-STO DB(CSRDB99) SPACENAM(CSRTSACC)
END
//*-------------------------------------------------------------------*

Then we perform the DNS1COPY with the translation of the ID's (ID's can be
gathered via DSN1PRINT of SQL-from-the-catalog)

//XLATOBID EXEC PGM=DSN1COPY,
// PARM='OBIDXLAT,NUMPARTS(0),DSSIZE(2G),PAGESIZE(4K),FULLCOPY,RESET'
//*
//SYSUT1 DD DSN=A59G042.CSRDB01.CSRTSACC.P0000.DB2FIC.V10058,
// DISP=SHR,UNIT=VTSSALL,LABEL=(1,SL),
// DCB=(LRECL=4096,RECFM=FB,BLKSIZE=28672),
// VOL=SER=(350145)
//*
//SYSUT2 DD DSN=DSNDB0T.DSNDBD.CSRDB99.CSRTSACC.I0001.A001,
// DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSXLAT DD *
0313,0808
0044,0002
0045,0003
//*-------------------------------------------------------------------* [...]76_OFC08A78E1.5DB62FF8-ONC12576F1.003465FC-C12576F1.0035B493@belastingdienst.nl 12817 475 16_Re: Dual Logging13_Robert Knight28_bknight@REMOTEDBAEXPERTS.COM31_Thu, 25 Mar 2010 07:01:03 -0400331_us-ascii I had this issue to deal with at a site about 6 years ago they were looking at cost reductions.

I communicated to all involved the possible implications that could occur.

Then flatly stated that if single logging is still wanted fine, but when the subsystem crashes don't call me, call the DASD people. [...]75_8902ECFB06C73440874A90F82900BA0E186DF6AC54@osgood.rdba.remotedbaexperts.com 13293 53 40_Re: Dummy LISTDEF with a REORG statement14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 25 Mar 2010 22:10:17 +1100391_US-ASCII I'm adding this so it can be found if anyone ever searches the archives:

Another option would be to run DSNUPROC twice. Once with OPTIONS
PREVIEW and then (with COND=(0,NE)) without. If there was nothing in
the LISTDEF, then the options would fail and you wouldn't attempt it for real.

James Campbell

On 25 Mar 2010 at 10:17, Laurens Zwanepol wrote: [...]49_4BABDF49.30444.1F3D052E@jacampbell.acslink.net.au 13347 130 12_Re: DSN1COPY12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 25 Mar 2010 05:00:03 -0700547_us-ascii Phil,
I have a minor rebuttal to some of your suggestions:
Two points:

1) What do you do if you have moderately large LOB datasets that you want to copy? The time to unload/load, if even possible, way be way more than the amount of time you can afford the system to be down. We have several LOB tablespaces that are large enough that it would take somewhere between 24 hours and 2 weeks to just unload. There is no way that we can afford the time to have the system unavailable while a UNLOAD is running. Not to mention [...]44_119174.90414.qm@web112110.mail.gq1.yahoo.com 13478 36 16_Re: Dual Logging12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Thu, 25 Mar 2010 12:52:37 +0000522_UTF-8 Hi Dale. Out of interest, how many logs do you have? What amount of DASD is being used by your active log datasets? As others have said - and even if you have a relatively large number of logs - the amount of DASD is going to be small in comparison to the actual data. Also, how do you manage your archive logs? Are they on DASD too? If a lot of archive log history is being kept on DASD that could be something to look at. Dual logging is generally considered a "best practice". Human error has been mentioned [...]54_7543882987122585.WA.adambaldwines.ibm.com@www.idug.org 13515 666 12_Re: DSN1COPY13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Thu, 25 Mar 2010 09:37:23 -0400372_us-ascii Hi Myron

Fair enough BUT I have to rebut one of your rebuttals :)

It seems that with each year that goes by there are more and more reasons to cause DSN1COPY to "fail" - just consider the implications of reordered vs basic row format in DB2 9 - by default, you have almost NO control over the row format of the source OR the target tablespaces [...]58_4440F5DA00E3F3459BBCB97431B91B6611A59B86@MAILR004.mail.lan 14182 70 40_ADMIN: Anonymous accounts being disabled16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Thu, 25 Mar 2010 09:55:27 -0400384_utf-8 In an attempt to 'clean up' the subscription here. I have set to NOMAIL all accounts that have Anonymous as the name. (and there are a few).

Anonymous IDs is not how anyone should present themselves in an professional community like DB2-l.

The next set will be deletion of these subscribers. Feel free in contact me off line if you have any issues with this. [...]70_551C24F0D5EA4E47BA9B76E14D016DD5067D07C8@nasa-dtw-ex005.nasa.cpwr.corp 14253 56 28_Re: Monitor LOCK ESCALATIONS17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Thu, 25 Mar 2010 09:24:52 -0500598_us-ascii Anil

That data is also written to SMF accounting fields QTXALEX (exclusive lock escalation) and QTXALES (shared lock escalation) so your monitoring reporting software can also report on it.

Regards
Rich
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Anil
Sent: Wednesday, March 24, 2010 3:37 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Monitor LOCK ESCALATIONS

That was the thought that crossed my mind as well (capture DSNI031I messages). But just wasn't sure if there was a better way to monitor it. [...]79_3A61DE20404B9D41A954E5380147DD28013D2DF5B093@MEWMAD0PC02G02.accounts.wistate.us 14310 92 16_Re: Dual Logging11_Dale Miller33_dalemiller@NORTHWESTERNMUTUAL.COM31_Thu, 25 Mar 2010 10:00:25 -0500578_utf-8 Thanks to everyone for their feedback. I kept my original posting open to avoid channeling the replies too narrowly.

Adam,
You bring up one of the crucial topics. The Active logs for us are not so much an issue as is the 'snowball' effect of copying the Active logs to Archive logs. Active logs are on disk for at least a day, sometimes more depending on activity level. The Archive logs are more of an issue. Standard setup creates an archive log for each active log copy, thus 2 archive log copies. Depending on configurations, archive logs can have both [...]71_C60050EC44783A47A27E4949289D254701FB4230@ntemph2003m00.exssrv.nmfco.com 14403 143 16_Re: Dual Logging14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 25 Mar 2010 11:14:38 -0400584_us-ascii Dale,
Archive logs should, for performance/recovery reasons, go to disk. It can be a virtual-tape disk if you need, but should not be pure tape. The reason for this is that while active logs are accessed randomly during a rollback, archive logs are accessed sequentially. If you're rolling back a large unit of work and you have to tap an archive log, you have to access the log _sequentially_ and read it _backwards_. Applying a single log's worth of backward entries from a physical tape can take _hours_ and, if you're trying to do this in a DB2 restart scenario, [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46753@MAIL02.fisalan.nycnet 14547 364 12_Re: DSN1COPY12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 25 Mar 2010 08:15:33 -0700549_utf-8 Two comments here: 1) The volume of data for a LOB tablespace doesn't have to be very big to make UNLOAD not feasible. Start with about 750,000 to 2 million rows. To me, that's not a very large table. But this size table will take UNLOAD somewhere between 10 and 200 hours (or more) to UNLOAD. Is that really feasible in a production environment with 24x7 availability? 2) If XML uses the same UNLOAD features and tools as LOBs but DSN1COPY can't be used, that worries me for XML data. With LOB unloads taken many many hours, will we see [...]42_7617.19922.qm@web112102.mail.gq1.yahoo.com 14912 32 16_Re: Dual Logging12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Thu, 25 Mar 2010 15:16:57 +0000528_UTF-8 Dale, an often quoted ROT is to keep the archive logs on DASD for 48 hours. Like all ROTs, in reality "it depends". You do want to have two archives - don't confuse the situation by thinking about the mirrored DASD. If DASD really is an issue - and depending on you recovery strategy and SLAs, you can push one arhive to VTS or use HSM to migrate one of the archives. The only sure thing is that the people who want to save money on what is generally inexpensive DASD are normally the same people who will shout when [...]54_9753563600277006.WA.adambaldwines.ibm.com@www.idug.org 14945 186 16_Re: Dual Logging13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Thu, 25 Mar 2010 11:28:31 -0400395_iso-8859-1 Remember, DB2 will ONLY use an archive log dataset to access log data that is not currently available in ANY of the active logs (even old, archived ones)

SO, just because a log is archived to tape that does not mean DB2 will necessarily need to READ the tape. If the required log records are handy in an as-yet not reused old active log dataset, DB2 will use that instead [...]58_4440F5DA00E3F3459BBCB97431B91B6611A59BA1@MAILR004.mail.lan 15132 232 16_Re: Dual Logging14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 25 Mar 2010 12:14:15 -0400530_iso-8859-1 Phil G.,

It was a really big unit of work.

Someone wrote some bad code and ran it in production. Logs spitting out every ten minutes and the bloody thing ran for two hours before Systems noticed that we were locking the entire TEMPDB tablespace set, hanging up the (physical) warehouses, preventing normal production access to the stock tables, and costing about $50K/hour in lost productivity for the warehouse crews. We tried to Drop the Temp Tablespaces, as I recall, and that crashed the system. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46755@MAIL02.fisalan.nycnet 15365 269 16_Re: Dual Logging13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Thu, 25 Mar 2010 12:22:24 -0400592_iso-8859-1 At least you still had the logs......

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

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

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil
Sent: 25 March 2010 16:14
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] Dual Logging

Phil G.,

It was a really big unit of work. [...]58_4440F5DA00E3F3459BBCB97431B91B6611A59BAB@MAILR004.mail.lan 15635 26 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?12_Amlan Prasad16_amlan_pd@MSN.COM31_Thu, 25 Mar 2010 17:16:16 +0000672_UTF-8 I doubt the situation I explained can be simply solved by dynamic or static call...

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
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!
_____________________________________________________________________ [...]47_6414815750185456.WA.amlanpdmsn.com@www.idug.org 15662 27 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?12_Amlan Prasad16_amlan_pd@MSN.COM31_Thu, 25 Mar 2010 17:21:26 +0000749_UTF-8 The problem we have in our Endevor setup is that such a processor group is not setup which will have two link-edit steps to write to two different load modules.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
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!
_____________________________________________________________________ [...]47_7429646877950645.WA.amlanpdmsn.com@www.idug.org 15690 695 16_Re: Dual Logging12_Isaac Yassin20_yassini@BEZEQINT.NET31_Thu, 25 Mar 2010 19:37:06 +0200421_utf-8 Hi,

Just use the following form:

I __________________ is the DASD manager of ________.

I am the sole responsible person to the decision to have DB2 run at single log mode.

I am the sole responsible to any problem occurred due to this decision.

I will personally compensate any user and or customer of the company for the damages incurred due to the mentioned above decision. [...]35_00bf01cacc41$ca158930$5e409b90$@net 16386 28 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?12_Amlan Prasad16_amlan_pd@MSN.COM31_Thu, 25 Mar 2010 18:05:32 +0000759_UTF-8 hi Dan, thanks. Your article is just what I was looking for. Its amazing. I now just hope my project's environment managment team agrees to it.

thanks again. Amlan

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
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!
_____________________________________________________________________ [...]47_7199386922812309.WA.amlanpdmsn.com@www.idug.org 16415 29 41_Re: UNLOAD - Increase of temporary space?9_Mushtaq P14_mpasha@UGA.EDU31_Thu, 25 Mar 2010 18:15:38 +0000297_UTF-8 We experienced the same error couple of weeks ago on an INSERT statement with an 'OR' logic in the WHERE clause. Initially we increased the sort work space, but it was causing the same error even after doubling the space. The simple fix was to replacing the 'OR' with the UNION clause. [...]46_8024064891763704.WA.mpashauga.edu@www.idug.org 16445 26 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?12_Amlan Prasad16_amlan_pd@MSN.COM31_Thu, 25 Mar 2010 17:24:29 +0000687_UTF-8 Unfortunately DB2 stored procedure is not allowed as a policy decision (I do not know the reason).

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
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!
_____________________________________________________________________ [...]47_5423237603535997.WA.amlanpdmsn.com@www.idug.org 16472 161 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?15_Chris Hoelscher21_choelscher@HUMANA.COM31_Thu, 25 Mar 2010 14:29:43 -0400425_US-ASCII we also do noy allow stored procedures from the MF - only from distributed
platforms - we (not me personally) were shown the costs did not justify
the use of stored procedures on MF platforms over other alternatives .....

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

you only need to test the programs that you want to work correctly [...]68_OF80BFDF17.7E22E0C3-ON852576F1.00656E8D-852576F1.006599A2@humana.com 16634 467 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 25 Mar 2010 14:44:17 -0400413_us-ascii _what_ costs? The instructions to start a stored procedure? Sure, it's more expensive compared with COBOL code on the MF making direct calls, but what about distributed users coming in with dynamic Java code calls? A couple of bad access paths avoided there would pay for a lot of stored procedure executions. And you get encapsulation of business rules, which is generally considered a Good Thing. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC46757@MAIL02.fisalan.nycnet 17102 49 12_Execute Plan4_Anil21_alisha_kale@YAHOO.COM31_Thu, 25 Mar 2010 20:42:13 +0000664_UTF-8 Hi All !

Before I ask my question, let me give the background information:
1. We have a DB2 program PGM0001
2. PGM0001 is bound using a collection COLLTST1 - creates package COLLTST1.PGM0001
3. Collection COLLTST1 points to tables with qualifiers TEST1
4. We have a db2 plan BATPLAN1 -collection COLLTST1 is included in plan BATPLAN1
5. RUN PROGRAM(PGM0001) using PLAN(BATPLAN1) will execute PGM0001 and point to TEST1 tables.
Now lets say someone else goes and
6. BIND the DBRM for PGM0001 to collection COLLTST2 - creates package COLLTST2.PGM0001
7. Collection COLLTST2 points to tables with qualifiers TEST2
8. Plan [...]52_3614894207613791.WA.alishakaleyahoo.com@www.idug.org 17152 78 16_Re: Execute Plan15_Attuluri, Vidya27_Vidya.Attuluri@MARRIOTT.COM31_Thu, 25 Mar 2010 16:47:13 -0400477_us-ascii The order of Collection ids in PKLIST of Plan dictates, package from
what collection will be executed. If you want a specific collection id
package to be executed, then SET CURRENT PACKAGESET OR SET CURRENT
PACKAGE PATH can be used inside the program

-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Anil
Sent: Thursday, March 25, 2010 4:42 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] Execute Plan [...]81_3E90A949C5684E46AEDAB76BD03B81830776105C@HDQNCEXCL1V1.mihdq.marrcorp.marriott.com 17231 70 16_Re: Dual Logging16_Gregory Palgrave28_gpalgrave@STAFF.IINET.NET.AU31_Fri, 26 Mar 2010 08:41:49 +0800470_utf-8 As others have said, do not fall for this 'hardware errors are a thing of the past' fairy tale.

We run dual logging on our Linux DB2 and we have had hardware and/or software issues this year which have caused (soft) I/O errors on the primary log path and resulted in nasty messages in the diagnostics log. DB2 was able to soldier on with the second log while we sorted it out. Z/OS and M/F hardware may be more resilient, but things do break at times. [...]71_8522673947DF7D4394C962BFE441CD27011B3001@PER-EXCHMBX.win2k.iinet.net.au 17302 88 16_Re: Dual Logging10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 26 Mar 2010 10:15:53 +0100462_US-ASCII Hi all

Just cutted/pasted from IBM-MAIN.......



This week one of our TS7700 clusters had a spontaneous reboot and was
unavailable for 22 minutes. The other cluster in the grid operated
normally. Investigations by IBM showed that this was a know bug in the
V1R5 microcode which is resolved in V1R6.

TS7700 users who have intentions to upgrade their 1.5 code to 1.6, might
want to review their planning. [...]66_OF2031FBC9.E2721AD7-ONC12576F2.00325CBD-C12576F2.003286E2@cesve.it 17391 116 16_Re: Dual Logging10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 26 Mar 2010 10:20:13 +0100462_US-ASCII Hi all

Just cutted/pasted from IBM-MAIN.......



This week one of our TS7700 clusters had a spontaneous reboot and was
unavailable for 22 minutes. The other cluster in the grid operated
normally. Investigations by IBM showed that this was a know bug in the
V1R5 microcode which is resolved in V1R6.

TS7700 users who have intentions to upgrade their 1.5 code to 1.6, might
want to review their planning. [...]66_OF4A792350.B458AAA8-ONC12576F2.0032F56E-C12576F2.0032EC50@cesve.it 17508 80 16_Re: Dual Logging10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 26 Mar 2010 10:40:49 +0100755_US-ASCII 'Just CUT/pasted' from IBM-MAIN.........and it's only
friday........apologies

Max Scarpa
Certified DB2 for Oz/S sysGort

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

The hitchhikers Galaxy Guide to IDUG EU 2010:

- DON'T PANIC
- DB2 V. 9 and V......9+1
- DB2 LUW 9.7 with Oracle Comp. Features..
- PureScale
- PureQuery
******************************************************************************************************************************************* [...]66_OFDB84EBBD.708EF962-ONC12576F2.0034E8D6-C12576F2.0034CF0D@cesve.it 17589 329 58_User Speakers wanted for IDUG Europe (and IDUG in general)13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 26 Mar 2010 08:13:26 -0400495_us-ascii Dear all

I've just realised that the upcoming IDUG conference in Tampa will be the THIRTY-EIGHTH IDUG conference at which I have presented. How scary is that! I knew I was getting on a bit, but this is ridiculous

One thing that has always impressed me about the IDUG conferences is the strength of the user presentations. It's one of the very few "user group" events that still manages to attract real users to share their expertise and experiences with their peers. [...]58_4440F5DA00E3F3459BBCB97431B91B6611A59BF6@MAILR004.mail.lan 17919 295 16_Re: Dual Logging17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Fri, 26 Mar 2010 12:24:46 -0000488_iso-8859-1 Since it's Friday I'll ask...

Out of curiosity, where may one survey the sorry remains of the developer, their bones being picked clean by crows and bleached by the desert sun?

Thanks.

Aurora

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

http://www.ca.com/

P please don't print this e-mail unless you really need to! [...]56_3D02E8610514C04F991CF832BA154C661056707C@UKSLMS11.ca.com 18215 458 62_Re: User Speakers wanted for IDUG Europe (and IDUG in general)10_Roger Hecq18_Roger.Hecq@UBS.COM31_Fri, 26 Mar 2010 08:30:51 -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_1A700EEF49343148A08879B1E3CA5BA61451711E@NSTMC101PEX1.ubsw.net 18674 594 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?16_Daniel Luksetich18_danl@DB2EXPERT.COM31_Fri, 26 Mar 2010 08:06:57 -0500603_us-ascii I was once told by one of the IBM developers that calling stored procedures
locally could potentially be a performance benefit. This is due to the fact
that RRF attached is newer and better written, and thus has a shorter code
path then the other attach modules. This quite obviously depends on the
quantity of SQL statements offloaded from the calling program to the stored
procedure. Now, I'm only repeating what I've been told, and have never
personally tested to see if there is actually a benefit and where that
benefit might be realized. Maybe someone else has? [...]35_00c501cacce5$375317d0$a5f94770$@com 19269 683 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?16_Daniel Luksetich18_danl@DB2EXPERT.COM31_Fri, 26 Mar 2010 08:09:16 -0500419_us-ascii I've used the generic attach approach to use stored procedures as stored
procedures remotely from Java, and as local called modules. Of course, this
only works when you don't return result sets.

Cheers,

Dan

Daniel L Luksetich

IBM Information Champion

IBM Certified Database Administrator - DB2 9 for z/OS

IBM Certified System Administrator - DB2 9 for z/OS [...]35_00ca01cacce5$8a33d430$9e9b7c90$@com 19953 583 62_Re: User Speakers wanted for IDUG Europe (and IDUG in general)13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 26 Mar 2010 09:25:16 -0400453_us-ascii Well, in my defence I did say "THIRTY-EIGHTH IDUG conference" not "THIRTY-EIGHTH IDUG Europe conference"

When you add up the North American ones, the European ones, the old Canadian Symposium and the Asia/Pacific & India events, it's quite a lot less than 38 years :)
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk [...]58_4440F5DA00E3F3459BBCB97431B91B6611A59C02@MAILR004.mail.lan 20537 908 62_Re: User Speakers wanted for IDUG Europe (and IDUG in general)16_Daniel Luksetich18_danl@DB2EXPERT.COM31_Fri, 26 Mar 2010 08:59:28 -0500568_us-ascii I remember my first user presentation. Back then no fancy powerpoint or
laser pointers. I had to scroll my presentation on a blackboard in ones and
zeros, and sometimes I ran out of ones! Ah, and look how far I've come. ;-o>

User presentations rock so all you lurkers submit and go to Vienna. Then I
can buy you a beer at the wonderful Schweizerhaus! And you can use
powerpoint and laser pointers, and not blackboards that you had to carry
uphill in the snow for 10 miles each way. Also, IDUG supplies extra ones
these days too! [...]35_00e101caccec$8df0ff10$a9d2fd30$@com 21446 117 16_Re: Dual Logging14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 26 Mar 2010 10:09:52 -0400479_iso-8859-1 Aurora,

It was a customer/programmer, not answerable to the IT hierarchy. I don't know what was said or done with her, although we didn't have such a problem again while I worked there. I'd guess that someone went over what she'd done and applied best-practice process improvements, because that's what we did with our customers usually when something went south. Customers worked for the owners of our organization; we were more or less a service bureau. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2033BC4675B@MAIL02.fisalan.nycnet 21564 348 39_Cost of Stored Procedure Called Locally14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Fri, 26 Mar 2010 09:29:29 -0500556_iso-8859-1 Number of SQL statements in a procedure is one factor mitigating the cost
of invocation but there is another one now that can upset the old
calculations - native procedures. Out goes all the overhead of finding or
creating an address space to run a procedure, task switch, passing of
parameters between DBM1 and SPAS. A native SP call doesn't **look** very
different from issuing a SELECT ( NOTE - I have emphasized "look" as I
haven't done any measurements and I could be very wrong about this
impression of mine ! ). [...]66_OFECC6A333.E3DC3439-ON862576F2.004DFA88-862576F2.004F9A91@hcsc.net 21913 707 62_Re: User Speakers wanted for IDUG Europe (and IDUG in general)10_Roger Hecq18_Roger.Hecq@UBS.COM31_Fri, 26 Mar 2010 10:47:02 -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_1A700EEF49343148A08879B1E3CA5BA61451719B@NSTMC101PEX1.ubsw.net 22621 777 43_Re: Cost of Stored Procedure Called Locally13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 26 Mar 2010 10:52:18 -0400557_us-ascii Native stored procedures are supposed to be LUDICRIOUSLY cheaper than the other vareties - none of that cross-memory mucking about for a start

I spoke to someone at IBM a couple of years ago who said that when his developers first showed him the benchmarks for native vs/ wlm stored procedures, he told them to go away and do the measurements again "properly this time" !
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk [...]58_4440F5DA00E3F3459BBCB97431B91B6611A59C19@MAILR004.mail.lan 23399 95 91_Re: Is there a way to execute the same non-CICS DB2 COBOL program in both batch and online?16_Daniel Luksetich18_danl@DB2EXPERT.COM31_Fri, 26 Mar 2010 09:55:45 -0500579_UTF-8 Here is how one of my clients who has quite successfully implemented the generic attach deals with the Endeavor issues. This is quoted from one of the programmers, but I have left out the specifics for confidentiality reasons:

"Modules that are shared are still linked in only one library. They are linked in the CICS library, and batch jobs that use them then need to link to the CICS load libraries. All our modules are called, so they can be compiled as batch even when used online. There was one exception was that became a copy statement that was compiled [...]35_010901caccf4$6ab27fd0$40177f70$@com 23495 623 43_Re: Cost of Stored Procedure Called Locally7_Ed Long19_rdhm99a@PRODIGY.NET31_Fri, 26 Mar 2010 09:00:17 -0700639_utf-8 We just started a head to head comparison of our external stored procs versus their identical Native cousins.
 
Other than some fun with delimiters - much like triggers they matter with natives-, they install pretty easily and appear to produce identical results.
 
No real performance data yet although I don't expect much difference.
 
Under load, I would expect the code path difference between the externals and the natives will shrink. I've seen WLM address spaces set up with 60 TCB's thus eliminating a lot of address space and WLM overhead.
 
At least part of the 'cost' comparison between [...]43_421514.46999.qm@web80207.mail.mud.yahoo.com 24119 54 58_Information Center updated (standard end of month message)12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 26 Mar 2010 19:34:10 +0000619_UTF-8 Today the Information Management Software for z/OS Solutions Information Center was updated. We are continuing to focus on maintaining information currency, improving the retrievability of stored procedure information, and improving the Unicode information.

The following DB2 9 for z/OS information was updated:

Administration Guide
Introduction to DB2 for z/OS
Installation Guide
Internationalization Guide
ODBC Guide and Reference
OmniFind Text Search Server Installation, Administration, and Reference
Performance Monitoring and Tuning Guide
Utility Guide and Reference [...]51_0235405424386995.WA.millerrlus.ibm.com@www.idug.org 24174 137 62_Re: Information Center updated (standard end of month message)7_Ed Long19_rdhm99a@PRODIGY.NET31_Fri, 26 Mar 2010 13:22:08 -0700615_iso-8859-1 Thank you for coming out yesterday.
Great job.

Edward Long

--- On Fri, 3/26/10, Roger Miller wrote:

From: Roger Miller
Subject: [DB2-L] Information Center updated (standard end of month message)
To: DB2-L@IDUGDB2-L.ORG
Date: Friday, March 26, 2010, 3:34 PM

Today the Information Management Software for z/OS Solutions Information Center was updated. We are continuing to focus on maintaining information currency, improving the retrievability of stored procedure information, and improving the Unicode information. [...]43_613013.18826.qm@web80201.mail.mud.yahoo.com 24312 31 64_AUTO: Prabeesh Raman is out of the office (returning 01/04/2010)14_Prabeesh Raman20_rprabeesh@IN.IBM.COM31_Sat, 27 Mar 2010 04:01:39 +0530367_US-ASCII I am out of the office until 01/04/2010.

I will not be on vacation .Will not return until 1st of April. Please
contact Sanotsh K Mishra for SIA and Arvind Tiwari for BIW related queries.

Note: This is an automated response to your message "[DB2-L] Information
Center updated (standard end of month message)" sent on 3/27/10 1:04:10. [...]68_OF7EDCA5FB.9190B182-ON652576F2.007BBF62-652576F2.007BBF62@in.ibm.com 24344 71 12_Re: DSN1COPY11_Rob Barbour22_rbarbour@ESAIGROUP.COM31_Fri, 26 Mar 2010 20:14:45 -0400417_ISO-8859-1 Hi Anil,

If you would kindly permit me a 'shameless vendor plug' for a product
that automates the task you are dealing with.


The BCV5 product may be worth investigating. The product
addresses many of the issues brought up by other DB2 Lister's and
provides the speed and automation to make the fast copy/refresh of
target systems simpler. The product provides for: [...]30_4BAD4DF5.4070304@esaigroup.com 24416 66 16_Re: Execute Plan15_Coleman, Troy L19_Troy.Coleman@CA.COM31_Sat, 27 Mar 2010 15:23:34 -0400541_utf-8 You will want to issue the SET CURRENT PACKAGESET statement.
I designed a system years ago when packages first came out in DB2 V2.3 using parameters for Batch and a DB2 table for CICS.
If you use a table then you will need a common table with the table owner hard coded. The first thing the transaction does is read the table to get the collection name. Issue the set current packageset and now your off using the correct set of tables. One other thing we did was put the name of the environment on the display so you could [...]56_F9576E62032243419E097FED5F0E75F30851F11D@USILMS12.ca.com 24483 988 22_No estoy en la oficina32_Lainez Gutierrez, Maria Victoria21_mvlainez@IBERDROLA.ES31_Sun, 28 Mar 2010 07:41:45 +0200730_iso-8859-1 Hola,

Hasta el 6 de Abril no voy a estar en la oficina. Para algún tema urgente relacionado con DB2 escribe un correo a Juan Calleja (jcallejav@iberdrola.es) y a Idoia Monasterio (imonasterio@iberdrola.es).

Un saludo,
Vicky

===============================================================
Este mensaje se dirige exclusivamente a su destinatario. Los datos incluidos en el
presente correo son confidenciales y sometidos a secreto profesional, especialmente en lo que
respecta a los datos personales, se prohibe divulgarlos, en virtud de las
leyes vigentes. Si usted no lo es y lo ha recibido por error o tiene conocimiento
del mismo por cualquier motivo, le rogamos que nos lo [...]73_534FFF2C8B16444DBF458EFA2E0C9F74011CA0A4@CLFEXBUZ23A.corp.iberdrola.local 25472 229 16_Re: Dual Logging12_Peter Suhner24_peter_suhner@HOTMAIL.COM31_Sun, 28 Mar 2010 23:14:11 +0200589_iso-8859-1 Dale, Phil,

Oracle also supports single logging, but dual logging is highly recommended. Oracle actually allows you to write the identical logs to ut to 9 destinations if you're addict to data safety - or if your storage is completely unreliable ;-). One can exaggerate...

In our shop, we also clearly go for dual logging for DB2 z/OS, LUW as well as for Oracle, even if there's a SAN with RAID 5 and Mirroring underneath. As it was already pointed out, a single log destination that fails would stop the DBMS from working. It needn't crash - it's bad enough [...]42_SNT107-W6E2C334B6F39326219D32F1210@phx.gbl 25702 182 16_Re: FREE PACKAGE12_Peter Suhner24_peter_suhner@HOTMAIL.COM31_Mon, 29 Mar 2010 00:23:30 +0200562_iso-8859-1 Anil,

not that I knew of. Package information is stored in the catalog only and FREE PACKAGE deletes all respective data from the catalog tables and SPT01. As you state correctly, the DBRM is required to recreate the package.

We try to avoid versions in our shop because they add to the complexity. If they are required, we limit the number of versions and make sure we know where the DBRMs are. As long as you don't move or overwrite them after the BIND, you can find this information in column PDSNAME of table SYSIBM.SYSPACKAGE. [...]43_SNT107-W18CBB9373F1C20481ADE22F1210@phx.gbl