Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 it's bi-directional. - - - - - Timothy Sipples IBM Consulting Enterprise Software Architect Specializing in Software Architectures Related to System z Based in Tokyo, Serving IBM Japan and IBM Asia-Pacific E-Mail: [EMAIL PROTECTED] -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: SPAM-LOW: Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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, I can't remember versions ?.0 (4.0, 5.0, 6.0), but I pretty sure there were no versions ?.8 (4.8, 5.8, 6.8, 7.8). Still talking about DB2 on MVS. -- Radoslaw Skorupka Lodz, Poland -- BRE Bank SA ul. Senatorska 18 00-950 Warszawa www.brebank.pl Sd Rejonowy dla m. st. Warszawy XII Wydzia Gospodarczy Krajowego Rejestru Sdowego, nr rejestru przedsibiorców KRS 025237 NIP: 526-021-50-88 Wedug stanu na dzie 01.01.2007 r. kapita zakadowy BRE Banku SA (w caoci opacony) wynosi 118.064.140 z. W zwizku z realizacj warunkowego podwyszenia kapitau zakadowego, na podstawie uchwa XVI WZ z dnia 21.05.2003 r., kapita zakadowy BRE Banku SA moe ulec podwyszeniu do kwoty 118.760.528 z. Akcje w podwyszonym kapitale zakadowym bd w caoci opacone. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 less DASD space for the file itself. You could then import that XML data into DB2 V9 in XML format, and run XML queries against it for security reporting. Just one thought; I'm still playing around with it. Walt Farrell, CISSP z/OS Security Design, IBM -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 leapfrogging in SQL vocabulary, etc., etc. - - - - - Timothy Sipples IBM Consulting Enterprise Software Architect Specializing in Software Architectures Related to System z Based in Tokyo, Serving IBM Japan and IBM Asia-Pacific E-Mail: [EMAIL PROTECTED] -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 f*ck-up 6.1 was with star-join ... I noticed our DBAs were out of the office all day yesterday - free breakfast has to be better than going to work and perusing the web. Shane ... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 installations really use it ? Can I use zIIP for my COBOL based application using CICS for online regular COBOL-DB2 for batch? Is new DB2 even slower than DB2 v.8 which is in turn slower than DB2 v.7 ? Does it consume more memory ? g -- Radoslaw Skorupka Lodz, Poland -- BRE Bank SA ul. Senatorska 18 00-950 Warszawa www.brebank.pl Sd Rejonowy dla m. st. Warszawy XII Wydzia Gospodarczy Krajowego Rejestru Sdowego, nr rejestru przedsibiorców KRS 025237 NIP: 526-021-50-88 Wedug stanu na dzie 01.01.2007 r. kapita zakadowy BRE Banku SA (w caoci opacony) wynosi 118.064.140 z. W zwizku z realizacj warunkowego podwyszenia kapitau zakadowego, na podstawie uchwa XVI WZ z dnia 21.05.2003 r., kapita zakadowy BRE Banku SA moe ulec podwyszeniu do kwoty 118.760.528 z. Akcje w podwyszonym kapitale zakadowym bd w caoci opacone. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 installations really use it ? /snip -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 problems. The succeeding odd numbered version has little new function, but did make the new function from the even numbered version that had many problems with it work. Tom Moulder T-REX Associates, Inc. Opinions are purely my own based on my limited experience with DB2 (since 1984) -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Shane Sent: Thursday, March 15, 2007 7:46 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, 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 f*ck-up 6.1 was with star-join ... I noticed our DBAs were out of the office all day yesterday - free breakfast has to be better than going to work and perusing the web. Shane ... -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.11/723 - Release Date: 3/15/2007 11:27 AM -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 workloads. Yes, I know, zAAP and zIIP are used under z/OS, but for modern workloads. If your apllication does not use it (majority of traditional applications don't) then you simply don't need it. When my application started to use MQ, I installed it and learnt. When my application started to use cryptography, I installed it and learnt. I also learnt and tried many other things, like DF/SMB just for curiosity. 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. I know what can I do i.e. with SMS, RMM, HSM, ICSF, HCD and many others 20 years old new things. Some (I repeat: *some*) old farts don't know - it's still to new for them. BTW: I'm not so young... vbg -- Radoslaw Skorupka Lodz, Poland -- BRE Bank SA ul. Senatorska 18 00-950 Warszawa www.brebank.pl Sd Rejonowy dla m. st. Warszawy XII Wydzia Gospodarczy Krajowego Rejestru Sdowego, nr rejestru przedsibiorców KRS 025237 NIP: 526-021-50-88 Wedug stanu na dzie 01.01.2007 r. kapita zakadowy BRE Banku SA (w caoci opacony) wynosi 118.064.140 z. W zwizku z realizacj warunkowego podwyszenia kapitau zakadowego, na podstawie uchwa XVI WZ z dnia 21.05.2003 r., kapita zakadowy BRE Banku SA moe ulec podwyszeniu do kwoty 118.760.528 z. Akcje w podwyszonym kapitale zakadowym bd w caoci opacone. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
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, 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 different platform. There was a DB2 UDB 8.2.2 for Linux, etc and if you're running DB2 Server, which VM and VSE are, then the current version is 7.4 I believe. Seb. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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, more Java more other modern stuff. How many installations really use it ? I am fairly sure my site will be using it but I don't know their schedule. Can I use zIIP for my COBOL based application using CICS for online regular COBOL-DB2 for batch? Yes, you can! Here's how: You run your shiny new DB2 work on the zIIP which frees up your non-z??P processors for your COBOL based applications using CICS. Really simple! (You asked if you can use the zIIP but you didn't ask if you could run COBOL on the zIIP.) My site has 4 zAAPs and 1 zIIP (so far) and we found that the zIIP was used MUCH more often than we (or IBM) had predicted. As I type this the zIIP is running around 35-40% busy with the CPs at 99%. Some days the zIIP is in the 90-99% range but the DB2 workload isn't busy right now. (By the way, Tim isn't an 'old guy' like most posters on this list. He is moderately young (certainly by ibm-main standards) and very enthusiastic for the z/Series platforms. Lets keep him that way.) -- Tom Schmidt Madison, WI -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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: bit.listserv.ibm-main To: IBM-MAIN@BAMA.UA.EDU Sent: Thursday, March 15, 2007 10:25 AM Subject: Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9) Is new DB2 even slower than DB2 v.8 which is in turn slower than DB2 v.7 ? Does it consume more memory ? g -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 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 its wake. IBM seemed a bit twitchy about release numbers for a while after that but memories fade. If you picked any digit at random you could probably make the case that they either do or do not favor that digit. I don't think there's any significant corporate consciousness behind choosing those numbers. My experience has been that every even numbered version of DB2 has brought with it significant problems. The succeeding odd numbered version has little new function, but did make the new function from the even numbered version that had many problems with it work. Even numbered releases tend to be the ones that bring in the biggest chunks of new function and the odd releases tend to be the cleanup releases, but even that isn't carved in stone. In any case, lots of new function almost always equals lots of new problems. CC -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 favorite: Angel from Heaven I'm sensing that none of these fit the tone of the conversation. Is there an Aussie acronym site I should be searching ??? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 (Sequent?), and has some code shared with Informix - z/OS (the original System R) - z/VSE, z/VM, which IIRC is based on DL/1 DB2 9 (note the lack of V - Timothy, you aren't following proper IBM marketing format *g* ) adds the XML functionality in DB2 for non-MF 8.2, AKA Viper. The big primary change is the introduction of native XML data storage, which does not follow Dr. Codd's model (shock! Horrors! Performance, finally!). Although this is not the first native XML data base - Software AG's Tamino, for example, has been around for a long, long time. Later, Ray -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Sebastian Welton Sent: Thursday March 15 2007 08:37 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, 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 different platform. There was a DB2 UDB 8.2.2 for Linux, etc and if you're running DB2 Server, which VM and VSE are, then the current version is 7.4 I believe. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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. John Gilmore Ashland, MA 01721-1817 USA _ Play Flexicon: the crossword game that feeds your brain. PLAY now for FREE. http://zone.msn.com/en/flexicon/default.htm?icid=flexicon_hmtagline -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
-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 platforms (Unix-type), which came from another data base product purchased by IBM a long time ago (Sequent?), and has some code shared with Informix - z/OS (the original System R) - z/VSE, z/VM, which IIRC is based on DL/1 IIRC, DL/I maps to IMS On VM/ESA (previous shop; many moons ago) we ran SQL, which probably maps to DB2 on z/OS. I think it was also called SQL on VSE. -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 there's any particular rhyme or reason to the numbering scheme. 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 its wake. IBM seemed a bit twitchy about release numbers for a while after that but memories fade. If you picked any digit at random you could probably make the case that they either do or do not favor that digit. I don't think there's any significant corporate consciousness behind choosing those numbers. My experience has been that every even numbered version of DB2 has brought with it significant problems. The succeeding odd numbered version has little new function, but did make the new function from the even numbered version that had many problems with it work. Even numbered releases tend to be the ones that bring in the biggest chunks of new function and the odd releases tend to be the cleanup releases, but even that isn't carved in stone. In any case, lots of new function almost always equals lots of new problems. Somehow I have the feeling that the major difference between the z side of the house and the Microsoft side of the house is that the z side of the house is more prone to test and look for problems. From what I see on my home machine, if I care to, I can find out a lot about the problems that may be on my system from Microsoft. I suspect that if you put a seasoned z series veteran in charge of the Microsoft side that it would become fairly reliable. CC -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
-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: When a supplanting release i + 1 is announced before release i is shipped, avoid release i. IIRC, CICS TS 2.2 was announced before 2.1 shipped. However, 2.1 had been announced as an early adopter release for whatever new functionality was being offered, and ISTR that the 2.1 announcement recommended that production users of CICS TS should wait for 2.2. Another trivium regarding CICS TS: Each of the first two versions delivered three release levels. -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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: IBM-MAIN@BAMA.UA.EDU Subject: Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9) -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 platforms (Unix-type), which came from another data base product purchased by IBM a long time ago (Sequent?), and has some code shared with Informix - z/OS (the original System R) - z/VSE, z/VM, which IIRC is based on DL/1 IIRC, DL/I maps to IMS On VM/ESA (previous shop; many moons ago) we ran SQL, which probably maps to DB2 on z/OS. I think it was also called SQL on VSE. -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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. Wayne Driscoll Product Developer JME Software LLC NOTE: All opinions are strictly my own. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Ray Mullins Sent: Thursday, March 15, 2007 3:33 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9) 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 (Sequent?), and has some code shared with Informix - z/OS (the original System R) - z/VSE, z/VM, which IIRC is based on DL/1 DB2 9 (note the lack of V - Timothy, you aren't following proper IBM marketing format *g* ) adds the XML functionality in DB2 for non-MF 8.2, AKA Viper. The big primary change is the introduction of native XML data storage, which does not follow Dr. Codd's model (shock! Horrors! Performance, finally!). Although this is not the first native XML data base - Software AG's Tamino, for example, has been around for a long, long time. Later, Ray -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Sebastian Welton Sent: Thursday March 15 2007 08:37 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, 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 different platform. There was a DB2 UDB 8.2.2 for Linux, etc and if you're running DB2 Server, which VM and VSE are, then the current version is 7.4 I believe. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 Informix - z/OS (the original System R) - z/VSE, z/VM, which IIRC is based on DL/1 IIRC, DL/I maps to IMS On VM/ESA (previous shop; many moons ago) we ran SQL, which probably maps to DB2 on z/OS. I think it was also called SQL on VSE. The first IBM relational product was SQL/DS which ran on VM. System/R was the original research prototype and it never shipped to the outside world. DB2 was developed independently of SQL/DS and it had a completely MVS-centric design that could never have fit into any other IBM mainframe OS. I don't know if SQL/DS ever ran on VSE, but I am certain that DB2 never did. DL/1 (data language 1) was and is the interface language for IMS/DB and its successors. It supports access to hierarchical parent/child data structures with verbs like Get Unique (GU), Get Next (GN) etc. The DL/1 model is wildly different than any SQL dialect. 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. CC -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: SPAM-LOW: Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 the office all day yesterday - free breakfast has to be better than going to work and perusing the web. -unsnip 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. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 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 Informix - z/OS (the original System R) - z/VSE, z/VM, which IIRC is based on DL/1 IIRC, DL/I maps to IMS On VM/ESA (previous shop; many moons ago) we ran SQL, which probably maps to DB2 on z/OS. I think it was also called SQL on VSE. The first IBM relational product was SQL/DS which ran on VM. System/R was the original research prototype and it never shipped to the outside world. DB2 was developed independently of SQL/DS and it had a completely MVS-centric design that could never have fit into any other IBM mainframe OS. I don't know if SQL/DS ever ran on VSE, but I am certain that DB2 never did. DL/1 (data language 1) was and is the interface language for IMS/DB and its successors. It supports access to hierarchical parent/child data structures with verbs like Get Unique (GU), Get Next (GN) etc. The DL/1 model is wildly different than any SQL dialect. 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. CC -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- Rich Smrcina VM Assist, Inc. Phone: 414-491-6001 Ans Service: 360-715-2467 rich.smrcina at vmassist.com Catch the WAVV! http://www.wavv.org WAVV 2007 - Green Bay, WI - May 18-22, 2007 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
-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, 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 different platform. There was a DB2 UDB 8.2.2 for Linux, etc and if you're running DB2 Server, which VM and VSE are, then the current version is 7.4 I believe. Seb. Pray tell what other platform is there??? Is there another platform other than z? Tom Moulder T-REX Associates, Inc. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.11/723 - Release Date: 3/15/2007 11:27 AM -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 its wake. Let me guess - you were employed by one such customer at the time ... Shane ... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 code shared with Informix - z/OS (the original System R) - z/VSE, z/VM, which IIRC is based on DL/1 IIRC, DL/I maps to IMS On VM/ESA (previous shop; many moons ago) we ran SQL, which probably maps to DB2 on z/OS. I think it was also called SQL on VSE. The first IBM relational product was SQL/DS which ran on VM. System/R was the original research prototype and it never shipped to the outside world. DB2 was developed independently of SQL/DS and it had a completely MVS-centric design that could never have fit into any other IBM mainframe OS. I don't know if SQL/DS ever ran on VSE, but I am certain that DB2 never did. DL/1 (data language 1) was and is the interface language for IMS/DB and its successors. It supports access to hierarchical parent/child data structures with verbs like Get Unique (GU), Get Next (GN) etc. The DL/1 model is wildly different than any SQL dialect. 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. CC SQL/DS was actually released on VSE a few months before VM. It was a cleaned-up version of System/R. DB2 was written from scratch to run on MVS. Besides the three mentioned so far there is also a fourth DB2 that is integrated with i5/OS. h -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 V9 z/OS GA (Was: What to do with extra storage on new z9)
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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
