1 IDUGDB2-L.ORG /home/listserv/home/db2-l June 2010, week 2
2 904 42_Re: MDEL, SKPT, SKCT Suspensions - V8 z\OS11_Mike Turner19_mike.turner@GMX.COM30_Tue, 8 Jun 2010 09:45:45 +0100394_iso-8859-1 Hi Jay
I posted the following response on June 4th and I saw it appear on the list. It is also in the archives:
The Select ... With UR will take an S-mode MDEL lock. In V8 the only thing I am aware of that will take an X-mode MDEL lock is a mass delete (SQL Delete with no Where clause). In V9 the SQL statements Truncate and Exchange also take X-mode MDEL locks. [...]44_780ABAE1AAAB4162994CD48029EA95FA@ToshibaA300
907 106 30_Re: Temporary Tables and TCB=112_Kirk Hampton37_kirk.hampton@ENERGYFUTUREHOLDINGS.COM30_Tue, 8 Jun 2010 07:56:19 -0500540_us-ascii I'm going to venture a guess that it is "temporary tables" that is the
key to this restriction in your shop. I am by no means an expert on
those, but depending on whether a previous stored procedure used Created
or Declared Global Temp tables, they might have encountered a catalog
contention issue that may have resulted in the NUMTCB=1 edict. I've seen
similar things happen. What is the syntax your new COBOL routine is
using for your temp tables. (Maybe you don't want to clone from the
older one...) [...]71_31F1BA84DF370A4C825F6E64D59DAF540425DC4C@MDCTXUEXCL01N4.corptxu.txu.com
1014 370 30_Re: Temporary Tables and TCB=114_Barbara Koenen33_barbara.koenen.bgit@STATEFARM.COM30_Tue, 8 Jun 2010 06:06:41 -0700506_us-ascii We also have NUMTCB=1 on some things like DSNUTILS that require it for
output serialization.
We found that for Cobol external SPs the number of TCBs that can run in
the address space can be affected by the LE options set. We had to do
some tuning of those with our language support folks to get optimum
usage of the address space storage. We ran into problems with NUMTCB
around 50 and decreased it lower, but that was researched years ago, so
maybe needs revisited. [...]67_9321A73F77470E4CB44903D606D207190DCE3345@WPSCV6MQ.OPR.STATEFARM.ORG
1385 39 18_What triggers -80512_George Henke22_henke_george@YAHOO.COM30_Tue, 8 Jun 2010 10:11:21 -0400434_UTF-8 Different date and timestamp?
If so, between what?
a) The load module and the package?
b) The load module and the collection?
c) The load module and the plan?
d) a and c?
e) b and c?
f) c only?
g ) a, b, and c?
_____________________________________________________________________
* IDUG Europe * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EA * [...]53_9063110149721956.WA.henkegeorgeyahoo.com@www.idug.org
1425 92 22_Re: What triggers -80511_Mike Turner19_mike.turner@GMX.COM30_Tue, 8 Jun 2010 15:30:35 +0100640_UTF-8 Hi George
If you get a -805, then one of the following problems has occurred:
· The Collection ID has been set wrongly by a SET CURRENT PACKAGESET
statement.
· The Package Name (Collection-ID.DBRM) is not included in the PKLIST of the
Plan, either specifically, or by a generic specification.
· The Consistency Token timestamp in the package does not match that in the
load module. The source program has been precompiled again and either the
load module was re-linked without binding the new package or the package was
bound but the new load module was not link-edited. Remember in [...]44_C63E5D203970462C8B384158DEACCF74@ToshibaA300
1518 217 56_Rational Software Consulting contract in Sacramento, Ca.11_Robin Marsh21_robin.marsh@GMAIL.COM30_Tue, 8 Jun 2010 09:57:05 -0500444_windows-1252 Palladian Consulting, a leader in IT services is seeking a Rational Software
Consultant for a 12 month contract opportunity in Sacramento, California.
Client is a state agency; all work is to be performed onsite.
Must be able to commit to start date of June 28, 2010
*CONTRACTOR SKILLS/EXPERIENCE *
Each of the Contractors proposed staff must meet the skills and experience
as listed below: [...]60_AANLkTim1fSrUy86Jx2ybEhE0asHJm6t0rq1SPG-SShgr@mail.gmail.com
1736 79 22_Re: What triggers -8059_Mike Bell21_mbell11a1@VERIZON.NET30_Tue, 8 Jun 2010 10:41:26 -0500392_us-ascii The path is fairly simple -
1. precompile puts the contoken and dbrmname into the DBRM and the
generated source.
2. compile stores the contoken and dbrmname in the load module.
3. BIND stores the contoken and dbrmname in SYSPACKAGE and creates an
execution module (skeleton cursor).
4. at execution time, every SQL call passes the contoken value and dbrmname. [...]43_D913A0CF7203404496AD618B947B03FB@mikelaptop
1816 39 19_pureQuery saves CPU11_Dave Beulke19_dave@DAVEBEULKE.COM30_Tue, 8 Jun 2010 12:12:01 -04000_51_8005671115112239.WA.davedavebeulke.com@www.idug.org
1856 81 30_AW: [DB2-L] What triggers -80535_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Wed, 9 Jun 2010 08:39:20 +0200732_iso-8859-1 Short answer: a
Mit freundlichen Gren
Walter Janien
ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Victoriaplatz 2
40477 Dsseldorf
mailto:walter.janissen@itergo.com
Vorsitzender des Aufsichtsrates: Jrgen Vetter
Geschftsfhrung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schn.
Sitz: Dsseldorf, Handelsregister: Amtsgericht Dsseldorf, HRB 37996
-----Ursprngliche Nachricht-----
Von: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von George Henke
Gesendet: Dienstag, 8. Juni 2010 16:11
An: DB2-L@IDUGDB2-L.ORG
Betreff: [DB2-L] What triggers -805 [...]43_DB2-L%201006090239298464.1294@IDUGDB2-L.ORG
1938 130 30_AW: [DB2-L] What triggers -80535_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Wed, 9 Jun 2010 08:51:17 +0200413_iso-8859-1 Hi Mike
One comment to item 6: When I recall it right, DB2 first checks, if a package with that name is already stored in the EDM-pool, before it scans the entries in the PKLIST. So, if you have that package in different collections, which are named in the PKLIST and you don't set the current packageset special register, it could be, that DB2 picks up a package, that you didn't want to. [...]43_DB2-L%201006090251268001.1296@IDUGDB2-L.ORG
2069 272 125_The DB2Night Show Episode #21 - The Keys to Mastering DB2 LUW Locking with Mike Winer, IBM STSM - Friday 11 June 10 am US CDT13_David Chapman24_David.Chapman@IAG.COM.AU30_Wed, 9 Jun 2010 17:46:15 +1000614_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 #21 - The Keys to Mastering DB2 LUW Locking with Mike Winer, IBM STSM
The International DB2 Users Group (IDUG) is pleased to partner with DBI to deliver a free Webcast by renowned presenter Scott Hayes, President & CEO, DBI. This live event will run for 90 minutes. [...]43_DB2-L%201006090346252097.129A@IDUGDB2-L.ORG
2342 55 50_Problem creating table with XML column DB2 V9 z/OS32_Kimmo M=?UTF-8?Q?=C3=B6rnesten?=27_kimmo.mornesten@SWEDBANK.SE30_Wed, 9 Jun 2010 07:12:57 -0400515_utf-8 Hi,
Has anyone experienced a problem creating a table that has an XML column?
CREATE TABLE KNDTKFM
(TIDPKT_UPPL TIMESTAMP NOT NULL WITH DEFAULT,
FORFRAGAN_BANK XML NOT NULL)
IN KNDP950.KNDTKFM
AUDIT NONE
DATA CAPTURE CHANGES
CCSID EBCDIC
NOT VOLATILE
APPEND NO ;
---------+---------+---------+---------+---------+---------+--
DSNT408I SQLCODE = -204, ERROR: DBPAN001 IS AN UNDEFINED NAME
Haven't been able to figure out what kind of object DBPAN001 is. [...]59_4628561904896824.WA.kimmo.mornestenswedbank.se@www.idug.org
2398 371 44_SV: [DB2-L] z/OS DB2 9: U0046 in online LOAD13_Olle Brostrom25_olle.brostrom@SWEDBANK.SE30_Wed, 9 Jun 2010 13:29:19 +0200496_iso-8859-1 Hello,
My problem with abendU0046 in an ONLINE LOAD where all rows was dups is a DB2 problem. IBM has opened APAR PM15760.
The problem was that DB2 did not supply DFSORT with a non-zero file size in this case.
Many thanks to Enrico, LIzette and Max for your try to help.
Olle
Frn: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] Fr Max Scarpa
Skickat: den 7 maj 2010 14:38
Till: DB2-L@IDUGDB2-L.ORG
mne: Re: [DB2-L] z/OS DB2 9: U0046 in online LOAD [...]70_B0000573F0F67C438DC58043C06F4CAB49D3A998BB@FSPAS01EV011.fspa.myntet.se
2770 26 30_Re: Temporary Tables and TCB=111_Gary Snider29_gsnider@CENTRAL-INSURANCE.COM30_Wed, 9 Jun 2010 07:56:52 -0400442_UTF-8 Yes, I should clarify that NUMTCB=1 is a standard when temprary tables are used. If temporary tables are not used we run with NUMTCB>1. We are using Declared Global Temp tables. Is the catalog contention issue documented somewhere? How do you monitor this contention?
_____________________________________________________________________
* IDUG Australasia * Sydney, Australia * 1-3 September 2010 * http://IDUG.ORG/AU * [...]60_9696117324853448.WA.gsnidercentralinsurance.com@www.idug.org
2797 94 54_Re: Problem creating table with XML column DB2 V9 z/OS11_Enrico Haak21_eh@INSOFT-SOFTWARE.DE30_Wed, 9 Jun 2010 14:47:44 +0200685_UTF-8 Hi Kimmo,
like with LOBs DB2 implicitly creates some additional objects.
(XML Tablespace, index ...).
Please see SQL Reference Guide V9 p. 1098.
To me it looks like an undefined Bufferpool name from Panel DSNTIP1.
Please double check.
Regards,
Enrico
Am 09.06.2010 13:12, schrieb Kimmo Mörnesten:
> Hi,
>
> Has anyone experienced a problem creating a table that has an XML column?
>
> CREATE TABLE KNDTKFM
> (TIDPKT_UPPL TIMESTAMP NOT NULL WITH DEFAULT,
> FORFRAGAN_BANK XML NOT NULL)
> IN KNDP950.KNDTKFM
> AUDIT NONE
> DATA CAPTURE CHANGES
> CCSID EBCDIC
> NOT VOLATILE
> APPEND NO ;
[...]35_4C0F8D70.8030207@insoft-software.de
2892 92 30_Re: Temporary Tables and TCB=113_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Wed, 9 Jun 2010 08:11:54 -0500630_us-ascii I'm not sure I'm following how NUMTCB=1 would help with catalog contention here. Just thinking this through a little, if NUMTCB=50 and you have 40 concurrent requests come in then you have the potential for 40 concurrent threads all declaring a temporary table concurrently from a single address space. However, if you have NUMTCB=1 and 40 concurrent requests come in then you have 40 concurrent threads all declaring a temporary table concurrently from 40 different address spaces. Either way you have the same concurrent access to the catalog and same potential for contention (which I have not personally seen to [...]87_18E3472326219848899E4980BFE573B303E747D7EB@PFGDSMMBX001.principalusa.corp.principal.com
2985 82 54_Re: Problem creating table with XML column DB2 V9 z/OS16_Michael Liberman31_michael.liberman@CHIRONTECH.NET30_Wed, 9 Jun 2010 14:32:13 +0100368_UTF-8 Hi Kimmo,
Based on the number associated with the object name DBPAN, I assume that DB2 is trying to create a table and table space to store your XML data (TYPE = 'P' in sysibm.systables).
Is this the first time that you are trying to define an XML column? Have you tried defining something similar to the
object specified on the error message? [...]55_000901cb07d8$2dd0cc60$89726520$@liberman@chirontech.net
3068 99 33_Re: Increment Alphanumeric Values11_Akash Pilot13_akash@USA.COM30_Wed, 9 Jun 2010 10:14:21 -0400429_UTF-8 Each range represents a unique attribute. Throwing everything into one range defeats the purpose of what I am trying to do.
-Akash
On Mon, 7 Jun 2010 18:30:26 -0700, Dave Nance wrote:
>With those ranges wouldn't it be a lot less storage to just have one entry that covers a begin range of 0999 and ending range of 3800, since you cover the whole spectrum?
�
David Nance [...]45_7990556968278760.WA.akashusa.com@www.idug.org
3168 150 30_Re: Temporary Tables and TCB=113_David Simpson22_dsimpson@THEMISINC.COM30_Wed, 9 Jun 2010 11:48:49 -0400572_us-ascii Well, it probably helps the contention since WLM is unlikely to fire up
40 copies of the SP address space. NUMTCB=1 will not get you down to 1
thread at a time, but it will probably reduce the number of concurrent
threads.
Another thing to think about is trying to reduce the number of declares
and drops. IF you're calling the same procedure repeatedly and IF the
GTT has the same structure each time, you may be able to avoid DECLAREs
by checking to see if a previous call in the same TCB already declared
the table you need. I [...]67_7EC87535E7581C4C890F5BF1CF9A93740297BEE8@THEMISSRV1.themisinc.local
3319 23 22_Re: What triggers -80512_George Henke22_henke_george@YAHOO.COM30_Wed, 9 Jun 2010 15:29:15 -0400617_UTF-8 Thank you very much, Mike. This is very helpful.
_____________________________________________________________________
* IDUG Australasia * Sydney, Australia * 1-3 September 2010 * http://IDUG.ORG/AU *
* 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!
_____________________________________________________________________ [...]53_3524794375463846.WA.henkegeorgeyahoo.com@www.idug.org
3343 25 22_Re: What triggers -80512_George Henke22_henke_george@YAHOO.COM30_Wed, 9 Jun 2010 15:29:59 -0400629_UTF-8 Thank you very much, Mike.
This is also very helpful.
_____________________________________________________________________
* IDUG Australasia * Sydney, Australia * 1-3 September 2010 * http://IDUG.ORG/AU *
* 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!
_____________________________________________________________________ [...]53_1509823160237384.WA.henkegeorgeyahoo.com@www.idug.org
3369 25 12_QMF for z/OS11_Miran Cotic16_coticm@PETROL.SI31_Thu, 10 Jun 2010 01:04:21 -0400536_UTF-8 Hi List,
Is there any good/working alternative for IBM DB2 QMF - Workstation or Web ?
Regards,
Miran Cotic
_____________________________________________________________________
* IDUG Europe * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]48_9586129964603260.WA.coticmpetrol.si@www.idug.org
3395 27 54_Re: Problem creating table with XML column DB2 V9 z/OS32_Kimmo M=?UTF-8?Q?=C3=B6rnesten?=27_kimmo.mornesten@SWEDBANK.SE31_Thu, 10 Jun 2010 04:17:24 -0400563_utf-8 Thank-you!
Apparently for some reason the existing database had been assigned to a non-existing storage group.
Regards,
Kimmo
_____________________________________________________________________
* IDUG Europe * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________ [...]59_9515374161524336.WA.kimmo.mornestenswedbank.se@www.idug.org
3423 36 35_DDF-DSNZPARM_CONDBAT in z/OS-DB2/V912_PUSCH Othmar27_Othmar.Pusch@IT-AUSTRIA.COM31_Thu, 10 Jun 2010 12:00:43 +0200557_utf-8 Hi dear Listeners !
o) Background of this question:
We run z/OS-1.11 with DB2/V9 on z10 in our SYSPELX’s. In the greatest db2-sharing-system we coupled a lot of db2-subsystems to a db2_sharing-sys together. Based on some DDF_connect-problem's (e.g. X'00D31034) i wanna now to change CONTSTOR, MINSTOR, M(ax)DBAT and CONDBAT. With results of IFCID0225 (QW0225AL etc.) i know really good the usage and size of thread-/stack-storage (<-> M(ax)DBAT). I can set the CONDBAT-parm from 0 til 150.000 (with defaulting to 10.000) in dsnzparm. [...]63_81BB61A7ECD28B40BC5E4701B999860896523AB5D8@A2XMXS1V1.A2X.LAN.AT
3460 78 16_Re: QMF for z/OS10_Dave Nance16_dav1mo@YAHOO.COM31_Thu, 10 Jun 2010 03:37:53 -0700656_iso-8859-1 You could use QMF. There is a QMF for Windows product out there. There are other GUI tools to let you query the data, but I haven't seen anything else with the ease of use of forms and procs. David Nance ________________________________ From: Miran Cotic To: DB2-L@IDUGDB2-L.ORG Sent: Thu, June 10, 2010 1:04:21 AM Subject: [DB2-L] QMF for z/OS Hi List, Is there any good/working alternative for IBM DB2 QMF - Workstation or Web ? Regards, Miran Cotic _____________________________________________________________________ * IDUG Europe * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EA * * Your only [...]42_542893.6463.qm@web57804.mail.re3.yahoo.com
3539 38 16_Re: QMF for z/OS11_Diana Nagel16_dknagel@BEPC.COM31_Thu, 10 Jun 2010 07:55:48 -0500413_utf-8 Advanced Query Tool. I have had for years and love it. Desktop...You can download for 30 day trial and cost is minimal for product and upgrades..It improves my productivity 1000%
diana
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Miran Cotic
Sent: Thursday, June 10, 2010 12:04 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] QMF for z/OS [...]56_6454C4DAE553484980557DB37B06BC0301DFD365@HDQ153.bepc.net
3578 75 16_Re: QMF for z/OS10_Roger Hecq18_Roger.Hecq@UBS.COM31_Thu, 10 Jun 2010 09:46:36 -0400467_us-ascii I have not found a satisfactory alternative to QMF. It has its foibles
and it is not inexpensive, but I believe that its functionality and ease
of use are unmatched.
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 Miran Cotic
Sent: Thursday, June 10, 2010 1:04 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] QMF for z/OS [...]62_1A700EEF49343148A08879B1E3CA5BA6153194B5@NSTMC101PEX1.ubsw.net
3654 84 16_Re: QMF for z/OS12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 10 Jun 2010 07:17:42 -0700550_us-ascii I would fully concur. Excellent tool and really pretty cheap, considering tool capabilities. Lots and lots of functionality and can access other DBMSs as well easily.
________________________________
From: Diana Nagel
To: DB2-L@IDUGDB2-L.ORG
Sent: Thu, June 10, 2010 8:55:48 AM
Subject: Re: [DB2-L] QMF for z/OS
Advanced Query Tool. I have had for years and love it. Desktop...You can download for 30 day trial and cost is minimal for product and upgrades..It improves my productivity 1000% [...]44_798896.86951.qm@web112104.mail.gq1.yahoo.com
3739 58 16_Re: QMF for z/OS0_24_carol.sutfin@REGIONS.COM31_Thu, 10 Jun 2010 09:26:33 -0500683_US-ASCII CA has a Mainframe replacement - Report Facility .
It's the old Platinum Report Facility.
Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
carol.sutfin@regions.com
From: Miran Cotic
To: DB2-L@IDUGDB2-L.ORG
Date: 06/10/2010 01:07 AM
Subject: [DB2-L] QMF for z/OS
Sent by: IDUG DB2-L
Hi List,
Is there any good/working alternative for IBM DB2 QMF - Workstation or
Web ?
Regards,
Miran Cotic
_____________________________________________________________________
* IDUG Europe * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EA
* [...]71_OFF49DFEF5.6699F2AA-ON8625773E.004F2C71-8625773E.004F5607@corp.rgbk.com
3798 29 17_STAY RESIDENT YES11_Gary Snider29_gsnider@CENTRAL-INSURANCE.COM31_Thu, 10 Jun 2010 11:37:28 -0400598_UTF-8 Hello, we are running ZOS V9 and DB2 V9, using COBOL external Stored Procedures. I have been reviewing the Redbook, “DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond” looking for performance tips when defining Stored Procedures. In the book they recommend defining frequently run procedures with “STAY RESIDENT YES”. I ran a query and we are not using this in any of our procedures. Would anyone be willing to share their experience with “STAY RESIDENT YES”? I am curious to know what other shops are doing and how they measured the impact of the change from NO [...]60_0489364782523626.WA.gsnidercentralinsurance.com@www.idug.org
3828 310 23_Re: IBM support toolbar13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Thu, 10 Jun 2010 11:40:37 -0400418_us-ascii Further to my post about the IBM Toolbar, I was just prompted for a "new version"
BUT now that it has installed this new version, I don't even seem to HAVE an IBM support toolbar any more
Do I take it that it's now dead??
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk [...]60_4440F5DA00E3F3459BBCB97431B91B6612B61E049A@MAILR004.mail.lan
4139 130 16_Re: QMF for z/OS12_Peter Suhner24_peter_suhner@HOTMAIL.COM31_Thu, 10 Jun 2010 17:50:41 +0200527_iso-8859-1 Miran,
it depends a bit on what part of the QMF functionality you focus on.
I know AQT (Advanced Query Tool) and consider it amongst the best query tools (flexible, batch mode, good performance, stable, supports a variety of target DBMS systems).
If it's more about writing procedures or extensive report formatting features, you might want to prefer typical reporting solutions (CrystalReports comes to my mind). I've also seen people using MS Access (although I wouldn't favor that one). [...]43_SNT107-W10F73CE5E63A96CA16C3BBF1D80@phx.gbl
4270 106 21_Re: STAY RESIDENT YES10_Mark Stone17_mastone@GMAIL.COM31_Thu, 10 Jun 2010 09:02:53 -0700675_windows-1252 I'm not using cobol SP's, but rather external SQL SP's, but I can confirm
that we experienced a significant improvement in performance for frequently
executed SP's used by our online applications.
On Thu, Jun 10, 2010 at 8:37 AM, Gary Snider
wrote:
> Hello, we are running ZOS V9 and DB2 V9, using COBOL external Stored
> Procedures. I have been reviewing the Redbook, DB2 9 for z/OS Stored
> Procedures: Through the CALL and Beyond looking for performance tips when
> defining Stored Procedures. In the book they recommend defining frequently
> run procedures with STAY RESIDENT YES. I [...]60_AANLkTinkNQ0owcROs2KwkSbuPdM43m9L9gae8r4qqd7-@mail.gmail.com
4377 300 16_Re: QMF for z/OS18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM31_Thu, 10 Jun 2010 09:51:54 -0700585_us-ascii Hello Miran,
I agree too. I used AQT for some time and found it to be really useful. It is quite inexpensive for the functionality it provides.
Satish Srikakulapu
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Myron Miller
Sent: Thursday, June 10, 2010 7:18 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] QMF for z/OS
I would fully concur. Excellent tool and really pretty cheap, considering tool capabilities. Lots and lots of functionality and can access other DBMSs as well easily. [...]55_D42E68651088914B9B327A4EEA8433ACABA9D168@VM251.apsc.com
4678 229 13_[JOB POSTING]7_Kim May28_kim.may@THEFILLMOREGROUP.COM31_Thu, 10 Jun 2010 13:00:00 -0400393_us-ascii I am looking for DBA's with experience with DB2 on AIX in a high transaction
volume shop for a long-term temp position in Boston. My customer has no
travel budget available; candidates must be local. If you - or anyone you
know - are interested, please contact me off list at
kim.may@thefillmoregroup.com. Thanks!
Kim May, Vice President, Business Development [...]41_4c111a2b.1d7ddc0a.5fd4.09ac@mx.google.com
4908 58 21_Re: STAY RESIDENT YES13_David Simpson22_dsimpson@THEMISINC.COM31_Thu, 10 Jun 2010 14:05:01 -0400412_utf-8 2 things to think about:
1. If you use STAY RESIDENT YES you need to be careful about initializing storage at the beginning of a procedure (should be doing this anyway) since you will be reusing a previous call's environment.
2. When you recompile code you will need to do WLM Refreshes of the stored procedure environment to pick up the new code since it isn't being loaded every time. [...]67_7EC87535E7581C4C890F5BF1CF9A93740297BFDC@THEMISSRV1.themisinc.local
4967 314 23_Re: IBM support toolbar17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Thu, 10 Jun 2010 13:39:52 -0500447_us-ascii I got the same enhancement. Same issue with the search popping up the portal page. Really cuts into the usefulness
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: Thursday, June 10, 2010 10:41 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] IBM support toolbar
Further to my post about the IBM Toolbar, I was just prompted for a "new version" [...]79_3A61DE20404B9D41A954E5380147DD28014FA7878E79@MEWMAD0PC02G02.accounts.wistate.us
5282 75 21_Re: STAY RESIDENT YES14_Barbara Koenen33_barbara.koenen.bgit@STATEFARM.COM31_Thu, 10 Jun 2010 11:54:33 -0700461_UTF-8 Using Stay Resident was one of tuning changes we made to improve performance and throughput. The caveats below are important to consider though. You definitely will need to do WLM refreshes when you implement new versions of SPs.
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of David Simpson
Sent: Thursday, June 10, 2010 1:05 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] STAY RESIDENT YES [...]67_9321A73F77470E4CB44903D606D207190DD9113A@WPSCV6MQ.OPR.STATEFARM.ORG
5358 59 21_Re: STAY RESIDENT YES14_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE31_Thu, 10 Jun 2010 21:48:09 +0200619_UTF-8 There was recently a thread on the ASSEMBLER LIST regarding
constructed reentrancy vs. natural reentrancy using the RENT compile
option with C, C++ or PL/1.
I want to add, that RENT does not help with the initialization problems
with STAY RESIDENT YES. Even static storage in the WSA (in the
case of RENT) is not initialized again, if a resident stored proc is called
a second time. This is because the LE enclave is not restarted. So you
have the responsibility to re-initialize all your static variables on every
call of the stored proc (or better: use automatic variables, or: [...]28_4C114179.8090406@t-online.de
5418 156 39_Re: DDF-DSNZPARM_CONDBAT in z/OS-DB2/V910_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 11 Jun 2010 12:42:44 +0200384_UTF-8 Hi
Hope I understood your question well...... See:
Lessons Learned from Data Sharing Health Checks by Judy Ruby Brown
NA IDUG 2005 (probably there more recent versions)
There's a good description about storage usage/evaluation with a tool
description (MEMU2) giving storage usage. It's a very good paper, IMHO.
Let me know if you need a copy. [...]66_OFD8B0E0CE.A9ABBED1-ONC125773F.003623F7-C125773F.003AD789@cesve.it
5575 386 52_Re: [DB2 z/OS V8] MQT hiding itself from optimizer !16_Robert Catterall21_rfcatterall@GMAIL.COM31_Fri, 11 Jun 2010 10:56:53 -0400416_ISO-8859-1 Bala,
Sorry about the very late response -- I've gotten WAY behind on DB2-L,
obviously.
I take it you're looking for the optimizer to use your MQT without it (the
MQT) having to be explicitly referenced in a query. That's made possible by
the ENABLE QUERY OPTIMIZATION clause in the CREATE TABLE statement that
defines the MQT, and ENABLE QUERY OPTIMIZATION is the default. [...]60_AANLkTikmh9Pz4nu0zIXdOREetROdJAVvJdIcvm87e6TJ@mail.gmail.com
5962 126 21_Re: [AD] QMF for z/OS17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Fri, 11 Jun 2010 16:36:01 +0100471_us-ascii Thanks Carol,
The bottle of wine is in the post.
Can I also plug our great CA DB2 Value Pack including ISQL (Interactive
SQL) and DB2C (DB2 Commands Tool).
Thanks.
Aurora
Aurora Emanuela Dell'Anno
CA Technologies - MSC
Sr. Engineering Services Architect
Tel: +44 (0)1753 577 733
Mobile: +44 (0)7768 235 339
Aurora.Dellanno@ca.com
CA Limited
Ditton Park, Riding Court Road, Datchet, SL3 9LL, UK [...]56_3D02E8610514C04F991CF832BA154C66105676C9@UKSLMS11.ca.com
6089 348 19_Re: Friday "survey"17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Fri, 11 Jun 2010 16:41:04 +0100523_iso-8859-1 Hello lists,
I will publish the partial results of my "survey" next week, thanks to all those who responded.
Very interesting food for thought there, that I will try and summarise in my email next week, meantime if you have any MORE comments or responses please reply to me offline!
Thanks.
Aurora
Aurora Emanuela Dell'Anno
CA Technologies - MSC
Sr. Engineering Services Architect
Tel: +44 (0)1753 577 733
Mobile: +44 (0)7768 235 339
Aurora.Dellanno@ca.com [...]56_3D02E8610514C04F991CF832BA154C66105676CA@UKSLMS11.ca.com
6438 43 37_[AD] New LinkedIn Group - Team EZ-DB213_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Fri, 11 Jun 2010 11:47:56 -0400554_iso-8859-1 TEAM EZ-DB2 is a professional group for EZ-DB2 users, Cogito team members & business partners, and other professionals interested in the EZ-DB2 family of products.
The group will promote discussion on product news, events, user experiences, enhancement suggestions and other product related subjects. Membership subject to Cogito approval.
For more information, and to request membership, please head to http://www.linkedin.com/groups?gid=3097868&trk=myg_ugrp_ovr or search for the group in the LinkedIn groups directory [...]60_4440F5DA00E3F3459BBCB97431B91B6612B61E0583@MAILR004.mail.lan
6482 156 21_Re: [AD] QMF for z/OS0_24_carol.sutfin@REGIONS.COM31_Fri, 11 Jun 2010 12:49:13 -0500599_US-ASCII I figure with more users then Chris can not retire.
Also, less problems for me to find.
Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
carol.sutfin@regions.com
From: "Dell'Anno, Aurora"
To: DB2-L@IDUGDB2-L.ORG
Date: 06/11/2010 11:27 AM
Subject: Re: [DB2-L] [AD] QMF for z/OS
Sent by: IDUG DB2-L
Thanks Carol,
The bottle of wine is in the post.
Can I also plug our great CA DB2 Value Pack including ISQL (Interactive
SQL) and DB2C (DB2 Commands Tool). [...]71_OFCB892A1B.666A0374-ON8625773F.0061B92F-8625773F.0061E436@corp.rgbk.com
6639 69 71_New England DB2 Users Group June 17 2010 - Great Stuff Plus a Hamburger7_Ed Long19_rdhm99a@PRODIGY.NET31_Fri, 11 Jun 2010 12:09:32 -0700624_iso-8859-1 Our next meeting will be next Thursday June 17 2010 in Sturbridge Mass at the Publick House. There are some seats available so hurry to WWW.NEDB2UG.ORG to register.
Our speakers include:
Jim Brogan (IBM)offering a utility update:
Bilung Lee (IBM)on the Type 4 JDBC driver.
Dwaine Snow (IBM) on LUW 9.7 and 9.8.
Finally Diwakar Rao(Fidelity) onone user's experience implementing some of the V9 features we've all heard about.
As usual, we will have our raffle, my whistle, and this time, our picnic. We will also handicap the World Cup (Brazil is the answer)!
See you then. [...]43_994986.72107.qm@web80202.mail.mud.yahoo.com
6709 72 25_DB2 LUW Disaster Recovery12_Bob Jeandron21_bob.jeandron@USDA.GOV31_Sun, 13 Jun 2010 17:50:59 -0400497_UTF-8 Am new to LUW (AIX), previous experience with Z/OS. Need to set up
disaster recovery at alternate site for a partitioned DB. Will use backup and recover.
Is there a redbook that describes the process using an offline DB2 backup to recover
the DBs at the alternate site? The AIX folks here say they can recover the files
(software, etc.) using savevg. I am thinking that a DB2 recover would build the
DB, if the file systems are there, from a DB2 backup. Is that correct? [...]53_4331093866131471.WA.bob.jeandronusda.gov@www.idug.org
6782 228 29_Re: DB2 LUW Disaster Recovery16_Gregory Palgrave28_gpalgrave@STAFF.IINET.NET.AU31_Mon, 14 Jun 2010 09:39:56 +0800340_utf-8 Hi Bob,
You can use backup and recover – offline is easiest, but online + rollforward works fine as well. If your file systems are defined identically, it is very straight-forward. If the files systems are different, you may need to look at a redirected restore. Depending on your needs, you could look at HADR as well. [...]73_8522673947DF7D4394C962BFE441CD270509726716@PER-EXCHMBX.win2k.iinet.net.au
7011 231 49_[AD] IBM DB2 Connect Class Starts Monday, June 217_Kim May28_kim.may@THEFILLMOREGROUP.COM31_Mon, 14 Jun 2010 11:08:41 -0400579_US-ASCII Frank Fillmore will deliver IBM CF602, DB2 Connect 9 to DB2 for z/OS DRDA
Implementation with TCP/IP, in Towson, Maryland (just north of Baltimore),
starting Monday, June 21, 2010. This course runs infrequently - this
session is guaranteed to run and there are 2 seats available. It is a 4
day course, running Monday through Thursday, and costs $2600. If you are
interested in attending, please register at the IBM training
course_description&courseCode=CF602> site. [...]41_4c1645ff.c739dc0a.2813.41ae@mx.google.com
7243 187 43_IDUG EMEA 2010: DB2 Experts Panel Questions13_Phil Grainger26_phil.grainger@COGITO.CO.UK31_Mon, 14 Jun 2010 11:28:16 -0400371_us-ascii A highlight of every IDUG conference, the DB2 Experts Panel Discussion brings the IBM strategists and developers, as well as independent DB2 experts, to you.
These key DB2 community representatives are available to offer their suggestions, insights and answers to your questions.
Questions can be submitted during the panel session or in advance. [...]60_4440F5DA00E3F3459BBCB97431B91B6612B84D2723@MAILR004.mail.lan