1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l May 2009, week 3 2 58 60_Re: SV: [DB2-L] DB2 z/OS V9 - To small SDSNEXIT and LNKLST ?11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Fri, 15 May 2009 06:30:46 +0000694_ISO-8859-1 Hello Hanne,

don't you use customized authorization routines ( DSN3@SGN ...) to allow usage of secondary ( RACF group) IDs for example ?... They also reside in DSNEXIT on our installation ...

Regards, Nenad









On Thu, 14 May 2009 15:32:22 +0200, Hanne Lyssand wrote:

>We do a copy of: DSNHDECP and DSNHMCID to SDSNLOAD who is in the lnklst. >DSNHDECP is also the same all over as of now. > >hanne > >_____________________________________________________________________ > >* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * > >There is a discussion list for people who are going to [...] 61 394 68_SV: [DB2-L] SV: [DB2-L] DB2 z/OS V9 - To small SDSNEXIT and LNKLST ?13_Olle Brostrom25_olle.brostrom@SWEDBANK.SE31_Fri, 15 May 2009 08:31:09 +0200434_iso-8859-1 Hi Cathy, Yes we are running DB2 9. Our migration strategy is not to run mixed versions in the same DSG and therefore we have not touched that problem. //Olle

________________________________ Från: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] För Taddei, Cathy Skickat: den 14 maj 2009 19:54 Till: DB2-L@WWW.IDUGDB2-L.ORG Ämne: Re: [DB2-L] SV: [DB2-L] DB2 z/OS V9 - To small SDSNEXIT and LNKLST ? [...] 456 206 24_Re: revoke sysadm impact16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Fri, 15 May 2009 09:27:17 -0400556_iso-8859-1 Well not to be undone

If you have DBA-XPERT from Compuware, then just run the revoke impact report and away you go.















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. [...] 663 115 28_Looking for some information0_29_Sherri.Sterling@BPD.TREAS.GOV31_Fri, 15 May 2009 09:39:59 -0400343_US-ASCII We have 5 production subsystems so here is a grand total.



* the size of your DSNDB07 (or equivalent if DS) database * the number of 4K workfiles (table spaces) defined in DSNDB07 * the number of 32K workfiles (table spaces) defined in DSNDB07 * the size of the buffer pool supporting DSNDB07 * the size of SRTPOOL [...] 779 60 7_History0_17_db46@CHRYSLER.COM31_Fri, 15 May 2009 10:01:47 -0400335_US-ASCII I am working with an old DB2 database (been around for 20 years or more) and there is almost no referential integrity. I am at odds with a developer who is into his 70's that said when they started using DB2 there was no such thing as RI.

Was there RI in DB2 version 1 for OS/MVS ? If not, then when was it added. [...] 840 245 11_Re: History13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 15 May 2009 16:06:03 +0200517_us-ascii 2.1 I think. Although a little bird says V3. How's that for helpful?

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of db46@CHRYSLER.COM Sent: 15 May 2009 15:02 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] History



I am working with an old DB2 database (been around for 20 years or more) and there is almost no referential integrity. I am at odds with a developer who is into his 70's that said when they started using DB2 there was no such thing as RI. [...] 1086 88 11_Re: History14_Peter Backlund21_BacklundDB2@TELIA.COM31_Fri, 15 May 2009 16:07:03 +0200 1175 289 11_Re: History13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 15 May 2009 16:08:54 +0200309_us-ascii OK, colours to the mast time. I've looked up the oldest SQL Reference I have, V2.3, and it talks about RI constructs, so before 2.3. I'll bet another rubber cheque on 2.1.

From: Bell, Raymond Sent: 15 May 2009 15:06 To: 'DB2 Database Discussion list at IDUG' Subject: RE: [DB2-L] History [...] 1465 29 57_Re: [[DB2-L] DB2 z/OS V9 - To small SDSNEXIT and LNKLST ?13_Hanne Lyssand20_Hanne.Lyssand@VPS.NO31_Fri, 15 May 2009 16:11:45 +0200591_iso-8859-1 I have that member (DSN3ØSGN) in SDSNEXIT but I have not found the a reason for copying it to lnklst. I jused stated what we do, if it's a good thing I don't know :-)

We use RACF-groups.

Hanne

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 1495 130 11_Re: History13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Fri, 15 May 2009 09:12:25 -0500598_ISO-8859-1 DB2 enforced referential integrity was introduced in DB2 V2.1.

read more here - http://it.toolbox.com/blogs/db2zos/db2-history-101-version-21-22281

Willie

db46@CHRYSLER.COM wrote: > > I am working with an old DB2 database (been around for 20 years or > more) and there is almost no referential integrity. I am at odds with > a developer who is into his 70's that said when they started using DB2 > there was no such thing as RI. > > Was there RI in DB2 version 1 for OS/MVS ? If not, then when was it > added. > > Dean J. Burchill > 248-576-3957 > (8) 776-3957 [...] 1626 26 26_ROLLUPS USING JOIN ON MQTS14_Carol Goldberg19_puli@MINDSPRING.COM31_Fri, 15 May 2009 15:03:56 +0000511_windows-1252 Is it possible to join 2 mqt tables, to build a higher level rollup, or is there a better way to go about that.

Carol

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 1653 52 32_Re: Looking for some information19_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Fri, 15 May 2009 10:06:23 -0500692_us-ascii We have: (15) 4k tablespace at an average of 2500 cylinders (but stddev is large; and bulk of tablespaces are at either 1200 cylinders or 3300 cylinders)

(5) 32k tablespaces for 250 cylinders (and very little 32k sorting)

Sort buffer pool has 10,000 pages

In DSNTIJUZ, SRTPOOL=1280,

Thanks, Rich Humphris



E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert [...] 1706 147 4_UHC?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 15 May 2009 11:10:25 -0400759_us-ascii Is there a United Healthcare DBA watching this list? I need to talk to someone inside the company. (Subject is confidential.)

--Phil Sevetson





========================================================= Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication [...] 1854 149 8_Re: UHC?10_Mark Stone17_mastone@GMAIL.COM31_Fri, 15 May 2009 08:26:39 -0700703_ISO-8859-1 If you're trying to get you're claim paid good luck. That company has so many competing IT departments, you'll be lucky to get any straight answer (I used to work for them in CA).

On Fri, May 15, 2009 at 8:10 AM, Sevetson, Phil wrote:

> Is there a United Healthcare DBA watching this list? I need to talk to > someone inside the company. (Subject is confidential.) > > --Phil Sevetson > > ------------------------------ > ========================================================= > Confidentiality Notice: This e-mail communication, and any attachments, > contains confidential and privileged information for the exclusive use of > the recipient(s) [...] 2004 31 11_Re: History11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Fri, 15 May 2009 15:35:01 +0000552_- >Was there RI in DB2 version 1 for OS/MVS ?

NO.



>If not, then when was it added.

DB2 V1.3 -- circa 1988.

- Too busy driving to stop for gas!

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 2036 61 11_Re: History15_Hagedorn, Linda24_Linda_Hagedorn@MEDCO.COM31_Fri, 15 May 2009 11:39:33 -04001160_us-ascii In case there are other history questions, or need the doc, here are links to DB2 manuals since the beginning.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr/Shelves/f0qx2e00 R110 http://publibz.boulder.ibm.com/cgi-bin/bookmgr/Shelves/f0qx2e01 R120 http://publibz.boulder.ibm.com/cgi-bin/bookmgr/Shelves/sqlx2e02 R220 http://publibz.boulder.ibm.com/cgi-bin/bookmgr/Shelves/DSNSH0A2 R230

http://publibz.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnsh0b7 R310

http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnsh0da R410

http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnsh0f3 R510

http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnsh0g4 R610

http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnshha8 R710

http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/DSNSHJA7 R810 http://publib.boulder.ibm.com/cgi-bin/bookmgr/Shelves/dsnshka2 R910





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ted MacNEIL Sent: Friday, May 15, 2009 11:35 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History [...] 2098 60 11_Re: History13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 15 May 2009 17:45:29 +0200333_us-ascii Ummm... having worked on DB2 for OS/2 etc these are of interest, but I think as far back as the BookManager books for DB2 for MVS, OS/390, z/OS goes V2.3 is as old as I've found to date.

Cheers though.



Raymond PS. If anyone does know where the old V1.1, V1.2 and V1.3 books can be found, do tell. [...] 2159 138 11_Re: History10_Roger Hecq18_Roger.Hecq@UBS.COM31_Fri, 15 May 2009 11:52:33 -0400479_us-ascii Linda, You are always a great source of info, but the first 3 links are for db2/2, and not for DB2. But you were probably still in high school for those early releases!!



Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Hagedorn, Linda Sent: Friday, May 15, 2009 11:40 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History [...] 2298 112 11_Re: History10_Roger Hecq18_Roger.Hecq@UBS.COM31_Fri, 15 May 2009 11:55:43 -0400475_us-ascii Were they ever available in other than hard copy? I still have some of them, and the early release presentations, but I don't remember them ever being available on CD.



Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bell, Raymond Sent: Friday, May 15, 2009 11:45 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History [...] 2411 28 11_Re: History11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Fri, 15 May 2009 16:05:16 +0000316_- Sorry (I know it's bad form to reply to one's own post), I meant DB2 V2.

------Original Message------ From: (yahoo) Ted MacNEIL Sender: DB2 Data Base Discussion List To: DB2 List ReplyTo: DB2 List Sent: May 15, 2009 11:35 Subject: Re: [DB2-L] History

>Was there RI in DB2 version 1 for OS/MVS ? [...] 2440 22 11_Re: History30_edward.krisiewicz@jpmorgan.com30_edward.krisiewicz@JPMORGAN.COM31_Fri, 15 May 2009 16:09:14 +0000663_windows-1252 They were only available on 8-track.

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________

IDUG DB2-L FAQ and e-mail settings are located on the IDUG.org Listserv page. If you are not already an IDUG.org member, please register at http://www.idug.org/register _____________________________________________________________________ 2463 303 11_Re: History13_Hampton, Kirk26_kirk.hampton@CAPGEMINI.COM31_Fri, 15 May 2009 12:20:58 -0400629_windows-1252 Hello Dean,

I'm not anywhere near my 70's yet, but both DB2 and I have been in this shop since Version 1.2, and only 1 application out of a hundred has ever used DB2-enforced RI.

Is there a problem with that ?

_________________________________________________________________ J Kirk Hampton / Capgemini / Dallas

Senior Infrastructure Engineer / Capgemini Energy Office: +1 972 216 3119 / Mobile: +1 817 228 6083 / www.us.capgemini.com Fax: +1 972 216 3185 Mesquite Data Center, 2947 Executive Blvd, Mesquite, TX, 75149 Email: Kirk.Hampton@capgemini.com [...] 2767 350 11_Re: History13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Fri, 15 May 2009 12:06:52 -0500573_ISO-8859-1 If there is an interest in DB2 for z/OS history, I blogged about every release from V1.1. through V4 with what was delivered in each release.

Willie

Roger Hecq wrote: > Linda, > You are always a great source of info, but the first 3 links are for > db2/2, and not for DB2. But you were probably still in high school for > those early releases!! > > > Roger Hecq > MF IB USA DB Support > 203-719-0492 / 19-337-0492 > > -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On > Behalf Of Hagedorn, Linda [...] 3118 36 11_Compression13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Fri, 15 May 2009 12:38:54 -0500199_ISO-8859-1 Hi All,

I just published a blog post asking for compression details

http://it.toolbox.com/blogs/db2zos/compression-on-db2-for-zos-31672

Check out

Thanks

3155 53 30_Re: ROLLUPS USING JOIN ON MQTS14_Larry Kintisch17_LKint@VERIZON.NET31_Fri, 15 May 2009 14:10:11 -0400566_us-ascii Hi Carol, There are no restrictions that I know of on how you can use MQT's once they've been created. You can JOIN, UNION [etc] them together, and in so doing you can build a view [or a table expression] that does the JOIN or UNION and then aggregates further. Be sure to eliminate unwanted rows [if the MQT was built with ROLLUP, CUBE, or GROUPING SETS] with appropriate WHERE limits [xxx IS NULL or xxx IS NOT NULL]. I found a useful reference to this at the link below. Hope this helps. Larry Kintisch Pres., ABLE Information Services 845-353-0885 [...] 3209 496 24_Re: revoke sysadm impact13_Hampton, Kirk26_kirk.hampton@CAPGEMINI.COM31_Fri, 15 May 2009 14:24:52 -0400333_windows-1252 I have performed the procedure, outlined by Lucy below, many times on DB2 v7 and earlier, and it works fine, but costs you an outage.

It's nice to find that on v8 and above you can now use SET SYSPARM to dynamically alter the SYSADM and SYSADM2 zParms. We are on v8 CM, should be getting to NFM this summer. [...] 3706 389 2_RI0_17_db46@CHRYSLER.COM31_Fri, 15 May 2009 14:58:27 -0400564_ISO-8859-1 Unfortunately yes. Over the years many people have 'achieved' access to the DB in a variety of ways. I/we am constantly having to 'fix' the data or help users write QMF queries in order do their jobs.

Any time you depend on programmatic solutions for DB integrity, you will have problems. But I am not going to get into a discussion about using RI. Some developers hate it because it slows down the DB. Others love it because it protects the DB from bad users, bad developers, and bad DB architects. To err is human, to really foul up takes [...] 4096 151 11_Re: History13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 15 May 2009 21:47:46 +0200457_us-ascii Roger, you might be right. I cut my teeth on DB2 for MVS V1.3 and used to 'acquire' most of the hardback (well, paperback) DB2 manuals for each release, but soft-copies are a relatively recent development. Think I've found PDF versions back to about V5 and .BOOs to V2.3 but before that? As scarce as hen's teeth. And, being until recently one of the 'new Bedouin' DB2-wise, I've tended to travel light so the paper stuff has long since gone. [...] 4248 207 11_Re: History10_Roger Hecq18_Roger.Hecq@UBS.COM31_Fri, 15 May 2009 16:07:08 -0400308_us-ascii I might be right? Perish the thought! Can't be!

DB2 went GA in 1Q85. I don't remember any online documentation until the mid-90's, so that would take care of versions 1 & 2 of frame DB2. I remember having Book Mgr on the frame, and then CD's took over quickly in the '96-'97 time frame. [...] 4456 117 11_Re: History12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Fri, 15 May 2009 16:15:18 -0500316_us-ascii Interesting - nothing for DB2 1.3 or 2.1? I worked in a shop that spent a lot of time 'gaming' the optimizer in 1.3 only to have all the access paths blow up when we went to 2.1. We also had a lot of fun with 2.1 trashing the middle 4 bytes of the log RBA. That went on for weeks before we backed off. [...] 4574 90 54_AVOID PREPAREs by exploiting the local statement cache11_Sameer Rana21_sameerdrana@GMAIL.COM31_Fri, 15 May 2009 21:16:36 +0000457_windows-1252 Folks ,

We are at the end of the road in the options we can think of to get our Dynamic SQLs to AVOID PREPAREs by exploiting the local statement cache.

We aren't in as bad shape in that all PREPARES are SHORT PREPAREs but neverthless bulk of our dynamic SQL by virtue of even the SHORT PREPAREs is spending 55-60% CPU in doing just PREPARES! This is an overkill and I am just hoping to get them to avoid prepares altogether. [...] 4665 154 6_Re: RI0_24_carol.sutfin@REGIONS.COM31_Fri, 15 May 2009 16:28:10 -0500438_UTF-8 Dean

It's been a bad Friday all around. Not everyone over 60 is that set in their ways.

I love RI on a database as long as it is not over done.

Carol Sutfin Corporate DBA Regions Financial Corp. (205)261-5214 carol.sutfin@regions.com





db46@CHRYSLER.COM Sent by: DB2 Data Base Discussion To List DB2-L@WWW.IDUGDB2-L.ORG Subject [DB2-L] RI 05/15/2009 01:58 PM [...] 4820 552 60_Re: SV: [DB2-L] DB2 z/OS V9 - To small SDSNEXIT and LNKLST ?13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Fri, 15 May 2009 15:20:46 -0700430_iso-8859-1 Hi Olle. Did you take a group outage to do the upgrade? We upgraded one member at a time, with up to a week between members.

We had to fall back to version 8 for a web query that was performing badly, so all we had to do was bring up a v8 member and turn off DDF in all other members. When we got the query fixed, we turned DDF back on in the other members and shut down the v8 member. I love data sharing! [...] 5373 56 6_Re: RI16_mocion@libero.it16_mocion@LIBERO.IT31_Sat, 16 May 2009 02:04:08 -0500514_UTF-8 I saw RI applied rarely, let's say in 1% of all databases I managed. And I'm by far under 70s :-)

With old machine and disks it was a real pain. I worked with a very big database without RI and we hadn't problem for almost 10 years, when it was migrated to UNIX platform (and they spent twice to maintain it, with a potential disaster in one case). I don't know how RI is now , the only database I had was a small one so responding pretty quickly to updates. Probably now RI is better, but I see [...] 5430 30 6_Re: RI10_Todd Burch17_toddburch@MAC.COM31_Sat, 16 May 2009 06:51:59 -0500401_US-ASCII It's quite common to see RI constraints defined in DDL in Service SQL when working problems on the queues.

And, it seems to be a fairly solid feature too - not too many reported problems these days.

Todd DB2 z/OS Support.

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...] 5461 40 25_Re: Question about rebind14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 16 May 2009 21:54:40 +1000455_US-ASCII Look in SDSNCLST(DSNTBIND) as an example of an SP that does binds.

James Campbell

On 13 May 2009 at 21:10, RENUSHARMA@AOL.COM wrote:

> > Hello List > > I have an urgent requirement to run rebind using stored procedure. I > cannot use the sysproc.rebind_routine_package as these packages > are not from store procedure.Urgent help is rqeuired. Please guide > me towards any documentation > > Thanks in advance > Renu > > [...] 5502 102 30_DB2 RI and other DB2 features.0_17_db46@CHRYSLER.COM31_Sat, 16 May 2009 11:02:58 -0400389_US-ASCII They way I best put it is as follows:

Foreign Keys, check constraints, indexes, triggers, and UDF's can be really bad when your doing insert, updates, and deletes due to the overhead.

Foreign Keys, check constraints, indexes, triggers, UDF's, stored procedures, and views are really good when extracting data quickly from the database and database consistency. [...] 5605 70 34_Re: DB2 RI and other DB2 features.16_mocion@libero.it16_mocion@LIBERO.IT31_Sat, 16 May 2009 13:54:03 -0500650_ISO-8859-1 There were cases where reserve parachute interfered with main canopy so worsening the emergency situation.... It depends on skydiver.....:-|

Max Scarpa





db46@CHRYSLER.COM ha scritto: > > They way I best put it is as follows: > > Foreign Keys, check constraints, indexes, triggers, and UDF's can be > really bad when your doing insert, updates, and deletes due to the > overhead. > > Foreign Keys, check constraints, indexes, triggers, UDF's, stored > procedures, and views are really good when extracting data quickly > from the database and database consistency. > > In the 'old' days you had to predict [...] 5676 68 14_DBM1 cpu usage13_Laila hosaini19_lshosaini@YAHOO.COM31_Sun, 17 May 2009 23:03:33 -0700333_iso-8859-1

Hi Dear Listers

Some times DM1 address space ,cpu usage is about 60-70 ,I don't know why? How can I trace it? another problem is Buffer pool HIT ratio,average of buffer pools hit ratio ia about 40%, these 2 topics(DBM1& BUFFER POOLS) are related ???? any guid would be useful. Thanks IN advance. L.S.H [...] 5745 151 41_More presentations from UK DB2 User Group10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 18 May 2009 03:49:14 -0400468_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, May 18th 2009





Here are several presentations from UK DB2 User Group, available on GSEUKDB2 website:



- DSN1LOGP - It could save your job one day (z/OS) by Raymond Bell





- Position Power! DB2 for z/OS Spatial Features by Julian Stuhler [...] 5897 96 71_Antwort: [DB2-L] AVOID PREPAREs by exploiting the local statement cache11_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 18 May 2009 10:08:51 +0200435_ISO-8859-1 what about your ZPARMS ??? Just doing a BIND with KEEPDYNAMIC doesnt help you much without making sure that ZPARM MAXKEEPD > 0 (better yet is 8000) and CACHEDYN = YES. I know that that is then the GLOBAL cache but that is where only the 1st prepare is big the rest are then small. All you get with LOCAL is that the statement strings are kept across commits and then implicit prepares. Not really worth it! go GLOBAL ! [...] 5994 299 23_DB2 V8 Migration failed18_Ujjal Bhattacharya14_UjjalB@NBK.COM31_Mon, 18 May 2009 11:50:08 +0300384_us-ascii We had a failure during DB2 V8 migration CM Mode in Production while trying to BIND DSNTIA81 plan . The CATMAINT job went successfully and when we stopped and restarted DB2 V8 , we got the message

DSNYASCP 'START DB2' NORMAL COMPLETION as expected.

We also received DB2 V8 identity message: ( DSNG007I @ DB2 CATALOG LEVEL (810) CODE LEVEL (810) MODE (C) ) [...] 6294 75 24_Re: revoke sysadm impact19_Sysdba_AHE/CORP/TPG34_Sysdba_AHE/CORP/TPG@GB.TNTPOST.COM31_Mon, 18 May 2009 13:08:18 +0100308_US-ASCII One warning about using SET SYSPARM to change an INSTALL SYSADM - it only actually works if the command is issued from an INSTALL SYSADM id.

Otherwise the command appears to work but the new INSTALL SYSADM does not come into effect and a "warning" message is issued to the DB2 MSTR log. [...] 6370 79 41_Antwort: Re: [DB2-L] revoke sysadm impact11_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 18 May 2009 14:12:49 +0200746_ISO-8859-1 ow! I bet that hurt!





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

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 6450 86 34_Re: DB2 RI and other DB2 features.0_17_db46@CHRYSLER.COM31_Mon, 18 May 2009 08:49:01 -0400 6537 57 24_Re: revoke sysadm impact0_17_db46@CHRYSLER.COM31_Mon, 18 May 2009 08:39:07 -0400 6595 75 41_More presentations from UK DB2 User Group10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 18 May 2009 02:49:14 -0500412_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, May 18th 2009

Here are several presentations from UK DB2 User Group, available on GSEUKDB2 website:

- DSN1LOGP - It could save your job one day (z/OS) by Raymond Bell

- Position Power! DB2 for z/OS Spatial Features by Julian Stuhler [...] 6671 216 18_Re: DBM1 cpu usage23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Mon, 18 May 2009 10:26:36 -0400336_iso-8859-1 60 or 70 what? Over what timeframe?

You can't trace DBM1 usage itself, and why would you want to do that?

Buffer pool hit ratios are interesting to track, but useless as a performance metric.

More IO causes more CPU. Synch IO is charged to the application, while prefetch costs are charged to DBM1. [...] 6888 36 75_Re: Antwort: [DB2-L] AVOID PREPAREs by exploiting the local statement cache11_Sameer Rana21_sameerdrana@GMAIL.COM31_Mon, 18 May 2009 14:55:11 +0000419_windows-1252 Roy , Thanks for your response but as I mentioned that PREPARES ( according to our accounting reports and application trace log ) account for 55% of CPU. I agree on a scale of 1 - 10 , 10 represents FULLPREPARE, 1 represents SHORT PREPARE ( which we are doing everytime ) and 0 represents AVOIDED PREPARE. But why should we spend 55% CPU even on SHORT PREPARES if we can avoid them and save that CPU? [...] 6925 40 23_VSAM to DB2 conversion.11_James Jones19_jamesz900@YAHOO.COM31_Mon, 18 May 2009 16:33:57 +0000557_windows-1252 Anyone have any real life experiences they can share regarding VSAM to DB2 conversion. I at the research stage of this project and I am interested in finding out what tools any one chose or did you use home grown migration. What degree of effort was put in to normalizing the data for DB2 and the amount of source code changes that ended up being required ? Did anyone layer in COMMIT/restart logic into the applications and how much effort that took. Did this effort take longer and cost more than anticipated ? Any feedback appreciated. [...] 6966 176 29_Re-Partitioning Input Desired11_Jeff Agosta20_agost003@MC.DUKE.EDU31_Mon, 18 May 2009 17:17:52 +0000613_windows-1252 Esteemed colleagues - Current scenario, we are z/OS v8 nfm and have a 52 way partitioned Tablespace, partitioned on an application maintained key. The key consists of 12 bytes (1 alpha and 11 numerics) and is used by multiple applictions for key assignment The alpha goes from a-z, A-Z and the numerics from 00000000001 - 99999999999 Originally the ts was partitioned 26 ways (using only upper case alphas A-Z). We had maxed out this scheme and repartitioned this using upper/lower case aphas giving us 52 partitions This was accomplished using reorg unload only. We are soon getting to the 4gb [...] 7143 84 27_Re: VSAM to DB2 conversion.0_33_armando.jorge.arranja@BANCOBPI.PT31_Mon, 18 May 2009 18:22:17 +0100553_us-ascii Be carefull with home made tools and poor normalization of data. There are more than twenty columns named FILLER in production around here.



Armando



_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 7228 30 11_Re: History12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Mon, 18 May 2009 17:38:05 +0000413_windows-1252 ...Raymond, I recently got rid of (don't know why) my old V1.2 SQL guide... a very thin manual (about 1cm) with hardly any functions.

First worked on a DB2 V1.2 which used to abend if we entered dates beyond 1989....

Cheers, Adam

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...] 7259 34 80_AD:IDUG Denver 2009 VSP titled "Bind and Rebind Analysis" presented by Mike Bell9_Eric West25_ewest@HLSTECHNOLOGIES.COM31_Mon, 18 May 2009 18:02:03 +0000356_ISO-8859-1 Ladies and Gentlemen, If you missed Mike Bell’s Presentation titled “Bind and Rebind Analysis” at IDUG Denver 2009, you can now download the presentation by visiting and registering on our Website at www.hlstechnologies.com. If you have and questions or issues that you would like to discuss, please do not hesitate to contact us. Regards, [...] 7294 77 27_Re: VSAM to DB2 conversion.7_Ed Long19_rdhm99a@PRODIGY.NET31_Mon, 18 May 2009 11:19:03 -0700419_us-ascii One I was involved with long ago took the approach that every KSDS was by definition its own table.

Every ESDS was blessed with a key and became its own table.

In this way, phase one of the conversion becomes converting read and write to Select and (Isrt, dlet, updt).

After you get over the big hurdle, you can then go back and start tuning the programs to be more set oriented etc. [...] 7372 224 33_Re: Re-Partitioning Input Desired7_Ed Long19_rdhm99a@PRODIGY.NET31_Mon, 18 May 2009 11:25:50 -0700378_us-ascii I guess I'd reconsider EA given the size task that awaits you and the chances, associated with it, of a very bad day. The EA alternative requires the minimum changes and has the lowest risk.

Management may be uncomfortable with some SMS work but they are going to be positively twitchy about an outage like the one your repartitioning alternatives require. [...] 7597 64 11_Re: History14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 18 May 2009 19:29:55 +0100397_iso-8859-1 Next we'll be nudging each other and saying things like "You remember when CICS abended and it brought down DB2 - and if DB2 abended it brought down CICS???"

Phil G Another-V1.2-er

________________________________

From: DB2 Data Base Discussion List on behalf of Adam Baldwin Sent: Mon 18/05/2009 18:38 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History [...] 7662 93 53_Fwd: Heart of America DB2 User Group meeting reminder10_Dave Churn19_davechurn@GMAIL.COM31_Mon, 18 May 2009 13:35:26 -0500505_ISO-8859-1 Members and Listers,

Our quarterly meeting is fast approaching. On June 8, Bonnie Baker and Terry Purcell will present at the Heart of America DB2 Users Group meeting in Kansas City. Terry is giving two presentations, Stabilizing access paths across rebinds and DB2 z/OS Optimizer: What have you done for me lately? Bonnie is going to be presenting details she found regarding DB2 locks, sorts, and index-only updates and deletes. Bonnie's and Terry's biographies are listed below. [...] 7756 72 55_Re: [Adv] Advance SQL Training - join me in NYC 5/27-2914_Larry Kintisch17_LKint@VERIZON.NET31_Mon, 18 May 2009 14:55:31 -0400563_us-ascii Just an update: this class WILL run in NYC Wed 5/27 thru noon Fri 5/29. It is only scheduled about twice a year so this week is the last week to have your developers registered. Thanks, Larry Kintisch

At 03:55 PM 5/8/2009, you wrote: >Hi Listers, > > I've been teaching DB2 classes as a contract instructor for IBM > for 17 years and hope this IBM workshop will help you and some of > your developers catch up with some advanced techniques. Without > your quick registrations the class will be cancelled! > > May 27-29 "CE130DB2 SQL Workshop [...] 7829 45 14_Installing OSC17_Darren Kilpatrick31_darren.kilpatrick@WELLPOINT.COM31_Mon, 18 May 2009 19:47:36 +0000497_windows-1252 I have installed OSC and I am trying to connect to a DB2 subsystem on z/OS through a DB2 connect gateway. i get this error message. Any suggestions?

Exception Stack Trace: com.ibm.db2zos.osc.exception.OSCException: com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][10333][11649] No license was found. An appropriate license file db2jcc_license_*.jar must be provided in the CLASSPATH setting.

at com.ibm.db2zos.osc.ui.subsystem.ConnectThread.connect (Unknown Source) [...] 7875 149 27_Re: VSAM to DB2 conversion.23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Mon, 18 May 2009 16:01:40 -0400420_iso-8859-1 Ed,

That approach falls in the term PORT - one of my least favorite 4 letter words.

It's an expedient for getting a system converted, but costs often costs several times as much CPU and elapsed for a given workload.

The tune it later approach - never (rarely) happens. There's always enough resources to do it wrong the first time. but never enough to correct the basic flaws later. [...] 8025 77 18_Re: Installing OSC13_David Simpson22_dsimpson@THEMISINC.COM31_Mon, 18 May 2009 16:23:27 -0400473_us-ascii What is your DB2 Connect configuration? Are you trying to go from a client (without DB2 Connect) directly to a z/OS server?

David Simpson Senior Technical Advisor Themis Training dsimpson@themisinc.com http://www.themisinc.com

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Darren Kilpatrick Sent: Monday, May 18, 2009 2:48 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Installing OSC [...] 8103 69 11_Re: History12_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 18 May 2009 23:38:26 +0300397_utf-8 Hi,

Date (DB2 date & time) came on 1.3 On 1.2 we used integer to store them and had assembler functions called from PL1/Cobol to do the math.

Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Adam Baldwin Sent: Monday, May 18, 2009 8:38 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History [...] 8173 206 27_Re: VSAM to DB2 conversion.7_Ed Long19_rdhm99a@PRODIGY.NET31_Mon, 18 May 2009 13:38:09 -0700437_us-ascii I've also been involved with grand redesign versions of the project that collapsed under their own weight of high expectations,unmet dates and deliverables.

In one case, it devolved into a "PORT" and lived happily ever after.

Let me see, the favorite phrase from IDUG last week.....IT DEPENDS.

Edward Long



--- On Mon, 5/18/09, Joel Responsive Systems wrote: [...] 8380 67 18_Re: Installing OSC9_Stan Hoey22_shoey@CIRCLE-GROUP.COM31_Mon, 18 May 2009 21:44:48 +0100532_us-ascii To use the Type4 driver, I had to add the directory containing db2jcc.license.cisuz.jar and db2jcc4.jar to my CLASSPATH system variable.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Darren Kilpatrick Sent: Monday, May 18, 2009 8:48 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Installing OSC

I have installed OSC and I am trying to connect to a DB2 subsystem on z/OS through a DB2 connect gateway. i get this error message. Any suggestions? [...] 8448 101 27_Re: VSAM to DB2 conversion.14_Larry Kintisch17_LKint@VERIZON.NET31_Mon, 18 May 2009 16:59:15 -0400594_us-ascii Hi James, For the benefit of some Listers not familiar with a VSAM to DB2 conversion, let's start from the beginning.

VSAM files were both sequential ["Entry Sequenced"] and Indexed ["Keyed Sequence"]. Many VSAM files from the 1970's were copies of 80-byte "card file" layouts or larger tape file layouts. Many files of either type had multiple record types ["H" in column 1 is a header record; "D" in column 1 is a trailer, etc.]. Most had alternate indexes. It was common to use the COBOL concept of repeating groups [OCCURS nn TIMES] for, say, 12 monthly sales amounts. [...] 8550 89 11_Re: History13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Mon, 18 May 2009 17:19:17 -05001160_UTF-8 I did a series of blogs that detailed most of the DB2 releases

DB2 V1.1 - http://it.toolbox.com/blogs/db2zos/db2-history-101-version-11-22046

DB2 V1.2 - http://it.toolbox.com/blogs/db2zos/db2-history-101-version-12-22083

http://it.toolbox.com/blogs/db2zos/an-addendum-to-mondays-history-101-post-on-db2-v12-22133

DB2 V1.3 - http://it.toolbox.com/blogs/db2zos/db2-history-101-version-13-22097

DB2 V2.1 - http://it.toolbox.com/blogs/db2zos/db2-history-101-version-21-22281

DB2 V2.2 - http://it.toolbox.com/blogs/db2zos/db2-history-101-version-22-23967

DB2 V2.3 - http://it.toolbox.com/blogs/db2zos/db2-history-101-version-23-23968

DB2 V3 - http://it.toolbox.com/blogs/db2zos/db2-history-101-version-3-23969

DB2 V4 - http://it.toolbox.com/blogs/db2zos/db2-history-101-version-4-23970

Isaac Yassin wrote: > Hi, > > Date (DB2 date & time) came on 1.3 > On 1.2 we used integer to store them and had assembler functions called from PL1/Cobol to do the math. > > Isaac Yassin > > -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of [...] 8640 48 33_Re: Re-Partitioning Input Desired11_Jeff Agosta20_agost003@MC.DUKE.EDU31_Mon, 18 May 2009 23:43:07 +0000585_windows-1252 Ed, Thanks for the reply and please know that I TOTALLY am in agreement, but the power one gets when one goes into management can often be unsurmountable for those in the trenches. That being said, I'm still pursuing and would appreciate all the ammo I can get. I'd be especially interested in any personal experiences with EA should you or otjers be willing to share. Also, our table space is defined as LARGE which I understand will greatly impact (negate) an attempt to use EA. Therefore in this case, we'd have to an unload recreate process, however the benefits [...] 8689 85 33_Re: Re-Partitioning Input Desired9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 18 May 2009 19:07:19 -0500544_us-ascii A good test is worth a lot of recommendations.

1. I do not know if type large gives you the 5 byte rid entry in the index so start with dsn1prnt of both ts and index. 2. I do not know of any problems with DSN1COPY from normal to EA datasets but that should be next. Setup a ea tablespace with one partition and try copying from the existing partition 3. if everything works, then new database with new stogroup with high level catalog pointed to EA and DSSIZE 64G is your starting point Then DSN1COPY each partition to the [...] 8775 83 33_Re: Re-Partitioning Input Desired7_Ed Long19_rdhm99a@PRODIGY.NET31_Mon, 18 May 2009 19:12:43 -0700658_us-ascii I've been using EA datasets for several years without incident.

The only sticky bit is getting the ACS routines right and that is pretty straight forward.

Not sure about the DSN1COPY stuff; a test is in order.



Edward Long



--- On Mon, 5/18/09, Jeff Agosta wrote:

> From: Jeff Agosta > Subject: Re: [DB2-L] Re-Partitioning Input Desired > To: DB2-L@WWW.IDUGDB2-L.ORG > Date: Monday, May 18, 2009, 7:43 PM > Ed, > Thanks for the reply and please know that I TOTALLY am in > agreement, but > the power one gets when one goes into management can often [...] 8859 228 92_Antwort: Re: [DB2-L] Antwort: [DB2-L] AVOID PREPAREs by exploiting the local statement cache11_Roy Boxwell16_R.Boxwell@SEG.DE31_Tue, 19 May 2009 06:48:16 +0200472_ISO-8859-1 But you cannot avoid prepares with just local cache being active. To actively avoid prepares you *must* go global.





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 [...] 9088 151 27_Re: DB2 V8 Migration failed11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Tue, 19 May 2009 05:22:47 +0000571_ISO-8859-1 I did dozens of migration to V8 and V9 ( CM) and almost every time the LINKLIST was changed dynamically without any problems. I would suggest you to check the service level of your V7 and also V8 code. I'm always trying to apply the most recent RSU*, HIPER and PRP source IDs on both version before migration. Did you perform all the checks on catalog/directory (DSN1COPY, premigration queries)? Did you make sure that no obsolete threads/utilities were active? If the dump was initiated for 04E abend, you can raise a PMR and ask IBM for explanation ... [...] 9240 190 40_SV: [DB2-L] Looking for some information13_Olle Brostrom25_olle.brostrom@SWEDBANK.SE31_Tue, 19 May 2009 07:38:19 +0200325_iso-8859-1



We are running DB2 9 NFM Our large production system is a 4-way DS group where each member are configured as follows:

Work file database: 8 32K tablespaces of 2GB size each 4 4K tablespace of 2GB each Total size = 24GB

Buffer pools for sorting: 20000 4K buffers 1800 32K buffers [...] 9431 196 27_Re: DB2 V8 Migration failed18_Ujjal Bhattacharya14_UjjalB@NBK.COM31_Tue, 19 May 2009 08:50:55 +0300476_us-ascii Nenad, Thanks for the information. Before migration we ensured there were no active threads in the system and no utilities as well. But there were two irrelevant tablespaces that were in copy pending status. All the health checks were performed ( DSNICOPY with PARM CHECK for Catalog & Directory , DSN1CHKR & Check Index for Catalogs & Directory) and we got return code as 0 even before migration with DB2 down and after Migration. CATMAINT was also successful. [...] 9628 223 18_Re: DBM1 cpu usage13_Laila hosaini19_lshosaini@YAHOO.COM31_Mon, 18 May 2009 23:29:28 -0700478_iso-8859-1 Dear Joel Thanks a lot;;; you help me a lot bye

--- On Mon, 5/18/09, Joel Responsive Systems wrote:



From: Joel Responsive Systems Subject: Re: [DB2-L] DBM1 cpu usage To: DB2-L@WWW.IDUGDB2-L.ORG Date: Monday, May 18, 2009, 6:56 PM









60 or 70 what? Over what timeframe?

You can't trace DBM1 usage itself, and why would you want to do that? [...] 9852 28 11_Re: History12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Tue, 19 May 2009 06:40:27 +0000411_windows-1252 Shows how my memory is going Isaac. I thought that we had date in 1.2... The only constant throughout my 21 years with DB2 is that any time there's a problem on the machine, the MVS Sysprogs blame DB2!!! Maybe one day....

Cheers, Adam

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...] 9881 239 27_Re: DB2 V8 Migration failed11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Tue, 19 May 2009 07:10:47 +0000663_ISO-8859-1 What about DB2 maintenance level ? What about location ( LMOD/CSECT) where the abend occurred? You can use that to search technical support for similar symptoms ....

Regards, Nenad



On Tue, 19 May 2009 08:50:55 +0300, Ujjal Bhattacharya wrote:

>Nenad, > Thanks for the information. Before migration we ensured there >were no active threads in the system and no utilities as well. But there >were two irrelevant tablespaces that were in copy pending status. All >the health checks were performed ( DSNICOPY with PARM CHECK for Catalog >& Directory , DSN1CHKR & Check Index for Catalogs & Directory) and [...] 10121 87 27_Re: VSAM to DB2 conversion.9_Stan Hoey22_shoey@CIRCLE-GROUP.COM31_Tue, 19 May 2009 09:04:02 +0100586_us-ascii Jim,

I agree with virtually everything contributed by other listers to your question. However, this is as much a business issue as it is a technical issue.

You cannot migrate a VSAM file to DB2 using a transparency product, and expect to achieve the same performance and CPU usage compared to an application that is designed to run on a relational database. However, using a transparency product assists a VSAM to DB2 migration project by reducing the risk. This is because you migrate on a file by file basis and do not have to change any application code. [...] 10209 292 27_Re: DB2 V8 Migration failed18_Ujjal Bhattacharya14_UjjalB@NBK.COM31_Tue, 19 May 2009 11:20:36 +0300318_us-ascii Thanks for sharing your thoughts.

We have applied all the PTFs recommended by IBM including the Fallback PTF. For a change we did not go for selective PTF application.

Anyway we have raised a PMR with IBM and It's been a long time I heard from the DB2 Level 2 Support.

Regards Ujjal [...] 10502 28 33_Re: Re-Partitioning Input Desired12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Tue, 19 May 2009 08:34:22 +0000596_windows-1252 Jeff, you say "but scanning every partition for each unload statement is excessive" - maybe I've missed something when reading your post but have you tried UNLOAD (IBM) with PART specified?

Cheers, Adam

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 10531 66 47_CREATE/ALTER STOGROUP with VOLUMES("*","*","*")11_John Matear27_John.Matear@BANKWEST.COM.AU31_Tue, 19 May 2009 16:30:22 +0800395_us-ascii Hello, Has anybody used multiple * on the CREATE or ALTER STOGROUP statement to try and make DB2 datasets go multi-volume? I was under the impression that one * was enough to inform SMS to manage these datasets and that various SMS rules would dictate if the DB2 datasets went multi-volume or not. My storage guys are saying that the DBAs need to specify if DB2 goes multi-volume. [...] 10598 335 27_Re: DB2 V8 Migration failed14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 19 May 2009 10:32:01 +0100382_iso-8859-1 Not that this helps you current question, but I am left wondering WHY you let the DB2 started tasks pick up their load modules from the Linklist? Having the relevant DB2 libraries STEPLIBbed to their startup JCL procedures means you have much more control (and you wouldn't now be thinking "I wonder if DB2 was actually picking up the RIGHT DB2 load libraries.....) [...] 10934 732 27_Re: DB2 V8 Migration failed12_Paul Ogborne19_paulogborne@AOL.COM31_Tue, 19 May 2009 05:55:16 -0400408_us-ascii Hi Phil,

Your argument for STEPLIBing is one I always use too.? Since V9 I like to STEPLIB sdsnexit and sdsnload (in that order).? This approach also makes life a lot easier when migrating to new versions where multiple subsystems exist in the same?lpar. The counter argument, always strongly presented by my z/OS systems programmer is that the linklist provides for better performance. [...] 11667 903 35_SV: [DB2-L] DB2 V8 Migration failed13_Olle Brostrom25_olle.brostrom@SWEDBANK.SE31_Tue, 19 May 2009 12:17:05 +0200508_iso-8859-1 I also heard that z/OS sysprogs says that the linklist provides better performance, but as far as I understand DB2 load the code once when DB2 restarts with no further access to SDSNLOAD, anyone agree?

Best Regards/Med vänliga hälsningar Olle Broström



________________________________ Från: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] För Paul Ogborne Skickat: den 19 maj 2009 11:55 Till: DB2-L@WWW.IDUGDB2-L.ORG Ämne: Re: [DB2-L] DB2 V8 Migration failed [...] 12571 457 27_Re: DB2 V8 Migration failed11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Tue, 19 May 2009 10:33:14 +0000414_ISO-8859-1 As for "better performance" argument : I believe that DB2 loads its modules only once at startup so it doesn't make much difference from where the modules are loaded.

Had one example where some STEPLIBed LE modules were called many times in the batch job and loaded every time from the DASD. Removing them form the STEPLIB enabled loading from the linklist and made a huge difference there. [...] 13029 43 96_Re: Antwort: Re: [DB2-L] Antwort: [DB2-L] AVOID PREPAREs by exploiting the local statement cache11_Sameer Rana21_sameerdrana@GMAIL.COM31_Tue, 19 May 2009 10:36:49 +0000545_windows-1252 Oh absolutely! GLOBAL we must be, whether in this world or DB2:) And as you can see that SHORT PREPARES are incrementing for every prepare in our system, which suggests atleast the copy in GLOBAL CACHE is being reused. This is also shown in Dyn statement cache SQL stats screen. But my focus is now on making every EXECUTE use the local copy of stmt in LOCAL CACHE even past COMMIT points ( and I know you can do it ) to start seeing the AVOIDED PREPAREs start ticking. The fact that we are not seeing a single avoided prepare [...] 13073 28 27_Re: DB2 V8 Migration failed11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Tue, 19 May 2009 10:40:00 +0000461_- > The counter argument, always strongly presented by my z/OS systems programmer is that the linklist provides for better performance.

1. How many times is the module fetched? Once, right? 2. You can use LLA/VLF for more than just the link list.



- Too busy driving to stop for gas!

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...] 13102 25 33_Re: Re-Partitioning Input Desired11_Jeff Agosta20_agost003@MC.DUKE.EDU31_Tue, 19 May 2009 10:51:30 +0000777_windows-1252 Adam, Thanks for the tip and I do see that now. Will make note of that option. Tku, Jeff A

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________

IDUG North America 2008 Attendee Testimonial- "The technical content of the conference was excellent and useful. Not only are the "how-to" sessions helpful, it's very beneficial to learn about new features in upcoming releases." _____________________________________________________________________ 13128 62 32_DB2 z/OS - SECQTY 0, means what?15_Douwe van Sluis21_d.b.van.sluis@HOME.NL31_Tue, 19 May 2009 14:18:35 +0200451_iso-8859-1 Dear list,

We had a problem with DB2's Workfile Database in V9. We created new spaces for the Workfile Database using DSNTWFG. We used an user enhanced version of the DSNTWFG REXX. The adjustment we made is to set SECQTY 0. We don't want our Workfiles to extent.

Suddenly we got a low space warning on our SMS Storage Group. We discovered that we had lots of secondary dataset for the Workfile Spaces (A002, A003, etc.). [...] 13191 101 51_Re: CREATE/ALTER STOGROUP with VOLUMES("*","*","*")15_Douwe van Sluis21_d.b.van.sluis@HOME.NL31_Tue, 19 May 2009 14:21:35 +0200678_us-ascii One star is enough. You need to setup a SMS Dataclass to use multiple volumes.

Vriendelijke groet, Douwe van Sluis



----- Origineel bericht ----- Van: John Matear Datum: dinsdag, mei 19, 2009 10:41 Onderwerp: [DB2-L] CREATE/ALTER STOGROUP with VOLUMES("*","*","*") Aan: DB2-L@WWW.IDUGDB2-L.ORG



> Hello, > Has anybody used multiple * on the CREATE or ALTER STOGROUP statement > to > try and make DB2 datasets go multi-volume? I was under the impression > that > one * was enough to inform SMS to manage these datasets and that various > SMS rules would dictate if the DB2 datasets went multi-volume [...] 13293 54 27_Re: VSAM to DB2 conversion.12_Davis, Kriss17_kpdavis@ILSTU.EDU31_Tue, 19 May 2009 07:46:21 -0500514_us-ascii One thing to keep in mind. The JCL for batch programs will change if you run your new DB2 programs under the TSO monitor. This seems to be the way most DB2 shops I know about run batch DB2 COBOL programs. And once you start running COBOL programs under TSO, you will need to deal with issues like how abend and return codes are passed back to the operating system. They can easily not be passed back and then your batch workload scheduler will believe the program completed normally when it did not. [...] 13348 64 43_DB2 z/OS: Data Sharing Migration Techniques13_Olle Brostrom25_olle.brostrom@SWEDBANK.SE31_Tue, 19 May 2009 13:52:09 +0000364_windows-1252 Hi Cathy, I think it's a good idea to start a new thread on this topic.

I'm impressed over your migration technique. My vision would also be to run migration together with production load on the other members, but I don't dare! we are always taking a group outage in on both migration steps (CM and NFM), we are just passing through ENFM. [...] 13413 159 51_Re: CREATE/ALTER STOGROUP with VOLUMES("*","*","*")0_19_mike.holmans@BT.COM31_Tue, 19 May 2009 15:17:37 +0100290_us-ascii One star is enough IF that is how the storage admin people in your shop have configured it. Our storage admin guys have not configured SMS that way, and I think I just about understood their explanation of why - but I'm not going to attempt to garble it by repeating it here. [...] 13573 25 18_Re: Installing OSC17_Darren Kilpatrick31_darren.kilpatrick@WELLPOINT.COM31_Tue, 19 May 2009 14:31:34 +0000794_windows-1252 where did you update those variables? in the db2profile on DB2 Connect? If so, what did the code look like?

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________

IDUG North America 2008 Attendee Testimonial- "The technical content of the conference was excellent and useful. Not only are the "how-to" sessions helpful, it's very beneficial to learn about new features in upcoming releases." _____________________________________________________________________ 13599 116 11_Date format16_Wallace, Stephen25_stephen.wallace@LANDG.COM31_Tue, 19 May 2009 15:35:58 +0100387_us-ascii We have a modified version of DSNTIAUL which unloads dates in the EUR format dd.mm.yyyy rather than using our site's date exit. I suspect that this program was precompiled using the parameter DATE(EUR), how can I prove this, is the date format held in the catalog?

Thanks, Steve Wallace Mainframe DBA Legal & General Assurance Society Work: 01737 374308 (7100 4308) [...] 13716 140 27_Re: VSAM to DB2 conversion.14_Larry Kintisch17_LKint@VERIZON.NET31_Tue, 19 May 2009 10:42:24 -0400575_us-ascii Hi Stan and Listers,

Stan's comments about performance are valuable and his point about the usual need to re-write VSAM applications is correct.

As I teach IBM's course "CV960 Application Performance and Tuning" or mine and Tapio's "TL120 Cost-Saving Database Index Design", I emphasize avoiding the WORST DB2 access path: read an entire row into the program and check to see if it's what you want; if not get the next. This VSAM-style [or even BSAM/QSAM-style] search code was common 30 years ago. VSAM had limited search via index capabilities! [...] 13857 35 27_Re: VSAM to DB2 conversion.5_anand19_mahadea@LABCORP.COM31_Tue, 19 May 2009 14:50:56 +0000399_ISO-8859-1 To reiterate Ed's question, why do it? Maybe it is a done deal in your case, would you like share what is the driver? Is it because non MVS apps need access to the VSAM datasets? Is VSAM getting in the way of running a 24 hour shop and you don't like the Sharelevel options or IAM or those alternative? Are you planning to migrate off the z box and this is a step in that direction? [...] 13893 29 51_Re: CREATE/ALTER STOGROUP with VOLUMES("*","*","*")11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Tue, 19 May 2009 15:05:51 +0000330_- >One star is enough. You need to setup a SMS Dataclass to use multiple volumes.

No you don't. You can specify multiple volumes, overriding your dataclass, by specifying multiple (or fewer) asterisks. You are rarely stuck with having to do it by only the dataclass.



- Too busy driving to stop for gas! [...] 13923 53 21_EXPLAIN(NO) - Why????14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 19 May 2009 16:18:11 +0100416_iso-8859-1 Hi all,

A thought occurred to me whilst I was presenting at IDUG in Denver

Given that DB2 does NOT produce an error if you do an EXPLAIN(YES) without a corresponding PLAN_TABLE to dump the rows into, WHY is there an EXPLAIN(NO) option?

I guess some developers might think they want to bind without an explain, but in any real situation surely all binds ought to be EXPLAIN(YES)? [...] 13977 214 33_Re: Re-Partitioning Input Desired10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 19 May 2009 11:29:53 -0400467_us-ascii I have twice had to convert from old partitioned to EA partitioned, because of the 4GB limit. It was disruptive, because a Drop / Create is required, but I did not experience any problems. One TS has 254 partitions and the other had 12. In neither case was changing the partitioning key or the number of partitions a viable alternative. The storage management group defined an EA enabled pool for each TS and the creation of the new TS was a non-event. [...] 14192 104 25_Re: EXPLAIN(NO) - Why????10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 19 May 2009 11:37:19 -0400448_us-ascii I could easily be wrong, but it seems to me that the bind would fail if you specified EXPLAIN(YES) and the PLAN_TABLE was not available.

Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Grainger, Phil Sent: Tuesday, May 19, 2009 11:18 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] EXPLAIN(NO) - Why???? [...] 14297 99 27_Re: VSAM to DB2 conversion.14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Tue, 19 May 2009 10:41:37 -0500467_us-ascii You only wish that these coding techniques were history unfortunately they are not. A lot of Java code does exactly that - get a row by primary key (preferably a surrogate key) and make sure to get every column. I/O routines of old days go by fancy names of Container Managed Persistance or persistance framework. Any change to these i/o layers is considered detrimental to good OO design, portability, maintainability etc. But ... it's so cool. Khalid [...] 14397 114 11_Re: History10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 19 May 2009 11:44:03 -0400497_us-ascii And any real SysProg had a green card and a good dozen 80-column cards in his pocket (behind the pocket protector)! And a green card wasn a S/360 Reference Summary, and not an immigration document!

Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Grainger, Phil Sent: Monday, May 18, 2009 2:30 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History [...] 14512 101 25_Re: EXPLAIN(NO) - Why????14_Benjamin Kniaz26_Benjamin.X.Kniaz@CHASE.COM31_Tue, 19 May 2009 10:46:48 -0500491_us-ascii Nope that is correct. It happened to me about 20 seconds ago!

Nicely timed question

Ben

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roger Hecq Sent: Tuesday, May 19, 2009 11:37 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] EXPLAIN(NO) - Why????

I could easily be wrong, but it seems to me that the bind would fail if you specified EXPLAIN(YES) and the PLAN_TABLE was not available. [...] 14614 159 11_Re: History14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 19 May 2009 11:49:41 -0400349_us-ascii Programmers had sheets with 80x24 grids on 'em for coding (Comments, A and B margins highlighted); green plastic IBM flowchart stencils; 132x60 grid sheets that looked like graph paper, for report design. And for a deck of punched cards, you'd put a marker slash diagonally across the top to make re-sorting easier if you dropped 'em. [...] 14774 153 25_Re: EXPLAIN(NO) - Why????14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 19 May 2009 16:47:01 +0100532_iso-8859-1 I must admit, I haven't tried it lately - but last time I did try, it didn't even produce a warning

HOWEVER

You made me go and read the V8 manual, where it says :-

"If owner.PLAN_TABLE does not exist at bind time, the value of the option VALIDATE determines the success of the bind operation. v If the value is BIND, the bind fails. v If the value is RUN, DB2 checks to see if the table exists again at run time. If it still does not exist, the plan or package cannot run. If it does exist, DB2 [...] 14928 190 25_Re: EXPLAIN(NO) - Why????14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 19 May 2009 16:52:27 +0100550_iso-8859-1 Whilst we are on this subject, in Terry Purcells presentation at IDUG last week, he talked of a change to DB2 9 in that information IS planted in the directory about access paths EVEN IF YOU SAY EXPLAIN(NO) and this information can be extracted with OSC

This means, in DB2 9, you really CAN see the access path choices made by DB2 at bind time - on V8 and earlier, the only way to get access path data for an EXPLAIN(NO) plan was to rebind it with EXPLAIN(YES), which means you may not really be seeing the correct access path [...] 15119 294 11_Re: History13_Michael Ebert18_mebert@AMADEUS.COM31_Tue, 19 May 2009 15:58:59 +0000316_ISO-8859-1 This reminds me of one list I was on a long time ago, I think it was called MVS-MAIN or something like that. They had virtually nothing except talk of the kind

- "do you remember the days when disks were drums?" - "yeah, that was when I programmed the onboard computer of the lunar lander"... [...] 15414 34 55_DB2 ESE v9.5 on z/VM and SuSE 10 - memory sizing tips ?14_Bruce Lightsey25_Bruce.Lightsey@ITS.MS.GOV31_Tue, 19 May 2009 11:23:43 -0500367_US-ASCII first attempt at bring up an ESE on z/VM and SuSE 10 - grabbed v9.5 fp3b and installed it, but even the toolsdb bufferpools won't start due to lack of memory ( it IS a small vm to start with ). DB2 starts and I can connect to the database, but there are a slew of error messages in the db2diag.log where the bufferpools fail due to insufficient memory. [...] 15449 399 11_Re: History13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 19 May 2009 11:36:53 -0500587_ISO-8859-1 IBM-MAIN is still around... and going strong...

http://bama.ua.edu/archives/ibm-main.html

Willie

Michael Ebert wrote: > > This reminds me of one list I was on a long time ago, I think it was > called MVS-MAIN or something like that. They had virtually nothing > except talk of the kind > > - "do you remember the days when disks were drums?" > - "yeah, that was when I programmed the onboard computer of the lunar > lander"... > > Those were the days :-) > > Dr. Michael Ebert > DB2 & Oracle Database Administrator > aMaDEUS Data Processing > Erding [...] 15849 92 27_Re: VSAM to DB2 conversion.14_Larry Kintisch17_LKint@VERIZON.NET31_Tue, 19 May 2009 13:25:20 -0400564_us-ascii Hi Kriss and Khalil,

Thanks for the added "worries" about JCL and batch that I neglected. And you both raised the question of "I/O modules" -- subprograms that are called to read and entire row of DB2 data by key and pass the data over to the "VSAM program" as a VSAM record structure. This is SECOND WORST access path for DB2 but may be marginally acceptable for single row access by key. What all listers need to understand is that VSAM [and BSAM/QSAM] reads into memory an ENTIRE RECORD and the COBOL I/O area maps the fields. Compare this [...] 15942 191 25_Re: EXPLAIN(NO) - Why????13_David Simpson22_dsimpson@THEMISINC.COM31_Tue, 19 May 2009 13:39:12 -0400530_us-ascii How 'bout unit test environments that have almost no real data. Explains here don't mean much anyway and with developers binding every few minutes your plan table (and the 14 other explain tables in V9) could end up bigger than your test database.

I'm a big fan of binding with EXPLAIN(YES) in any environment that produces a meaningful explain and EXPLAIN(NO) where it doesn't. I've had development plan tables fill up after years of binding bringing development to a halt (binds fail) until we clean it up. [...] 16134 219 11_Re: History10_Roger Hecq18_Roger.Hecq@UBS.COM31_Tue, 19 May 2009 13:55:13 -0400506_us-ascii And I still have some of all of them, plus a few Algol manuals, etc.

I wish I'd kept some of the keychains that I made from the connectors for the 407 accounting machine that I worked on in college

Roger Hecq MF IB USA DB Support 203-719-0492 / 19-337-0492

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: Tuesday, May 19, 2009 11:50 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History [...] 16354 87 59_DFSMSdss RESTORE FULL VOLUMES and no ICF catalog to match !12_Mark Vickers26_MarkVickers@GROCERYBIZ.COM31_Tue, 19 May 2009 13:01:51 -0500365_US-ASCII I am testing my fallback (full restore) from v8 NFM to CM and hit a problem....

For my test subsystem, I did full volume backups and now subsequent restores using DFSMSdss and forgot to backup my ICF user catalog !

Not all the datasets get an ICF catalog error, so I was wondering if anyone has any ideas how I can get this cleaned up ? [...] 16442 252 37_Using the RAND() function: Endpoints?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 19 May 2009 14:04:06 -0400317_us-ascii Hello, all. I'm using the RAND() to generate random values and have run into an interesting question.

Suppose I wish to generate values from 1 to 10 with equal likelihood (uniform distribution) and no chance of generating any other values. RAND() would seem at first glance to be ideal for this: [...] 16695 539 41_Re: Using the RAND() function: Endpoints?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 19 May 2009 14:07:27 -0400732_us-ascii Oh, should anyone be interested; I'm using the construct below to generate test data





WITH UNIFORM_DISTRIBUTION (LEVEL, SAMPLE_VAL)

AS

(SELECT 1, 1 FROM SYSIBM.SYSDUMMY1

UNION ALL

SELECT LEVEL + 1, INTEGER(RAND() * 10)

FROM UNIFORM_DISTRIBUTION

WHERE LEVEL < 100000

)

SELECT SAMPLE_VAL, COUNT(*)

FROM UNIFORM_DISTRIBUTION

GROUP BY SAMPLE_VAL

;





________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: Tuesday, May 19, 2009 2:04 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Using the RAND() function: Endpoints? [...] 17235 263 26_Re: [fluff][DB2-L] History14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 19 May 2009 14:10:08 -0400492_us-ascii Somewhere in Aetna's Middletown office, someone has the "crest" from an IBM S/360 -- a big ol' bar of polished looks-like-aluminum with "IBM System/360" in big painted IBM-font letters on it. Best piece of scrap-memorabilia I've ever laid eyes on.

--Phil

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roger Hecq Sent: Tuesday, May 19, 2009 1:55 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History [...] 17499 89 15_Re: Date format14_Larry Kintisch17_LKint@VERIZON.NET31_Tue, 19 May 2009 14:17:02 -0400447_us-ascii Hi Steve,

I don't believe its a DSNTIAUL issue. When DB2 for z/OS is installed, zparm panel DSNTIP4 sets the "standard" DATE and TIME formatting for output. The SQL you request, such as SELECT PREMIUM_DATE,... should be revised to SELECT CHAR(PREMIUM_DATE,ISO),...

Hope that helps.

Larry Kintisch Pres. ABLE Information Services 845-353-0885 http://www.DBIndexDesign.com

At 10:35 AM 5/19/2009, you wrote: [...] 17589 950 41_Re: Using the RAND() function: Endpoints?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 19 May 2009 14:18:18 -0400657_us-ascii ...and I seem to have almost answered my own question: using LEVEL < (one million) gets me no occurrences of 10 as a SAMPLE_VAL:

WITH UNIFORM_DISTRIBUTION (LEVEL, SAMPLE_VAL)

AS

(SELECT 1, 1 FROM SYSIBM.SYSDUMMY1

UNION ALL

SELECT LEVEL + 1, INTEGER(RAND() * 10)

FROM UNIFORM_DISTRIBUTION

WHERE LEVEL < 1000000

)

SELECT SAMPLE_VAL, COUNT(*)

FROM UNIFORM_DISTRIBUTION

GROUP BY SAMPLE_VAL

;

---------+---------+---------+---------+-----

SAMPLE_VAL

---------+---------+---------+---------+-----

0 99612

1 100283

2 100128 [...] 18540 390 11_Re: History13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 19 May 2009 11:26:37 -0700383_us-ascii Yes, they are -- lots of good information if you don't mind 100 pieces of email a day. And they can turn almost any topic into the one Dr. Ebert cited.

________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero Sent: Tuesday, May 19, 2009 9:37 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: History [...] 18931 87 41_Re: Using the RAND() function: Endpoints?11_Nick Cianci19_ncianci@AU1.IBM.COM31_Wed, 20 May 2009 04:36:13 +1000393_UTF-8 Phil, Just came off a Late night deployment so might not be firing on all cylinders.

But if you said RAND()*0.999999999 ... whilst you reduce your result set a bit, you guarantee not to hit 1 (providing you don't hit a rounding error)

Statistically if you can hit 1 you will (usually at the worst possible moment) eventually, it may just be that it's very improbable. [...] 19019 66 11_Re: History12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 19 May 2009 21:40:50 +0300571_utf-8 Hi,

Used to it - I think they teach the "blame it on DB2" in sysprog course ;-)

Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Adam Baldwin Sent: Tuesday, May 19, 2009 9:40 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History

Shows how my memory is going Isaac. I thought that we had date in 1.2... The only constant throughout my 21 years with DB2 is that any time there's a problem on the machine, the MVS Sysprogs blame DB2!!! Maybe one day.... [...] 19086 246 41_Re: Using the RAND() function: Endpoints?15_Tony Provenzola27_Anthony.G.Provenzola@KP.ORG31_Tue, 19 May 2009 11:52:30 -0700621_ISO-8859-1 In general, with RANDOM functions, I believe that the result is between 0 and 1 EXCLUSIVE. I don't think that you would actually ever get a 0 or a 1. If you were rounding instead of truncating, then you could have a problem.



NOTICE TO RECIPIENT: If you are not the intended recipient of this e-mail, you are prohibited from sharing, copying, or otherwise using or disclosing its contents. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and permanently delete this e-mail and any attachments without reading, forwarding or saving them. Thank [...] 19333 98 18_ordering V9 (z/OS)15_Chris Hoelscher21_choelscher@HUMANA.COM31_Tue, 19 May 2009 15:02:52 -0400319_US-ASCII comparing what we installed for V8 vs what is orderable for V9 - I note that the following V8 FMID is not orderable for V9

HDB881A DB2 ONLINE HELP



I am not sure exactly what this piece entails, but is the functionality of this piece rolled into something else? or has it disapeared? [...] 19432 28 11_Re: History11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Tue, 19 May 2009 19:08:30 +0000449_- >And they can turn almost any topic into the one Dr. Ebert cited.

There is a rule (by I forget who), that any topic on IBM-Main will eventually devolve into something that happened in the 1960's.

That's what the delete button is for!

- Too busy driving to stop for gas!

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...] 19461 47 49_Job post: Senior DBA wanted in Northwest Arkansas9_Ajay Sahu20_ajay_sahu@JBHUNT.COM31_Tue, 19 May 2009 19:02:43 +0000553_windows-1252 Are you an experienced database administrator? Interested in moving to beautiful and dynamic Northwest Arkansas? If so, please apply to our ad on careerbuilder.com. Search for "database administrator" in zip code 72745. The company name is JBHunt. More details at http://www.careerbuilder.com/JobSeeker/Jobs/JobDetails.aspx? Job_DID=J8F3P96VJGZ0SJ89V8L&siteid=cb_emailjob_US

Northwest Arkansas is a family friendly place with good public schools and temperate weather. http://www.jbhunt.com/jobs/lifewithjbhunt/livinginnwa.html [...] 19509 238 22_Re: ordering V9 (z/OS)13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 19 May 2009 12:12:25 -0700519_us-ascii The elements in that FMID are the bookmanager books, shelves, and indexes. IBM is abandoning bookmanager for DB2 documentation, although the DB2 9 manuals are available in bookmanager format on the documentation CD.

As soon as there are no more bookmanager books for DB2, I will get a job as a z/OS sysprog. I have tried to use the information center -- it is soooo frustrating to find what I want when I know exactly which manual it's in, but I'm forced to wade through irrelevant search results. [...] 19748 663 41_Re: Using the RAND() function: Endpoints?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 19 May 2009 15:20:03 -0400371_us-ascii If that's the case it'd be nice if someone mentioned it in the manual. The range of seed values appears to be 1 to 2GB, so I'd think that the endpoints might be encountered at a frequency of 2/2GB, which means we're unlikely to encounter them even if they're possible. But a flat "yes or no" on endpoints should be part of the documentation. In my opinion. [...] 20412 254 41_Re: Using the RAND() function: Endpoints?14_Larry Kintisch17_LKint@VERIZON.NET31_Tue, 19 May 2009 15:31:42 -0400435_iso-8859-1 Hi Phil, In your iterative Select, try: SELECT LEVEL + 1, 1+(INTEGER(RAND() * 10)

By the way, I generated a 10 million-row data warehouse test fact table and dimension tables on my PC "DB2 Express-C" using ideas from the IBM Press Blue Book "DB2 EXPRESS: Easy Development and Administration", [ISBN 013146397-7] section 9.3 Generating Sample Data. Version 9z also supports the OLAP Row_number() Over() function. [...] 20667 88 42_Full Restore and no ICF catalog to match !12_Mark Vickers26_MarkVickers@GROCERYBIZ.COM31_Tue, 19 May 2009 14:37:44 -0500365_US-ASCII I am testing my fallback (full restore) from v8 NFM to CM and hit a problem....

For my test subsystem, I did full volume backups and now subsequent restores using DFSMSdss and forgot to backup my ICF user catalog !

Not all the datasets get an ICF catalog error, so I was wondering if anyone has any ideas how I can get this cleaned up ? [...] 20756 360 11_Re: History7_Ed Long19_rdhm99a@PRODIGY.NET31_Tue, 19 May 2009 12:59:21 -0700566_iso-8859-1 I couldn't digest the bs anymore so I digest the whole day into one handy bite sized blob. Goes down better with a Sam Adams.

Edward Long

--- On Tue, 5/19/09, Taddei, Cathy wrote:

From: Taddei, Cathy Subject: Re: [DB2-L] History To: DB2-L@WWW.IDUGDB2-L.ORG Date: Tuesday, May 19, 2009, 2:26 PM





Yes, they are -- lots of good information if you don't mind 100 pieces of email a day. And they can turn almost any topic into the one Dr. Ebert cited. [...] 21117 141 47_Re: DB2 z/OS: Data Sharing Migration Techniques13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 19 May 2009 13:02:20 -0700503_us-ascii Hi Olle. Our production group operates with 2 regular members and a spare, all configured identically (bufferpools, log sizes, zparms, etc.). We are relatively new to data sharing (since October 2007), so we still have a "prime" DB2 member which runs the bulk of our online and batch workload. I run catmaint in the "non-prime" DB2 member during a slow period. However, this will be changing soon, so our 2 regular members will be equally busy. Then I'll just choose one to upgrade first. [...] 21259 132 11_Re: History13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 19 May 2009 15:10:21 -0500584_ISO-8859-1 That reminds me of time I was working on a 2311 and....

Just joking... I'm way too young to remember 2311s...

Willie

Ted MacNEIL wrote: >> And they can turn almost any topic into the one Dr. Ebert cited. >> > > There is a rule (by I forget who), that any topic on IBM-Main will eventually devolve into something that happened in the 1960's. > > That's what the delete button is for! > > - > Too busy driving to stop for gas! > > _____________________________________________________________________ > > * IDUG 09 Denver, CO, USA * May 11-15, 2009 [...] 21392 432 43_Re: ordering V9 (z/OS) [slightly off topic]14_Chad A. Walmer19_Cwalmer@RITEAID.COM31_Tue, 19 May 2009 16:17:53 -0400583_us-ascii Cathy, I know this conversation (debate?) has come up before but I really like the Information Center and rarely use the Book Manager documentation any more (mostly just for the DB2 Diagnostic manual and some of the z/OS system manuals.) Are you aware that you can scope the topics/books that you're searching from the Infocenter? Just choose the Search scope link next to the Go button, click on the New button, and then select which books/topics you want to search. After selecting the topics, choose a name for the list and click Ok. Now you can choose to only look [...] 21825 27 11_Re: History11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Tue, 19 May 2009 20:19:55 +0000400_- >That reminds me of time I was working on a 2311 and....

At the risk of continuing an O/T thread. The first machine I worked on was a 3033, and the disk was 3330, with 3400 (not 3420) drives.

- Too busy driving to stop for gas!

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...] 21853 412 43_Re: ordering V9 (z/OS) [slightly off topic]13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 19 May 2009 13:35:09 -0700355_iso-8859-1 Hi Chad. Thanks for the suggestions. I had used the search scope, but found it a PITA to set up and still gave extraneous results. But I guess I didn't give it enough of a chance, I suppose I should set up several lists as you have done, and bookmark the manuals I use most. Maybe I'll do that in v-next (while I'm updating my résumé). :) [...] 22266 307 41_Re: Using the RAND() function: Endpoints?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 19 May 2009 16:39:33 -0400349_us-ascii Larry, your iterative-select correction is fine if I don't want zeroes, thanks. I'll take a look at that blue book, but I'm getting my money from working as a z/OS DB2 and IMS DBA at present so it won't be my first read. OTOH, Row_number() over() sounds interesting and I'll look into it for its potential for my current customers :-) [...] 22574 251 22_Re: ordering V9 (z/OS)13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 19 May 2009 15:41:44 -0500353_ISO-8859-1 What you need to do is get a copy of Information Center loaded down to your workstation or server. It's extremely cool. You get to do everything you can do using Information Center on the web without having to be connected. It even comes with an update feature so you workstation based copy can stay as fresh of the web based version... [...] 22826 134 11_Re: History13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 19 May 2009 15:43:50 -0500531_ISO-8859-1 I think this O/T thread is doing just fine... and as long as I'm following AND participating, I don't think is will be stopped because I think talking history is good every once in a while...

Willie BTW, List Moderator and List Sysop



Ted MacNEIL wrote: >> That reminds me of time I was working on a 2311 and.... >> > > At the risk of continuing an O/T thread. > The first machine I worked on was a 3033, and the disk was 3330, with 3400 (not 3420) drives. > > - > Too busy driving to stop for [...] 22961 238 27_Re: VSAM to DB2 conversion.9_Stan Hoey22_shoey@CIRCLE-GROUP.COM31_Tue, 19 May 2009 21:45:06 +0100458_us-ascii Khalid

tools like CICS VT Transparency will not change the world and there are obvious inefficiencies with a SELECT * from taba approach (which is why the product doesn't do it this way). In an ideal world, businesses can afford to wait for legacy systems to be modernised, whatever it costs. Looking out of my window, the world looks less than ideal. As a result, transparency technology has its place despite its apparent limitations. [...] 23200 271 22_Re: ordering V9 (z/OS)7_Ed Long19_rdhm99a@PRODIGY.NET31_Tue, 19 May 2009 13:47:20 -0700472_iso-8859-1 My experience is similar to Cathy's; Info Center adds limited value and slows me down. I jump to the manuals via LOOKAT. I guess this makes me hardcore or old school. Let us pray that LOOKAT doesn't go away.

Edward Long

--- On Tue, 5/19/09, Willie Favero wrote:

From: Willie Favero Subject: Re: [DB2-L] ordering V9 (z/OS) To: DB2-L@WWW.IDUGDB2-L.ORG Date: Tuesday, May 19, 2009, 4:41 PM [...] 23472 307 41_Re: Using the RAND() function: Endpoints?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 19 May 2009 16:52:58 -0400432_us-ascii Hey, Larry, how'd you get a copy of " DB2 EXPRESS: Easy Development and Administration"? I was scouting it and Amazon claims it hasn't been released yet!

--Phil

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Larry Kintisch Sent: Tuesday, May 19, 2009 3:32 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Using the RAND() function: Endpoints? [...] 23780 314 41_Re: Using the RAND() function: Endpoints?14_Larry Kintisch17_LKint@VERIZON.NET31_Tue, 19 May 2009 17:08:36 -0400661_us-ascii I found the Amazon Listing by ISBN number 013146397-7 or by "Easy Development". The title they have is DB2(R)... LK



At 04:52 PM 5/19/2009, you wrote: >Hey, Larry, how'd you get a copy of " DB2 EXPRESS: Easy Development and >Administration"? I was scouting it and Amazon claims it hasn't been >released yet! > >--Phil > >-----Original Message----- >From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On >Behalf Of Larry Kintisch >Sent: Tuesday, May 19, 2009 3:32 PM >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: Re: [DB2-L] Using the RAND() function: Endpoints? > >Hi Phil, > In your iterative Select, try: >SELECT LEVEL + 1, [...] 24095 42 51_Re: CREATE/ALTER STOGROUP with VOLUMES("*","*","*")16_mocion@libero.it16_mocion@LIBERO.IT31_Tue, 19 May 2009 16:14:38 -0500525_ISO-8859-15 See :

John Iczkovits DB2 and Storage Management, a Guide to Surviving a Perfect Marriage SHARE 2007 (page 57 for instance)

Or

Disk storage access with DB2 for z/OS redpaper , 2006

There's a description on DB2-SMS interaction.

HTH

Max Scarpa Certified DB2 sysghost CPC member IDUG 2009 - Rome

IDUG Europe 2008 Attendee Testimonial - "Great but IDUG 2009 in Rome will be even useful, I've a used hairpiece in case 'bald sysprog' Max needs more hairs ! ' :-)))) [...] 24138 314 72_DB2 z/OS - Java Bound Package Executes Dynamically instead of Statically11_Hardy, Dale14_DHardy@MIB.COM31_Tue, 19 May 2009 17:18:01 -0400453_us-ascii I have a Java developer who has written a program, bound it to a collection whose name is the same as her logon id and executing it from a batch program. But, at execution time it is not recognizing the bound package. Instead, it is executing the program dynamically.





We have similar Java applications that execute packages successfully in batch but can't figure out why this particular one is behaving differently. [...] 24453 255 11_Re: History23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Tue, 19 May 2009 18:11:10 -0400278_iso-8859-1 Ok Willie.... my first machine was a 650 with vacuum tubes, and the first one I programmed was a 12K 1401. Wired some boards for EAM equipment. I had a 2311 datacell sitting in my office for years, but it must have gotten dumped in one of the many office moves. [...] 24709 2302 27_Re: DB2 V8 Migration failed14_Alexander John28_JAlexander@WOOLWORTHS.COM.AU31_Wed, 20 May 2009 09:57:49 +1000500_us-ascii Hi Folks,

We have always Steplibd to SDSNEXIT & SDSNLOAD & never had any performance issues.

00C90101 from memory implies that the RBA in that page is ahead of the catalog!, which can happen in circumstances where perhaps a tablespace was DSN1COPYd from another system which had an RBA that was ahead of the system the tablespace was restored to, which isnt the case here!, I am sure there are other scenarios that would cause C90101, & would appreciate feedback on this. [...] 27012 33 25_Re: EXPLAIN(NO) - Why????11_Jeff Agosta20_agost003@MC.DUKE.EDU31_Wed, 20 May 2009 03:14:08 +0000346_windows-1252 Phil, If memory serves (although I admit at this age that's an anomaly !), I recall that binding w/ explain(no) was prefered in case of autobinds where this would be more costly and totally unnecessary. I recall one shop I was at years ago, binding w/explain(yes) to get the access paths, then immediately rebind w/ explain(no) [...] 27046 69 25_Re: EXPLAIN(NO) - Why????14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 20 May 2009 05:02:10 +0100345_iso-8859-1 Hi Jeff

"...autobinds where this would be more costly and totally unnecessary."

Why do you say totally unnecessary.? ANY time a plan is rebound (certainly in production) you really ought to have Explain output - otherwise how will you know what DB2 has chosen for access path if you have problems?

Phil G CA [...] 27116 54 20_DB2 for z/OS RSU081212_Ayalew Kassa20_ayalakassa@YAHOO.COM31_Tue, 19 May 2009 21:17:30 -0700323_iso-8859-1 after we apply RSU0812 , an application analyst run reorg, runstats, and rebind on two tables. And, now the access path of a query that is executing on the two tables is changed from index access to tablespace access. Does anyone has this kind of issue after applying this maintenace in DB2 ?Thanks,Ayalew. [...] 27171 369 27_Re: DB2 V8 Migration failed18_Ujjal Bhattacharya14_UjjalB@NBK.COM31_Wed, 20 May 2009 08:05:53 +0300341_us-ascii We have done the same exercise in our disaster site where we have explicitly defined the STEPLIB in all the Db2 started tasks and it still failed with the same error. We also did a REORG on the SYSPLAN Tablespace in our DR site and the only thing changed is the PAGE number which is obvious ; the error code remained the same. [...] 27541 81 28_Antwort: [DB2-L] Date format11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 20 May 2009 07:27:46 +0200450_ISO-8859-1 look in the DBRM. On the first line are a set if bit flags - one of which is the DATE format





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 [...] 27623 414 27_Re: DB2 V8 Migration failed14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 20 May 2009 06:30:52 +0100367_iso-8859-1 I think you need to wait for IBM to respond

00c90101 usually means that DB2 doesn't understand the data page (or doesn't like what it sees there)

Have you tried a DSN1PRNT of the affected page in SYSPLAN?

Is there anuthing obvious wrong with it??

The Diagnosis manual should help you to determine if all is as it should be [...] 28038 405 39_Antwort: Re: [DB2-L] ordering V9 (z/OS)11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 20 May 2009 07:37:57 +0200424_ISO-8859-1 but it is so slow, the search doesnt work at all well, there is no easy way to limit the books searched and, my pet hate, it comes up always in GERMAN...Now I know I live and work in germany and my PC is german and I can speak and read german but I do *not* want my technical docu "default" to be German...I have yet to find a way to turn off this "feature" and so I currently *never* use this "info center" [...] 28444 510 42_Antwort: Re: [DB2-L] EXPLAIN(NO) - Why????0_17_Rolf.Drees@GAD.DE31_Wed, 20 May 2009 07:47:51 +0200568_ISO-8859-1 Hello Phil,

perhaps it would be a good idea to get an DSNZPARM that holds the default for Explain.

Kind regards

Rolf Drees Anwendungsentwicklung Querschnittsfunktionen / Datenbankmanagement Tel.: 0251 7133 - 2238 ; Fax.: 0251 7133 - 92238

GAD eG GAD-Straße 2 - 6 48163 Münster

http://www.gad.de

Vorstand: Anno Lederer (Vors.), Dr. Elmar Pritsch (stv. Vors.), Jörg Dreinhöfer, Friedhelm Wagner Aufsichtsratsvorsitzender: Wilfried Guttmann Sitz: Münster/Westf., Amtsgericht Münster, Genossenschafts-Register 337 [...] 28955 143 46_History - plus Version life cycle quetsions...11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 20 May 2009 08:12:02 +0200623_ISO-8859-1 Thanks to Willies blog I have filled in a few gaps in the chart below...can anyone else fill in the remaining details....I know it's a waste of time but I have carried this around with me for years and now it looks nearly finished...

Version GA End of Service 1.1 1985-04-02 ? 1.2 1986-03-07 1988-06-30 1.3 1987-06-26 ? <--- My first DB2 version that I played with on a 3033 2.1 1988-09-?? ? 2.2 1989-09-22 ? 2.3 1991-10-25 ? 3.1 1993-12-17 2001-01-31 (planned was 1998-12-31) 4.1 1995-11-30 2001-12-31 5.1 1997-06-27 2002-12-31 6.1 1998-06-30 2005-06-30 7.1 2001-03-30 2008-06-30 8.1 2004-03-26 tbd [...] 29099 175 43_Re: Antwort: Re: [DB2-L] ordering V9 (z/OS)13_Hanne Lyssand20_Hanne.Lyssand@VPS.NO31_Wed, 20 May 2009 09:25:46 +0200488_us-ascii I don't know how it's in German, but in Norwegian it's just the index that is translated. When you actually find the information it's in English. And who has made the translation? So first I try to translate from English to Norwegian to follow the index, and it's not simple. When we talk "computerish" we mix the to languages, so in the end we don't know if a word is English or Norwegian or something in between (usually a English word with a Norwegian suffix or prefix). [...] 29275 119 60_Antwort: Re: [DB2-L] Antwort: Re: [DB2-L] ordering V9 (z/OS)11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 20 May 2009 10:02:52 +0200472_UTF-8 its ALL german here...perhaps they have more germans working for them and so you get the Index and I get the whole darn thing.... I just set my region to be UK english (it was anyway) and now I cannot even get to the info center...when I enter DB2 all I get is LUW stuff....ARGARGARGARHAHRHRA "suchberiech" is also a joke...you have to click in too many places that make no sense....sometimes am I sure that IBM are actively trying to *hide* the manuals.... :) [...] 29395 88 60_Antwort: Re: [DB2-L] Antwort: Re: [DB2-L] ordering V9 (z/OS)11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 20 May 2009 10:08:26 +0200485_ISO-8859-1 Now I have got US english but the "Group by: Version and Product" always returns "uncategorized" - this makes it useless....in fact less than useless....thankfully tomorrow is a bank holiday here so I can vent my frustation on a few cool beers...





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 [...] 29484 359 15_Re: Date format13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Wed, 20 May 2009 10:13:25 +0200543_us-ascii Hi Steve,

I couldn't' let this go, although I still don't have an answer. Roy must be on the right line, in that it's the precompile that sets the option so it must be held in the details of the DBRM/package - or, less likely, the load module. If it's a bit switch somewhere a good candidate is field NBRMSTMB, described (according to DSNMACS member DSNXNBRM) as 'flags, reserved'. Helpful. Although I've given up trying to get a layout for this field. Might be time to raise a PMR with IBM and ask the guys wot wrote it. [...] 29844 252 32_Antwort: Re: [DB2-L] Date format11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 20 May 2009 10:21:25 +0200615_ISO-8859-1 ok ok I checked

Its all in the DSNXPOPT macro:

POPT DSECT PARSER OPTIONS POPTHOST DS C OPTIONS AND HOST LANGUAGE POPTQUOT EQU X'80' APOST(0) OR QUOTE(1) POPTCOMM EQU X'40' PERIOD(0) OR COMMA(1) POPTQUOS EQU X'20' APOSTSQL(0) OR QUOTESQL(1) POPTGRA EQU X'10' MIXED YES!NO POPTPOPT EQU X'08' USE POPT YES!NO POPTHST EQU X'07' HOST LANGUAGE POPTCHAR DS C CHARACTER SET BEING USED POPTHST2 DS C V2 R1 HOST LANGUAGE POPTTDT DS C DATE/TIME OPTIONS, 0 = NONE POPTTLOC EQU X'80' LOCAL TIME POPTTJIS EQU X'40' JIS TIME POPTTISO EQU X'20' ISO TIME POPTTEUR EQU X'20' EUR TIME POPTTUSA EQU X'10' [...] 30097 66 40_DB2 V8 Migration - List prefetch problem11_Michael Lim22_MichaelLim@HKEX.COM.HK31_Wed, 20 May 2009 16:56:35 +0800506_us-ascii Hello,

I recently upgraded DB2 to V8 CM mode (RSU 0812) on my z/OS 1.9 development environment. The developers very quickly encountered a problem where some programs were taking 30% longer to run.

Further investigation revealed that after a rebind, access paths that used to use list prefetch were no longer using list prefetch. We tried various tweaks to attempt to influence the optimizer to choose list prefetch, but nothing worked (although we did not attempt using hints). [...] 30164 306 57_Antwort: [DB2-L] DB2 V8 Migration - List prefetch problem11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 20 May 2009 11:16:24 +0200401_ISO-8859-1 I am intrigued as List Prefetch is not actually that good (it depends of course!) What I would like to know is the access path before and after - did it swap from L to tablespace scan for example or is it that your SYSCOLDIST contains garbage and/or not enough data? Remember that V8 is very sensitive to bad/missing stats. See my earlier posts about how to find out and rectify this! [...] 30471 436 61_Re: Antwort: [DB2-L] DB2 V8 Migration - List prefetch problem11_Michael Lim22_MichaelLim@HKEX.COM.HK31_Wed, 20 May 2009 18:13:58 +0800346_iso-8859-1 Roy,

I am aware that List Prefetch will not account for the 30% difference. Actually there are other contributing factors that we have identified.

Anyway, to answer your question, the access path before and after is matching column on a 1-column index. The only difference is the missing 'L' in the Prefetch column. [...] 30908 541 78_Antwort: Re: [DB2-L] Antwort: [DB2-L] DB2 V8 Migration - List prefetch problem11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 20 May 2009 12:19:18 +0200660_ISO-8859-1 so what were "...the other contributing factors.." then? Please tell!





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







Michael Lim Gesendet von: DB2 Data Base Discussion List 20.05.2009 12:13 Bitte antworten an DB2 Database Discussion list at IDUG [...] 31450 63 24_Re: DB2 for z/OS RSU081211_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Wed, 20 May 2009 10:29:22 +0000340_ISO-8859-1 Firstly you should examine the access path and statistics to see why DB2 chose to use TS scan. Maybe manually adjusted statistics or optimizer hint was in effect?

You could check the output of the SMP/E apply job to identify PTF that eventually pertain your issue ... Are you also applying PRP sourceids beside RSUs? [...] 31514 36 52_DB2 z/OS V9 - Restarting load with SYSREC DD DUMMY ?11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Wed, 20 May 2009 10:40:01 +0000395_ISO-8859-1 Hello, is anybody restarting load utility with SYSREC DD DUMMY in case of TS space shortage or incorrect data in the input dataset ?

We used that to avoid RECP restricted statuses and taking IMAGE copies/logging when loading tables on DB2 V8.

In V9 CM load restart with SYSREC DD DUMMY ended successfully ( RC=4) but the TS was left in RECP and indexes in RBDP.... [...] 31551 44 63_Re: DFSMSdss RESTORE FULL VOLUMES and no ICF catalog to match !14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 20 May 2009 21:30:14 +1000344_US-ASCII If you have clusters without BCS entries, you'll need to delete with VVR; if you have BCS entries without clusters , you'll need to delete with NOSCRATCH.

Possibly you'll need to get your storage folks to do this and these are protected parameters.

James Campbell

On 19 May 2009 at 13:01, Mark Vickers wrote: [...] 31596 40 24_Re: DB2 for z/OS RSU081214_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 20 May 2009 21:30:14 +1000482_US-ASCII Have you turned (zparm) OPTXOIRC ON. That might help.

James Campbell

On 19 May 2009 at 21:17, Ayalew Kassa wrote:

> > > after we apply RSU0812 , an application analyst run reorg, runstats, and rebind on two tables. And, now the access path of a query that is executing on the two tables is changed from index access to tablespace access. Does anyone has this kind of issue after applying this maintenace in DB2 ? > > > Thanks, > > > Ayalew. > > > [...] 31637 442 15_Re: Date format16_Wallace, Stephen25_stephen.wallace@LANDG.COM31_Wed, 20 May 2009 12:45:11 +0100485_us-ascii Raymond, You won't be surprised to hear we don't have the DBRM. All I've got is the package so I'm raising a PMR with IBM.

Cheers, Steve Wallace Mainframe DBA Legal & General Assurance Society Work: 01737 374308 (7100 4308)





________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bell, Raymond Sent: 20 May 2009 09:13 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Date format [...] 32080 440 24_Re: DB2 for z/OS RSU081213_Walters, Paul28_Paul.A.Walters@SALLIEMAE.COM31_Wed, 20 May 2009 08:03:29 -0400661_us-ascii We had a similar problem with RSU0812.

Did your query go from index only to index and tablespace?

What is the setting of OPTIXOPREF? We had to open a ticket with IBM on this and we are currently waiting on a fix PK84092 PROBLEM SUMMARY: **************************************************************** * USERS AFFECTED: For all DB2 for z/OS users who have indexes * * that can do index-only access on some * * queries. * **************************************************************** * PROBLEM DESCRIPTION: An index which can do index-only access * * and has better overall filtering can * * lose to an index which needs to access [...] 32521 28 25_Re: EXPLAIN(NO) - Why????11_Jeff Agosta20_agost003@MC.DUKE.EDU31_Wed, 20 May 2009 12:17:21 +0000582_windows-1252 Phil, Unnecessary from the fact that access paths weren't expected to change. Anyway this was a LONG time ago and that was what the shop's reasoning was. Personally, we (I) explain always. Jeff A

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 32550 108 25_Re: EXPLAIN(NO) - Why????12_McLaren Phil32_Phil.McLaren@AXAWINTERTHUR.CO.UK31_Wed, 20 May 2009 13:17:23 +0100472_us-ascii Course, the autobind explain can also be controlled with the ABEXP ZPARM. I always imagined this option existed due to the overheads, so I guess IBM think there is overhead enough with EXPLAIN to justify the need to turn it off?

Perhaps there is also a case should you have a corrupt PLAN_TABLE tablespace causing binds to fail (would it fail or just complain - I don't know)...but I'm thinking outside of the square now though, probably too far out. [...] 32659 23 32_Truls Pedersen is out of office.14_Truls Pedersen16_tpeders6@CSC.COM31_Wed, 20 May 2009 14:25:09 +0100705_US-ASCII I will be out of the office starting 20.05.2009 and will not return until 25.05.2009.

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________

IDUG North America 2008 Attendee Testimonial- "The most important thing I always find at IDUG is the revisiting of old assumptions, with new functions and features." _____________________________________________________________________ 32683 62 51_DB2 for z/OS V8 migration - SCCSID code page change12_Jim McAlpine22_jim.mcalpine@GMAIL.COM31_Wed, 20 May 2009 14:37:53 +0100566_ISO-8859-1 I thought I'd seen this question asked previously but I can't find anything in the archives. Anyway has anyone gone to DB2 V8 before doing the SCCSID code page change that is supposedly required. I have already migrated a number of systems including doing the required code page change first but I have a system where I don't have the separate source for the views and until I can get the DB2 Admin Tool installed I would like to continue with the V8 migration before changing the SCCSID. Has anyone else done the migration this way round and was it [...] 32746 658 14_Re: History OT14_Barbara Koenen33_barbara.koenen.bgit@STATEFARM.COM31_Wed, 20 May 2009 06:43:08 -0700435_us-ascii Okay, guys. You just made my day. I feel extremely young now, since the first system I worked on was just one of those "new" 360s. I also remember the finals week it was down because we couldn't get a part any more since IBM didn't make them anymore.





(The only time I ever saw vacuum tubes was on the old TV we had when I was a kid, that I watched Star Trek on when it was still on the network...) [...] 33405 279 27_Re: VSAM to DB2 conversion.14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Wed, 20 May 2009 09:00:02 -0500371_us-ascii Come on Stan, when did I say anything about CICS VT Transparency or DL/2 for that matter ? These and similar tools do have a place in grand scheme of things. Read my earlier post again, I was talking about NEWLY written Java apps using row at a time all columns always techniques. What's even worse that they insist that it's the right way to do it. Khalid [...] 33685 344 76_Re: DB2 z/OS - Java Bound Package Executes Dynamically instead of Statically11_Hardy, Dale14_DHardy@MIB.COM31_Wed, 20 May 2009 10:20:25 -0400671_us-ascii Never mind.





There were multiple packages involved and one of them hadn't been bound so the application executed dynamically.









From: Hardy, Dale Sent: Tuesday, May 19, 2009 5:18 PM To: 'DB2 Database Discussion list at IDUG' Subject: DB2 z/OS - Java Bound Package Executes Dynamically instead of Statically





I have a Java developer who has written a program, bound it to a collection whose name is the same as her logon id and executing it from a batch program. But, at execution time it is not recognizing the bound package. Instead, it is executing the program dynamically. [...] 34030 117 46_Re: Full Restore and no ICF catalog to match !12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 20 May 2009 07:31:45 -0700471_iso-8859-1 Ouch! Been there, done that. Re-catalog the datasets on all the volumes you restored.

--- On Tue, 5/19/09, Mark Vickers wrote:



From: Mark Vickers Subject: [DB2-L] Full Restore and no ICF catalog to match ! To: DB2-L@WWW.IDUGDB2-L.ORG Date: Tuesday, May 19, 2009, 12:37 PM





I am testing my fallback (full restore) from v8 NFM to CM and hit a problem.... [...] 34148 99 46_Re: Full Restore and no ICF catalog to match !9_Mike Bell21_mbell11a1@VERIZON.NET31_Wed, 20 May 2009 09:46:14 -0500470_us-ascii you have two cleanup options

1. recatalog - define cluster ----- RECATALOG This requires that the target catalog name be exactly the same as the origional catalog name

2. delete with nvr or vvr option depending on whether the catalog entry is missing or the physical data set.

The problem is I don't know of any tools that can automate this for you. I am sure they must exist - just I never had the time to research/build or anything. [...] 34248 165 15_Re: Date format9_Mike Bell21_mbell11a1@VERIZON.NET31_Wed, 20 May 2009 09:51:00 -0500350_us-ascii the information is there in SYSIBM.SYSPACKSTMT with SEQNO=0. You have to select it out as HEX(STMT) to get the bit fields in a workable format. This is the rest of the DBRM header that isn't in the defined columns. There are also tools that will rebuild the DBRM from the same information. We have them - I know other people have them. [...] 34414 15 14_Re: History OT11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Wed, 20 May 2009 14:59:31 +0000335_Windows-1252 >since the first system I worked on was just one of those “new” 360s. >I also remember the finals week it was down because we couldn’t get a part any more since IBM didn’t make them anymore.

Coincidently, that happened to me/us in the late 1970's (University of Waterloo).

- Too busy driving to stop for gas! 34430 453 27_Re: VSAM to DB2 conversion.9_Stan Hoey22_shoey@CIRCLE-GROUP.COM31_Wed, 20 May 2009 16:43:13 +0100512_us-ascii Hi Khalid

I must have missed your earlier post and apologise (not a word I use very often) for my impetuousness. I owe you a beer (a phrase I use even less than the word apologise)

(o;

Humbled but still comfortably numb, Stan

________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of M. Khalid Khan Sent: Wednesday, May 20, 2009 3:00 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] VSAM to DB2 conversion. [...] 34884 615 14_Re: History OT23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 20 May 2009 12:46:33 -0400402_iso-8859-1 While the body may win more arguments over time, age is in the mind.

How do I get the teenager out of this old body?





Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com [...] 35500 681 76_Re: DB2 z/OS - Java Bound Package Executes Dynamically instead of Statically15_Douwe van Sluis21_d.b.van.sluis@HOME.NL31_Wed, 20 May 2009 19:50:04 +0200558_us-ascii To prevent applications from executing dynamically you can use only NULLID.SYSSTAT in your PKLIST or set the property db2.jcc.sqljUncustomizedWarningOrException to 2.



Vriendelijke groet, Douwe van Sluis











-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens Hardy, Dale Verzonden: woensdag 20 mei 2009 16:20 Aan: DB2-L@WWW.IDUGDB2-L.ORG Onderwerp: Re: [DB2-L] DB2 z/OS - Java Bound Package Executes Dynamically instead of Statically [...] 36182 155 75_Re: Difference between DSNTIAUL and UNLOAD utility wrt CLOB column handling3_Ray22_ray_in_doubt@YAHOO.COM31_Wed, 20 May 2009 11:09:09 -0700484_iso-8859-1 Sabarish,

We could also force OPHINTS onto a statement using DSNTIAUL in case of query regression which we will not be able to do via UNLOAD

Cheers, Ray

--- On Mon, 5/11/09, Matthew Donald wrote:



From: Matthew Donald Subject: Re: [DB2-L] Difference between DSNTIAUL and UNLOAD utility wrt CLOB column handling To: DB2-L@WWW.IDUGDB2-L.ORG Date: Monday, May 11, 2009, 2:45 PM [...] 36338 639 22_Re: ordering V9 (z/OS)12_Isaac Yassin20_yassini@BEZEQINT.NET31_Wed, 20 May 2009 22:17:42 +0300382_utf-8 Hi,





I participated in the IC UFO at IDUG Denver and have it on my laptop.

Still cumbersome comparing to the bookmanager.

I know people are working on improvement but it is still way behind.

Yesterday I needed to check for something – it took the new IC about 20 minutes to build the index and it does each time you start it. [...] 36978 198 34_Re: CPU Impact on Getpages and i/o10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Wed, 20 May 2009 19:17:24 +0000423_windows-1252 We know that when the system gets busy the resonse time slows down. During those times we see the higher getpage and sync/io rates.

The numbers are for the exact same query looking for the exact same number of dependents per claim. Statistically there should not be any significant variation in workload because the query and result sets for an entire day of claim processing will be very similar. [...] 37177 438 46_Re: Full Restore and no ICF catalog to match !16_Broyles, Carol L27_Carol.L.Broyles@ACS-INC.COM31_Wed, 20 May 2009 14:21:15 -0500363_US-ASCII Mark,





I know you can re-define a missing BCS entry if you know where all the pieces are. I don't have the syntax in front of me. We use a Mainstar catalog tool that will generate the DEFINE CLUSTER command to do it. I can generate a bogus VSAM file and delete noscratch the BCS entry to get the syntax for you if you need it. [...] 37616 411 24_Re: DB2 for z/OS RSU081213_Hampton, Kirk26_kirk.hampton@CAPGEMINI.COM31_Wed, 20 May 2009 16:02:22 -0400553_iso-8859-1 We put on PUT0811 several weeks ago, which probably has many of the same PTF's as RSU0812. Last week, we had a very similar symptom with a package in a development environment, the same package in Production is using the index, but the development one is doing TS scan. I had not turned it in as a problem yet, because the stats are considerably different in DEV, we have only one partition loaded out of 20, and I thought that might be it, although we have not had that kind of issue before. We have both OPTIXOPREF and OPTXOIRC turned [...] 38028 34 50_Re: History - plus Version life cycle quetsions...16_mocion@libero.it16_mocion@LIBERO.IT31_Wed, 20 May 2009 15:12:28 -0500323_ISO-8859-1 Hi folks

As I started with DB2 V3 (and V4 was available) I feel so young.........



Max Scarpa Certified DB2 sysghost CPC member IDUG 2009 - Rome

IDUG Europe 2008 Attendee Testimonial - "Great but IDUG 2009 in Rome will be by far better , I've never seen a DB2 sysghost !' :-)))) [...] 38063 538 34_Re: CPU Impact on Getpages and i/o23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 20 May 2009 16:16:50 -0400477_Windows-1252 Jorg,

This seems to fall into a "nothing changed" scenario, but nothing is always the same.

How about some system statistics and application actg data to compare?



Thanks, Joel



Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com [...] 38602 29 50_Re: History - plus Version life cycle quetsions...11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Wed, 20 May 2009 20:37:25 +0000456_- >As I started with DB2 V3 (and V4 was available) I feel so young.........

I started before/with the first version of DB2. At the time, my ex was a model 204 DBA and had to make the jump to DB2. It wasn't too difficult, since they both use inverted lists. The main difference is, in M204, the index and the data are in the same file. And, M204, was a couple of years behind in getting to 31-bit addressing. - Too busy driving to stop for gas! [...] 38632 66 14_Re: History OT13_Hampton, Kirk26_kirk.hampton@CAPGEMINI.COM31_Wed, 20 May 2009 16:37:34 -0400342_windows-1252 University of Waterloo... the setting for "The Adolescence of P-1" an old Sci-Fi book I still have a copy of somewhere.

learned COBOL on a 360 running DOS/VS at college, but my first real job was on a 370/168 running OS/VS1. Something less than 4 meg of memory, IIRC.

Thanks, Kirk Hampton Capgemini Dallas, TX [...] 38699 42 14_Re: History OT11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Wed, 20 May 2009 20:50:20 +0000601_- >University of Waterloo... >the setting for "The Adolescence of P-1" an old Sci-Fi book I still have a copy of somewhere.

Yes. And, the movie.

>learned COBOL on a 360 running DOS/VS at college,

I'm not sure of the OS.

We wrote our COBOL programmes on an interactive system running on an s/36. The system was called WIDJET (Waterloo Interactive Job Entry Terminal). It wrapped JCL around the programme, submitted it to an OS 'Service Machine' running under VM, compiled, linked and went, and sent the output back to us. And, the archiving of programmes took forever. [...] 38742 41 14_Re: History OT11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Wed, 20 May 2009 21:30:53 +0000329_- I know it's bad form to reply to one's own post. But, it was WIDJET, rather than WIJET. Waterloo interactive DEBUG (and) job entry terminal. ------Original Message------ From: (yahoo) Ted MacNEIL Sender: DB2 Data Base Discussion List To: DB2 List ReplyTo: DB2 List Sent: May 20, 2009 16:50 Subject: Re: [DB2-L] History OT [...] 38784 82 14_Re: History OT0_17_db46@CHRYSLER.COM31_Wed, 20 May 2009 17:38:11 -0400573_US-ASCII "Open the pod doors HAL". "I sorry Dave I can't do that"

When I started in this business professionally in 1982 PC didn't mean politically correct or personal computer (those things didn't exist), it meant Para Commander Parachute. Now it's reversed. Well the TI-99/4 come out in 1979 and cost about $1,200 so very few people owned them and it wasn't until the TI-99/4A come out at the 'more' reasonable price of about $500 in 1981 that some people started to own a PC (I actually had a TRS-80 that I gave to my local school district that probably got [...] 38867 292 14_Re: History OT13_Bright, Randy20_Randy_Bright@BMC.COM31_Wed, 20 May 2009 16:42:50 -0500753_us-ascii Binary Interchange Technology (Technique?)



Randy Bright Solutions Architect, DB2 Utilities

BMC Software, Inc.

________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of db46@CHRYSLER.COM Sent: Wednesday, May 20, 2009 4:38 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT



"Open the pod doors HAL". "I sorry Dave I can't do that"

When I started in this business professionally in 1982 PC didn't mean politically correct or personal computer (those things didn't exist), it meant Para Commander Parachute. Now it's reversed. Well the TI-99/4 come out in 1979 and cost about $1,200 so very few people owned them and it wasn't [...] 39160 312 14_Re: History OT10_Irwin, Jim19_Jim.Irwin@OA.MO.GOV31_Wed, 20 May 2009 16:44:27 -0500384_us-ascii In the good old days I would have been hard pressed to tell you what BIT stands for but thanks to Google I can tell you that it stands for Binary Digit.





From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of db46@CHRYSLER.COM Sent: Wednesday, May 20, 2009 4:38 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT [...] 39473 432 14_Re: History OT13_Bright, Randy20_Randy_Bright@BMC.COM31_Wed, 20 May 2009 16:51:39 -0500514_us-ascii I found my old Assembler Language Programming text book from 1971 and it confirms Jim's assertion.

Google, or a hard-backed text book from 1971. We really have come a long way.



Randy Bright Solutions Architect, DB2 Utilities

BMC Software, Inc.

________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Irwin, Jim Sent: Wednesday, May 20, 2009 4:44 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT [...] 39906 466 14_Re: History OT14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 20 May 2009 17:49:36 -0400490_us-ascii You had to _google_ that? You sure you're a geek?





________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Irwin, Jim Sent: Wednesday, May 20, 2009 5:44 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT





In the good old days I would have been hard pressed to tell you what BIT stands for but thanks to Google I can tell you that it stands for Binary Digit. [...] 40373 238 14_Re: History OT13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 20 May 2009 14:58:38 -0700461_us-ascii >>Only corporations owned computers and we all sat at 3278 'terminals' and did our coding.<< I worked for a very large corporation (SWBT) in 1982 and nobody had their own terminal, mostly because a large population of TSO users would have bogged the machine down too much. You walked down the hall to the TSO room and waited for a terminal. They gave the systems programmers our own terminals in 1983, so I'm not sure when the TSO room went away. [...] 40612 212 14_Re: History OT23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 20 May 2009 18:02:20 -0400289_iso-8859-1 IBM started selling their PC in 1981, as a personal computer. My first one in '83 had a 10 meg drive. a defrag had to run all night.

late that yr my teen age son did a DEL *.* while in the root directory....... of course he replied Y to the "are you sure" question. [...] 40825 239 14_Re: History OT0_17_db46@CHRYSLER.COM31_Wed, 20 May 2009 18:11:29 -0400324_US-ASCII Nope, binary integer (0 and 1).

Then there was nibbles, and bytes, and half words, words, etc.

Yea, forgot exactly when IBM came out with their first PC. Mine and 250K hard drive and 4 Meg's of ram built into the mother ram (upgraded to 20 Meg by adding four 4 Meg chips in the designated slots. [...] 41065 200 22_Re: ordering V9 (z/OS)12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 20 May 2009 15:13:13 -0700639_iso-8859-1 Very good if your workstation has enough memory or enough CPU to run this. But GOOD LUCK running on a limited machine. You can get coffee between responses, slow, slow and slower. Myron ________________________________ From: Willie Favero To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Tuesday, May 19, 2009 4:41:44 PM Subject: Re: [DB2-L] ordering V9 (z/OS) What you need to do is get a copy of Information Center loaded down to your workstation or server. It's extremely cool. You get to do everything you can do using Information Center on the web without having to be connected. It even comes with an update [...] 41266 286 43_Re: ordering V9 (z/OS) [slightly off topic]12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 20 May 2009 15:15:35 -0700640_utf-8 My problem with Info Center is that it returns lots of topics that don't even possibly relate to the query. Like IMS version data on DB2 queries. Happens a lot for me. I use it sometimes, but generally find it easier to search bookmanager versions (and seriously faster and I do mean faster). Myron ________________________________ From: Chad A. Walmer To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Tuesday, May 19, 2009 4:17:53 PM Subject: Re: [DB2-L] ordering V9 (z/OS) [slightly off topic] Cathy, I know this conversation (debate?) has come up before but I really like the Information Center and rarely use the Book [...] 41553 107 11_Re: History12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 20 May 2009 15:16:32 -0700646_iso-8859-1 Unfortunately, I remember the 2311s coming out and even their predecessor, the 1311s. Big deal at the time. (won't say when). ________________________________ From: Willie Favero To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Tuesday, May 19, 2009 4:10:21 PM Subject: Re: [DB2-L] History That reminds me of time I was working on a 2311 and.... Just joking... I'm way too young to remember 2311s... Willie Ted MacNEIL wrote: And they can turn almost any topic into the one Dr. Ebert cited. There is a rule (by I forget who), that any topic on IBM-Main will eventually devolve into something that happened in the 1960's. [...] 41661 538 14_Re: History OT23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 20 May 2009 18:20:12 -0400387_iso-8859-1 Now you're getting back there. I still have some of the IBM Green PI manuals from the 60's.

Pack Rats rule !!



Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com [...] 42200 413 14_Re: History OT23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 20 May 2009 18:23:17 -0400388_iso-8859-1 Where were you getting a MS in computer science in the 50's? I thought the courses were all part the EE curriculum back then.

Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com [...] 42614 467 43_Re: ordering V9 (z/OS) [slightly off topic]13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 20 May 2009 17:25:13 -0500650_UTF-8 Have you tried setting the scope prior to a search?

Willie

Myron Miller wrote: > My problem with Info Center is that it returns lots of topics that > don't even possibly relate to the query. Like IMS version data on DB2 > queries. Happens a lot for me. I use it sometimes, but generally > find it easier to search bookmanager versions (and seriously faster > and I do mean faster). > > Myron > > ------------------------------------------------------------------------ > *From:* Chad A. Walmer > *To:* DB2-L@WWW.IDUGDB2-L.ORG > *Sent:* Tuesday, May 19, 2009 4:17:53 PM > *Subject:* Re: [DB2-L] ordering [...] 43082 412 14_Re: History OT0_17_db46@CHRYSLER.COM31_Wed, 20 May 2009 18:30:32 -0400484_US-ASCII No, my instructor was coding in octal in the late 1950's.

I got my BS in Computer Science from Univ. or Michigan in 1982 and my MS in Computer Science for Oakland University.

Dean J. Burchill 248-576-3957 (8) 776-3957





Joel Responsive Systems Sent by: DB2 Data Base Discussion List 05/20/2009 06:24 PM Please respond to DB2 Database Discussion list at IDUG [...] 43495 56 14_Re: History OT0_17_db46@CHRYSLER.COM31_Wed, 20 May 2009 18:33:13 -0400614_US-ASCII No, my instructor was coding in octal in the late 1950's.

I got my BS in Computer Science from Univ. or Michigan in 1982 and my MS in Computer Science for Oakland University.

Dean J. Burchill 248-576-3957 (8) 776-3957

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 43552 89 14_Re: History OT0_24_carol.sutfin@REGIONS.COM31_Wed, 20 May 2009 18:34:58 -0500325_UTF-8 Okay, I can't stay out of this.

I will take the hard-back text book over Google any day. I still have a copy of S360 Principles of OPS. Also my handy dandy DB2.3 Reference guide and OSI CICS 1.6 Command Level Guide that cost me $10 in 197..

and saying I can't possibly write a program to use up 65K. [...] 43642 349 43_Re: ordering V9 (z/OS) [slightly off topic]12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 20 May 2009 18:24:03 -0700692_utf-8 yes. Several times. ________________________________ From: Willie Favero To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Wednesday, May 20, 2009 6:25:13 PM Subject: Re: [DB2-L] ordering V9 (z/OS) [slightly off topic] Have you tried setting the scope prior to a search? Willie Myron Miller wrote: My problem with Info Center is that it returns lots of topics that don't even possibly relate to the query. Like IMS version data on DB2 queries. Happens a lot for me. I use it sometimes, but generally find it easier to search bookmanager versions (and seriously faster and I do mean faster). Myron ________________________________ From: Chad A. Walmer [...] 43992 30 58_EXPLAIN(NO) - Why???? Triggers are created w/ Explain (no)30_edward.krisiewicz@jpmorgan.com30_edward.krisiewicz@JPMORGAN.COM31_Thu, 21 May 2009 02:04:49 +0000364_ISO-8859-1 I know in V7, triggers were created with Explain(no). Maybe the IBM trigger developers can let us know why they chose this option?

For non-triggers: One possibility is the binder can be a BIND Agent only and cannot create a plan table. If you need to bind ASAP and cannot find a DBA to create a plan-table, change bind cards to EXPLAIN(NO). [...] 44023 59 49_Re: Group Bufferpool (Critical Shortage of Space)0_37_Sangameswara.R.Panchomarthi@CHASE.COM31_Wed, 20 May 2009 22:54:22 -0400374_us-ascii Hi,

I am seeing something odd. I have a process that runs inserts every night into a heavily partitioned table 2K parts.

I have inserts running on 25 wide jobs per LPAR on 4 LPAR's each job has N parts defined (only records for those parts are funneled to those jobs input files) to it for the insert process, and these all run at the same time. [...] 44083 110 49_Re: Group Bufferpool (Critical Shortage of Space)12_Tal Lifshitz27_Tal.Lifshitz@UBS-HAINER.COM31_Thu, 21 May 2009 09:23:52 +0300458_ISO-8859-1 If you are using DB2 version 9, you can use the -ACCESS DATABASE(?) SPACENAM(?) PART(?) MODE(NGBPDEP) to convert the specified page set or partition, non-disruptively to a non-group buffer pool dependent. You should use this before running large batch processes against a particular page set or partition to improve performance in a data sharing environment. Only issue this command to the member on which you plan to run the batch programs. [...] 44194 27 56_Re: DB2 z/OS V9 - Restarting load with SYSREC DD DUMMY ?5_Steve21_malutjuta@HOTMAIL.COM31_Thu, 21 May 2009 10:03:18 +0000708_windows-1252 Hi Nenad,

Anything unusual in the SYSPRINT report?

regards, Steve M

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________

IDUG DB2-L FAQ and e-mail settings are located on the IDUG.org Listserv page. If you are not already an IDUG.org member, please register at http://www.idug.org/register _____________________________________________________________________ 44222 107 20_DB2 Pagination logic15_Bright Kasimani18_kbrighti@GMAIL.COM31_Thu, 21 May 2009 16:41:51 +0530574_ISO-8859-1 Listers,

I have a requirement to support pagination in the front end. The UI will render the result in multiple pages and the user can navigate through the pages using the First, Previous, Next, Last buttons. The data store is DB2 for z/OS.

The logic is implemented as follows: 1. To begin with the first 500 rows will be returned from the table. 2. When the user clicks the "next" button, the next set of 500 rows will be returned from the table [condition: > the last key column from the previous page] 3. When the user clicks the "previous" [...] 44330 50 47_Submitting batch job from DB2 Stroed Procedure?11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Thu, 21 May 2009 12:22:50 +0000347_ISO-8859-1 Hello,

I created a DB2 trigger that calls a REXX DB2 stored procedure that should submit JCL from a PDS member:

Rexx DB2 SP contains only :

SUBMIT JCLIN

And it's WLM address space has JCLIN allocated as : . . //JCLIN DD DISP=SHR, // DSN='A010735.CNTL(WTO)' . . When the procedure is called it returns : [...] 44381 49 50_Re: History - plus Version life cycle quetsions...12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM31_Thu, 21 May 2009 08:38:24 -0400385_US-ASCII Well I guess I will jump in here. I was an IMS system programmer when i had my first contact with DB2 back in 1984. The bank i worked for was a beta site for DB2 before it was GA. DB2 has come along way since then. Jeff

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...] 44431 70 56_Re: DB2 z/OS V9 - Restarting load with SYSREC DD DUMMY ?11_Nenad Vidak21_nenad.vidak@GMAIL.COM31_Thu, 21 May 2009 12:52:11 +0000566_windows-1250 Well, this can be called unusuall , I guess: . .

DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=0 DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:02 .09 DSNUGSRX - TABLESPACE IDPDBA01.SCLGEIN3 IS IN RECOVER PENDING .09 DSNUGSRX - INDEX IDPA.JCLGEIN0 IS IN REBUILD PENDING .09 DSNUGSRX - INDEX IDPA.JCLGEIN1 IS IN REBUILD PENDING .09 DSNUGSRX - INDEX IDPA.JCLGEIN2 IS IN REBUILD PENDING .09 DSNUGSRX - INDEX IDPA.JCLGEIN3 IS IN REBUILD PENDING DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4 . . [...] 44502 432 14_Re: History OT10_Roger Hecq18_Roger.Hecq@UBS.COM31_Thu, 21 May 2009 08:55:20 -0400382_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. [...] 44935 542 14_Re: History OT10_Irwin, Jim19_Jim.Irwin@OA.MO.GOV31_Thu, 21 May 2009 07:55:41 -0500603_us-ascii I'm trying real hard to fit in with the kids.......





From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: Wednesday, May 20, 2009 4:50 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT





You had to _google_ that? You sure you're a geek?





________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Irwin, Jim Sent: Wednesday, May 20, 2009 5:44 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT [...] 45478 159 49_Re: Group Bufferpool (Critical Shortage of Space)0_37_Sangameswara.R.Panchomarthi@CHASE.COM31_Thu, 21 May 2009 08:50:00 -0400478_us-ascii Unfortunately these tables need to be available 24X7 for the customer on the Web and Global Call Centers. Batch Jobs run on all 4 LPARs at the same time.

During the last run, this table is being accessed only by batch during that time. We are sure that there is no inter DB2 Read/Write interest on same partition at the time batch inserts are running. I am not sure why the Group Buffer Pools are used if there is no DB2 Read/Write interest at that moment. [...] 45638 58 51_Re: Submitting batch job from DB2 Stroed Procedure?15_Lizette Koehler23_starsoul@MINDSPRING.COM31_Thu, 21 May 2009 08:58:40 -0400580_us-ascii A quick google search on IKJ79204I turned up the following thread http://ibmmainframes.com/post-155574.html

It should have some answers for you.

The main point is SUBMIT is a TSO command and if your stored procedures is not a TSO address space (PGM=IKJEFT01 for example), that may be why it is failing.

Lizette

> Hello, > > I created a DB2 trigger that calls a REXX DB2 stored procedure that should > submit JCL from a PDS member: > > Rexx DB2 SP contains only : > > SUBMIT JCLIN > > And it's WLM address space has JCLIN allocated as : > [...] 45697 657 14_Re: History OT10_Roger Hecq18_Roger.Hecq@UBS.COM31_Thu, 21 May 2009 09:01:50 -0400382_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. [...] 46355 309 34_Re: CPU Impact on Getpages and i/o10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Thu, 21 May 2009 13:21:22 +0000490_windows-1252 Hi Joel,

It's basiocally a condition wherre if we plot the getpages and sync/io we see a variable curve that matches the elapsed time. That, of cousre makes sense. What is odd is there is also a correlation that this happens more when the CPU is busy. For instance the worst case is an elapsed time 2 seconds, over 650 getpages per request and over 250 sync i/os per request. An average time is around 1.3 -1.4 seconds with 550 getpages and 200 sync i/os per call. [...] 46665 236 25_Re: EXPLAIN(NO) - Why????10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Thu, 21 May 2009 13:26:54 +0000454_windows-1252 This makes sense to me. Why fill up Plan tables that you just need to empty out later? I had 280 rows from one package I was deleting just the superfluous rows from May. With thousands of packages that does add up.

Unfortunately for us the binds are part of change control and trying to tell people Explain(No) here and Explain(Yes) there would engender so much confusion that it's easier just to automate a plan table clean up. [...] 46902 115 96_Re: Antwort: Re: [DB2-L] Antwort: [DB2-L] AVOID PREPAREs by exploiting the local statement cache13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Thu, 21 May 2009 08:26:55 -0500616_us-ascii I think there may just be a misunderstanding of what that bind parameter does -- it just gives you the option of avoiding the PREPARE, it does not do it automatically. Just to step back for a minute... As you are undoubtedly aware, before a dynamic statement can be executed it must be prepared. Once the PREPARE is issued, the statement can be executed repeatedly without issuing another PREPARE. Without KEEPDYNAMIC, this would be true until a COMMIT was issued, at which point the PREPARE needs to be executed again. In other words, "PREPARE, EXECUTE, EXECUTE, EXEUTE, *COMMIT*, PREPARE, EXECUTE... [...] 47018 101 14_Re: History OT14_M. Khalid Khan24_Mohammad_Khan@BCBSIL.COM31_Thu, 21 May 2009 08:28:45 -0500452_us-ascii I'm sure the good Doktor has no reason to feel envious of IBM-MAIN, whatever they can do we can do better ... yay. I just have one request to the people talking about xxxx in 19nn - please include a short blurb about xxxx and possibly a picture or a link to a picture. The reason for this request is that I have a real hard time differentiating between all the 5349s, 8123s, 3112s etc. I think it's already Friday in New Zealand ! Khalid [...] 47120 136 27_Re: VSAM to DB2 conversion.10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Thu, 21 May 2009 13:35:12 +0000420_windows-1252 The BCA is redoing ITS from VSAM to DB2 and they are using i/o modules. The complexity of some of teh code seems excessive but so far it's not really one of the things that causes performance issues. The BLUE2 dynamic SQL has done much more of that.

As for the OP question, I have to agree with the people who ask why do it? The best question to ask the business is what do you want to pay for? [...] 47257 76 18_Re: Installing OSC10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Thu, 21 May 2009 13:37:29 +0000757_windows-1252 If you are connecting to DB2 on z/OS you need a product license file. We have one because we own DB2 Connect EE. Plug that jar into your classpath and you will be fine.

On Mon, 18 May 2009 19:47:36 +0000, Darren Kilpatrick wrote:

>I have installed OSC and I am trying to connect to a DB2 subsystem on z/OS >through a DB2 connect gateway. i get this error message. Any suggestions? > >Exception Stack Trace: >com.ibm.db2zos.osc.exception.OSCException: >com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][10333][11649] No license >was found. An appropriate license file db2jcc_license_*.jar must be provided in >the CLASSPATH setting. > > at com.ibm.db2zos.osc.ui.subsystem.ConnectThread.connect [...] 47334 390 24_Re: DB2 Pagination logic13_David Simpson22_dsimpson@THEMISINC.COM31_Thu, 21 May 2009 09:41:51 -0400380_us-ascii You can always cast the column in your ORDER BY





ORDER BY CAST(C1 AS CHAR(10) CCSID ASCII)





This will probably degrade the performance of the query and make it impossible to use an index to avoid the sort, but you will get the correct order. This should allow you to eliminate the program sort in the application as well. [...] 47725 611 14_Re: History OT15_Patrick Hignett32_Patrick.Hignett@SSSWORLDWIDE.COM31_Thu, 21 May 2009 14:44:52 +0100416_us-ascii You guys are SO young. I started in 1970 as an operator on a KDF9 which was the grandson of LEO. 5, 7 and 9 hole paper tape! And the noise that the mechanical flip flops made was something else.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Irwin, Jim Sent: 21 May 2009 13:56 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT [...] 48337 177 27_Re: VSAM to DB2 conversion.23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Thu, 21 May 2009 09:49:22 -0400502_Windows-1252 IO modules, historically, have been the kiss of death regarding DB2 performance for every conversion I have ever seen.

That approach generally removes all possibility of tuning.



Regards, Joel







Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com [...] 48515 91 49_Re: Group Bufferpool (Critical Shortage of Space)13_Case, Missy J24_Missy.Case@FIRSTDATA.COM31_Thu, 21 May 2009 08:57:34 -0500302_US-ASCII I heard a Lawson & Lusketich (Forgive me if I mis-spell it, Dan) that said 'no means no' if you have close no on your datasets, even if you THINK there's no inter-DB2 read/write interest. DB2 will keep a tag on that dataset. If you change your object to close YES, this will be released. [...] 48607 58 96_Re: Antwort: Re: [DB2-L] Antwort: [DB2-L] AVOID PREPAREs by exploiting the local statement cache11_Sameer Rana21_sameerdrana@GMAIL.COM31_Thu, 21 May 2009 14:10:13 +0000530_windows-1252 Hello Mike ,

Thanks a lot for taking your time to give a very nice account of what could be occuring. Each argument holds a lot of weight because it is in line with our observations and what we have been suspecting but unable to prove. The application is developed in VB and they are using ODBC to come into DB2. I am not a big fan of VB especially with DB2 for Z/OS and doubt it is sophisticated enough in not issuing PREPARES past COMMIT points for the same SQL text. This is the code our team has been [...] 48666 227 27_Re: VSAM to DB2 conversion.10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Thu, 21 May 2009 14:10:27 +0000658_windows-1252 Sometimes flexibility and ease of conversion cost a lot less then a redesign. I don't know in this case, the BCA writes the models and code.

On Thu, 21 May 2009 09:49:22 -0400, Joel Responsive Systems wrote:

>IO modules, historically, have been the kiss of death regarding DB2 >performance for every conversion I have ever seen. > >That approach generally removes all possibility of tuning. > > >Regards, >Joel > > > > >Joel Goldstein >Responsive Systems >IBM Gold Consultant >Buffer Pool Tool for DB2, the worldwide industry standard > Performance software that works...... Predicts IO Rate !! > [...] 48894 214 56_R: [DB2-L] Group Bufferpool (Critical Shortage of Space)15_Moschelli Mauro34_mauro.moschelli@INTESASANPAOLO.COM31_Thu, 21 May 2009 16:35:21 +0200354_iso-8859-1 Don't forget to STOP/START the object after the ALTER. It IS really an easy alter, but it takes effect the first time it is opened after the alter, so it MUST be stopped once in order to work, or each member cycled, whatever is less disruptive in your environment.

HTH



Mauro Moschelli Intesa Sanpaolo Group Services [...] 49109 90 24_Re: DB2 Pagination logic14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 21 May 2009 15:42:23 +0100451_iso-8859-1 Hi Bright

Simple answer DON'T SORT ON THE FRONT END!!! You are doing work at the client that ought to be done at the server

Get DB2 to return the data in the order you want in the first place

Phil Grainger CA

________________________________

From: DB2 Data Base Discussion List on behalf of Bright Kasimani Sent: Thu 21/05/2009 12:11 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 Pagination logic [...] 49200 907 14_Re: History OT14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 21 May 2009 10:35:29 -0400343_us-ascii Yeah, but I started early. I had a personal computer in '67. (Check out the Digicomp 1 http://mindsontoys.com/kits.htm. I broke the first one, and they got me a second one, Folks, it was a real computer - with logic and programmability but too small for a compiler - just not an electricity-powered computer. It was mechanical.) [...] 50108 20 14_Re: History OT11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Thu, 21 May 2009 15:18:42 +0000325_Windows-1252 >I was learning computer programming in BASIC in the fall of ’73, so you’ve got me beat by a few years.

I've got you beat, too.

My first computer course was in '71. It was called 'Computer Concepts' and was a high school course. I learned FORTRAN. One so old that it had only arithmetic IF's. [...] 50129 518 14_Re: History OT13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Thu, 21 May 2009 09:01:12 -0700566_us-ascii >>You guys are SO young.<<

Yes, still under 50 (though not for long) and I'm looking forward to all of you retiring so I can start raking in the big bucks. Of course, by that time IBM will have invented technology to make systems programmers obsolete (something they've been trying to do for decades). I remember in 1994 one of my colleagues at Amex left the MVS group and joined the DB2 group because IBM announced some initiative to make systems programming so easy to do, you could hire a high school graduate to install your OS. She is near [...] 50648 57 14_Re: History OT0_24_carol.sutfin@REGIONS.COM31_Thu, 21 May 2009 11:22:42 -0500458_UTF-8 How about Fortran II in 1965 on an IBM 7045.

It was Spring break week my freshman year of college.

The "computer" courses were part of the Math department.

Carol Sutfin Corporate DBA Regions Financial Corp. (205)261-5214 carol.sutfin@regions.com





Ted MacNEIL To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List Re: [DB2-L] History OT [...] 50706 27 14_Re: History OT11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Thu, 21 May 2009 18:36:39 +0000406_- >The "computer" courses were part of the Math department.

At the University of Waterloo, they always have been. But, you can get a degree in Computer Science, which mine is (with a minor in Stats).

- Too busy driving to stop for gas!

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...] 50734 575 14_Re: History OT15_Campbell, Wayne28_Wayne.Campbell@COURTS.WA.GOV31_Thu, 21 May 2009 11:38:52 -0700638_us-ascii My first computer, Apple IIe 16k memory and duel floppy drives.

Most memorable quote from instructor in collage: When a student ask how much memory floppy(179k?) was, The instructor replied, "more than you would ever need.

That instructor was the first person I meet that could actually read a hex.

Wayne Campbell DB2 DBA Administrative Office of the Courts (360) 705-5268 Email: wayne.campbell@courts.wa.gov From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of db46@CHRYSLER.COM Sent: Wednesday, May 20, 2009 3:11 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT [...] 51310 120 14_Re: History OT13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US31_Thu, 21 May 2009 11:41:57 -0700500_us-ascii Ok, I can't resist anymore. I started in 67 on a Burroughs B-200 - Operator/programmer 4K of memory, no disk, had to read the lights on the console. It had a great assembler language - 3 operands.

http://closeyourbrowser.com/tag/burroughs-b200/

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of carol.sutfin@REGIONS.COM Sent: Thursday, May 21, 2009 9:23 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT [...] 51431 34 25_Re: EXPLAIN(NO) - Why????14_Peter Vanroose17_pvanroose@ABIS.BE31_Thu, 21 May 2009 18:44:38 +0000449_ISO-8859-1 >Unfortunately for us the binds are part of change control and trying to tell >people Explain(No) here and Explain(Yes) there would engender so much >confusion that it's easier just to automate a plan table clean up.

Wouldn't it be easier, then, that Explain(Yes) would be the default, and that DB2 silently ignores it when it does not find a PLAN_TABLE? That was more or less the original question of this thread, I believe. [...] 51466 26 24_Re: DB2 Pagination logic14_Peter Vanroose17_pvanroose@ABIS.BE31_Thu, 21 May 2009 18:49:33 +0000759_ISO-8859-1 Consider using a static scrollable cursor. (This will materialize the query result at the DB2 side, though.)

-- Peter Vanroose.

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA *

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________

IDUG DB2-L FAQ and e-mail settings are located on the IDUG.org Listserv page. If you are not already an IDUG.org member, please register at http://www.idug.org/register _____________________________________________________________________ 51493 168 49_Re: Group Bufferpool (Critical Shortage of Space)0_37_Sangameswara.R.Panchomarthi@CHASE.COM31_Thu, 21 May 2009 15:00:06 -0400342_us-ascii Thanks for the Reply. It appears that DB2 keeps the pageset P-Lock until the dataset is closed, which is causing the inter DB2 interest and GBP Flooding.

If we alter the object to Close 'Yes', does that release the Pageset P-lock? OR should we also need to reduce the DSMAX, so that the datasets get closed immediately ? [...] 51662 62 25_Re: EXPLAIN(NO) - Why????14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 21 May 2009 20:08:25 +0100530_iso-8859-1 Probably too late for DB2 X - there's always DB2 Y though.......

________________________________

From: DB2 Data Base Discussion List on behalf of Peter Vanroose Sent: Thu 21/05/2009 19:44 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] EXPLAIN(NO) - Why????





>Unfortunately for us the binds are part of change control and trying to tell >people Explain(No) here and Explain(Yes) there would engender so much >confusion that it's easier just to automate a plan table clean up. [...] 51725 202 14_Re: History OT14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 21 May 2009 20:09:46 +0100616_iso-8859-1 "duel floppy drives"??

At dawn, no doubt

Sorry Wayne - couldn't resist

Luckily Friday is looming

Phil G

________________________________

From: DB2 Data Base Discussion List on behalf of Campbell, Wayne Sent: Thu 21/05/2009 19:38 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT





My first computer, Apple IIe 16k memory and duel floppy drives.





Most memorable quote from instructor in collage: When a student ask how much memory floppy(179k?) was, The instructor replied, "more than you would ever need. [...] 51928 118 14_Re: History OT13_George Toolan19_gtoolan@COMCAST.NET31_Thu, 21 May 2009 16:57:13 -0400454_UTF-8 That beats my learning FORTRAN II on a loosely coupled 7090/7091 in 1967.

George Toolan

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of carol.sutfin@REGIONS.COM Sent: Thursday, May 21, 2009 12:23 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT

How about Fortran II in 1965 on an IBM 7045.

It was Spring break week my freshman year of college. [...] 52047 131 14_Re: History OT23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Thu, 21 May 2009 17:20:05 -0400442_utf-8 Fortran II was my first programming language in 1963.

Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com

Buffer Pool Tool for DB2 on www.LinkedIn.com Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1 [...] 52179 163 14_Re: History OT12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Thu, 21 May 2009 16:26:24 -0500470_us-ascii Yes, back when I helped Grace Hopper develop A-0 ....

Is if Friday yet?



Rick Weaver Working with the evolving Mainframe since 1977.



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joel Responsive Systems Sent: Thursday, May 21, 2009 4:20 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] History OT

Fortran II was my first programming language in 1963. [...] 52343 214 14_Re: History OT0_24_carol.sutfin@REGIONS.COM31_Thu, 21 May 2009 16:32:48 -0500426_US-ASCII Grace is my hero.

I want to grow up and be just like her and have a boat named after me.

Carol Sutfin Corporate DBA Regions Financial Corp. (205)261-5214 carol.sutfin@regions.com





"Weaver, Rick" To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List Re: [DB2-L] History OT



05/21/2009 04:26 PM [...] 52558 614 14_Re: History OT23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Thu, 21 May 2009 17:35:12 -0400475_iso-8859-1 Originally IBM said companies would not need a full time DBA for DB2.....



Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com

Buffer Pool Tool for DB2 on www.LinkedIn.com Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1 [...] 53173 72 51_Re: Submitting batch job from DB2 Stroed Procedure?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 22 May 2009 09:54:18 +1000387_US-ASCII From memory: - SUBMIT allocates an INTRDR dataset. (Hence the suggestion to use a JCL allocated INTRDR) - most REXX SP JCL I've seen has only the standard DB2 libraries in their STEPLIBs. This makes the execution environment "authorised" - an authorised environment cannot allocate an INTRDR dataset

James Campbell

On 21 May 2009 at 12:22, Nenad Vidak wrote: [...] 53246 42 14_Re: History OT14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 22 May 2009 09:54:18 +1000344_US-ASCII This is the first computer I used: http://en.wikipedia.org/wiki/CSIRAC 1962 - I was too young to really understand what I was doing, but I blew an overflow trying to calculate 2**64. Then it was time for Dad (who was programming some linear equations to the determine the optimal angle to take paper off rollers) to take me home. [...]