1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l January 2010, week 4 2 300 157_Upcoming IDUG Webcast - "The DB2Night Show Episode #11 - "DB2 9.7 Optimizer Updates", Scott Hayes, DBI Software" - Friday 29 January 2010 at 10:00 am USA CST13_David Chapman24_David.Chapman@IAG.COM.AU31_Fri, 22 Jan 2010 14:45:24 +1100822_us-ascii

_______________________________________________________________________________________

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



Hello DB2 List,

Here is an upcoming webcast that you may be interested in.

The DB2Night Show Episode #11 - 08 Jan 2010 - "DB2 9.7 Optimizer Updates", Scott Hayes, DBI Software

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 approximately 60 minutes and participants will have the opportunity to pose questions to the presenter. Capacity is limited, so register [...] 303 120 49_Re: Finding DB2 objects in questionable status...17_Tunen, Marcel van31_Marcel.van-Tunen@CORUSGROUP.COM31_Fri, 22 Jan 2010 07:52:48 +0100538_us-ascii How about using DSNACCOX with these settings:

Querytype Restrict Objecttype ALL Checklevel 8

Met vriendelijke groet, Marcel van Tunen

-----Original Message----- From: Phil Grainger [mailto:phil@GRAINGERDATABASESOLUTIONS.COM] Sent: Wednesday, January 20, 2010 5:59 PM Subject: Re: Finding DB2 objects in questionable status...

Unfortunately IBM don't externalize many of the "questionable statuses" so a -DIS DATABASE is the only guaranteed way to find the oddities (like RECP, AREORP, RBDP etc.) [...] 424 534 90_FW: Red Alert: z/OS Potential DB2 Data Inconsistencies Following a CF Failure (2010.01.21)12_McLaren Phil32_Phil.McLaren@AXAWINTERTHUR.CO.UK31_Fri, 22 Jan 2010 09:00:36 +0000733_us-ascii Hi folks, another red alert, so soon after the last one (!) Phil

[http://www.ibm.com/systems/support/csn/images/notification_sys_z.jpg]

21 Jan 2010







Dear Subscriber (phil.mclaren@winterthur-life.co.uk),

The following are the latest updates to your subscription at IBM My notifications.

[http://www.ibm.com/vrm/images/newsletter/template/headab2col/bar_dot_training.gif] Note: Forward this message to colleagues who may benefit from this technical information. The "Subscribe or Unsubscribe" link at the bottom of this message will allow them to create their own subscriptions. [http://www.ibm.com/vrm/images/newsletter/template/headab2col/bar_dot_training.gif] [...] 959 154 36_Re: DB2 for z/OS V9 Catalog poster ?11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 22 Jan 2010 12:57:29 +0100625_UTF-8 Danke Steen!

Just clicked on it - I hope it's as pretty as the V8 one!!!



Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de

Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert







"Rasmussen, Steen" Gesendet von: IDUG DB2-L 21.01.2010 16:57 Bitte antworten an IDUG DB2-L [...] 1114 155 36_Re: DB2 for z/OS V9 Catalog poster ?11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 22 Jan 2010 12:59:52 +0100418_UTF-8 OMG...gave me a good laugh on a grey friday!!! I will indeed swing around and catch you at the IDUG - Last time I heard Helsinki was being mentioned...something about "Cheap beer" :)





Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de [...] 1270 140 55_SV: [DB2-L] Connectivity between DB2 sub systems in zOS13_Hanne Lyssand20_Hanne.Lyssand@VPS.NO31_Fri, 22 Jan 2010 13:30:49 +0100276_us-ascii Datasharing is more complicated, but you get so much more. With connect if DB2 go down, the connection is gone to so both DB2's have to be up an running. To add a member to a datasharing group is not so complicated, it's the first 2 that give you most problems. [...] 1411 351 44_AW: [DB2-L] DB2 for z/OS V9 Catalog poster ?12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 22 Jan 2010 13:31:37 +0100513_iso-8859-1 >>> something about "Cheap beer" <<<





Roy, the average price of a beer in Helsinki is between 5 and 10 euro. ...

Regards, Georg

---------------------------------------------------------------------- P Think before you print.

-----Ursprngliche Nachricht----- Von: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Roy Boxwell Gesendet: Freitag, 22. Januar 2010 13:00 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: Re: [DB2-L] DB2 for z/OS V9 Catalog poster ? [...] 1763 245 48_Re: AW: [DB2-L] DB2 for z/OS V9 Catalog poster ?11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 22 Jan 2010 13:59:00 +0100471_UTF-8 Georg, it's called irony!!!!! I happen to know how much it costs there as I used to go there a lot (My sister worked there for a few years) and I know that beer costs a fortune but in Italy it was also 8 Euros for a "smallish" beer....





Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de [...] 2009 101 59_Re: SV: [DB2-L] Connectivity between DB2 sub systems in zOS11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 22 Jan 2010 14:01:26 +0100421_UTF-8 worse its creating one DS out of two single DB2 sub-systems...Just think of two tables with the same name but different columns or sometimes even worse two tables with the same name and columns but different "meanings"....the possibilities are nearly endless when you "merge" DB2 subsystems...good work for an external contractor though! But back to the original point -> Yep TCP/IP with DDF is the way to go! [...] 2111 892 48_Re: AW: [DB2-L] DB2 for z/OS V9 Catalog poster ?12_Jose Antonio17_jamorcillo@CAM.ES31_Fri, 22 Jan 2010 14:00:48 +0100579_iso-8859-1 In Spain is 2-3 euros :-)





__________________________ Jos A Morcillo Valenciano Tfno.: +34 965 90 51 43 747-Produccin Informtica



__________________________









________________________________

De: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] En nombre de Peter, Georg Enviado el: viernes, 22 de enero de 2010 13:32 Para: DB2-L@WWW.IDUGDB2-L.ORG Asunto: [DB2-L] AW: [DB2-L] DB2 for z/OS V9 Catalog poster ?





>>> something about "Cheap beer" <<< [...] 3004 285 36_Re: DB2 for z/OS V9 Catalog poster ?13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 22 Jan 2010 14:15:17 +0100466_utf-8 Hey Roy,

Glad it got a chuckle; that was the intention. If we both make it to IDUG this year – wherever it ends up being – we’ll see if there’s a weißbier about somewhere. Or are you more a Helles man? Infidel...

Laters,



Raymond

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Boxwell Sent: 22 January 2010 12:00 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 for z/OS V9 Catalog poster ? [...] 3290 465 36_Re: DB2 for z/OS V9 Catalog poster ?13_Phil Grainger34_phil@GRAINGERDATABASESOLUTIONS.COM31_Fri, 22 Jan 2010 13:21:36 -0000425_us-ascii You could always put Quests on a window - the one you want to se on the inside, and ...





Hey - It's Friday :-)





Phil Grainger

Grainger Database Solutions Ltd

_____

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Peter Suhner Sent: 21 January 2010 23:12 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 for z/OS V9 Catalog poster ? [...] 3756 172 47_Re: Connectivity between DB2 sub systems in zOS28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Fri, 22 Jan 2010 19:03:45 +0530734_US-ASCII Please have a look at => http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2.doc.dshare/zint.htm#zint

















Ramachandran A Sent by: IDUG DB2-L 21/01/2010 18:02 Please respond to IDUG DB2-L



To DB2-L@WWW.IDUGDB2-L.ORG cc

Subject [DB2-L] Connectivity between DB2 sub systems in zOS











Dear list,

Our project needs to establish connectivity between two DB2 sub systems which are running on two different zOS systems in the same sysplex. But I am not sure this feature is available or not. [...] 3929 317 48_Re: AW: [DB2-L] DB2 for z/OS V9 Catalog poster ?11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 22 Jan 2010 14:55:01 +0100476_UTF-8 and I take it that

a) It is a good beer and b) It is a large beer

then Spain would get my 12 points!!!!





Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de

Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert [...] 4247 496 48_Re: AW: [DB2-L] DB2 for z/OS V9 Catalog poster ?10_Roger Hecq18_Roger.Hecq@UBS.COM31_Fri, 22 Jan 2010 08:56:16 -0500382_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. [...] 4744 1304 48_Re: AW: [DB2-L] DB2 for z/OS V9 Catalog poster ?12_Jose Antonio17_jamorcillo@CAM.ES31_Fri, 22 Jan 2010 14:59:56 +0100564_iso-8859-1 hehehe very good!





__________________________ Jos A Morcillo Valenciano Tfno.: +34 965 90 51 43 747-Produccin Informtica



__________________________









________________________________

De: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] En nombre de Roy Boxwell Enviado el: viernes, 22 de enero de 2010 14:55 Para: DB2-L@WWW.IDUGDB2-L.ORG Asunto: Re: [DB2-L] AW: [DB2-L] DB2 for z/OS V9 Catalog poster ?







and I take it that [...] 6049 27 48_Re: AW: [DB2-L] DB2 for z/OS V9 Catalog poster ?14_Tommy Petersen30_tommy_petersen@NEWYORKLIFE.COM31_Fri, 22 Jan 2010 14:05:25 +0000738_utf-8 Have you tried Computer Associates? http://www.ca.com/us/content/campaign.aspx?cid=94127

I would be weary of the beer price quoted, I have never met a Finn (is that the correct term?) who would order just one beer?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups, there is probably one near you! Regional User Groups are your local connection to the Worldwide DB2 User Community _____________________________________________________________________ [...] 6077 15 59_Re: SV: [DB2-L] Connectivity between DB2 sub systems in zOS11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Fri, 22 Jan 2010 14:09:48 +0000307_Windows-1252 >To add a member to a datasharing group is not so complicated, its the first 2 that give you most problems.

If any at all. (8-{]} We were lucky, when we implemented it, we were building from scratch, rather than trying to connect two existing.

- Too busy driving to stop for gas! 6093 165 49_LOAD Utility fails: UNABLE TO RESTART BUILD PHASE12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 22 Jan 2010 15:25:20 +0100576_us-ascii Environment is DB2 z/OS V8 CM --------------------------------------------





Collegues,





a LOAD Utility from one of our programmers fails:



myuser INDDEW DSNUPROC LOAD - ABEND=S04E U0000 REASON=00E40310

myuser 1 DSNUPROC DSNUTILB ------------ S04E.

UNABLE TO RESTART BUILD PHASE





Question 1: Any good idea why the LOAD crashes ?





And as a result of this action two indexes went into REBUILD INDEX state. When I tried to rebuild them the job fails [...] 6259 170 36_Re: DB2 for z/OS V9 Catalog poster ?11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 22 Jan 2010 15:27:16 +0100591_UTF-8 my window is not *that* big!!!





Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Straße 5 40470 Düsseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de http://www.seg.de

Software Engineering GmbH Amtsgericht Düsseldorf, HRB 37894 Geschäftsführung: Siegfried Fürst, Gerhard Schubert







Phil Grainger Gesendet von: IDUG DB2-L 22.01.2010 14:21 Bitte antworten an IDUG DB2-L [...] 6430 358 27_Re: LUW TEMPSPACE Disk Full13_Mark Horrocks22_agentlease@HOTMAIL.COM31_Fri, 22 Jan 2010 14:30:33 +0000702_Windows-1252

Hi,





You need to check,





1. Your OS parameter ulimit should be unlimited as a greedy join will create temporary files that will fill your filesystem.





2. If you can reproduce the peoblem check the files in the filesystem i.e. what suffix?





Thanks.

> Date: Thu, 21 Jan 2010 13:41:55 -0500 > From: pgunning@GUNNINGTS.COM > Subject: Re: [DB2-L] LUW TEMPSPACE Disk Full > To: DB2-L@WWW.IDUGDB2-L.ORG > > You might be filling up one directory in the filesystm and when that happens with SMS then DB2 considers tablespace full, even if space avail in other container, a guess would be 0 [...] 6789 113 53_Re: LOAD Utility fails: UNABLE TO RESTART BUILD PHASE28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Fri, 22 Jan 2010 20:15:15 +0530572_UTF-8 Could you please paste the LOAD statements from the SYSIN ?









"Peter, Georg" Sent by: IDUG DB2-L 22/01/2010 19:55 Please respond to IDUG DB2-L



To DB2-L@WWW.IDUGDB2-L.ORG cc

Subject [DB2-L] LOAD Utility fails: UNABLE TO RESTART BUILD PHASE











Environment is DB2 z/OS V8 CM --------------------------------------------

Collegues,

a LOAD Utility from one of our programmers fails: [...] 6903 138 44_SV: [DB2-L] DB2 for z/OS V9 Catalog poster ?13_Hanne Lyssand20_Hanne.Lyssand@VPS.NO31_Fri, 22 Jan 2010 16:02:10 +0100485_us-ascii Who has a office wall at all these times, I am still so lucky that I have my one desk.

If the price of beer is to decide where IDUG Europe ends up being I will suggest Island this year.

Hanne









_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________ [...] 7042 315 53_AW: LOAD Utility fails: UNABLE TO RESTART BUILD PHASE35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Fri, 22 Jan 2010 16:12:10 +0100362_iso-8859-1 Hello Georg

A failure in a Load-jobs happens in our test-environment all the time. Reasons are:

- output-limit exceeded - time-limit exceeded

When this happens in the index-evaluation phase or in the discard phase the tablespace is in RECP and the indexes are in RBDP.

I wonder, what the status of your tablespace is? [...] 7358 58 73_z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?14_Bruce Lightsey25_Bruce.Lightsey@ITS.MS.GOV31_Fri, 22 Jan 2010 09:14:35 -0600620_US-ASCII I have DB2 v9 installed in my playground lpar and all works nicely there ( z/os v1.9, etc ).

Now I am trying to convert the first subsystem on one of the development lpars and when I get to "Migration step 17: Start DB2 Version 9.1" I continually get :



DSNR001I -DB8T RESTART INITIATED DSNR045E -DB8T DSNRRPRC DB2 SUBSYSTEM IS STARTING 634 AND IT WAS NOT STARTED IN A PREVIOUS RELEASE WITH THE FALLBACK SPE APPLIED. FALLBACK SPE APAR: PK11129 NEW RELEASE LEVEL: 0000D450 KNOWN LEVEL(S): 0000D3010000D3250000D35000000000000 IEF450I DB8TMSTR DB8TMSTR - ABEND=S04F U0000 REASON=00000000 [...] 7417 50 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?12_Cuneyt Goksu22_cuneyt.goksu@GMAIL.COM31_Fri, 22 Jan 2010 15:53:17 +0000465_Windows-1252 Did you recycle your V8 after applied fallback ?

Cuneyt

AVEA BlackBerry Servisi ile gnderildi.

-----Original Message----- From: Bruce Lightsey Date: Fri, 22 Jan 2010 09:14:35 To: Subject: [DB2-L] z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?

I have DB2 v9 installed in my playground lpar and all works nicely there ( z/os v1.9, etc ). [...] 7468 92 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?13_Phil Grainger34_phil@GRAINGERDATABASESOLUTIONS.COM31_Fri, 22 Jan 2010 16:03:05 -0000547_us-ascii It's been a long time since I did it, but you can (under your v8 subsystem, as v9 won't start) do a DIAGNOSE DISPLAY MEPL to make sure the ptfs were applied to the libraries that DB2 is using and not to somewhere else

Phil Grainger

Grainger Database Solutions Ltd

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bruce Lightsey Sent: 22 January 2010 15:15 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ? [...] 7561 26 41_Re: [DB2 V9] Lobs and FETCH WITH CONTINUE35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_walter.janissen@ITERGO.COM31_Fri, 22 Jan 2010 16:05:47 +0000614_utf-8 Hi

Just for your information: There is an open problem, which describes just that: PK99730

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups, there is probably one near you! Regional User Groups are your local connection to the Worldwide DB2 User Community _____________________________________________________________________ [...] 7588 83 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?13_Mick P Graley16_mgraley2@CSC.COM31_Fri, 22 Jan 2010 16:14:32 +0000377_UTF-8 Bruce,

Maybe the code that is applied to your SMP/E target zone hasn't been rolled out to the "live" SDSNLOAD library. I would compare the "live" and SMP/E target SDSNLOAD libraries (if you don't really run off the SMP/E target libraries - we don't).

IBM will possibly ask you to run a DIAGNOSE DISPLAY MEPL utility to check the level of your modules. [...] 7672 99 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?13_Mick P Graley16_mgraley2@CSC.COM31_Fri, 22 Jan 2010 16:21:30 +0000340_UTF-8 Bruce,

I've just looked at the APAR and there's also a HOLD action to re-assemble and link DSNHDECP - did you do that also?

Mick.



MICK GRALEY DB2 for z/OS DBA - GOS DBA Service & Capability Centre CSC

GOS | office: +44 (0)1246 214871 | fax: +44 (0)1246 214503 | mgraley2@csc.com | www.csc.com [...] 7772 49 32_Z/OS DB2 V8 CM Runstats/COLGROUP10_Dave Nance16_dav1mo@YAHOO.COM31_Fri, 22 Jan 2010 09:09:41 -0800262_iso-8859-1 Does anyone know if you have to be in NFM to use the COLGROUP parm on a runstats or if it is possible to run it in CM mode? I continue to read the entire table before failing with a S0C4 reason 3B. Thanks for any help you can provide. Dave Nance [...] 7822 67 46_answer found: Z/OS DB2 V8 CM Runstats/COLGROUP10_Dave Nance16_dav1mo@YAHOO.COM31_Fri, 22 Jan 2010 09:32:47 -0800598_iso-8859-1 Never mind, I should have finished the research I was doing. There is an APAR out there for this issue, APAR number PK79644 Thanks. David Nance ________________________________ From: Dave Nance To: IDUG DB2-L Sent: Fri, January 22, 2010 12:09:41 PM Subject: Z/OS DB2 V8 CM Runstats/COLGROUP Does anyone know if you have to be in NFM to use the COLGROUP parm on a runstats or if it is possible to run it in CM mode? I continue to read the entire table before failing with a S0C4 reason 3B. Thanks for any help you can provide. Dave Nance [...] 7890 122 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?14_Bruce Lightsey25_Bruce.Lightsey@ITS.MS.GOV31_Fri, 22 Jan 2010 11:37:22 -0600543_UTF-8 1) Yes - I have reassembled everything DSNHDECP included ; 2) Yes I have stopped the subsystem and restarted it several times ( and attempted to restart under v9, too ) ; 3) SMP/E shows that the various modules were applied to the correct libraries but DIAGNOSE DISPLAY MEPL doesn't show the maintenance to be present ( and I have called in outside sets of eyes to verify that the libraries involved are, indeed, the same ones ) ; 4) the only thing that hasn't happened is an actual IPL of the lpar - the systems folks say that the [...] 8013 29 36_Re: Z/OS DB2 V8 CM Runstats/COLGROUP11_Pia Velazco21_piavelazco@US.IBM.COM31_Fri, 22 Jan 2010 17:30:45 +0000668_UTF-8 Hi Dave,

We use it in DB2 V8 CM mode and ran into the same S0C4 RC=3B abend. You might want to look at PK79644.

Best regards, Pia Velazco

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups, there is probably one near you! Regional User Groups are your local connection to the Worldwide DB2 User Community _____________________________________________________________________ [...] 8043 390 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM31_Fri, 22 Jan 2010 13:17:28 -0500370_UTF-8 Do you run out of SMPE libs? If not did you copy the smpe libs to the libs you use to start DB2 up? If the libs are in linklist has it been refreshed?

HTHs Jeff







Bruce Lightsey Sent by: IDUG DB2-L 01/22/2010 01:12 PM Please respond to IDUG DB2-L [...] 8434 46 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?13_Irwin Deutsch28_ideutsch@PRINCESSCRUISES.COM31_Fri, 22 Jan 2010 10:52:20 -0800614_US-ASCII The ERLY code gets installed ONLY at IPL. So you need an IPL! (SET doesn't work there.)

Irwin

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups, there is probably one near you! Regional User Groups are your local connection to the Worldwide DB2 User Community _____________________________________________________________________ 8481 207 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?13_Phil Grainger34_phil@GRAINGERDATABASESOLUTIONS.COM31_Fri, 22 Jan 2010 20:53:50 -0000429_US-ASCII Well, if MEPL says it's not there then it isn't!

Not much help, but that is your problem

Phil Grainger

Grainger Database Solutions Ltd

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bruce Lightsey Sent: 22 January 2010 17:37 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ? [...] 8689 79 80_Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS14_Surekha Parekh20_surekha21@UK.IBM.COM31_Fri, 22 Jan 2010 21:50:22 +0000646_UTF-8 Hints and tips to get the most out of IBM DB2 9 for z/OS

Broadcast date: January 26, 2010, 11 a.m., Eastern Standard Time, 4:00 p.m. UTC

Developed for: IT managers, database administrators and managers, systems programmers and application architects

Technical level: Intermediate

With IT budgets shrinking, every shop is facing the same challenge of keeping a lid on risk, and yet demonstrating how IT delivers real business value to the enterprise. Because companies rely on data to drive their businesses, databases are at the center of this challenge. DB2® 9 for z/OS® can play a major role in helping [...] 8769 75 150_Free Webcast Looking to upgrade to DB2 9 for z/OS and improve productivity and reduce costs? Hear directly from one of our customers: UK Land Registry14_Surekha Parekh20_surekha21@UK.IBM.COM31_Fri, 22 Jan 2010 21:53:38 +0000398_UTF-8 Looking to upgrade to DB2 9 for z/OS and improve productivity and reduce costs? Hear directly from one of our customers: UK Land Registry

Broadcast date: February 23, 2010, 11 a.m., Eastern Standard Time, 4:00 p.m. UTC

Developed for: IT managers, IT and application architects, database administrators and managers, systems programmers

Technical level: Intermediate [...] 8845 64 49_Free local DB2 for z/OS Seminars in North America14_Surekha Parekh20_surekha21@UK.IBM.COM31_Fri, 22 Jan 2010 22:10:20 +0000577_UTF-8 Free DB2 for z/OS Technical Update DB2 9 & X - Limited Places

Attend our free technical education seminars on DB2® 9 & X for z/OS® and learn how an upgrade can help address demands for more database capacity and cost-cutting capabilities.

Detailed Agenda & Registration

http://www-01.ibm.com/software/os/systemz/summit/track2.html?S_TACT=&S_CMP= Announcement ! DB2 for z/OS Technical Update Seminars in USA 28th Jan - Washington 2nd Feb - Atlanta 9th Feb - St Louis 11th Feb - NYC 18th Feb - Toronto 4th March - Chicago 9th March - Dallas [...] 8910 101 84_Re: Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 22 Jan 2010 17:07:03 -0500533_us-ascii Surekha,

Please include information about how to sign up for this webcast, or if signup is not required, information about how to navigate to it when the time comes. I'd love to attend, but without directions to get there...

--Phil

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Surekha Parekh Sent: Friday, January 22, 2010 4:50 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS [...] 9012 118 84_Re: Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Fri, 22 Jan 2010 17:06:51 -0600693_ISO-8859-1 Phil

Here's the link to the registration page and web description...

http://www-01.ibm.com/software/os/systemz/telecon/26jan/

Willie

Sevetson, Phil wrote: > Surekha, > > Please include information about how to sign up for this webcast, or if signup is not required, information about how to navigate to it when the time comes. I'd love to attend, but without directions to get there... > > --Phil > > -----Original Message----- > From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Surekha Parekh > Sent: Friday, January 22, 2010 4:50 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] Free Upcoming Webcast - Hints and tips to get the most [...] 9131 33 27_Re: LUW TEMPSPACE Disk Full9_Andy Hunt21_andy_hunt@YAHOO.CO.UK31_Sat, 23 Jan 2010 02:56:47 +0000308_utf-8 An update for those who contributed...

Removed container FS1 so it just used FS2. I was logged on at point of failure and saw it using all the storage on FS2. We don't have more disks to throw at this system, so now resorting to rewriting the process. This'll make it run a lot faster too. [...] 9165 137 41_Re: can I restore only a particular table12_tim malamphy20_timalamphy@YAHOO.COM31_Fri, 22 Jan 2010 21:11:36 -0800360_iso-8859-1 Yes, as Phil indicates, it's much better if you can plan ahead and keep 1 table per tablespace. But if you didn't implement that ahead of time, and are stuck with a broken table, you can restore the whole database elsewhere, do an export for that table, and then import/load that data back into a production table. The indexes will be rebuilt. [...] 9303 178 36_Re: Oracle to DB2 IBM Migration Tool0_17_jtonchick@AOL.COM31_Sat, 23 Jan 2010 00:31:11 -0500338_utf-8

I attended the IBM OnDemand Conference last October. There were several presentations on the DB2 LUW 9.7 PL/SQL support. If you contact your IBM rep, I'm sure they'd be glad to send you the presentations and maybe even hook you up with one of the individuals that presented on their company's Oracle to DB2 conversion. [...] 9482 129 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?14_Barbara Koenen33_barbara.koenen.bgit@STATEFARM.COM31_Fri, 22 Jan 2010 22:37:55 -0700390_UTF-8 I thought the commands to load ERLY code without an IPL were new with V9. It was the first time I saw them.

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bruce Lightsey Sent: Friday, January 22, 2010 11:37 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ? [...] 9612 39 41_Re: can I restore only a particular table14_Peter Vanroose17_pvanroose@ABIS.BE31_Sat, 23 Jan 2010 09:42:29 +0000582_UTF-8 Btw, the same holds when you need to restore only a selected number of rows of a table, e.g. after an unwanted DELETE ... WHERE ...

-- Peter Vanroose ABIS Training & Consulting.

On Fri, 22 Jan 2010 21:11:36 -0800, tim malamphy wrote: >Yes, as Phil indicates, it's much better if you can plan ahead and keep 1 table per tablespace. > But if you didn't implement that ahead of time, and are stuck with a broken table, you can restore the whole database elsewhere, do an export for that table, and then import/load that data back into a [...] 9652 658 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?15_Chris Hoelscher21_choelscher@HUMANA.COM31_Sat, 23 Jan 2010 12:02:34 -0500363_ISO-8859-1 yes it is a new feature - but from what I understand - you MUST do an IPL the first time to load V9 ERLY code on an LPAR - then, quoteth the raven, NEVERMORE ....

Chris Hoelscher Senior IDMS & DB2 Database Administrator Humana Inc 502-476-2538 choelscher@humana.com

you only need to test the programs that you want to work correctly [...] 10311 1697 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 24 Jan 2010 12:06:57 +1100338_ISO-8859-1 If, however, you have UK44315 applied to your V8 early code, you can run DB2 9 under V8 early code. This also enables you run some "future release of DB2 for z/OS". Wonder what they mean by that :-)

There is also an earlier PTF that is specific for running 9 under V8 early code, but I can't find it at the moment. [...] 12009 158 40_IDUG Europe 2010 - Call For Presentation10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 25 Jan 2010 09:48:57 +0100489_ISO-8859-1 IDUG Europe 2010 Call For Presentations

We are proud to announce that the Call for Presentations for this year's IDUG Europe conference is now open.

The International DB2 Users Group (IDUG) is an independent, not-for-profit, user-run organization whose mission is to support and strengthen the information services community by providing the highest quality education and services designed to promote the effective utilization of the DB2 family of products. [...] 12168 308 33_Recursive Common Table Expression14_Galeos Antonis19_AGaleos@EUROBANK.GR31_Mon, 25 Jan 2010 11:42:28 +0200581_us-ascii Dear listers hi ,





Is it possible to use a recursive common table expression with DSNTIAUL like the example below ?





//SYSTSIN DD *

DSN SYSTEM(XXXX) RETRY(0) TEST(0)

RUN PROGRAM(DSNTIAUL) PARM('SQL') PLAN(TIBPLAN) -

LIB('DSN810.XXXX.RUNLIB.LOAD')

END

/*

//SYSIN DD *

WITH APPL(AP_A,AP_B) AS

(

SELECT A,B FROM TABLEA JOIN TABLEB

ON TABLEA.A = TABLEB.A

WHERE SOME-CRITERIA

)

SELECT A,B FROM TABLEC JOIN APPL

ON AP_A = TABLEC.A [...] 12477 122 37_Re: Recursive Common Table Expression33_=?iso-8859-2?Q?Zden=ECk=20Chmel?=14_zchmel@POST.CZ31_Mon, 25 Jan 2010 12:16:15 +0100659_iso-8859-2 Hi Antonis,

I didn't test your example, but generally DSNTIAUL can work with a recursive CTE.

Cheers Zdenek

> ------------ Pvodn zprva ------------ > Od: Galeos Antonis > Pedmt: [DB2-L] Recursive Common Table Expression > Datum: 25.1.2010 11:16:16 > ---------------------------------------- > Dear listers hi , > > > > Is it possible to use a recursive common table expression with DSNTIAUL > like the example below ? > > > > //SYSTSIN DD * > > DSN SYSTEM(XXXX) RETRY(0) TEST(0) > > RUN PROGRAM(DSNTIAUL) PARM('SQL') PLAN(TIBPLAN) - > > LIB('DSN810.XXXX.RUNLIB.LOAD') > > END > > /* > > //SYSIN [...] 12600 376 37_AW: Recursive Common Table Expression35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM31_Mon, 25 Jan 2010 12:50:39 +0100553_iso-8859-1 Hi

The problem can be, that you forgot the semicolon at the end of the statement.

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 [...] 12977 182 40_Distributed Processing with DB2 for z/OS10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 25 Jan 2010 08:56:20 -0500529_Windows-1252

Hi DB2 user,

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

Last update on Monday, January 25th 2010





Here are several presentations and articles about Distributed Processing with DB2 for z/OS, available on different websites:





- An Introduction to Distributed Processing with DB2 for z/OS by Hugh Smith





- Distributed Processing with DB2 for z/OS Advanced Topics by Hugh Smith [...] 13160 301 20_Data Studion 2.2.0.111_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 25 Jan 2010 15:28:19 +01002326_ISO-8859-1 anyone else tried running this?? All I get when I try and do anything is this java exeption screen:

Could not open the editor: An unexpected exception was thrown.

and when I click "details" I get this "really helpful" java dump that makes a CEEDUMP look self explanatory!!!

java.lang.NullPointerException at com.ibm.datatools.dsoe.ui.tunesql.TabHandler4Query.createQueryContextSection(TabHandler4Query.java:1295) at com.ibm.datatools.dsoe.ui.tunesql.TabHandler4Query.createPartControl(TabHandler4Query.java:962) at com.ibm.datatools.dsoe.ui.tunesql.DSOEEditor.createPartControl(DSOEEditor.java:180) at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:661) at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:428) at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:594) at org.eclipse.ui.internal.EditorReference.getEditor(EditorReference.java:266) at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditorBatched(WorkbenchPage.java:2820) at org.eclipse.ui.internal.WorkbenchPage.busyOpenEditor(WorkbenchPage.java:2729) at org.eclipse.ui.internal.WorkbenchPage.access$11(WorkbenchPage.java:2721) at org.eclipse.ui.internal.WorkbenchPage$10.run(WorkbenchPage.java:2673) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2668) at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2652) at org.eclipse.ui.internal.WorkbenchPage.openEditor(WorkbenchPage.java:2635) at com.ibm.datatools.dsoe.ui.action.OpenEditorAction.run(OpenEditorAction.java:73) at com.ibm.datatools.dsoe.ui.project.wizard.OECreationWizard$1.run(OECreationWizard.java:132) at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:133) at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3800) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3425) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2384) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2348) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2200) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:495) at [...] 13462 825 126_Invitation: Re: [DB2-L] Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS (Jan 26 11:00 AM EST)11_Dan DeShong23_ddeshong@AESSUCCESS.ORG31_Mon, 25 Jan 2010 09:23:26 -0500 14288 801 100_Update: Re: [DB2-L] Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS11_Dan DeShong23_ddeshong@AESSUCCESS.ORG31_Mon, 25 Jan 2010 09:24:16 -0500 15090 329 103_Cancelled: Re: [DB2-L] Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS11_Dan DeShong23_ddeshong@AESSUCCESS.ORG31_Mon, 25 Jan 2010 10:10:35 -0500 15420 886 130_Re: Invitation: Re: [DB2-L] Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS (Jan 26 11:00 AM EST)14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Mon, 25 Jan 2010 09:45:21 -0600472_us-ascii Why are you sending this to me (and many others) ? I have already got two copies. Please stop.







Dan DeShong@pheaa.org Sent by: Daniel DeShong/PHEAA@pheaa.org 01/25/2010 09:42 AM Please respond to IDUG DB2-L



To DB2-L@WWW.IDUGDB2-L.ORG cc

Subject [DB2-L] Invitation: Re: [DB2-L] Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS (Jan 26 11:00 AM EST) [...] 16307 656 24_Re: Data Studion 2.2.0.113_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Mon, 25 Jan 2010 10:52:49 -0500557_utf-8 ' tag, Roy,





Have a wander through the Data Studio forum found here:

http://www.ibm.com/developerworks/forums/db2_forums.jspa





They may be able to help.





Dave

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Boxwell Sent: Monday, January 25, 2010 9:28 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Data Studion 2.2.0.1







anyone else tried running this?? All I get when I try and do anything is this java exeption screen: [...] 16964 243 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?13_Mick P Graley16_mgraley2@CSC.COM31_Mon, 25 Jan 2010 17:18:14 +0000511_US-ASCII Agreed. If your code is in the link-list did you remember to refresh the LLA?

Mick.









From: Phil Grainger

To: DB2-L@WWW.IDUGDB2-L.ORG

Date: 22/01/2010 21:00

Subject: Re: [DB2-L] z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?











Well, if MEPL says it's not there then it isn't!

Not much help, but that is your problem [...] 17208 180 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?13_Mick P Graley16_mgraley2@CSC.COM31_Mon, 25 Jan 2010 17:31:32 +0000300_UTF-8 Yeah - it's been this way as far back as I can remember - ERLY code is generally backward/forward compatible between "adjacent" versions of DB2, to minimise the need for IPLs. I've run DB2 V7 on V8 ERLY code and DB2 V8 on V7 ERLY code with no problems. Not had to deal with V9 yet though! [...] 17389 45 52_DB2 luw v8.2 - Question on INPLACE REORG performance13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Mon, 25 Jan 2010 17:42:28 +0000410_utf-8 I am trying to implement the use of INPLACE REORG for 2 OLTP databases on the same server. I am new(ish) to the Unix enviroment and can not seem to find any information regarding tuning DB CONFIG parameters to improve the performance of an inplace reorg.

DatabaseA - is the larger database and has most of the resource allocations (as least 80% of total memory) - inplace reorg performs well [...] 17435 41 80_Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS14_Surekha Parekh20_surekha21@UK.IBM.COM31_Mon, 25 Jan 2010 17:43:35 +0000471_UTF-8 Don't Miss our Free Web Event Tomorrow - 26th January 2010 at 11 EST 16:00 GMT

Here is the Registration URL

http://www-01.ibm.com/software/os/systemz/telecon/26jan/index.html?S_TACT=109A000&S_SurekhaIDUG

I saw a email to say this is cancelled - however this is definitely not cancelled - this event will be available on replay so if you can not attend the live recording please register for the event so you can listen to it "On Demand" . [...] 17477 352 77_Re: z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ?12_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 25 Jan 2010 20:28:22 +0200364_UTF-8 I have both V7 and v9 on V9 early code w/o any problem.



Isaac Yassin

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mick P Graley Sent: Monday, January 25, 2010 7:32 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] z/os db2 v8 to v9 conversion roadblock - what am I being so dense about ? [...] 17830 48 29_db2tech@yahoo.com Only a test0_22_DB2information@AOL.COM29_Mon, 25 Jan 2010 13:29:42 EST625_US-ASCII to db2tech@yahoo.com

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings, Webcasts, Conferences- what is going on next? RUG leaders- get your events on the calendar today! _____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L 17879 36 84_Re: Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Mon, 25 Jan 2010 18:31:51 +0000339_- How many times do we have to be told? This is upwards of 8 since 8AM (Eastern - North America) today!

------Original Message------ From: Surekha Parekh Sender: IDUG DB2-L To: DB2 List ReplyTo: DB2 List Sent: Jan 25, 2010 12:43 Subject: [DB2-L] Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS [...] 17916 93 24_New to Stored Procedures13_Robert Glover21_bob.glover@LPSVCS.COM31_Mon, 25 Jan 2010 18:52:55 +0000670_utf-8 Hello, I am writing my very 1st SP and need a little direction. I call the SP and present it w/ (2) input fields and expect (1) output value returned. No Selects are to be done. To make it really simple I coded one single IF. It follows:

CREATE PROCEDURE BGPROC (IN PARAMETER_NAME CHARACTER(24) ,IN SETTING CHARACTER(39) ,OUT NEW_SETTING CHARACTER(39) ) RESULT SETS 1 LANGUAGE SQL MODIFIES SQL DATA EXTERNAL NAME 'BGPROC' WLM ENVIRONMENT DPG1WLM1 ASUTIME NO LIMIT ------------------------------------------ MAIN: BEGIN ------------------------------------------ IF (SUBSTR(PARAMETER_NAME,1,7) = 'SMFACCT') THEN SET NEW_SETTING = 'NO'; END IF; END MAIN [...] 18010 120 130_Re: Invitation: Re: [DB2-L] Free Upcoming Webcast - Hints and tips to get the most out of IBM DB2 9 for z/OS (Jan 26 11:00 AM EST)16_Mark Labby - AES21_mlabby@AESSUCCESS.ORG31_Mon, 25 Jan 2010 13:57:57 -0500 18131 82 56_Re: DB2 luw v8.2 - Question on INPLACE REORG performance12_Phil Gunning19_pkgunning@GMAIL.COM31_Mon, 25 Jan 2010 14:04:14 -0500560_UTF-8 Jack, number of indexes on a table, yes even if only doing a table reorg and setting of util_impact_lim will affect running of online reorg. By default it is set to 10 which means throttle online utilities to use only 10 pct of available cpu. You can set this to a higher number or set to 100 to disable online utility throttling. Also, locking activity on the table being reorg'd. If the table is highly active reorg will spend time waiting for locks, this is with allow write access also. You can eliminate truncation at the end by specifying the [...] 18214 98 28_Re: New to Stored Procedures14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 25 Jan 2010 14:48:44 -0500550_us-ascii Robert,

You need to change your SPUFI options/settings so that SPUFI doesn't recognize the semicolon as an end-of-statement, then put your new end of statement marker after the "END MAIN" expression.

Contact me offline if you need more detail and I'll send screen captures in .DOC format.

--Phil S.

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Robert Glover Sent: Monday, January 25, 2010 1:53 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] New to Stored Procedures [...] 18313 24 14_NUMLKTS Survey10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Mon, 25 Jan 2010 19:51:34 +0000597_utf-8 What value do you have in your shop for default locks per tablespace before escalation, NUMLKTS?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings, Webcasts, Conferences- what is going on next? RUG leaders- get your events on the calendar today! _____________________________________________________________________ [...] 18338 115 28_Re: New to Stored Procedures15_Sudhir Muthuraj26_sudhir.raj@REALTIMEDBA.COM31_Mon, 25 Jan 2010 11:59:55 -0800631_us-ascii Change the default SQL TERMINATOR (on the DEFAULTS panel for SPUFI) to a character other than semicolon (like # ) Sudhir Muthuraj RealTime-DBA www.realtimedba.com







________________________________ From: Robert Glover To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Mon, January 25, 2010 1:52:55 PM Subject: New to Stored Procedures

Hello, I am writing my very 1st SP and need a little direction. I call the SP and present it w/ (2) input fields and expect (1) output value returned. No Selects are to be done. To make it really simple I coded one single IF. It follows: [...] 18454 146 28_Re: New to Stored Procedures15_Schade, Jeffrey15_JSchade@ISO.COM31_Mon, 25 Jan 2010 15:06:57 -0500588_iso-8859-1 The commands to reset the end-of statement are:



--#SET TERMINATOR # SP code goes here # --#SET TERMINATOR ;

Jeff _________________________________________ Jeffrey Schade Systems Consultant, Technology Engineering

ISO 545 Washington Boulevard Jersey City, NJ 07310 Voice: (201) 469-3738 FAX: (201) 748-1500 jschade@iso.com

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: Monday, January 25, 2010 2:49 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] New to Stored Procedures [...] 18601 172 28_Re: New to Stored Procedures14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 25 Jan 2010 15:23:14 -0500463_iso-8859-1 Be careful, all. I used Jeff's code but put a space between the two dashes and the hash ("-- #") -- almost decided it didn't work, but "--#" does the trick.

Thanks for the tip, Jeff! Where'd you find it?

--Phil

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Schade, Jeffrey Sent: Monday, January 25, 2010 3:07 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] New to Stored Procedures [...] 18774 75 18_Re: NUMLKTS Survey15_Sudhir Muthuraj26_sudhir.raj@REALTIMEDBA.COM31_Mon, 25 Jan 2010 12:24:14 -0800662_us-ascii In my experience this value is usually set at the default 1000. Sudhir Muthuraj RealTime-DBA www.realtimedba.com







________________________________ From: Jorg Lueke To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Mon, January 25, 2010 2:51:34 PM Subject: NUMLKTS Survey

What value do you have in your shop for default locks per tablespace before escalation, NUMLKTS?

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________ [...] 18850 193 18_Re: NUMLKTS Survey12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM31_Mon, 25 Jan 2010 15:27:33 -0500650_US-ASCII We run peoplesoft and have it set to 50000 Jeff





Sudhir Muthuraj Sent by: IDUG DB2-L 01/25/2010 03:24 PM Please respond to IDUG DB2-L



To DB2-L@WWW.IDUGDB2-L.ORG cc

Subject Re: [DB2-L] NUMLKTS Survey











In my experience this value is usually set at the default 1000.

Sudhir Muthuraj RealTime-DBA www.realtimedba.com



From: Jorg Lueke To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Mon, January 25, 2010 2:51:34 PM Subject: NUMLKTS Survey [...] 19044 64 47_How to Join DB2l from my yahoo.com emai address0_22_DB2information@AOL.COM29_Mon, 25 Jan 2010 15:56:44 EST313_US-ASCII

Need information on how to join the DB2L list with my yahoo email address. I have join and I receive a email with OK to confirm my email address. I did both ways by reply OK in message and also using the link. But I still do not receive db2L emails and when I send an email it get rejected. [...] 19109 100 11_DB2 and SMS9_Ford Wong14_fordie@SHAW.CA31_Mon, 25 Jan 2010 14:34:45 -0700489_us-ascii Dear Fellow Listers.

Our shops is finally thinking about going completely to DB2 and SMS. All our development databases stogroups have been SMS where SMS is controlled by our systems people (who add volumes when we need them). We are thinking about going SMS for our Productions Systems and having control by our DBA group. In the past we have had problems with getting enough space when we needed it and that is why we stayed away from SMS in our Production systems. [...] 19210 134 18_Re: NUMLKTS Survey13_Campbell, Jim26_Jim.Campbell@COURTS.WA.GOV31_Mon, 25 Jan 2010 15:04:27 -0800650_utf-8 We have ours set to the default 1000. Jim C.



The Metric Law of Least Resistance: “The more human effort required to calculate a metric, the less often (and less accurately) it will be calculated, until it is abandoned or ignored altogether.”

The information transmitted is intended only for the addressee and may contain confidential, proprietary and/or privileged material. Any unauthorized review, distribution or other use of or the taking of any action in reliance upon this information is prohibited. If you receive this in error, please contact the sender and delete or destroy this message and any copies. [...] 19345 58 59_[LUW] Certification roadmaps and Infosphere Warehouse / DWE23_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM31_Mon, 25 Jan 2010 19:19:40 -0600481_ISO-8859-1 Going through the 734 exam, it is obvious that many DBA skills critical to DB2 DWE support are not covered; a few topics not apparently covered are: load considerations for partitioned databases, db2_all/rah, rebalancer etc. 734 felt less than "advanced" in this area.

Going through the various IBM certification roadmaps I don't see a clear DBA-oriented path for DWE DB2 DBA's. Does such exist, one that covers admin skillset rather than designer-oriented? [...] 19404 44 34_Only a test from db2tech@yahoo.com13_Edward Benoit17_db2tech@YAHOO.COM31_Mon, 25 Jan 2010 18:24:40 -0800655_us-ascii







_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations! DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among many more categories of help waiting for you! Whether you are an old hand or a DB2 newbie, we have presentations for every level. _____________________________________________________________________ [...] 19449 51 18_Re: NUMLKTS Survey10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 26 Jan 2010 08:41:39 +0100705_US-ASCII Dafault 1000 in a shop, 2000 in another.

Max Scarpa





_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations! DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among many more categories of help waiting for you! Whether you are an old hand or a DB2 newbie, we have presentations for every level. _____________________________________________________________________ [...] 19501 52 55_Re: *****SPAM***** Re: [DB2-L] New to Stored Procedures14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 26 Jan 2010 19:09:55 +1100612_US-ASCII One place is the Appendix in Application Programming and SQL Guide titled "Running DSNTEP2 and DSNTEP4"

James Campbell

On 25 Jan 2010 at 15:23, Sevetson, Phil wrote:

> Be careful, all. I used Jeff's code but put a space between the two dashes and the hash ("-- #") -- almost decided it didn't work, but "--#" does the trick. > > Thanks for the tip, Jeff! Where'd you find it? > > --Phil > > -----Original Message----- > From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Schade, Jeffrey > Sent: Monday, January 25, 2010 3:07 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [...] 19554 292 37_Re: Recursive Common Table Expression16_Wallace, Stephen25_stephen.wallace@LANDG.COM31_Tue, 26 Jan 2010 09:24:01 -0000308_us-ascii Antonis, I see you've had a couple of replies saying it should work. I have to say I've not been able to get DSNTIAUL to work with a CTE, I had to go back to a nested table expression.

Regards, Steve Wallace Mainframe DBA Legal & General Assurance Society Work: 01737 374308 (7100 4308) [...] 19847 119 37_Re: Recursive Common Table Expression14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 26 Jan 2010 21:32:41 +1100556_US-ASCII What is the actual error message you receive? Or what is it that makes you think it is not working?

James Campbell

On 26 Jan 2010 at 9:24, Wallace, Stephen wrote:

> > Antonis, > I see you've had a couple of replies saying it should work.I have to say I've not been able toget > DSNTIAUL to work with a CTE,I had to go back to a nested table expression. > > Regards, > Steve Wallace > Mainframe DBA > Legal & General Assurance Society > Work: 01737 374308 (7100 4308) > > > > From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] [...] 19967 60 18_Re: NUMLKTS Survey10_Dave Nance16_dav1mo@YAHOO.COM31_Tue, 26 Jan 2010 03:36:38 -0800302_iso-8859-1 In a couple of shops using row level locking, we had it set at 50000 and one with page level set at 50000 as well. David Nance ________________________________ The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. [...] 20028 238 50_Mathematician wanted - number of potential indexes13_Phil Grainger34_phil@GRAINGERDATABASESOLUTIONS.COM31_Tue, 26 Jan 2010 11:59:46 -0000444_US-ASCII Hi all





I'm sure there is someone out there who is better at maths than me and can answer this question





I'm trying to figure out the MAXIMUM number of candidate indexes on a table with "n" columns





Ignoring the ascending/descending choice, for tables with small numbers of columns it's easy





Table with 1 column has 1 candidate index (col1) [...] 20267 175 37_Re: Recursive Common Table Expression14_Galeos Antonis19_AGaleos@EUROBANK.GR31_Tue, 26 Jan 2010 14:22:31 +0200458_us-ascii Thank you all for your answers . Finally I've tested and it works fine and with good performance results

-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of James Campbell Sent: Tuesday, January 26, 2010 12:33 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Recursive Common Table Expression

What is the actual error message you receive? Or what is it that makes you think it is not working? [...] 20443 220 28_Re: New to Stored Procedures15_Schade, Jeffrey15_JSchade@ISO.COM31_Tue, 26 Jan 2010 08:01:10 -0500413_iso-8859-1 We use it at my shop for trigger code and it has been awhile since I checked for it in the manuals but I found it documented in the Application Programming & SQL Guide.

Jeff _________________________________________ Jeffrey Schade Systems Consultant, Technology Engineering

ISO 545 Washington Boulevard Jersey City, NJ 07310 Voice: (201) 469-3738 FAX: (201) 748-1500 jschade@iso.com [...] 20664 309 54_Re: Mathematician wanted - number of potential indexes10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 26 Jan 2010 08:06:52 -0500382_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. [...] 20974 504 54_Re: Mathematician wanted - number of potential indexes13_Phil Grainger34_phil@GRAINGERDATABASESOLUTIONS.COM31_Tue, 26 Jan 2010 13:44:58 -0000505_US-ASCII That's what I first thought, but 3! Is 3 x 2 x 1 = 6, nowhere near the actual 15 candidates for a 3 column table





So it's accelerating faster than factorial would account for





Phil Grainger

Grainger Database Solutions Ltd

_____

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roger Hecq Sent: 26 January 2010 13:07 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Mathematician wanted - number of potential indexes [...] 21479 405 54_Re: Mathematician wanted - number of potential indexes13_Michael Ebert18_mebert@AMADEUS.COM31_Tue, 26 Jan 2010 13:55:01 +0000594_ISO-8859-1 Actually

f(0) = 0 f(n) = n*(f(n-1)+1) = n*f(n-1)+n

so it goes up a bit faster than n!.

Dr. Michael Ebert DB2 & Oracle Database Administrator aMaDEUS Data Processing Erding / Munich, Germany







Roger Hecq To DB2-L@WWW.IDUGDB2-L.ORG cc

bcc

Subject Re: [DB2-L] Mathematician wanted - number of potential indexes









Roger Hecq Please respond to : IDUG DB2-L Sent by: IDUG DB2-L 26-01-10 14:06 [...] 21885 82 54_Re: Mathematician wanted - number of potential indexes0_14_cowletw@NU.COM31_Tue, 26 Jan 2010 08:55:37 -0500232_UTF-8 Looks like the pattern for your example could be:

Columns = 1, Indexes = 1 Columns = 2, Indexes = 2 + 2*1 = 4 Columns = 3, Indexes = 3 + 3*2 + 3*2*1 = 15 Columns = 4, Indexes = 4 + 4*3 + 4*3*2 + 4*3*2*1 = 64 etc.. [...] 21968 259 34_Question on File Transfer Software13_Robert Knight28_bknight@REMOTEDBAEXPERTS.COM31_Tue, 26 Jan 2010 09:15:44 -0500884_us-ascii



Anyone have any experiences using enterprise solutions to manage file transfers, data transfers, encryption, etc.





Can offer advice or experiences?





If you prefer to discuss offline please contact me at:



Bob Knight Sr.Database Administrator 412 208-1637 Direct Number 412 327-2211 Cell bknight@remotedbaexperts.com







[cid:image001.gif@01CA9E68.23E24820]

Confidentiality Statement: This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this [...] 22228 532 54_Re: Mathematician wanted - number of potential indexes10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 26 Jan 2010 09:25:46 -0500382_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. [...] 22761 98 79_FYI - Consolidation of IDUG groups on LinkedIn - IDUG Europe 2009 group closure10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 26 Jan 2010 15:32:12 +0100382_US-ASCII Esteemed listers

Some weeks ago IDUG started groups consolidation in LinkedIn with a main group "IDUG: The World Wide DB2 User Community ". Beneath this, there are now various subgroups and one, namely "IDUG Europe Conference ", will replace the old group IDUG Europe 2009 and all informations about IDUG European events will be posted in this brand new group. [...] 22860 400 54_Re: Mathematician wanted - number of potential indexes13_Michael Ebert18_mebert@AMADEUS.COM31_Tue, 26 Jan 2010 14:30:49 +0000432_ISO-8859-1 Actually (to add to my previous email), the number of possible indexes approaches e*n!-1 (e=2.71828...) for large n, so it has the same growth order as n!. Checking some more, the final answer is floor(e*n!-1)...

Dr. Michael Ebert DB2 & Oracle Database Administrator aMaDEUS Data Processing Erding / Munich, Germany







Roger Hecq To DB2-L@WWW.IDUGDB2-L.ORG cc [...] 23261 463 36_Re: DB2 for z/OS V9 Catalog poster ?17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Tue, 26 Jan 2010 15:33:41 -0000460_iso-8859-1 Raymond,

you just had me laughing out loud at the memory of Omar Sharif in Top Secret ("what phony dog poo?" :-)

Sorry I know it's only Tuesday but the week seems long already...



Thanks.



Aurora



Aurora Emanuela Dell'Anno CA Sr. Engineering Services Architect Tel: +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com http://www.ca.com/ [...] 23725 642 54_Re: Mathematician wanted - number of potential indexes14_Leblanc, Fritz27_fritz.leblanc@SALLIEMAE.COM31_Tue, 26 Jan 2010 10:34:42 -0500351_us-ascii I think what you're actually looking for is the number of permutations which is dependent on both the number of columns in the table and the number of columns in the index.

The basic formula for permutations is expressed as nPk = n!/(n-k)! where n is the number of columns in the table, and k is the number of columns in the key. [...] 24368 892 54_Re: Mathematician wanted - number of potential indexes14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 26 Jan 2010 10:41:45 -0500485_iso-8859-1 The general answer is actually non-recursive, but I can't figure out how to collapse it. It uses the coefficients of a binomial distribution (what's the proper name for that!?!) f(0) = 1*0! (where 0! Is understood to be 0) f(1) = 1*0! + 1*1! f(2) = 1*0! + 2*1! + 1*2! f(3) = 1*0! + 3+1! + 3*2! + 1*3! f(4) = 1*0! + 4+1! + 6*2! + 4*3! + 1*4! f(5) = 1*0! + 5+1! + 10*2! + 10*3! + 5*4! + 1*5! Etc. I'm not sure how to collapse that; but it allows you to know f(n) without [...] 25261 532 54_Re: Mathematician wanted - number of potential indexes17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM31_Tue, 26 Jan 2010 15:42:20 -0000679_iso-8859-1 it's something to do with quantumumumumuuuuuum, I think.





Thanks.



Aurora



Aurora Emanuela Dell'Anno CA 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!







________________________________

From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Michael Ebert Sent: 26 January 2010 14:31 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Mathematician wanted - number of potential indexes [...] 25794 109 25_ADMIN listserv is working16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Thu, 28 Jan 2010 11:37:30 -0500541_utf-8 Just a quick note that though we had an issue, if you receive this message then all is back to normal.

Please accept our apology to this disruption



Le contenu de ce courriel s'adresse au destinataire seulement. Il contient de l'information pouvant être confidentielle. Vous ne devez ni le copier ni l'utiliser ni le divulguer qui que ce soit moins que vous soyez le destinataire ou une personne désignée autorisée. Si vous le receviez par erreur, veuillez nous aviser immédiatement et le détruire. [...] 25904 549 54_Re: Mathematician wanted - number of potential indexes19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Thu, 28 Jan 2010 12:38:34 -0500748_iso-8859-1 Don't forget, there is another factor: asc/desc for each column!

Larry Jardine Production DBA DBA Plan/Product Requests: https://wiki.aetna.com/confluence/display/dbaplan/Requests



________________________________ From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: Tuesday, January 26, 2010 10:42 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Mathematician wanted - number of potential indexes

The general answer is actually non-recursive, but I can't figure out how to collapse it. It uses the coefficients of a binomial distribution (what's the proper name for that!?!) f(0) = 1*0! (where 0! Is understood to be 0) f(1) = 1*0! + 1*1! f(2) = 1*0! + 2*1! + 1*2! f(3) = [...] 26454 13 54_Re: Mathematician wanted - number of potential indexes11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Thu, 28 Jan 2010 18:47:10 +0000194_Windows-1252 >Don't forget, there is another factor: asc/desc for each column!



Yes, but the original poster (Phil) asked us to ignore that one. - Too busy driving to stop for gas! 26468 1068 54_Re: Mathematician wanted - number of potential indexes10_Roger Hecq18_Roger.Hecq@UBS.COM31_Thu, 28 Jan 2010 14:02:44 -0500382_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. [...] 27537 337 54_Re: Mathematician wanted - number of potential indexes9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 28 Jan 2010 13:04:53 -0600297_iso-8859-1 but remember that with v9? You can now read indexes backward so it is not required to have both ascending and descending index. I am not certain that it can match each level though.

If you have col1 asc, col2 desc, col3 asc can you do Order by col1 asc, col2 asc ,col desc? [...] 27875 57 22_DDF Connection Pooling15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM31_Thu, 28 Jan 2010 14:45:31 -0700420_us-ascii Does DB2 for z/OS (9.1) offer any type of DDF Connection Pooling? We are going to have CICS transactions that connect to remote databases. From what I can tell, each time we do a CONNECT to the remote database it establishes a new TCP/IP socket, and the socket is closed when the CICS task is terminated. Since all of our relational data is remote it seems to me this may cause us some performance issues. [...] 27933 367 54_Re: Mathematician wanted - number of potential indexes12_Martin Hubel17_Martin@MHUBEL.COM31_Thu, 28 Jan 2010 17:02:56 -0500 28301 140 29_Re: ADMIN listserv is working23_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM31_Thu, 28 Jan 2010 15:57:19 -0600579_ISO-8859-1 What is the ideal address to notify about DB2-L errors?

On Thu, Jan 28, 2010 at 10:37, Galambos, Robert < Robert.Galambos@compuware.com> wrote:

> Just a quick note that though we had an issue, if you receive this > message then all is back to normal. > > Please accept our apology to this disruption > > > > Le contenu de ce courriel s'adresse au destinataire seulement. Il contient > de l'information pouvant tre confidentielle. Vous ne devez ni le copier ni > l'utiliser ni le divulguer qui que ce soit moins que vous soyez le > destinataire [...] 28442 62 36_[LUW] Unload in recover history file23_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM31_Thu, 28 Jan 2010 15:58:53 -0600401_ISO-8859-1 I notice that there is a type of activity captured in the DB2 v9 LUW recovery history file called 'Unload'. Can anyone tell me what activity in the LUW context would result in an UNLOAD event? Unloads occur in the OS/390 world and are also implemented in IBM Multiplatform Tools (HPU) but I'm not sure what it means in the DB2 9 LUW Enterprise edition. I can't find any documentation. [...] 28505 279 58_Question about a error from db2 9.5 and PeopleSoft 8.9 LUW12_John Lendman27_lendman@PALMBEACH.K12.FL.US31_Thu, 28 Jan 2010 17:13:46 -0500383_US-ASCII



We are receiving the following error after we migrated to db2 9.5 LUW FP 4. Has anyone running PeopleSoft of like software received this error and if so what did you do to get around it?





(-3037) was encountered (SQLSTATE PS-037) Failed SQL stmt:RUN TRUNCATE T ABLE (PS_TL_IPT25





We I look this up I get this [...] 28785 580 54_Re: Mathematician wanted - number of potential indexes12_Peter Suhner24_peter_suhner@HOTMAIL.COM31_Thu, 28 Jan 2010 23:44:54 +0100394_Windows-1252

Mike, actually you can't. An index with col1 asc, col2 desc, col3 asc will work in the inverse mode for all columns only. Which gives you col1 desc, col2 asc, col3 desc in this example.

Even though it's almost Friday again, the digital world is still not completely unlimited...

Peter

_______________________ peter suhner peter_suhner@hotmail.com [...]