Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-18 Thread Timothy Sipples
Chris Craddock writes: It is true that there are separate code bases for the z and non-z forms of DB2, but as time passes most new functions are added to the open platforms first and wherever possible that code is shared with DB2 on z. I'm told that uni-directionality used to be true, but now

Re: SPAM-LOW: Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-16 Thread R.S.
Rick Fochtman wrote: [...] IIRC, ?.0 release of anything was barely better than beta code and usually got a massive load of fixes before anyone could really expect any useful value. And the ?.8 release was the final release and 'functional stabilization' time. Are talking about DB2 ? Well,

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-16 Thread Walt Farrell
On 3/15/2007 11:26 AM, R.S. wrote: What can I do with XML in DB2 ? My application doesn't use it. I'm *not* application programmer, so I won't change it. You could, for example, tell RACF SMF Unload (IRRADU00) to produce an XML-formatted output file instead of a flat file. This takes much

DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Timothy Sipples
DB2 Version 9 for z/OS available March 16, 2007: http://www.ibm.com/common/ssi/rep_ca/1/897/ENUS207-041/ENUS207041.PDF More stuff moves into 64-bit land, lots of XML goodies, increased zIIP affinity (including stored procedures), rearchitected stored procedures (for better performance), more

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Shane
On Thu, 2007-03-15 at 17:04 +1000, Timothy Sipples wrote: DB2 Version 9 for z/OS available March 16, 2007: Is it just me, or has anyone else noticed that IBM never releases a ?.0 of DB2 - 5.1, 6.1, 7.1, 8.1 now 9.1 Maybe they know no-one trusts a dot.zero release. Then again, given what a

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Bob Shannon
Then again, given what a f*ck-up 6.1 was with star-join ... DB2 6.1 is AFH Shane. Bob -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Ted MacNEIL
DB2 Version 9 for z/OS available March 16, 2007: Thank you for your (unbiased) marketting pitch! - Too busy driving to stop for gas! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread R.S.
Timothy Sipples wrote: DB2 Version 9 for z/OS available March 16, 2007: http://www.ibm.com/common/ssi/rep_ca/1/897/ENUS207-041/ENUS207041.PDF More stuff moves into 64-bit land, lots of XML goodies, increased zIIP affinity [...] So, more XLM, more Java more other modern stuff. How many

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Jon Brock
Wouldn't XML, Java, and more other modern stuff qualify as an add-on such as you mentioned in the MVS Experience thread? Surely you're not saying, Don't tell me about DB2 and your XML, we DON'T NEED IT! big grin Jon snip So, more XLM, more Java more other modern stuff. How many

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Tom Moulder
On the subject of dot.zero release, did you also notice that there is never a dot.two release? Always new versions. New versions typically have a price increase on the MLC, whilst new releases do not. My experience has been that every even numbered version of DB2 has brought with it significant

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread R.S.
Jon Brock wrote: Wouldn't XML, Java, and more other modern stuff qualify as an add-on such as you mentioned in the MVS Experience thread? Surely you're not saying, Don't tell me about DB2 and your XML, we DON'T NEED IT! big grin Apples and oranges. zIIP, zAAP, IFL are for non-MVS

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Sebastian Welton
On Thu, 15 Mar 2007 10:22:51 -0500, Tom Moulder [EMAIL PROTECTED] wrote: On the subject of dot.zero release, did you also notice that there is never a dot.two release? Always new versions. New versions typically have a price increase on the MLC, whilst new releases do not. Unless you're on a

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Tom Schmidt
On Thu, 15 Mar 2007 15:25:51 +0100, R.S. wrote: Timothy Sipples wrote: DB2 Version 9 for z/OS available March 16, 2007: http://www.ibm.com/common/ssi/rep_ca/1/897/ENUS207-041/ENUS207041.PDF More stuff moves into 64-bit land, lots of XML goodies, increased zIIP affinity [...] So, more XLM,

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread jim harrison
I met with some IBM DB2 folks this week and they claim performance was a big aim of V9 and that it buys back a lot of the CPU lost to V8. Not sure about the memory, but with 64 bit addressing, I can't see it going down. - Original Message - From: R.S. [EMAIL PROTECTED] Newsgroups:

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Craddock, Chris
On the subject of dot.zero release, did you also notice that there is never a dot.two release? Always new versions. New versions typically have a price increase on the MLC, whilst new releases do not. I don't know that there's any particular rhyme or reason to the numbering scheme. There

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Dave Kopischke
On Thu, 15 Mar 2007 08:53:25 -0400, Bob Shannon wrote: Then again, given what a f*ck-up 6.1 was with star-join ... DB2 6.1 is AFH Shane. AFH ??? I tried to look up this acronym, but I can only find stupid things like: American Fork and Hoe Assassins for Hire Australian Fluid Handling or my

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Bob Shannon
AFH ??? Ancient History Bob Shannon -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Ray Mullins
Yes, but the DB2 on z/VM and z/VSE is not really DB2. :-) There are 3 different code platforms for DB2 - I'm missing some details, so someone please fill in the blanks... - Non-mainframe platforms (Unix-type), which came from another data base product purchased by IBM a long time ago

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread john gilmore
Chris Craddock writes: I don't know that there's any particular rhyme or reason to the numbering scheme. and I should agree in general. There is, however, one ROT that I have found very useful: When a supplanting release i + 1 is announced before release i is shipped, avoid release i.

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Chase, John
-Original Message- From: IBM Mainframe Discussion List On Behalf Of Ray Mullins Yes, but the DB2 on z/VM and z/VSE is not really DB2. :-) There are 3 different code platforms for DB2 - I'm missing some details, so someone please fill in the blanks... - Non-mainframe

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Clark Morris
On 15 Mar 2007 09:29:24 -0700, in bit.listserv.ibm-main you wrote: On the subject of dot.zero release, did you also notice that there is never a dot.two release? Always new versions. New versions typically have a price increase on the MLC, whilst new releases do not. I don't know that

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Chase, John
-Original Message- From: IBM Mainframe Discussion List On Behalf Of john gilmore Chris Craddock writes: I don't know that there's any particular rhyme or reason to the numbering scheme. and I should agree in general. There is, however, one ROT that I have found very useful:

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Ray Mullins
Ah, SQL/DS - that's what I was thinking of. But I have seen DL/1 references on the other platforms in casual conversation. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Chase, John Sent: Thursday March 15 2007 13:40 To:

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Wayne Driscoll
Ray, The non-mainframe (ie DB2 LUW (Linux/Unix/Windows) is actually based on the OS/2 Database Manager, which became DB2/2 then DB2 UDB, then UDB became the standard moniker for all DB2 products, so LUW was used to distinguish from z/OS. Also, in the non-MF world, 8.2 was Stinger, and 9 is Viper.

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Craddock, Chris
There are 3 different code platforms for DB2 - I'm missing some details, so someone please fill in the blanks... - Non-mainframe platforms (Unix-type), which came from another data base product purchased by IBM a long time ago (Sequent?), and has some code shared with

Re: SPAM-LOW: Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Rick Fochtman
snip--- Is it just me, or has anyone else noticed that IBM never releases a ?.0 of DB2 - 5.1, 6.1, 7.1, 8.1 now 9.1 Maybe they know no-one trusts a dot.zero release. Then again, given what a f*ck-up 6.1 was with star-join ... I noticed our DBAs were out of

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Rich Smrcina
The IBM relational database that runs on VM VSE is called DB2, but it is essentially the same codebase as SQL/DS. Unfortunately the product hasn't changed much in the last 15 years or so. Craddock, Chris wrote: There are 3 different code platforms for DB2 - I'm missing some details, so

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Tom Moulder
-Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Sebastian Welton Sent: Thursday, March 15, 2007 10:37 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9) On Thu, 15 Mar 2007 10:22:51 -0500,

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Shane Ginnane
CC wrote on 16/03/2007 02:29:12 AM: There was a huge debacle with IMS V2.2 in the mid '80s that cost several high-end customers $$ millions. V2.2 was going to be the release that finally got the V1.3 customers to migrate and I suppose it eventually was, but there were lots of bodies left in

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Henry Willard
Craddock, Chris wrote: There are 3 different code platforms for DB2 - I'm missing some details, so someone please fill in the blanks... - Non-mainframe platforms (Unix-type), which came from another data base product purchased by IBM a long time ago (Sequent?), and has some

Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)

2007-03-15 Thread Craddock, Chris
There was a huge debacle with IMS V2.2 in the mid '80s that cost several high-end customers $$ millions. Shane asks (rhetorically) Let me guess - you were employed by one such customer at the time ... Oh yeah. No prizes for guessing who. CC