1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2006, week 5
2 490 30_Re: Cross Invalidation Entries3_Les21_db2dba@BTINTERNET.COM31_Sat, 29 Jul 2006 15:50:17 +0100309_us-ascii Nick no problem, will email you. I woudl say that anything that is interesting to the list re stats and trends etc should remain here as sometimes the most simple of questions can help people in the future. I will post back anything I think might help anybody in the future. all the best Leslie [...]
493 18 83_Mar=?ISO-8859-1?Q?=EDa_Jos=E9_Artigas_Cort=E9s/ATCA_est=E1?= ausente de la oficina.0_17_mjartigas@ATCA.ES31_Sat, 29 Jul 2006 22:03:41 +0200604_ISO-8859-1 Estaré ausente de la oficina desde el 29/07/2006 y no volveré hasta el 20/08/2006.
Responderé a su mensaje cuando regrese. --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
512 103 45_Re: Hi volume stored procedures (z/OS db2 v7)11_Mike Kalena16_mkalena@BEAR.COM31_Sat, 29 Jul 2006 16:26:09 -0500566_ISO-8859-1 We let WLM manage the started tasks.
As you stated, WLM determines the number of tasks based on goals. If you start missing, it starts more. When you stop using them, it stops the tasks.
We also found that WLM will start them based on service class, in other words we have DB2PWLM as our default production environment. We have CICS regions in service class ONLPRDHI and say 2 batch jobs one in PRDBATHI the other in PRDBATMD. If we had a transaction in CICS and a batch job running in each of these service classes, if they all called [...]
616 84 45_Tons of DSNU344I messages during a LOAD - WHY0_22_DB2information@AOL.COM29_Sat, 29 Jul 2006 18:43:12 EDT375_US-ASCII Hello List, We are getting tons of these message during a LOAD of a DB2 table. We were not getting these messages when duting the load before today. DSNU344I -DB2T DSNURBXA - UNIQUE INDEX KEY DUPLICATES KEY OF INDEXED RECORD
AT RID X'0000005201',
INDEX = VOFIX2.VXLQ1601,
TABLE = VOFIX2.VTLQ16,
RECNO = 1,
RID = X'000000525A' [...]
701 58 49_Re: Tons of DSNU344I messages during a LOAD - WHY9_Mike Bell21_mbell11a1@VERIZON.NET31_Sat, 29 Jul 2006 18:10:30 -0500429_US-ASCII usually means you are loading the same dataset as last run. I would check on GDG, dataset created, maybe duplicate records were generated.
Mike
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of DB2information@AOL.COM Sent: Saturday, July 29, 2006 5:43 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Tons of DSNU344I messages during a LOAD - WHY [...]
760 346 30_Re: Cross Invalidation Entries3_Les21_db2dba@BTINTERNET.COM31_Sun, 30 Jul 2006 09:57:18 +0100309_us-ascii Nick no problem, will email you. I woudl say that anything that is interesting to the list re stats and trends etc should remain here as sometimes the most simple of questions can help people in the future. I will post back anything I think might help anybody in the future. all the best Leslie [...]
1107 33 44_Re: Global Buffer Pool Tuning Considerations17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Sun, 30 Jul 2006 09:33:12 -0500601_- Group Bufferpool Vs turning off SMF writing and VSAM stripping?. Isn't this completely unrelated?.
When there is a memory constraint where will AUTOALT get memory from?. On a constrained system shouldn't you be sizing the structure with proper INITSIZE, upfront?. The idea behind turning off SMF will probably not result in any savings unless this is rather an extreme case where you had to reduce SMF buffers and reconfigure the storage to CF. Are you operating with 256MB SMF buffers (I believe the max possible) and you now want to reduce this to 64Mb and takeaway the 190Mb from the [...]
1141 463 45_NEODBUG quarterly meeting Thursday, August 1711_James Szabo18_jim.szabo@CORE.COM31_Sun, 30 Jul 2006 13:12:33 -0400428_iso-8859-1 The Northeast Ohio Database Users Group (NEODBUG) hosts their quarterly meeting on Thursday, August 17, 2006 at the DoubleTree Hotel Cleveland South, 6200 Quarry Lane in Independence, Ohio USA. The agenda is as follows:
8:30 - 9:00 Registration
9:00 - 9:10 Opening Remarks
Michael James, NEODBUG Chairman
9:10 - 10:30 "DB2 Viper Test Drive Highlights" [...]
1605 50 25_Easy opportunity to shine13_Bell, Raymond22_raymond.bell@LANDG.COM31_Mon, 31 Jul 2006 10:15:47 +0100417_iso-8859-1 All,
Dead simple question for y'all. DB2 for z/OS V7 and I'm trying to alter a table that some git has had the audacity to run some dynamic SQL against. So I get 00E70081, which I'm interpreting as meaning I can't alter the table 'cause there's a reference to it in the dynamic statement cache. With regard to my question, and with all due respect to Rolf Harris, Can you guess what it is yet? [...]
1656 169 29_Re: Easy opportunity to shine13_Michael Ebert18_mebert@AMADEUS.COM31_Mon, 31 Jul 2006 11:25:46 +0200417_US-ASCII Well, the disclaimer was longer than your message... it's time that sort of spamming is made illegal...
The problem seems to be that there is a query still running or active. Try -DIS DB(dbname) TS(tsname,ixspaces) A USE and ... CLAIMERS and ... LOCKS to see who's accessing it.
Dr. Michael Ebert DB2 & *sigh* Oracle Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...]
1826 373 29_Re: Easy opportunity to shine13_Bell, Raymond22_raymond.bell@LANDG.COM31_Mon, 31 Jul 2006 10:40:19 +0100547_iso-8859-1 If I had a £ for every line of my footer I could retire already. Talk about 'a large number of electrons were seriously inconvenienced'.
I did eventually find the reference in the Runstats bumf about it doing exactly as it says on the tin i.e. invalidate the cache. I think I'm just being unlucky, as queries are coming in and going out all the time, re-establishing the cache for this object. I have seen a few bods under Claimers so I think I've got to be quick i.e. display (no one running), quick runstats, quick alter. [...]
2200 472 29_Re: Easy opportunity to shine14_Steurs Patrick21_Patrick.Steurs@NBB.BE31_Mon, 31 Jul 2006 11:55:01 +0200674_iso-8859-1 Hi Raymond,
If you only want to invalidate the cache add the runstats-keyword SAMPLE 1 , then your runstats will go faster.
greetings,
Patrick Steurs
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bell, Raymond Sent: maandag 31 juli 2006 11:40 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Easy opportunity to shine
If I had a £ for every line of my footer I could retire already. Talk about 'a large number of electrons were seriously inconvenienced'. [...]
2673 63 20_Yay! Got the scumbag13_Bell, Raymond22_raymond.bell@LANDG.COM31_Mon, 31 Jul 2006 10:54:21 +0100336_iso-8859-1 Dr. E,
Just thought I'd let you know, I was watching the CLAIMERS on this table and the moment they disappeared I quickly did runstats/alter and Shazam! I got my work done. So just bad timing on my part.
BBC says a sunny 29C out at München airport. Nice.
Raymond Bell Database Administrator [...]
2737 61 29_Re: Easy opportunity to shine14_Roy J Cornford23_roy_cornford@UK.IBM.COM31_Mon, 31 Jul 2006 11:43:55 +0100445_US-ASCII fyi...
"when you specify UPDATE NONE REPORT NO, RUNSTATS invalidates statements in the dynamic statement cache without collecting statistics, updating catalogs tables, or generating reports."
Roy
DB2 for z/OS European SWAT Team DB2 Development Galileo Centre MP135 Hursley Winchester SO21 2JN UK
+44 1962 816016
---------------------------------------------------------------------------------
2799 80 30_DB2UDB Windows 2003 SQLO_NORES17_Erkki Sondergaard16_esonderg@CSC.COM31_Mon, 31 Jul 2006 12:34:21 +0200526_US-ASCII I'm getting the subject error quite a bit on a DB2 UDB on Windows 2003 fixpak 9 (yes, I know it's old, hopefully I'll be allowed to patch it soon as we have FP 12 on in test).
I've been searching high and low for what ressource it is UDB can't get at, have plenty of examples in my db2diag.log (see below). I can provoke the error anytime I want to by taking a online backup where I get the error on the output file, but all of these examples below is coming during normal SQL operations. Anyone have any [...]
2880 163 29_Re: Easy opportunity to shine13_Bell, Raymond22_raymond.bell@LANDG.COM31_Mon, 31 Jul 2006 12:38:30 +0100342_iso-8859-1 Cheers Roy. I did eventually find a similar reference, so I was doing it right, just being unlucky in my timings. Eventually got it to work.
Incidentally, where did you find the text below? Because the V7 Utility Guide specifically states that combination of parms is invalid, as is borne out by me trying it just now. [...]
3044 143 30_Never mind, Larry - I found it13_Bell, Raymond22_raymond.bell@LANDG.COM31_Mon, 31 Jul 2006 12:43:26 +0100638_iso-8859-1 Larry,
I see the reference to UPDATE NONE REPORT NO in the V8 manuals - so that answers that question. Sigh...
Raymond Bell Mostly V7 and one V8 CM Database Administrator
This e-mail (and any attachments) may contain privileged and/or confidential information. If you are not the intended recipient please do not disclose, copy, distribute, disseminate or take any action in reliance on it. If you have received this message in error please reply and tell us and then delete it. Should you wish to communicate with us by e-mail we cannot guarantee the security of any data outside our [...]
3188 45 34_FW: Never mind, Larry - I found it13_Bell, Raymond22_raymond.bell@LANDG.COM31_Mon, 31 Jul 2006 12:44:26 +0100434_iso-8859-1 Oops. I meant 'Roy'. Man, time for me to stop writing e-mails for a day or so...
> -----Original Message----- > From: Bell, Raymond > Sent: 31 July 2006 12:43 > To: Db2-L (E-mail) > Subject: Never mind, Larry - I found it > > Larry, > > I see the reference to UPDATE NONE REPORT NO in the V8 manuals - so that > answers that question. Sigh... > > > Raymond Bell > Mostly V7 and one V8 CM Database Administrator [...]
3234 131 34_Re: DB2UDB Windows 2003 SQLO_NORES13_Mertens, Bart18_bart.mertens@CZ.NL31_Mon, 31 Jul 2006 14:36:25 +0200546_us-ascii Erkki,
It seems your DB2 is having trouble creating agents to perform I/O.
Regards, Bart
-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens Erkki Sondergaard Verzonden: maandag 31 juli 2006 12:34 Aan: DB2-L@WWW.IDUGDB2-L.ORG Onderwerp: [DB2-L] DB2UDB Windows 2003 SQLO_NORES
I'm getting the subject error quite a bit on a DB2 UDB on Windows 2003 fixpak 9 (yes, I know it's old, hopefully I'll be allowed to patch it soon as we have FP 12 on in test). [...]
3366 15 51_DB2 Tablespace Clones with Flashcopy v2 or Snapshot9_John Hays15_jhays@SFBLI.COM31_Mon, 31 Jul 2006 09:58:28 -0500361_- We want to use flashcopy V2 to copy tablespaces from Subsystem to Subsystem at a very high speed. We are looking for a software product that can update the object IDs in the target system after the copy is complete. We have found BCV5 from ESAI. Do you know of other companies that make products like this for object IDs updates or DSN1COPY replacement? [...]
3382 96 55_Re: DB2 Tablespace Clones with Flashcopy v2 or Snapshot11_Tom Moulder30_tom.moulder@TREXASSOCIATES.COM31_Mon, 31 Jul 2006 11:35:08 -0500422_us-ascii Here are the products that I know about. It does not mean that this is a complete list. You may want to do some searches on your own.
ESAI has two products, BCV4 and BCV5. The difference is whether you want to clone an entire subsystem or individual objects. This product is DASD vendor neutral and supports the major intelligent storage subsystem vendors, so you would have support for Flashcopy V2. [...]
3479 31 55_Re: DB2 Tablespace Clones with Flashcopy v2 or Snapshot12_Patrick Lyon22_ptlyon@MIDAMERICAN.COM31_Mon, 31 Jul 2006 12:35:56 -0500690_- On Mon, 31 Jul 2006 09:58:28 -0500, John Hays wrote:
>We want to use flashcopy V2 to copy tablespaces from Subsystem to >Subsystem at a very high speed. We are looking for a software product >that can update the object IDs in the target system after the copy is >complete. We have found BCV5 from ESAI. Do you know of other companies >that make products like this for object IDs updates or DSN1COPY >replacement? > >--------------------------------------------------------------------------- ------ >Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join [...]
3511 43 32_DB2v8 NFM Delete Cascade Problem14_Mark McCormack27_mamccormack@STATESTREET.COM31_Mon, 31 Jul 2006 14:50:04 -0400347_US-ASCII This may be of interest to some people. If you use RI, delete cascade, and not-padded indices, you might want to continue reading.
We have recently upgraded most of our subsystems to NFM after months at CM. We recently started to upgrade DB2v8 maintenance level from about RSU0905 to about RSU0604. We found a noteworthy bug. [...]
3555 302 43_DB2v8 z/OS: UNLOAD FROMCOPYDDN OBID Problem12_Marcia Crisp16_MA-Crisp@WIU.EDU31_Mon, 31 Jul 2006 14:27:51 -0500401_US-ASCII Esteemed DB2 Listers:
After UNLOADing from an image copy, my output data has X'0000' (instead of the OBID) in the first two columns. This only happens for one of my tablespaces; all the others have the OBID as expected.
I am using the UNLOAD utility to unload data from an image copy. The tablespace is segmented, with a single table in it. [...]
3858 200 47_Re: DB2v8 z/OS: UNLOAD FROMCOPYDDN OBID Problem15_Basivi Inaganti30_basivi.r.inaganti@JPMCHASE.COM31_Mon, 31 Jul 2006 16:14:56 -0400500_UTF-8 It looks to me that you are not anything doing wrong. Please take a look at the following PTF.
PK08167: UNLOAD FROMCOPY DOES NOT UNLOAD THE TABLE OBID Thanks, Basivi R. Inaganti :: Production Quality DBA :: Application Technology Services :: Enterprise Systems :: Ã… 614-213-5324 (Office) 1-888-354-5236 (Page)
Marcia Crisp Sent by: DB2 Data Base Discussion List 07/31/2006 03:27 PM Please respond to MA-Crisp@wiu.edu [...]
4059 201 47_Re: DB2v8 z/OS: UNLOAD FROMCOPYDDN OBID Problem15_Basivi Inaganti30_basivi.r.inaganti@JPMCHASE.COM31_Mon, 31 Jul 2006 16:19:49 -0400491_UTF-8 It looks to me that you are not doing wrong. Please take a look at the following PTF.
PK08167: UNLOAD FROMCOPY DOES NOT UNLOAD THE TABLE OBID Thanks, Basivi R. Inaganti :: Production Quality DBA :: Application Technology Services :: Enterprise Systems :: Ã… 614-213-5324 (Office) 1-888-354-5236 (Page)
Marcia Crisp Sent by: DB2 Data Base Discussion List 07/31/2006 03:27 PM Please respond to MA-Crisp@wiu.edu [...]