1 IDUGDB2-L.ORG /home/listserv/home/db2-l August 2010, week 1
2 130 74_Re: Project Planning Insights for Enterprise Datawarehouse (EDW) Migration9_Ramu Iyer18_ramu_asm@YAHOO.COM30_Sun, 1 Aug 2010 09:52:08 -0700584_us-ascii I recognize and appreciate the maturity level of technology management processes
in IBM pioneered technology solutions.
From a technology agnostic perspective (i.e., disregard the fact that my initial
post contained the keywords Teradata, Informatica, etc), I'd like to drill down
on the activity sequencing for the different layers apropos the EDW
infrastructure upgrade and data center migration. Just looking for some rules
of thumb to keep in mind, using the words of wisdom of DB2 professionals that
who have experienced a similar project. [...]43_595005.14859.qm@web65615.mail.ac4.yahoo.com
133 1045 22_No estoy en la oficina32_Lainez Gutierrez, Maria Victoria21_mvlainez@IBERDROLA.ES30_Mon, 2 Aug 2010 07:59:55 +0200725_us-ascii Hola,
Hasta el 31 de Agosto no voy a estar en la oficina. Para cualquier tema
urgente relacionado con DB2 escribe un correo:
- A Idoia Monasterio (imonasterio@iberdrola.es) hasta el 13 de
Agosto
- A Juan Calleja (jcallejav@iberdrola.es) desde el 16 al 30 de
Agosto
===============================================================
Este mensaje se dirige exclusivamente a su destinatario. Los datos incluidos en el
presente correo son confidenciales y sometidos a secreto profesional, especialmente en lo que
respecta a los datos personales, se prohibe divulgarlos, en virtud de las
leyes vigentes. Si usted no lo es y lo ha recibido por error o tiene conocimiento
[...]73_534FFF2C8B16444DBF458EFA2E0C9F74017D8FA2@CLFEXBUZ23A.corp.iberdrola.local
1179 218 61_[AD] DB2 Tech Talk - DB2 10 Is Coming - A First Look (Part 1)13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Mon, 2 Aug 2010 05:31:29 -0400353_us-ascii Join Phil Grainger for DB2 Tech Talks first look at DB2 10 for z/OS on Thursday August 5th at noon Eastern
Although DB2 10 is still in beta, and thus subject to IBM non-disclosure agreements, there is enough information now available in the public domain to give us a really good idea of what IBM are planning for this new release. [...]60_4440F5DA00E3F3459BBCB97431B91B6612B8FDBFDE@MAILR004.mail.lan
1398 268 65_Re: [AD] DB2 Tech Talk - DB2 10 Is Coming - A First Look (Part 1)12_McLaren Phil32_Phil.McLaren@AXAWINTERTHUR.CO.UK30_Mon, 2 Aug 2010 12:16:16 +0100391_us-ascii Hi Phil,
For those that can't make this date/time (including myself), will this webinar be available for replay at a later date?
Thanks
Phil
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil Grainger
Sent: 02 August 2010 10:31
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] [AD] DB2 Tech Talk - DB2 10 Is Coming - A First Look (Part 1) [...]72_1454A0984F246445950CB759E249F50F468F5F037B@csis564.wlp.uk.winterthur.com
1667 316 65_Re: [AD] DB2 Tech Talk - DB2 10 Is Coming - A First Look (Part 1)12_Peter Suhner24_peter_suhner@HOTMAIL.COM30_Mon, 2 Aug 2010 13:42:40 +0200483_Windows-1252 ...my question...
Date: Mon, 2 Aug 2010 12:16:16 +0100
From: Phil.McLaren@AXAWINTERTHUR.CO.UK
Subject: Re: [DB2-L] [AD] DB2 Tech Talk - DB2 10 Is Coming - A First Look (Part 1)
To: DB2-L@IDUGDB2-L.ORG
Hi Phil,
For those that can’t make this date/time (including myself), will this webinar be available for replay at a later date?
Thanks
Phil
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG]
On Behalf Of Phil Grainger [...]43_SNT107-W64CCB6B66F6B2EB477F7B3F1AD0@phx.gbl
1984 531 65_Re: [AD] DB2 Tech Talk - DB2 10 Is Coming - A First Look (Part 1)13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Mon, 2 Aug 2010 07:54:31 -0400542_us-ascii All being well, the webinar WILL be recorded and WILL be available for replay after the event
Also, we are still trying to work out the best way to bring these to a more EMEA-friendly time slot
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk
Attend IDUG 2010 - EMEA, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org [...]60_4440F5DA00E3F3459BBCB97431B91B6612B8FDC041@MAILR004.mail.lan
2516 44 49_Re: z/OS DB2v9 CM - REORG with LEAFNEAR & LEARFAR10_Joe Geller21_joerg6666@HOTMAIL.COM30_Mon, 2 Aug 2010 08:59:16 -0400401_UTF-8 LEAFNEAR is a count of index entries that are not in the same page or the next page of the
previous index entry. If you have FREEPAGE greater than 0, then a Reorg will leave free
pages and the first entry on the following page is a LEAFNEAR page (as it isn't the next page
after the previous). The same is true for Spacemap pages. Therefore, after a reorg,
LEAFNEAR will not 0. [...]53_8487139047607038.WA.joerg6666hotmail.com@www.idug.org
2561 744 93_Re: [AD] DB2 Tech Talk - DB2 10 Is Coming - A First Look (Part 1) - EMEA-friendly time slots!13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Mon, 2 Aug 2010 10:22:49 -0400451_us-ascii If you'll all bear with me, I've got a couple of additional announcements about Cogitos DB2 Tech Talks
Firstly, even if you think you may be UNABLE to attend a DB2 Tech Talk, can I please encourage you to register anyway. This is because our webinar hosting sends out an automatic eMail to all registered people after the event with a link to the recording. Thus making this the easiest way to track down the recording afterwards [...]60_4440F5DA00E3F3459BBCB97431B91B6612B8FDC063@MAILR004.mail.lan
3306 31 48_32K byte result set limit for stored procedures?16_Alison Pelletier28_alisonpelletier@DISCOVER.COM30_Mon, 2 Aug 2010 10:57:37 -0400433_UTF-8 Hello.
Is there a 32K byte result set limit for cobol stored procedures? Our SPs can be called by DDF, CICS and batch. I was told there definetely is a 32K limit for CICS. Is there for DDF and batch, as well? Is there a cobol working storage limitation? Our developers are under that impression and for larger than 32K byte result sets, they call the stored procedure multiple times with repositoning where clause. [...]60_4992096329303709.WA.alisonpelletierdiscover.com@www.idug.org
3338 907 93_Re: [AD] DB2 Tech Talk - DB2 10 Is Coming - A First Look (Part 1) - EMEA-friendly time slots!12_Peter Suhner24_peter_suhner@HOTMAIL.COM30_Mon, 2 Aug 2010 17:37:43 +0200388_Windows-1252 That's good news, Phil - thanks!
Date: Mon, 2 Aug 2010 10:22:49 -0400
From: phil.grainger@COGITO.CO.UK
Subject: Re: [DB2-L] [AD] DB2 Tech Talk - DB2 10 Is Coming - A First Look (Part 1) - EMEA-friendly time slots!
To: DB2-L@IDUGDB2-L.ORG
If you’ll all bear with
me, I’ve got a couple of additional announcements about Cogitos DB2 Tech
Talks [...]43_SNT107-W532B60CC8F41712397624EF1AD0@phx.gbl
4246 37 22_LUW TSM backup problem12_Bob Jeandron21_bob.jeandron@USDA.GOV30_Mon, 2 Aug 2010 14:55:02 -0400430_UTF-8 Am trying to backup up a partitioned DB2 DB using TSM. Our TSM system
is used to back up our entire environment. TSM admin has allocated us
10 drives. When backing up using DB2 Backup command, 1st 10 attempts
work fine but 11th and subsequent fail with:
SQL2025N An I/O error "41"
Looked this up and essentially says we are using > allowed number of drives.
Asked IBM and they say "yep that's right". [...]53_1546435805418568.WA.bob.jeandronusda.gov@www.idug.org
4284 65 26_Re: LUW TSM backup problem14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Mon, 2 Aug 2010 14:59:33 -0400444_us-ascii I _think_ if you're using the RETAIN subparameter on VOL, you could get this message. Check for that. zOS would write the first ten volumes _and keep them mounted_ in this case, I think.
--Phil Sevetson
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bob Jeandron
Sent: Monday, August 02, 2010 2:55 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] LUW TSM backup problem [...]64_1BA00CBB414DA34AA25ED82F4647CDE2036225E454@MAIL02.fisalan.nycnet
4350 144 62_[z/OS] ZPARM PARTKEYU deprecated? Inconsistent update behavior14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Mon, 2 Aug 2010 15:38:32 -0400398_us-ascii Help! We're seeing different behavior in UPDATE of a column in the partkey of a partitioned table, in two different systems, with PARTKEYU set to YES in both cases.
In SS01, we're seeing a successful update of COLA, a member of the partkey of partitioned table TB01.
In SS02, we're seeing a failed attempt to update COLA in TB01, whose partkey has COLA as the first column. [...]64_1BA00CBB414DA34AA25ED82F4647CDE2036225E456@MAIL02.fisalan.nycnet
4495 22 26_Re: LUW TSM backup problem12_Bob Jeandron21_bob.jeandron@USDA.GOV30_Mon, 2 Aug 2010 15:43:55 -0400641_UTF-8 Please note this if for Linux, Unix and Windows DB2.
_____________________________________________________________________
* IDUG Australasia * Sydney, Australia * 1-3 September 2010 * http://IDUG.ORG/AU *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]53_0425769208576014.WA.bob.jeandronusda.gov@www.idug.org
4518 46 26_Re: LUW TSM backup problem14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Mon, 2 Aug 2010 15:57:57 -0400833_us-ascii My error, sorry, Bob, didn't read the headline carefully enough.
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bob Jeandron
Sent: Monday, August 02, 2010 3:44 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] LUW TSM backup problem
Please note this if for Linux, Unix and Windows DB2.
_____________________________________________________________________
* IDUG Australasia * Sydney, Australia * 1-3 September 2010 * http://IDUG.ORG/AU *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train [...]64_1BA00CBB414DA34AA25ED82F4647CDE2036225E457@MAIL02.fisalan.nycnet
4565 125 52_Re: 32K byte result set limit for stored procedures?0_18_RENUSHARMA@AOL.COM28_Mon, 2 Aug 2010 23:10:29 EDT650_US-ASCII Hello List
Can anyone direct me towards a document showing why should not we use
referential integrity in DW or data marts.
thanks
Renu
In a message dated 8/2/2010 10:58:43 A.M. Eastern Daylight Time,
alisonpelletier@DISCOVER.COM writes:
Hello.
Is there a 32K byte result set limit for cobol stored procedures? Our SPs
can be called by DDF, CICS and batch. I was told there definetely is a
32K limit for CICS. Is there for DDF and batch, as well? Is there a cobol
working storage limitation? Our developers are under that impression and
for larger than 32K byte result sets, they [...]31_81062.32314ddb.3988e2a5@aol.com
4691 24 63_Auto Reply: DB2-L Digest - 2 Aug 2010 to 3 Aug 2010 (#2010-209)0_27_scott.a.saunders@ORACLE.COM30_Mon, 2 Aug 2010 22:05:08 -0700749_utf-8 From August 2 - 6, I will be visiting a customer or in transit. There will be a delay in responding to your email. For emergencies, contact my manager Pete Vammino at pete.vammino@oracle.com.
_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________ [...]44_527222cb-67ad-4cb8-936a-7887d2d79dcb@default
4716 268 154_The DB2Night Show Episode #24 - "DB2 LUW Oracle and Sybase Enablements and Updates", with Serge Rielau and Dwaine Snow, IBM - Friday 6 August 10 am US CDT13_David Chapman24_David.Chapman@IAG.COM.AU30_Tue, 3 Aug 2010 17:37:43 +1000601_us-ascii _______________________________________________________________________________________
Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________
Hi DB2 List.
The DB2Night Show Episode #24 - "DB2 LUW Oracle and Sybase Enablements and Updates", with Serge Rielau and Dwaine Snow, IBM
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. [...]43_DB2-L%201008030337568381.2A1C@IDUGDB2-L.ORG
4985 39 52_Re: 32K byte result set limit for stored procedures?14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Tue, 3 Aug 2010 18:34:07 +1000431_US-ASCII There is a 32K limit for a normal character parameter. But you can use a LOB - and since
the syntax diagram gives them a default size of 1MB, I guess there isn't a 32K limit.
Earlier versions of COBOL didn't like structure sizes of more than 32K - now they can be.
But you can use LOCATORs to pass large sizes. I would be surprised if you couldn't use
LOCATORs in CICS to pass sizes greater than 32K. [...]49_4C58611F.30738.42558FB9@jacampbell.acslink.net.au
5025 27 43_End of Support DB2 z/OS V8 is 30 April 201214_James Campbell25_jacampbell@ACSLINK.NET.AU30_Tue, 3 Aug 2010 19:06:01 +1000644_US-ASCII From ENUSZP10-0309.PDF - Today's European announcement letter
James Campbell
_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________ [...]49_4C586899.21532.4272C2E2@jacampbell.acslink.net.au
5053 59 52_Re: 32K byte result set limit for stored procedures?14_Steurs Patrick21_Patrick.Steurs@NBB.BE30_Tue, 3 Aug 2010 11:09:10 +0200649_us-ascii Hi,
Our version of cobol supports up to 16777200 bytes in working-storage.
This is nearly 16 Mb.
( IBM Enterprise COBOL for z/OS 3.4.1 -)
greetings,
Patrick Steurs
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of James
Campbell
Sent: dinsdag 3 augustus 2010 10:34
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] 32K byte result set limit for stored procedures?
There is a 32K limit for a normal character parameter. But you can use
a LOB - and since
the syntax diagram gives them a default size of 1MB, I guess there isn't
a 32K limit. [...]60_96DBEA7143ECD048905FAAA27D86E0D212E4075B@VSRBEX10.LANPRD.NBB
5113 238 34_z/OS DB2 V8 Unload file block size15_Flavell, Martin32_Martin.Flavell@COMPUTACENTER.COM30_Tue, 3 Aug 2010 11:40:44 +0100608_Windows-1252 Hi, I am hoping someone can help me.
The V8 Utilities manual says the following:
For output data sets, the online utilities determine both the logical record length
and the record format. Any specified values for LRECL or RECFM are ignored. If
you supply block size, that size is used; otherwise, the utility chooses a block size
that is appropriate for the storage device.
I am including DCB=BLKSIZE=27600 on the SYSREC card for an UNLOAD, but it keeps getting set to 32760. I am using 3390 as the output medium, so would expect something better to be used anyway. I [...]72_B42AA603414E1B4C84CC72CADD7436C72AC54B3B3C@UKEXEMAILP01.computacenter.uk
5352 82 48_Betr: [DB2-L] z/OS DB2 V8 Unload file block size15_Marcel Harleman31_mam.harleman@BELASTINGDIENST.NL30_Tue, 3 Aug 2010 12:55:31 +0200656_us-ascii Martin,
have you checked with your storage management admins? Perhaps there is some
sort of overrule of the blocksize (or maybe there should be one).
I've tested it over here and it works fine for me. But, I am on DB2 V9, so
perhaps ...
Regards,
Marcel.
------------------------------------------------------------------------
De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
vertrouwelijke informatie met de burger of voor de bekendmaking
van beslissingen. De Belastingdienst hanteert conventies voor het
gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl. [...]76_OF13F057B4.5F3E6A95-ONC1257774.003BD94C-C1257774.003C03E9@belastingdienst.nl
5435 280 52_Re: Betr: [DB2-L] z/OS DB2 V8 Unload file block size15_Flavell, Martin32_Martin.Flavell@COMPUTACENTER.COM30_Tue, 3 Aug 2010 12:50:31 +0100687_iso-8859-1 Hi Marcel,
I've done a bit more testing. If I just do an UNLOAD then the BLKSIZE is taken from the DCB. But I'm trying to do a DELIMITED UNLOAD, and that is still using 32760, no matter what I put on the DCB.
Regards,
Martin Flavell
-------------------------------------------------------------------------
IBM Certified Database Associate -- DB2 9 Fundamentals
IBM Certified Database Administrator -- DB2 UDB V8.1 for z/OS
IBM Certified Database Administrator -- DB2 UDB V8.1 for Linux, Unix, Windows
Oracle Database 11g Administrator : Certified Associate
------------------------------------------------------------------------- [...]72_B42AA603414E1B4C84CC72CADD7436C72AC54B3B3E@UKEXEMAILP01.computacenter.uk
5716 213 52_Re: 32K byte result set limit for stored procedures?15_Yadigar Dirican18_ydirican@YAHOO.COM30_Tue, 3 Aug 2010 05:21:06 -0700343_iso-8859-1 Hi,
The 32K limit can be extended by containers in CICS. If your cics/ts version is 3 or higher also can be used channels for this purpose.
For IBM Enterprise COBOL for z/OS 3.4 data item size, occurs integer limit v.b is
134,217,727 bytes. (REF:Enterprise COBOL for z/OS V3.4 Language Reference appendix B) [...]43_643778.76277.qm@web52102.mail.re2.yahoo.com
5930 38 38_DB2 Version 8 Out of Service announced13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Tue, 3 Aug 2010 07:33:19 -0500390_ISO-8859-1 Everyone always wants to know when DB2 Version 8 going out of service.
It looks like the suspense is over.
In today's IBM announcements it states that DB2 for z/OS Version 8
(5625-DB2) will all be going out of service on April 12, 2012. That a
little less than two years away.
Now might be a good time to start that plan to upgrade to DB2 9 for z/OS. [...]30_4C580C8F.7000408@attglobal.net
5969 75 42_Re: DB2 Version 8 Out of Service announced12_McLaren Phil32_Phil.McLaren@AXAWINTERTHUR.CO.UK30_Tue, 3 Aug 2010 13:53:14 +0100474_us-ascii Hi Willie,
I think it's April the 30th (not 12th), but I doubt that will alter anyone's plans :-)
Phil
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero
Sent: 03 August 2010 13:33
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] DB2 Version 8 Out of Service announced
Everyone always wants to know when DB2 Version 8 going out of service.
It looks like the suspense is over. [...]72_1454A0984F246445950CB759E249F50F468F5F066D@csis564.wlp.uk.winterthur.com
6045 97 48_Betr: [DB2-L] z/OS DB2 V8 Unload file block size15_Marcel Harleman31_mam.harleman@BELASTINGDIENST.NL30_Tue, 3 Aug 2010 15:12:42 +0200521_us-ascii I've done a bit more testing. If I just do an UNLOAD then the BLKSIZE is
taken from the DCB. But I'm trying to do a DELIMITED UNLOAD, and that is
still using 32760, no matter what I put on the DCB.
I see. The record length for character separated value files is 32756,
bigger than the blocksize you specified. So the utility will make the
blocksize lrecl+4 (=32760) and since you have no control over the record
format (to make the recordformat VBS for instance) you're stuck with it. [...]76_OF3337E790.80BD4692-ONC1257774.0047F3ED-C1257774.0048930A@belastingdienst.nl
6143 87 42_Re: DB2 Version 8 Out of Service announced13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Tue, 3 Aug 2010 10:15:10 -0500635_ISO-8859-1 Oops... Good catch.. thanks
Willie
On 8/3/2010 7:53 AM, McLaren Phil wrote:
> Hi Willie,
>
> I think it's April the 30th (not 12th), but I doubt that will alter anyone's plans :-)
>
> Phil
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero
> Sent: 03 August 2010 13:33
> To: DB2-L@IDUGDB2-L.ORG
> Subject: [DB2-L] DB2 Version 8 Out of Service announced
>
> Everyone always wants to know when DB2 Version 8 going out of service.
> It looks like the suspense is over.
>
> In today's IBM announcements it [...]30_4C58327E.2060209@attglobal.net
6231 866 93_Re: [AD] DB2 Tech Talk - DB2 10 Is Coming - A First Look (Part 1) - EMEA-friendly time slots!13_Phil Grainger26_phil.grainger@COGITO.CO.UK30_Tue, 3 Aug 2010 11:56:01 -0400431_us-ascii Last note from me on the subject, but the registration links for
"DB2 10 ..... Part 1" on August 19th at 3pm Central European time
"DB2 10 .... Part 2" on September 16th at 3pm Central European time
Are now live at www.cogito.co.uk
Phil Grainger
Cogito Ltd.
phil.grainger@cogito.co.uk
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk [...]60_4440F5DA00E3F3459BBCB97431B91B6612B8FDC125@MAILR004.mail.lan
7098 45 81_Smart Analytics Optimizer with zEnterprise=?UTF-8?Q?=E2=80=94Your_?=Private Cloud11_Dave Beulke19_dave@DAVEBEULKE.COM30_Tue, 3 Aug 2010 12:16:24 -04000_51_2248383907739642.WA.davedavebeulke.com@www.idug.org
7144 64 52_Re: 32K byte result set limit for stored procedures?7_Jan tje25_jan.moeyersons@ADELIOR.BE30_Tue, 3 Aug 2010 14:32:24 -0400377_UTF-8 Alison Pelletier wrote:
> Is there a 32K byte result set limit for cobol stored procedures? Our SPs can be called by DDF,
> CICS and batch. I was told there definetely is a 32K limit for CICS. Is there for DDF and batch,
> as well?
There is a limit of 32K for a COMMAREA in CICS, but that has nothing to do with result sets of stored procedures. [...]57_6664382893711114.WA.jan.moeyersonsadelior.be@www.idug.org
7209 277 66_Re: [z/OS] ZPARM PARTKEYU deprecated? Inconsistent update behavior23_Carlos.Olson@inovis.com23_Carlos.Olson@INOVIS.COM30_Tue, 3 Aug 2010 12:40:57 -0700614_us-ascii I seem to recall a production migration headache years ago where updates to partitioning key values worked in development but didn't work in production. I think it was because the production table was created in V4 before the PARTKEYU ZPARM became available and the table in development had been dropped and recreated after this feature had became available. If I remember correctly, I was forced to unload, drop/recreate the table and reload to fix the issue. I think the UPDATES column in the SYSIBM.SYSCOLUMNS had a value of 'N' for the partitioning key columns before I dropped and recreated the [...]63_BF551DA05F914444A738E58BF25FAC76177F1F23@CONMAILP01.itlogon.com
7487 398 66_Re: [z/OS] ZPARM PARTKEYU deprecated? Inconsistent update behavior14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Tue, 3 Aug 2010 16:40:38 -0400756_us-ascii Thanks, I'll check SYSCOLUMNS.
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Carlos.Olson@inovis.com
Sent: Tuesday, August 03, 2010 3:41 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [z/OS] ZPARM PARTKEYU deprecated? Inconsistent update behavior
I seem to recall a production migration headache years ago where updates to partitioning key values worked in development but didn't work in production. I think it was because the production table was created in V4 before the PARTKEYU ZPARM became available and the table in development had been dropped and recreated after this feature had became available. If I remember correctly, I was forced to unload, drop/recreate [...]64_1BA00CBB414DA34AA25ED82F4647CDE2036225E469@MAIL02.fisalan.nycnet
7886 425 66_Re: [z/OS] ZPARM PARTKEYU deprecated? Inconsistent update behavior14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Tue, 3 Aug 2010 16:51:39 -0400521_us-ascii Carlos: Thanks for a timely suggestion. That was indeed the problem. The column in question is barred from updates by a SYSCOLUMNS.UPDATES value of 'N'.
Randy, this concludes my investigation, I believe.
--Phil
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Carlos.Olson@inovis.com
Sent: Tuesday, August 03, 2010 3:41 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [z/OS] ZPARM PARTKEYU deprecated? Inconsistent update behavior [...]64_1BA00CBB414DA34AA25ED82F4647CDE2036225E46A@MAIL02.fisalan.nycnet
8312 131 53_[z/OS] Stored Procedure Definition & Graphic Datatype12_Cuneyt Goksu22_cuneyt.goksu@GMAIL.COM30_Wed, 4 Aug 2010 15:50:05 +0300417_ISO-8859-1 Hi,
When I define the following SP and then check the definition of parameters
thru SYSIBM.SYSPARMS, I see VARGRAPHIC for UserID parameter, instead of
GRAPHIC.
IBM admin tool also recreate DDL with VARGRAPHIC.
After creating the SP, run the SQL
SELECT * FROM SYSIBM.SYSPARMS WHERE NAME = 'CBRETZZZ'
then check the TYPENAME column...
would someone test for me as well ? [...]60_AANLkTikUZ1J9NFfQTDJSOBeoh_nGaBU4ePg+n+1KjxAW@mail.gmail.com
8444 75 57_Re: [z/OS] Stored Procedure Definition & Graphic Datatype10_Joe Geller21_joerg6666@HOTMAIL.COM30_Wed, 4 Aug 2010 10:47:48 -0400516_UTF-8 On V8 NFM, it comes out as Graphic as you would expect. I ran it exactly as you have it
listed (using SPUFI). We are not on V9 yet.
Joe
Hi,
When I define the following SP and then check the definition of parameters thru SYSIBM.SYSPARMS, I see VARGRAPHIC for UserID parameter, instead of GRAPHIC.
IBM admin tool also recreate DDL with VARGRAPHIC.
After creating the SP, run the SQL
SELECT * FROM SYSIBM.SYSPARMS WHERE NAME = 'CBRETZZZ'
then check the TYPENAME column... [...]53_5260575367812426.WA.joerg6666hotmail.com@www.idug.org
8520 71 57_Re: [z/OS] Stored Procedure Definition & Graphic Datatype12_McLaren Phil32_Phil.McLaren@AXAWINTERTHUR.CO.UK30_Wed, 4 Aug 2010 16:22:32 +0100538_utf-8 Hi Cuneyt,
I also get the VARGRAPHIC(11) using the Admin Tool (V7.02) DDL function, but in SYSPARMS via SPUFI, it's still GRAPHIC.
This is V9 NFM (RSU0910+).
So there's an alternative variation of the problem, where it appears as an Admin Tool quirk only?
Phil
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joe Geller
Sent: 04 August 2010 15:48
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [z/OS] Stored Procedure Definition & Graphic Datatype [...]72_1454A0984F246445950CB759E249F50F468F5F09E0@csis564.wlp.uk.winterthur.com
8592 232 57_Re: [z/OS] Stored Procedure Definition & Graphic Datatype12_Peter Suhner24_peter_suhner@HOTMAIL.COM30_Wed, 4 Aug 2010 22:11:05 +0200706_iso-8859-1 Hi Cuneyt,
identical behavior with our system (DB2 9 NFM).
SYSPARMS queried via SPUFI or QMF shows GRAPHIC(11).
AdminTool v7.2.0 shows (and generates) VARGRAPHIC(11)
Regards,
Peter
> Date: Wed, 4 Aug 2010 16:22:32 +0100
> From: Phil.McLaren@AXAWINTERTHUR.CO.UK
> Subject: Re: [DB2-L] [z/OS] Stored Procedure Definition & Graphic Datatype
> To: DB2-L@IDUGDB2-L.ORG
>
> Hi Cuneyt,
>
> I also get the VARGRAPHIC(11) using the Admin Tool (V7.02) DDL function, but in SYSPARMS via SPUFI, it's still GRAPHIC.
> This is V9 NFM (RSU0910+).
>
> So there's an alternative variation of the problem, where it appears as an Admin Tool [...]43_SNT107-W128F1348231D8CFB18B095F1AF0@phx.gbl
8825 72 25_third party RDBMS drivers15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Wed, 4 Aug 2010 15:58:12 -0600383_us-ascii Grasping at straws here, but...
Is there by chance anyone who sells z/OS client software that can be used to connect to either DB2 for Linux, UNIX and Windows or, preferably, to Oracle?
We have a crazy database access code path on z/OS.
User application (batch or CICS) -> DB2 on z/OS -> DB2 Federation Server on Linux (on Intel) -> Oracle (on Intel). [...]35_4C598E28.6F0F.0085.0@efirstbank.com
8898 369 72_Help needed for a SQL statement in DB2 f=?iso-8859-1?Q?=FCr_?=z/OS V8 CM12_Peter, Georg15_G.Peter@DZBW.DE30_Thu, 5 Aug 2010 14:30:01 +0200741_iso-8859-1 Environment: DB2 z/OS V8 Compatibility Mode (CM)
------------------------------------------------
Fellow collegues,
this SQL statement
UPDATE LAIF.MASSNAHME M
SET M.ART_MASSNAHME =
(CASE WHEN M.ART_MASSNAHME = '72' THEN '77'
WHEN M.ART_MASSNAHME = '21' THEN '78'
WHEN M.ART_MASSNAHME = '02' THEN '79'
END)
INNER JOIN LAIF.MASSNAHMEKONTEXT K ON
(M.MANDANT = K.MANDANT AND
M.PERSON_ID = K.PERSON_ID AND
M.MASS_KONTEXT_ID = K.MASS_KONTEXT_ID)
WHERE K.ART_KONTEXT = '01'
AND M.ART_MASSNAHME IN('02','21','72');
ends up with
DSNT408I SQLCODE = -4700, ERROR: ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE [...]58_99E58D5AC1BE6D4CBF492AF72B942C3D061ADD18@dzstus010.dzbw.de
9268 108 66_Re: [z/OS] ZPARM PARTKEYU deprecated? Inconsistent update behavior10_Mark Labby21_mlabby@AESSUCCESS.ORG30_Thu, 5 Aug 2010 09:29:35 -0400544_utf-8 We ran into this a number of years ago and it was exactly the situation
that Carlo described. The solution from IBM at the time was 'drop and
recreate the table' - which we all know is not gonna happen in production.
I had asked about being able to update the SYSCOLUMNS value to make it
updatable, but was told it was 'fixed' in DB2 9. I think they are not
changing the column value to show it is now updatable, but simply no longer
going to check that and allow the update, so they deprecated the ZPARM for
9. [...]67_OFE8AEFAA0.3F91E56E-ON85257776.00496A0E-85257776.004A1DD6@pheaa.org
9377 57 74_Re: Help needed for a SQL statement in DB2 f=?UTF-8?Q?=C3=BCr_?=z/OS V8 CM14_Peter Vanroose17_pvanroose@ABIS.BE30_Thu, 5 Aug 2010 11:55:51 -0400440_UTF-8 > UPDATE LAIF.MASSNAHME M
> SET M.ART_MASSNAHME =
> (CASE WHEN M.ART_MASSNAHME = '72' THEN '77'
> WHEN M.ART_MASSNAHME = '21' THEN '78'
> WHEN M.ART_MASSNAHME = '02' THEN '79'
> END)
> INNER JOIN LAIF.MASSNAHMEKONTEXT K ON
> (M.MANDANT = K.MANDANT AND
> M.PERSON_ID = K.PERSON_ID AND
> M.MASS_KONTEXT_ID = K.MASS_KONTEXT_ID)
> WHERE K.ART_KONTEXT = '01'
> AND M.ART_MASSNAHME IN('02','21','72'); [...]49_0776729039982165.WA.pvanrooseabis.be@www.idug.org
9435 165 66_Re: [z/OS] ZPARM PARTKEYU deprecated? Inconsistent update behavior14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Thu, 5 Aug 2010 12:06:18 -0400662_us-ascii Mark,
We're on DB2 9, at NFM. It's happening now.
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mark Labby
Sent: Thursday, August 05, 2010 9:30 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [z/OS] ZPARM PARTKEYU deprecated? Inconsistent update behavior
We ran into this a number of years ago and it was exactly the situation
that Carlo described. The solution from IBM at the time was 'drop and
recreate the table' - which we all know is not gonna happen in production.
I had asked about being able to update the SYSCOLUMNS value to make it
updatable, but was told [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF8D0@MAIL02.fisalan.nycnet
9601 218 76_Re: Help needed for a SQL statement in DB2 f=?iso-8859-1?Q?=FCr_?=z/OS V8 CM14_Larry Kintisch17_LKint@VERIZON.NET30_Thu, 5 Aug 2010 12:14:32 -0400446_iso-8859-1 Hi Georg,
The English language acronym "KISS" [ Keep It
Simple, Stupid ] seems to me to apply here [not
that we are stupid, but sometimes we get things
complicated]. I don't know what is wrong with the
syntax, but adding an INNER JOIN to select rows
for the update seems rather complicated. In (A)
below I've reworked the CASE into a Simple WHEN
and replaced the JOIN with a correlated EXISTS for clarity. [...]40_0L6O00IXLT4ALTE0@vms173015.mailsrvcs.net
9820 155 62_DB2 Z/os V8 set :H current date getting getpages & io waits???13_Case, Missy J24_Missy.Case@FIRSTDATA.COM30_Thu, 5 Aug 2010 11:40:41 -0500450_us-ascii I know, there are larger things to worry about in the DB2 world that a
couple of dozen getpages & some IO waits for a silly SetHOSTV statement.
Except we do it a LOT in a lot of programs and repeatedly throughout the
day via different programs. Why do I need to do IO waits or lockwaits
on what was originally supposed to be a phantom table (1 9 char column
name IBMREQD) that magically returns all your register values? [...]64_3C8EB6E657433F439F22BB22A069206802C2261C@WFDROMPXMASRV02.1DC.COM
9976 375 66_Re: DB2 Z/os V8 set :H current date getting getpages & io waits???10_Roger Hecq18_Roger.Hecq@UBS.COM30_Thu, 5 Aug 2010 13:12:47 -0400394_us-ascii Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system. [...]62_1A700EEF49343148A08879B1E3CA5BA615D58B52@NSTMC101PEX1.ubsw.net
10352 388 66_Re: DB2 Z/os V8 set :H current date getting getpages & io waits???9_Sam Baugh24_Sam.Baugh@MOTION-IND.COM30_Thu, 5 Aug 2010 12:13:08 -0500410_us-ascii Based on what CA Detector shows, it hits Directory table SPTR and index DSNSPT01, but I don't know why. This was for static SQL, so there is no PREPARE involved.
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Case, Missy J
Sent: Thursday, August 05, 2010 11:41 AM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] DB2 Z/os V8 set :H current date getting getpages & io waits??? [...]73_1A20EF32A1A1CA44B36AF5D6920397221646431911@MIHQPEXMB1.corp.motion-ind.com
10741 152 39_IBM announces DB2 pureScale on System X20_Cuneyt Goksu (Gmail)22_cuneyt.goksu@GMAIL.COM30_Thu, 5 Aug 2010 20:52:12 +0300626_us-ascii Today, at the Smarter Systems Event in Beijing, China, IBM will announce
the availability of DB2 pureScale on the System x platform running on
SUSE Linux. DB2 pureScale on System x builds on the flexibility of our
platform support and further strengthens IBM's portfolio of Smarter
Systems. DB2 pureScale on System x leverages the outstanding business
benefits of IBM X-ArchitectureR technology. In addition, running SUSE
Linux on IBM System x servers provides clients with an additional
cost-effective, open, reliable and secure IT environment that can easily
scale as workloads demand. [...]42_016301cb34c6$f029c7b0$3963ac09@cuneytgoksu
10894 100 93_If you live near Kansas City, Minnepolis, Dallas or Philadelphia..DB2 training close to home!11_Suresh Sane21_data_arch@HOTMAIL.COM30_Thu, 5 Aug 2010 13:02:07 -0500903_iso-8859-1 If you live near Kansas City, Minneapolis, Dallas or Philadelphia..
Check out the IDUG Regional events which will provide:
IDUG quality close to home
Top-notch speakers for a 2-day educational event
$395 off IDUG NA/EMEA registration for anyone who attends the Regional
Free certification ($200 value)
Check out this link:
http://www.idug.org/idug-regional-events/idug-regional-forums.html
Thx
Suresh
_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________ [...]42_COL104-W5499ED3AEE344CF4AB6A798900@phx.gbl
10995 140 64_Quick survey: what's your favorite source for DB2 informations ?10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 6 Aug 2010 09:24:32 +0200553_US-ASCII Esteemed DB2-L listers
Nowadays there are a lot of places where you can find informations about
DB2 and they are so many that all useful (and a little less useful)
news/announcement/hints and more are spread and
fragmented everywhere in the Internet and not always search engines help
in finding them.
So to improve social communications with DB2 professionals I invite you to
complete a quick survey to find what's the most used/useful (in your
opinion) forum/group/pub/golf club... where you can find [...]66_OFE084F3D5.1C64C189-ONC1257777.0024C3F7-C1257777.0028B255@cesve.it
11136 35 60_How to Get the DB2 Creator ID and Index details in Run Time?12_Amlan Prasad16_amlan_pd@MSN.COM30_Fri, 6 Aug 2010 05:10:18 -0400379_UTF-8 Hi,
DB2 is new to me so please pardon my questions if they seem to be silly for this forum.
1) What is the differece (if any) between DB2 creator, schema qualifier and owner?
2) How can I get these above values in run time if I have to do some processing based on that?
3) How can I get the DB2 key and index details in run-time if it is possible? [...]47_4751589590707754.WA.amlanpdmsn.com@www.idug.org
11172 266 84_AW: [DB2-L] Help needed for a SQL statement in DB2 f=?iso-8859-1?Q?=FCr_?=z/OS V8 CM12_Peter, Georg15_G.Peter@DZBW.DE30_Fri, 6 Aug 2010 14:37:58 +0200487_iso-8859-1 Thanks to Peter, Sam and Larry,
for answering my question. The problem is solved. And our application programmer is happy ;-))
A nice weekend to all of us !
Best regards,
Georg
-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Larry Kintisch
Gesendet: Donnerstag, 5. August 2010 18:15
An: DB2-L@IDUGDB2-L.ORG
Betreff: Re: [DB2-L] Help needed for a SQL statement in DB2 für z/OS V8 CM [...]58_99E58D5AC1BE6D4CBF492AF72B942C3D077D4D8E@dzstus010.dzbw.de
11439 361 57_Re: [z/OS] Stored Procedure Definition & Graphic Datatype20_Cuneyt Goksu (Gmail)22_cuneyt.goksu@GMAIL.COM30_Fri, 6 Aug 2010 16:47:27 +0300494_US-ASCII Thanks to all the feedback and help.
The issue is in Admin Tool. I'll open a PMR and will let DB2-L about
this.
Regards, Cuneyt
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Peter Suhner
Sent: Wednesday, August 04, 2010 11:11 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] [z/OS] Stored Procedure Definition & Graphic
Datatype
Hi Cuneyt,
identical behavior with our system (DB2 9 NFM). [...]42_00ff01cb356d$e9ae9030$980aa8c0@cuneytgoksu
11801 84 20_DBA job description.23_BOLEY Maurice C * Cliff32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Fri, 6 Aug 2010 11:37:43 -0700626_us-ascii aaarrrg. one of those day.
Tell me if this is a good succinct definition of a DBA's job.
Prevent developers and users from corrupting the company's data.
TGIF.
cliff:-)
_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]71_1885C0CA1657E04F827207AC4D66568F07D20CC3@ex-salemrev-3.odot.state.or.us
11886 96 58_[OT] Where should I post new knowledge about CA-Scheduler?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Fri, 6 Aug 2010 14:52:37 -0400678_us-ascii I found out about Driver Procs this morning, an incredibly useful way that CA Scheduler provides to extend certain functionality of z/OS JCL. Do any of you mainframers know where people go to discuss JCL and/or CA Scheduler? Is this an MVS-L thing?
_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]64_1BA00CBB414DA34AA25ED82F4647CDE203665DF8DF@MAIL02.fisalan.nycnet
11983 69 24_Re: DBA job description.0_24_carol.sutfin@REGIONS.COM30_Fri, 6 Aug 2010 13:58:30 -0500693_US-ASCII and themselves.
Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
carol.sutfin@regions.com
From: BOLEY Maurice C * Cliff
To: DB2-L@IDUGDB2-L.ORG
Date: 08/06/2010 01:40 PM
Subject: [DB2-L] DBA job description.
Sent by: IDUG DB2-L
aaarrrg. one of those day.
Tell me if this is a good succinct definition of a DBA's job.
Prevent developers and users from corrupting the company's data.
TGIF.
cliff:-)
The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here. [...]71_OFCC92F79A.A255C5A4-ON86257777.0068327B-86257777.00683B9E@corp.rgbk.com
12053 75 24_Re: DBA job description.10_Fred Edgar18_fredgarx@YAHOO.COM30_Fri, 6 Aug 2010 12:24:14 -0700505_iso-8859-1 Sounds more like a description for Super Hero.
--- On Fri, 8/6/10, BOLEY Maurice C * Cliff wrote:
From: BOLEY Maurice C * Cliff
Subject: [DB2-L] DBA job description.
To: DB2-L@IDUGDB2-L.ORG
Date: Friday, August 6, 2010, 1:37 PM
aaarrrg. one of those day.
Tell me if this is a good succinct definition of a DBA's job.
Prevent developers and users from corrupting the company's data. [...]42_592805.4516.qm@web30204.mail.mud.yahoo.com
12129 307 24_Re: DBA job description.12_Phil Gunning19_pkgunning@GMAIL.COM30_Fri, 6 Aug 2010 15:28:53 -0400430_us-ascii Someone who can open up a can of WhoopassT from time to time when needed. J
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Fred Edgar
Sent: Friday, August 06, 2010 3:24 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] DBA job description.
Sounds more like a description for Super Hero.
--- On Fri, 8/6/10, BOLEY Maurice C * Cliff
wrote: [...]35_002301cb359d$9ba60f00$d2f22d00$@com
12437 190 24_Re: DBA job description.10_Roger Hecq18_Roger.Hecq@UBS.COM30_Fri, 6 Aug 2010 15:41:23 -0400394_us-ascii Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system. [...]62_1A700EEF49343148A08879B1E3CA5BA615D58F5A@NSTMC101PEX1.ubsw.net
12628 25 24_Re: DBA job description.11_Ted MacNEIL18_eamacneil@YAHOO.CA30_Fri, 6 Aug 2010 19:49:30 +0000571_- >Sounds more like a description for Super Hero.
Nyuk! Nyuk! Nyuk!
-
I'm a SuperHero with neither powers, nor motivation!
Kimota!
_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________ [...]103_590029122-1281124157-cardhu_decombobulator_blackberry.rim.net-502943701-@bda026.bisx.prod.on.blackberry
12654 240 24_Re: DBA job description.9_Sam Baugh24_Sam.Baugh@MOTION-IND.COM30_Fri, 6 Aug 2010 14:52:44 -0500335_us-ascii Can't be prevented, DBA's are for damage recovery, and having to respond to any error message that includes the word INDEX in it, even if the application has nothing to do with DB2. We can sometimes prevent things like SELECT DISTINCT CURRENT DATE FROM a table with several million rows, unless they do it dynamically :o [...]73_1A20EF32A1A1CA44B36AF5D69203972216464320F8@MIHQPEXMB1.corp.motion-ind.com
12895 34 73_AUTO: Paul P Packham/GIS/CSC is out of the office. (returning 23/08/2010)14_Paul P Packham16_ppackham@CSC.COM30_Fri, 6 Aug 2010 21:15:00 +0100450_US-ASCII I am out of the office until 23/08/2010.
I am now on Annual Leave.
For urgent queries please contact Mick Graley on +44(0)1246214871,
otherwise I will respond when I return.
For a Union query please contact Colin W Walker or any
of the other reps. Colin's number is 01246 21 4699
Thanks Paul
Note: This is an automated response to your message "[DB2-L] DBA job
description." sent on 6/8/10 19:37:43. [...]65_OF8501D75F.2810A356-ON80257777.006F3C91-80257777.006F3C91@csc.com
12930 359 24_Re: DBA job description.23_BOLEY Maurice C * Cliff32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Fri, 6 Aug 2010 13:42:29 -0700634_us-ascii I've had other versions.
DBA, "the poor sod caught between the developers and the users"
cliff:-)
-----Original Message-----
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Phil
Gunning
Sent: Friday, August 06, 2010 12:29 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] DBA job description.
Someone who can open up a can of Whoopass(tm) from time to time
when needed. J
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Fred
Edgar
Sent: Friday, August 06, 2010 3:24 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: Re: [DB2-L] DBA job description. [...]71_1885C0CA1657E04F827207AC4D66568F07D20CC7@ex-salemrev-3.odot.state.or.us
13290 44 70_AUTO: Sajad Javid is out of the office (Travel) (returning 08/09/2010)11_Sajad Javid19_sajad.javid@TCS.COM30_Sat, 7 Aug 2010 11:04:16 +0530348_us-ascii I am out of the office until 08/09/2010.
I will be traveling and will not be accessing emails regularly.
Note: This is an automated response to your message "DB2-L Digest - 6 Aug
2010 to 7 Aug 2010 (#2010-213)" sent on 8/7/10 10:30:05.
This is the only notification you will receive while this person is away. [...]65_OFECBEB78A.9BC86C4D-ON65257778.001E9AAD-65257778.001E9AAE@tcs.com
13335 24 63_Auto Reply: DB2-L Digest - 6 Aug 2010 to 7 Aug 2010 (#2010-213)13_Chris Economy28_christine.economy@ORACLE.COM30_Fri, 6 Aug 2010 23:01:07 -0700703_utf-8 This is an auto-replied message. I am out of the office.
I will respond to your E-mail when I return.
Thank you.
_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]44_7a30a9d2-2973-4b06-b0b1-1afda775d4f4@default
13360 288 24_Re: DBA job description.12_Isaac Yassin20_yassini@BEZEQINT.NET30_Sat, 7 Aug 2010 09:52:39 +0300454_us-ascii Hi,
This applies to DBA's as well .
Isaac Yassin
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of BOLEY Maurice C *
Cliff
Sent: Friday, August 06, 2010 9:38 PM
To: DB2-L@IDUGDB2-L.ORG
Subject: [DB2-L] DBA job description.
aaarrrg. one of those day.
Tell me if this is a good succinct definition of a DBA's job.
Prevent developers and users from corrupting the company's data. [...]35_009b01cb35fd$20a603e0$61f20ba0$@net
13649 89 24_Re: DBA job description.14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM30_Sat, 7 Aug 2010 10:51:27 -0400610_UTF-8 DB2 is one of the first of an error of databases where
Preventing physical data corruption became the job of the DBMS.
As an asside base performace (access path selection) is also the job of the DB2 era DBMS.
This is quite diffrent from the era where the term DBA was invented.
DBA comes from the IMS era where the idea that databases were coorporate resources rather than individual resources.
DB2 broke away from this at the begining. DBADMIN for example is automaticly assigned to the Database creator, not the super star.
The IMS world suffered from an additional problem. [...]56_1130488668856996.WA.ibmsysproggeeksites.com@www.idug.org
13739 29 58_IDUG Social Media Survey - 5 minutes of your time required14_Surekha Parekh20_surekha21@UK.IBM.COM30_Sat, 7 Aug 2010 18:06:17 -0400885_UTF-8 Dear All
We are trying to improve our social marketing communications from IDUG – please can you take 5 minutes to complete this simple on-line survey so we can satisfy your communication needs and wants more effectively . Take Survey Now
https://www.surveymonkey.com/s/IDUGSocialMktg
_____________________________________________________________________
* IDUG EMEA * Vienna, Austria * 8-12 November 2010 * http://IDUG.ORG/EMEA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________ [...]52_6227469472477037.WA.surekha21uk.ibm.com@www.idug.org