1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 2007, week 5
2 77 23_DB2mag: Fall 2007 issue10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 29 Oct 2007 05:13:26 -0400634_iso-8859-1
Hi DB2 user, Here is a non-profit Blog about DB2 for z/OS (IBM mainframes): http://db2usa.blogspot.com Last update on Monday, October 29th 2007Fall 2007 issue of DB2mag is available online: - DB2 Makes Being Green Easy by David Beulke Reusing DB2 resources makes good business--and performance--sense. - DB2 DBA: Ultra Availability by Robert Catterall If you think 'never down, don't lose anything' is an impossible goal for DB2, you should think again. - DB2 for z/OS Buffer Pools and CPU Time by Robert Catterall What affect will tuning DB2 for z/OS buffer pools have on CPU time? - Optimistic Locking, Part [...]
80 259 32_Re: V7.2 BIND PACKAGE w/ V8 DBRM0_24_dpetronella@PERSHING.COM31_Mon, 29 Oct 2007 08:10:45 -0400597_ISO-8859-1 Thanks for the info Jim - sorry for such a vague question but we have been migrating our v7 subsystems to v8 and we got hit with an unexpected peculiar problem. We've found the issue so here is a potential issue for others to look out for:
We have several testing subsystems prior to Production. We recompile programs in all environments up to the environment just before Production. In that environment, and Production, we just move the underlying components and do the necessary BINDs. We unexpectedly got hit with the -104 syntax error below. As it turns out, the source [...]
340 248 32_Re: V7.2 BIND PACKAGE w/ V8 DBRM12_Travis, John25_john.travis@CAPGEMINI.COM31_Mon, 29 Oct 2007 12:36:03 -0000567_iso-8859-1 Check out PTF UK09292 for DB2 V7
Regards, John Travis
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of dpetronella@PERSHING.COM Sent: 29 October 2007 12:11 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] V7.2 BIND PACKAGE w/ V8 DBRM
Thanks for the info Jim - sorry for such a vague question but we have been migrating our v7 subsystems to v8 and we got hit with an unexpected peculiar problem. We've found the issue so here is a potential issue for others to look out for: [...]
589 92 32_Re: V7.2 BIND PACKAGE w/ V8 DBRM13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Mon, 29 Oct 2007 12:42:44 -0000422_iso-8859-1 Hi Dave,
What code page are you? The reason I ask is that I ran into a problem when turning on the V8 precompiler (once we were V8 CM everywhere) at a previous employer. They had C code that used the ¬ symbol X'5F' - but it was worse than that, in that they'd changed their 3270 emulation software to switch the less-than symbol X'4C' to be X'5F' so it would pass the C compiler - very complicated. [...]
682 180 50_CA Performance Handbook for DB2 for z/OS - Updated14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 29 Oct 2007 15:38:22 -0000380_us-ascii Yes - It's true
Many of you will remember the Performance Handbook for DB2 that was formerly published by PLATINUM Technology. Well, it's back and better than ever!. Thanks to a collaborative effort between Susan Lawson & Dan Luksetitch (of YL&A inc.) and CA, we are proud to announce the availability of this new version, updated for DB2 for z/OS v8 and v9. [...]
863 100 48_Problem Calling Language Based Stored Procedures16_Dean J. Burchill17_db46@CHRYSLER.COM31_Mon, 29 Oct 2007 11:47:15 -0400499_US-ASCII Recently our mainframe environment migrated to version 8 (finally). We had a few language based stored procedures written in PL/1. But when we recently tried to call them from a db2 client through command editor, we are getting -927 errors when they hit there first real EXEC SQL statements.
Reading the -927 message as follows: -927 THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED UNDER THE DSN COMMAND [...]
964 104 52_Re: Problem Calling Language Based Stored Procedures9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 29 Oct 2007 11:04:05 -0600454_windows-1250 From the fine manual DB2 Admin guide
The RRS attachment is required for stored procedures that run in a WLM-established address space.
This is a change from V7 and is covered in the installation/migration manual.
Another cut from the application programming manual
You can include DSNRLI when you link-edit your load module. For example, you can use a linkage editor control statement like this in your JCL: [...]
1069 78 39_DB2 z/OS Determining the Cost of an I/O13_FRITZ LEBLANC27_FRITZ.LEBLANC@SALLIEMAE.COM31_Mon, 29 Oct 2007 13:27:10 -0400499_US-ASCII Hi!
Do any of you have any information on how to determine the cost of an I/O? We're trying to put a monetary estimate of the benefits to be received on a reduction if I/O by X%. Unfortunately, we do not currently have any information regarding the cost of an I/O (Or millions of I/O). Is there any standard method to computing that cost given various inputs? What inputs would be required for the calculation? I think our current cost calculations are mips-based or msu-based. [...]
1148 40 12_Archive list13_Horacio Villa17_hvilla@AR.IBM.COM31_Mon, 29 Oct 2007 17:33:20 -0300261_US-ASCII Hi,
trying to look in the list's archive, but I get a Service Unavailable page. Anybody knows when will it be available?
Cheers,
Horacio Villa
---------------------------------------------------------------------------------
1189 237 16_Re: Archive list12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Mon, 29 Oct 2007 15:35:04 -0500435_us-ascii Along a similar DB2-L line, I've been getting two copies of every posting for the last several days. Any ideas?
Rick Weaver DB2 z/OS Product Manager BMC Software
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Horacio Villa Sent: Monday, October 29, 2007 3:33 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Archive list [...]
1427 397 16_Re: Archive list16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Mon, 29 Oct 2007 16:41:43 -0400400_us-ascii That happened to me a while ago, so I signed off and then subscribed again - cured my disease
Steen Rasmussen CA
Principal Technical Specialist DB2 tools
IBM Certified Database Associate -- DB2 9 Fundamentals
IBM Certified Database Administrator - DB2 9 DBA for z/OS
Tel : +1-630-505-6673 (US direct) Tel : +1-815-274-9589 (US mobile) [...]
1825 103 16_Re: Archive list14_Fazio, Richard21_RFAZIO@TRANSUNION.COM31_Mon, 29 Oct 2007 16:08:39 -0500403_UTF-8 DB2L is twice as good as any other list serve.
Faz
----- Original Message ----- From: DB2 Data Base Discussion List To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Mon Oct 29 15:35:04 2007 Subject: Re: [DB2-L] Archive list
Along a similar DB2-L line, I’ve been getting two copies of every posting for the last several days. Any ideas? [...]
1929 229 16_Re: Archive list13_Horacio Villa17_hvilla@AR.IBM.COM31_Mon, 29 Oct 2007 18:15:39 -0300710_ISO-8859-1 No answers to my original post?
Cheers,
Horacio Villa
"Fazio, Richard" Sent by: DB2 Data Base Discussion List 29/10/2007 18:08 Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject Re: [DB2-L] Archive list
DB2L is twice as good as any other list serve.
Faz
----- Original Message ----- From: DB2 Data Base Discussion List To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Mon Oct 29 15:35:04 2007 Subject: Re: [DB2-L] Archive list [...]
2159 125 32_Re: V7.2 BIND PACKAGE w/ V8 DBRM0_25_jacampbell@ACSLINK.NET.AU31_Tue, 30 Oct 2007 21:35:24 +1100337_ISO-8859-1 There is also a pre-compiler CCSID option. Read the description in the Appl Prog and SQL Guide, because, if you are using the DB2 Co-processor, the host language CCSID come into play. It is possible that the pre-compiler has decided to convert your text into CCSID 1047 - which is sometimes the default for program text. [...]
2285 161 32_Re: V7.2 BIND PACKAGE w/ V8 DBRM13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Tue, 30 Oct 2007 10:46:07 -0000328_iso-8859-1 James,
You're right, it was a precompiler option I got changed not a bind parm. CCSID 1047 sounds familiar - I tried to look for the recommended CCSID for C code (which is what we had the problem with) but couldn't find it, and of course the DB2-L Archives were (are?) out so couldn't check their either. [...]
2447 180 32_Re: V7.2 BIND PACKAGE w/ V8 DBRM0_25_jacampbell@ACSLINK.NET.AU31_Tue, 30 Oct 2007 22:06:04 +1100578_ISO-8859-1 Just checked my ccsid tables: the co-processor thinks the program code is in 1047; in 1047 x'5f' is a circumflex; so the co-processor "kindly" converts this to x'b0' - which is a circumflex in ccsid 37, your (I presume) SCCSID.
James Campbell
On 30 Oct 2007 at 10:46, Bell, Raymond wrote:
> James, > > You're right, it was a precompiler option I got changed not a bind parm. CCSID 1047 sounds familiar - I tried to look for the recommended CCSID for C code (which is what we had the problem with) but couldn't find it, and of course [...]
2628 103 16_Re: Archive list11_Mark Vitale23_mark.vitale@PERFMAN.COM31_Tue, 30 Oct 2007 07:42:40 -0500540_us-ascii It looks like the entire site is down, not just the archives.
Mark Vitale Product Manager, PerfMan for DB2, CICS TS, and Tape Libraries Telephone 610.865.0300 (ext. 138)
ISM - The power behind great IT decisions Visit us at www.perfman.com
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Horacio Villa Sent: Monday, October 29, 2007 5:16 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Archive list [...]
2732 182 54_ADMIN: we will be rebooting the server in a short time16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Tue, 30 Oct 2007 10:09:21 -0400315_iso-8859-1 It seems that there is an issue with the web interface and we need to restart the server to resolve this issue
I will be sending out another note just before the reboot and then after it is finished (by the hosting company)
This is only an issue with the web interface [...]
2915 155 33_ADMIN Server reboot in 10-15 min.16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Tue, 30 Oct 2007 10:13:47 -0400796_iso-8859-1 Just to let you know
Robert Galambos CIPP/C
Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 Database Administration Certified Information Privacy Professional/Canada robert.galambos@compuware.com
Tel: +1 905 886 7000 Toll Free: +1 800 263 7189 Fax: +1 905 886 7023 Quebec: +1 877-281-1888
Compuware Canada
Service is our best product Les renseignements contenus dans le présent message électronique sont confidentiels et concernent exclusivement le(s) destinataire(s) désigné(s). Il est strictement interdit de distribuer ou de copier ce message. Si vous avez reçu ce message par erreur, veuillez répondre par courriel à l'expéditeur et effacer ou détruire toutes [...]
3071 264 16_Re: Archive list16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Tue, 30 Oct 2007 10:17:52 -0400514_iso-8859-1 On occasion we have been having some problems with the web interface. more often then not it is caused because of the slow response time we are getting from the network.
While this is not the best solution, when you are getting a message like this, is to try again.
But as a side note, I will tell you that within a very short period of time there will be a major change that will should resolve this issue, without any compromise in terms of capability (it will be exactly the same) [...]
3336 22 30_PQTY -1 AND SQTY -1 V8 ZOS DB214_Neff Stephen R22_Stephen.R.Neff@IRS.GOV31_Tue, 30 Oct 2007 10:24:19 -0400433_US-ASCII Hello, Our shop is now on DB2V8 NFM. I was wondering why I should not change all our table space and index space to have PQTY -1 AND SQTY -1. As I understand this allows DB2 to make the allocation in accordance with the data in the table. As data increases the allocation increases. I was wondering why would you not to do this? I can't see the cons but that's why I am asking the question to the experts on this list. [...]
3359 72 34_Re: PQTY -1 AND SQTY -1 V8 ZOS DB29_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 30 Oct 2007 10:21:30 -0600363_windows-1250 The advantages - 1. one size fits all - don't have to think about it. 2. much less likely to have over-allocated test tables. programmers copy the DDL including the space but only load a minor amout of data. 3. does NOT fail to reach the second dataset. If you have a small secondary allocation, you can run out of extents before you get to 2G, [...]
3432 174 60_ADMIN: Server has been rebooted and Web interface is working16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Tue, 30 Oct 2007 11:38:46 -0400541_iso-8859-1 Thank you for your understanding. I have tested the web interface and it is working.
feel free in contacting the undersigned if you have any more concerns
Robert Galambos CIPP/C
Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 Database Administration Certified Information Privacy Professional/Canada robert.galambos@compuware.com
Tel: +1 905 886 7000 Toll Free: +1 800 263 7189 Fax: +1 905 886 7023 Quebec: +1 877-281-1888 [...]
3607 214 34_Re: PQTY -1 AND SQTY -1 V8 ZOS DB214_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 30 Oct 2007 15:43:14 -0000354_iso-8859-1 "all the really big tables will have some extra extents as they start small and then get bigger"
remember - since z/OS 1.6 when extents are allocated "adjacently", they will be merged into a SINGLE extent
it is no longer true that each extra allocation means more extents
Phil Grainger Product Management Director CA [...]
3822 69 34_Re: PQTY -1 AND SQTY -1 V8 ZOS DB219_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Tue, 30 Oct 2007 11:45:06 -0400514_us-ascii You may also want to consider how this will work with your current SMS ACS routines. If, for example, you use different storage groups for differently sized allocations (small pool/large pool), you may have some issues.
Larry Jardine
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mike Bell Sent: Tuesday, October 30, 2007 12:22 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] PQTY -1 AND SQTY -1 V8 ZOS DB2 [...]
3892 57 30_PQTY -1 AND SQTY -1 V8 ZOS DB214_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 30 Oct 2007 11:55:52 -0400562_utf-8 I didn't know that! That's ... really good engineering, I'm glad they finally did it.
--Phil Sevetson, NYCAPS DBA Support Financial Information Services Agency of The City of New York 450 West 33rd Street, 4th Floor New York, NY 10001 phone: (212) 857-1688 mailto: psevetson@fisa.nyc.gov ________________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Grainger, Phil Sent: Tuesday, October 30, 2007 11:43 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] PQTY -1 AND SQTY -1 V8 ZOS DB2 [...]
3950 260 34_Re: PQTY -1 AND SQTY -1 V8 ZOS DB210_Doyle Mark26_Mark.Doyle@QBEAMERICAS.COM31_Tue, 30 Oct 2007 11:19:28 -0500448_us-ascii Stephen asked: Hello, Our shop is now on DB2V8 NFM. I was wondering why I should not change all our table space and index space to have PQTY -1 AND SQTY -1. As I understand this allows DB2 to make the allocation in accordance with the data in the table. As data increases the allocation increases. I was wondering why would you not to do this? I can't see the cons but that's why I am asking the question to the experts on this list. [...]
4211 58 40_distribution stats option in V8 runstats20_Barth, Stephen (IHG)19_Steve.Barth@IHG.COM31_Tue, 30 Oct 2007 13:20:06 -0400619_us-ascii Does anyone know if this is available in V8 compatability mode, or if only in NFM? Thanks.
Steve Barth InterContinental Hotels Group
--------------------------------------------------------------------------------- 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
4270 20 44_Re: distribution stats option in V8 runstats15_Patrick Bossman18_bossman@US.IBM.COM31_Tue, 30 Oct 2007 12:28:36 -0500639_ISO-8859-1 Hi Steve, It's available in compatibility mode. Also, the Statistics Advisor piece of Visual Explain V8 also works in compatibility mode.
Regards, Pat
--------------------------------------------------------------------------------- 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
4291 29 44_Re: distribution stats option in V8 runstats20_Barth, Stephen (IHG)19_Steve.Barth@IHG.COM31_Tue, 30 Oct 2007 13:34:09 -0400838_us-ascii Thanks, Pat.
-----Original Message----- From: Patrick Bossman [mailto:bossman@US.IBM.COM] Sent: Tuesday, October 30, 2007 1:29 PM To: DB2-L@WWW.IDUGDB2-L.ORG; Barth, Stephen (IHG) Subject: Re: distribution stats option in V8 runstats
Hi Steve, It's available in compatibility mode. Also, the Statistics Advisor piece of Visual Explain V8 also works in compatibility mode.
Regards, Pat
--------------------------------------------------------------------------------- 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 [...]
4321 33 33_WPS metadata repository migration24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Tue, 30 Oct 2007 13:12:29 -0400401_iso-8859-1 WebSphere Portal Server (WPS) uses DB2 as its metadata repository. I have a customer that is migrating WPS v5 using DB2 for z/OS to WPS v6 on DB2 9 for AIX. Has anyone done this type of migration before? I can see all sorts of landmines in upgrading the app., changing databases, and moving from EBCDIC to ASCII all in one step. The landmines I can't see are the ones that concern me. [...]
4355 41 41_IBM Information On Demand 2008 Conference16_Charles Crockett24_cfcrockett_db2@YAHOO.COM31_Tue, 30 Oct 2007 14:02:49 -0700497_iso-8859-1 Did IBM announce the dates/location for the conference next year? If so, what are they?
Charles Crockett Phoenix, Arizona, USA cfcrockett_db2@yahoo.com
IBM Certified Solutions Expert - DB2 UDB V8.1 Database Administration for z/OS
602-997-8643 (Home) 602-803-0379 (Cell) 602-537-7690 (Office) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [...]
4397 202 45_Re: IBM Information On Demand 2008 Conference12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Tue, 30 Oct 2007 17:09:27 -0400482_us-ascii A repeat at Mandalay Bay
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Charles Crockett Sent: Tuesday, October 30, 2007 5:03 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] IBM Information On Demand 2008 Conference
Did IBM announce the dates/location for the conference next year? If so, what are they?
Charles Crockett Phoenix, Arizona, USA cfcrockett_db2@yahoo.com [...]
4600 64 45_Re: IBM Information On Demand 2008 Conference21_wfavero@attglobal.net21_wfavero@ATTGLOBAL.NET31_Tue, 30 Oct 2007 17:10:54 -0400565_iso-8859-1 October 26-31, 2008 Las Vegas Mandalay Bay
Willie
Original Message: ----------------- From: Charles Crockett cfcrockett_db2@YAHOO.COM Date: Tue, 30 Oct 2007 14:02:49 -0700 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] IBM Information On Demand 2008 Conference
Did IBM announce the dates/location for the conference next year? If so, what are they?
Charles Crockett Phoenix, Arizona, USA cfcrockett_db2@yahoo.com
IBM Certified Solutions Expert - DB2 UDB V8.1 Database Administration for z/OS [...]
4665 84 45_Re: IBM Information On Demand 2008 Conference18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 30 Oct 2007 17:16:32 -0400649_us-ascii AGAIN!! They can't find someplace else? Mix it up a little... :-)
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of wfavero@attglobal.net Sent: Tuesday, October 30, 2007 5:11 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] IBM Information On Demand 2008 Conference
October 26-31, 2008 Las Vegas Mandalay Bay
Willie
Original Message: ----------------- From: Charles Crockett cfcrockett_db2@YAHOO.COM Date: Tue, 30 Oct 2007 14:02:49 -0700 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] IBM Information On Demand 2008 Conference [...]
4750 99 45_Re: IBM Information On Demand 2008 Conference13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 30 Oct 2007 17:24:18 -0500657_ISO-8859-1 I think they figure I need the exercise... (smile)...
Willie
Whittaker, Stephen wrote: > AGAIN!! They can't find someplace else? Mix it up a little... :-) > > > > -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On > Behalf Of wfavero@attglobal.net > Sent: Tuesday, October 30, 2007 5:11 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: Re: [DB2-L] IBM Information On Demand 2008 Conference > > > October 26-31, 2008 > Las Vegas Mandalay Bay > > Willie > > Original Message: > ----------------- > From: Charles Crockett cfcrockett_db2@YAHOO.COM > Date: Tue, 30 Oct 2007 14:02:49 -0700 > [...]
4850 47 45_Re: IBM Information On Demand 2008 Conference16_Charles Crockett24_cfcrockett_db2@YAHOO.COM31_Tue, 30 Oct 2007 15:52:53 -0700482_iso-8859-1 IBM sometimes does a multi-year contract, helps them to get better rates. Last time, about 2002 to 2004 it was at the Vegas Hilton for 3 years.
"Whittaker, Stephen" wrote: AGAIN!! They can't find someplace else? Mix it up a little... :-)
Charles Crockett Phoenix, Arizona, USA cfcrockett_db2@yahoo.com
IBM Certified Solutions Expert - DB2 UDB V8.1 Database Administration for z/OS [...]
4898 184 45_Re: IBM Information On Demand 2008 Conference14_John Caccavale18_jcac@THEMISINC.COM31_Tue, 30 Oct 2007 19:02:09 -0400373_us-ascii The Conference will be in Las Vegas at the Mandalay Bay again in 2008 and 2009. They did enter into a 3 year agreement from what I was told while I was there this year.
Regards,
John Caccavale Vice President Themis Education 800.756.3000, main office 609.279.1558, home office 908.723.4938, cell phone 908.233.7401, fax jcaccavale@themisinc.com [...]
5083 55 20_SQL gend column name14_Alexander John28_JAlexander@WOOLWORTHS.COM.AU31_Wed, 31 Oct 2007 10:14:47 +1100743_us-ascii Hi All,
I am trying to write a query to automatically set the column I want to use based on which week day it is, but I do not think this can be in DB2/zOS V7? SELECT CASE WHEN (DAYOFWEEK(CURRENT DATE)=1) THEN 'SUN_ADV_ORD_FL' WHEN (DAYOFWEEK(CURRENT DATE)=2) THEN 'MON_ADV_ORD_FL' WHEN (DAYOFWEEK(CURRENT DATE)=3) THEN 'TUE_ADV_ORD_FL' WHEN (DAYOFWEEK(CURRENT DATE)=4) THEN 'WED_ADV_ORD_FL' WHEN (DAYOFWEEK(CURRENT DATE)=5) THEN 'THR_ADV_ORD_FL' WHEN (DAYOFWEEK(CURRENT DATE)=6) THEN 'FRI_ADV_ORD_FL' WHEN (DAYOFWEEK(CURRENT DATE)=7) THEN 'SAT_ADV_ORD_FL' END FROM SYSIBM.SYSDUMMY1 The above works fine, however I am not succeeding in using the generated column name (xxx_ADV_ORD_FL) in a where clause , I tried wrapping [...]
5139 110 34_Re: PQTY -1 AND SQTY -1 V8 ZOS DB213_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 30 Oct 2007 16:43:27 -0700525_us-ascii We had a problem with very large tablespaces and SMS. Our SMS pools had been set up according to data set size; I was trying to do a load on a very large tablespace which had -1 for PQTY and SQTY, and DB2 initially requested a small enough extent so that SMS shunted it off to the small pool. It wasn't long before that pool was exhausted, and my load job abended. I had to alter the tablespace to use realistic sizes to get it into the correct storage pool. We have since collapsed all our test DB2 pools into [...]
5250 23 50_Peoplesoft V8 with DB2 Z/OS - does it need Db2 V8?7_Steve M21_malutjuta@HOTMAIL.COM31_Tue, 30 Oct 2007 21:32:31 -0500725_windows-1252 Dear Db2 Listers,
Can anyone confirm Peoplesoft V7 (HRMS if relevant) can run with a backend database on DB2 z/OS V7.1 We heard rumours about problems when going to DB2 V8 unless migrating to Peoplesoft V8 first.
regards, Steve
--------------------------------------------------------------------------------- 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
5274 457 34_Re: PQTY -1 AND SQTY -1 V8 ZOS DB212_Cianci, Nick19_nick.cianci@EDS.COM31_Wed, 31 Oct 2007 13:37:20 +1100280_iso-8859-1 ... and z\OS 1.7 will give you up to a "potential" 7,257 extents (123 extents per volume over 59 volumes); and this is still using DB2 v7 if you are on it. The only catch here is that the SMS DataClass must be defined with "Extent Constraint Removal" set to "YES" [...]
5732 88 24_Re: SQL gend column name14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 31 Oct 2007 07:21:42 -0000359_iso-8859-1 Don't forget, what you are setting in the CASE statement here is a LITERAL and not a column name (columns are "named" with an AS clause) - which DB2 (8 and 9) throws out with a syntax error
However, this would be VERY easy with dynamic SQL - use application logic to build the statement how you want it depending on the day of the week [...]
5821 185 43_Re: DB2 z/OS Determining the Cost of an I/O0_28_Massimo.Scarpa@PHOENIXSPA.IT31_Wed, 31 Oct 2007 09:13:47 +0100373_US-ASCII It's a long debated and somewhat obscure topic.
In a recent paper, in a environment with 2 processors (shared with other LPARS) of an IBM 2084-307 and EMC disks of the last DMX generation accessed through FICON channels, it came out that
0,019 MIPS are required to start 1 DASD I/O per second, so for 50 I/O per second the cost is about 1 MIPS. [...]
6007 121 24_Re: SQL gend column name26_Sorensen Henrik (KSFI 442)33_henrik.sorensen@CREDIT-SUISSE.COM31_Wed, 31 Oct 2007 10:46:22 +0100565_us-ascii What are trying to do with the generated column names ? Have you looked into dynamic sql ?
Anyway something like this might work, assuming you have different tablenames for the different days
TABLE_SUN TABLE_MON TABLE_TUE etc
WITH table_week AS (wkday,ADV_ORD_FL) (select DAYOFWEEK(CURRENT DATE) wkday value(SUN_ADV_ORD_FL,MON_ADV_ORD_FL,TUE_ADV_ORD_FL) from sysibm.sysdummy1 d left outer join TABEL_SUN ON d.wkday=1 left outer join TABEL_MON ON d.wkday=2 left outer join TABEL_TUE ON d.wkday=3 ) select * from table_week [...]
6129 39 45_Re: IBM Information On Demand 2008 Conference13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Wed, 31 Oct 2007 07:35:29 -0400611_us-ascii I agree. In my evaluation for the conference, I said get it outta Vegas... Too smoky, too noisy.
I suggested they move it to New Orleans to help bolster rebuilding efforts there.
They always like all my ideas, so I'm sure we'll see an announcement to that effect shortly.
Dave
The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify [...]
6169 116 24_Re: SQL gend column name14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 31 Oct 2007 09:38:31 -0400630_us-ascii Could you use this in an alternate construction? What are you trying to use the generated column _for_?
SELECT CASE WHEN DAYOFWEEK(CURRENT DATE)=1 THEN 1 ELSE 0 END AS SUN_ADV_ORD_FL , CASE WHEN DAYOFWEEK(CURRENT DATE)=2 THEN 1 ELSE 0 END AS MON_ADV_ORD_FL , CASE WHEN DAYOFWEEK(CURRENT DATE)=3 THEN 1 ELSE 0 END AS TUE_ADV_ORD_FL , CASE WHEN DAYOFWEEK(CURRENT DATE)=4 THEN 1 ELSE 0 END AS WED_ADV_ORD_FL , CASE WHEN DAYOFWEEK(CURRENT DATE)=5 THEN 1 ELSE 0 END AS THU_ADV_ORD_FL , CASE WHEN DAYOFWEEK(CURRENT DATE)=6 THEN 1 ELSE 0 END AS FRI_ADV_ORD_FL , CASE WHEN DAYOFWEEK(CURRENT DATE)=7 THEN 1 ELSE 0 END [...]
6286 334 43_Re: DB2 z/OS Determining the Cost of an I/O35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 31 Oct 2007 09:49:41 -0400345_iso-8859-1 Hi Max,
Based on instruction path length for an IO, The approximate cost of a physical I/O is .000033 Ms. of CPU on a 2084 class processor, with a 428 MIP Uni-processor engine speed.
The number of processors is not a factor to the overhead cost, since any single IO can only be executed by one processor at a time. [...]
6621 336 34_Re: PQTY -1 AND SQTY -1 V8 ZOS DB213_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 31 Oct 2007 08:44:45 -0700431_us-ascii Nick, I agree that DB2 tends to favor small extents, and it bugs me too. I'm going to watch for fragmentation, now that we're one big happy storage pool.
Cathy
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Cianci, Nick Sent: Tuesday, October 30, 2007 7:37 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: PQTY -1 AND SQTY -1 V8 ZOS DB2 [...]
6958 82 45_Re: IBM Information On Demand 2008 Conference10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Wed, 31 Oct 2007 11:50:10 -0500735_windows-1252 Vegas is soo pricey these days. Plus I have to take the kids out Halloween.
On Tue, 30 Oct 2007 17:10:54 -0400, wfavero@attglobal.net wrote:
>October 26-31, 2008 >Las Vegas Mandalay Bay > >Willie > >Original Message: >----------------- >From: Charles Crockett cfcrockett_db2@YAHOO.COM >Date: Tue, 30 Oct 2007 14:02:49 -0700 >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: [DB2-L] IBM Information On Demand 2008 Conference > > >Did IBM announce the dates/location for the conference next year? If so, >what are they? > > > >Charles Crockett >Phoenix, Arizona, USA >cfcrockett_db2@yahoo.com > >IBM Certified Solutions Expert - DB2 UDB V8.1 Database Administration for >z/OS > >602-997-8643 [...]
7041 91 31_Re: DB2 active log size effects14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Wed, 31 Oct 2007 12:20:25 -0500387_windows-1252 Pearl, It is always best to be on supported versions of the software in question. DB2 V6 is not supported. The risk of a DB2 problem causing an outage is higher that a disaster that might require you to move to an alternate site. Your shop makes a big investment in the ability to move to an alternate site ... why not make an investment in obtaining software support? [...]
7133 89 24_Re: SQL gend column name13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US31_Wed, 31 Oct 2007 10:29:52 -0700681_US-ASCII John, Try
SELECT CASE WHEN (DAYOFWEEK(CURRENT DATE)=1) THEN SUN_ADV_ORD_FL WHEN (DAYOFWEEK(CURRENT DATE)=2) THEN MON_ADV_ORD_FL WHEN (DAYOFWEEK(CURRENT DATE)=3) THEN TUE_ADV_ORD_FL WHEN (DAYOFWEEK(CURRENT DATE)=4) THEN WED_ADV_ORD_FL WHEN (DAYOFWEEK(CURRENT DATE)=5) THEN THR_ADV_ORD_FL WHEN (DAYOFWEEK(CURRENT DATE)=6) THEN FRI_ADV_ORD_FL WHEN (DAYOFWEEK(CURRENT DATE)=7) THEN SAT_ADV_ORD_FL END FROM SOME.TABLE
Victor
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Alexander John Sent: Tuesday, October 30, 2007 4:15 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] SQL gend column name [...]
7223 100 32_DB2 DPF DB2_ALL error on Windows14_Matthew A Rhea23_matthew.rhea@US.IBM.COM31_Wed, 31 Oct 2007 13:20:48 -0400505_US-ASCII
All,
I'm running DB2 9 fixpack 2 on Windows XP. I created a database with 4 logical partitions (all on the same machine). I want to update the DB CFG using the DB2_ALL command, so that each of the 4 partitions will have the same configurations. Here are the results:
C:\Documents and Settings\Administrator>db2_all ";db2 update db cfg for partdb using logretain recovery" C:\Documents and Settings\Administrator> rah: C50023 rah: C50023 rah: C50023 rah: C50023 [...]
7324 214 24_Re: SQL gend column name13_Victor Loghin18_vgl_ca@HOTMAIL.COM31_Wed, 31 Oct 2007 15:20:04 -0400501_iso-8859-1 John,
How about using the OR as in WHERE ... AND ( ( DAYOFWEEK(CURRENT DATE) = 1 AND SUN_ADV_ORD_FL = 'Y' ) OR ( DAYOFWEEK(CURRENT DATE) = 2 AND MON_ADV_ORD_FL = 'Y' ) OR ( DAYOFWEEK(CURRENT DATE) = 3 AND TUE_ADV_ORD_FL = 'Y' ) OR ( DAYOFWEEK(CURRENT DATE) = 4 AND WED_ADV_ORD_FL = 'Y' ) OR ( DAYOFWEEK(CURRENT DATE) = 5 AND THU_ADV_ORD_FL = 'Y' ) OR ( DAYOFWEEK(CURRENT DATE) = 6 AND FRI_ADV_ORD_FL = 'Y' ) OR ( DAYOFWEEK(CURRENT DATE) = 7 AND SAT_ADV_ORD_FL = 'Y' ) ) AND ... [...]
7539 115 24_Re: SQL gend column name10_Doyle Mark26_Mark.Doyle@QBEAMERICAS.COM31_Wed, 31 Oct 2007 14:44:49 -0500428_us-ascii John,
It would make it _much_ easier for us if you posted the entire SQL with the syntax errors, if only so that we have a clear understanding what you are trying to do.
Mark
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Alexander John Sent: Tuesday, October 30, 2007 6:15 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: SQL gend column name [...]
7655 71 54_Re: Peoplesoft V8 with DB2 Z/OS - does it need Db2 V8?16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Wed, 31 Oct 2007 16:23:08 -0400440_iso-8859-1 You may want to post this message on the peoplesoft listserv as well
Robert Galambos CIPP/C
Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 Database Administration Certified Information Privacy Professional/Canada robert.galambos@compuware.com
Tel: +1 905 886 7000 Toll Free: +1 800 263 7189 Fax: +1 905 886 7023 Quebec: +1 877-281-1888 [...]
7727 127 54_Re: Peoplesoft V8 with DB2 Z/OS - does it need Db2 V8?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 31 Oct 2007 16:28:56 -0400333_utf-8 Steve,
Your title seems to be asking one question, the body of your message another.
Definitely, you can migrate to Peoplesoft HR v8-point-at-least-fourteen while on DB2V7 -- we did that a couple of years ago at a former employer (why are you still on PS/HR/v7? I don't think that's under support any more). [...]
7855 37 21_SQL procedure z/OS v716_Natalie Faulkner25_natalie.w.faulkner@WV.GOV31_Wed, 31 Oct 2007 16:03:43 -0500568_windows-1252 I am attempting to create and test my first SQL procedure.
I have created the procedure and performed the compile and bind. Everything appears to be correct. Because I am in play mode, I have kept the procedure very simple... no input or output parms - 1 result set.
When I call the procedure from my COBOL test program the WLM address space starts without errors. The test program executes without errors. I display the SQLCA - it shows a 0 sqlcode... I expect a +466... the ASSOCIATE, and LOCATE receive a -482 and -423 respectively. [...]
7893 89 24_Re: SQL gend column name14_Peter Vanroose26_peter_vanroose@YAHOO.CO.UK31_Wed, 31 Oct 2007 22:10:14 +0100465_iso-8859-1 If you want to set a variable column name -- that's not possible. The following will indeed put 'xxx_ADV_ORD_FL' as the time-varying *content* of the single row / single column table: SELECT CASE DAYOFWEEK(CURRENT DATE) WHEN 1 THEN 'SUN_ADV_ORD_FL' WHEN 2 THEN 'MON_ADV_ORD_FL' WHEN 3 THEN 'TUE_ADV_ORD_FL' WHEN 4 THEN 'WED_ADV_ORD_FL' WHEN 5 THEN 'THR_ADV_ORD_FL' WHEN 6 THEN 'FRI_ADV_ORD_FL' WHEN 7 THEN 'SAT_ADV_ORD_FL' END FROM SYSIBM.SYSDUMMY1 [...]
7983 63 25_Re: SQL procedure z/OS v715_Attuluri, Vidya27_Vidya.Attuluri@MARRIOTT.COM31_Wed, 31 Oct 2007 17:12:47 -0400481_us-ascii Natalie,
Did you specify DYNAMIC RESULT SETS 1 as part of the CREATE PROCEDURE statement?
Just verify the catalog to see that..
Regards Vidya
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Natalie Faulkner Sent: Wednesday, October 31, 2007 5:04 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] SQL procedure z/OS v7
I am attempting to create and test my first SQL procedure. [...]
8047 180 25_Re: SQL procedure z/OS v70_19_askwe@OPTONLINE.NET31_Wed, 31 Oct 2007 21:14:24 +0000510_windows-1252 Natalie,
The value 0 returned in your cobol calling program seemed to indicate that you have successfully called your sql stored procedure but because it did not return +466, it looks like that the result set was not returned.
1. Did you specify WITH RETURN in the Declare Cursor statement in the SQL procedure? 2. Since the sql procedure cannot issue DISPLAY statement, you can define an output parameter where the stored procedure can return a 'value' to the calling program. [...]
8228 94 30_DB2 z/OS V8 SMF Trace overhead10_Irwin, Jim19_Jim.Irwin@OA.MO.GOV31_Wed, 31 Oct 2007 16:18:28 -0500555_US-ASCII We run several of the accounting and statistical traces on our DB2 regions and do regular reporting on them. I know we need to keep some of the accounting traces for billing purposes but for a variety of reasons we have began to question if the benefits gained from the detailed reporting outweighs the cpu overhead involved in doing the tracing. The question I have is how can we actually measure the overhead caused by the extra traces. Will it show up in the Type 30 records for the started tasks i.e.; MSTR, DBM1, IRLM and DIST or is it [...]
8323 21 25_Re: SQL procedure z/OS v716_Natalie Faulkner25_natalie.w.faulkner@WV.GOV31_Wed, 31 Oct 2007 16:29:16 -0500342_windows-1252 dynamic result sets has been set to 1 with hold has been specified in the declare cursor
my concern is that the procedure collection/package are not showing up in my monitor datasets... I wonder if the CALL statement is successfully executing...
are there any LE RUNOPTS that might help the investigation ???? [...]
8345 224 34_Re: DB2 z/OS V8 SMF Trace overhead35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 31 Oct 2007 17:32:04 -0400403_iso-8859-1 Jim,
It[s somewhat dependant upon your version of DB2. Then, different traces incur overhead in different places as you know.
The actg traces impact the applications, and the heaviest impact is the package level classes.
Unless you have a total sandbox, with a driver system, you can't really measure your overheads because you can't guarantee workload consistency. [...]
8570 252 25_Re: SQL procedure z/OS v715_Joehlin, Gary L34_gary.l.joehlin@VERIZONBUSINESS.COM31_Wed, 31 Oct 2007 21:40:32 +0000363_US-ASCII Natalie,
Try this:
1) Confirm the SQL in the procedure is proper and executable by invoking it via the development center as an independent call and not use the editor
2) Confirm that, if you have a cursor, it's defined "WITH RETURN" and do NOT CLOSE the cursor in the SP, otherwise, you'll lose the result set. [...]
8823 178 43_Re: DB2 z/OS Determining the Cost of an I/O10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Wed, 31 Oct 2007 21:47:54 -0500396_ISO-8859-1 Joel,
What specifically is meant by a physical i/o? Is that just when you have to go all the way to the disk? Do caches count? What about i/o to memory (DB2 bufferpool)?
Also, where is the processor cost accounted for in SMF, back to the application?
On Wed, 31 Oct 2007 09:49:41 -0400, Joel Goldstein - Responsive Systems wrote: [...]
9002 191 43_Re: DB2 z/OS Determining the Cost of an I/O35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 31 Oct 2007 23:04:12 -0400360_iso-8859-1 Hi Jorg,
A physical IO is going to DASD. Finding the data in the controller cache is till an IO, the instruction path length does not change.
If you are finding your data in a bufferpool, this is not an IO.
The processor cost for a Synch IO is charged to the application address space, and reflected in the smf 101 record. [...]
9194 31 31_[Job] DB2 & CICS Specialists...19_Cuneyt Goksu (.NET)19_cuneytgoksu@USA.NET30_Thu, 1 Nov 2007 06:35:12 +0200413_iso-8859-9 A major bank in Riyadh, Saudi Arabia is looking for experienced DB2 and CICS System Programmers.
If you're interested, please contact me offline for details.
Iyi calismalar, Best Regards, Saludos, Lijepi pozdrav
------------------------- Cuneyt Goksu DB2 Specialist UDB for z/OS V8 Certified +90 555 2092562 +90 532 2540342 ------------------------- Think Enterprise, Think Z [...]