DB2 running in a Linux enviornment
what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393
Re: DB2 running in a Linux enviornment
Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
Re: DB2 running in a Linux enviornment
Dave, what about storage capacity for large data bases and performance. Date: Thu, 21 Apr 2011 10:17:46 -0500 From: d...@vsoft-software.com Subject: Re: DB2 running in a Linux enviornment To: IBMVM@LISTSERV.UARK.EDU Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
Re: DB2 running in a Linux enviornment
Cliff, We have about 15 z/Linux servers running db2 V9.5 and V9.7 servers between 4 and 6 GB of storage, using Luns and with No File System cache db2 option enable, with REORDER option off to this servers.. We have experiemented great performances. On Thu, Apr 21, 2011 at 12:32 PM, clifford jackson cliffordjackson...@msn.com wrote: Dave, what about storage capacity for large data bases and performance. Date: Thu, 21 Apr 2011 10:17:46 -0500 From: d...@vsoft-software.com Subject: Re: DB2 running in a Linux enviornment To: IBMVM@LISTSERV.UARK.EDU Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
Re: DB2 running in a Linux enviornment
Rogério, what mainframe/hardware are you running this on? IFL? z/VM? Thanks, Steve From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Rogério Soares Sent: Thursday, April 21, 2011 11:38 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: DB2 running in a Linux enviornment Cliff, We have about 15 z/Linux servers running db2 V9.5 and V9.7 servers between 4 and 6 GB of storage, using Luns and with No File System cache db2 option enable, with REORDER option off to this servers.. We have experiemented great performances. On Thu, Apr 21, 2011 at 12:32 PM, clifford jackson cliffordjackson...@msn.com wrote: Dave, what about storage capacity for large data bases and performance. Date: Thu, 21 Apr 2011 10:17:46 -0500 From: d...@vsoft-software.com Subject: Re: DB2 running in a Linux enviornment To: IBMVM@LISTSERV.UARK.EDU Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
Re: DB2 running in a Linux enviornment
Actually we running with Z196 with Z/VM 6.1, on a lpar with 200GB of Storage and 20 IFLS On Thu, Apr 21, 2011 at 12:52 PM, Gentry, Stephen stephen.gen...@lafayettelife.com wrote: Rogério, what mainframe/hardware are you running this on? IFL? z/VM? Thanks, Steve *From:* The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] *On Behalf Of *Rogério Soares *Sent:* Thursday, April 21, 2011 11:38 AM *To:* IBMVM@LISTSERV.UARK.EDU *Subject:* Re: DB2 running in a Linux enviornment Cliff, We have about 15 z/Linux servers running db2 V9.5 and V9.7 servers between 4 and 6 GB of storage, using Luns and with No File System cache db2 option enable, with REORDER option off to this servers.. We have experiemented great performances. On Thu, Apr 21, 2011 at 12:32 PM, clifford jackson cliffordjackson...@msn.com wrote: Dave, what about storage capacity for large data bases and performance. Date: Thu, 21 Apr 2011 10:17:46 -0500 From: d...@vsoft-software.com Subject: Re: DB2 running in a Linux enviornment To: IBMVM@LISTSERV.UARK.EDU Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
Re: DB2 running in a Linux enviornment
Yeah, I guess you would have great performance. 8-) Thanks for the info. Steve From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Rogério Soares Sent: Thursday, April 21, 2011 12:02 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: DB2 running in a Linux enviornment Actually we running with Z196 with Z/VM 6.1, on a lpar with 200GB of Storage and 20 IFLS On Thu, Apr 21, 2011 at 12:52 PM, Gentry, Stephen stephen.gen...@lafayettelife.com wrote: Rogério, what mainframe/hardware are you running this on? IFL? z/VM? Thanks, Steve From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Rogério Soares Sent: Thursday, April 21, 2011 11:38 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: DB2 running in a Linux enviornment Cliff, We have about 15 z/Linux servers running db2 V9.5 and V9.7 servers between 4 and 6 GB of storage, using Luns and with No File System cache db2 option enable, with REORDER option off to this servers.. We have experiemented great performances. On Thu, Apr 21, 2011 at 12:32 PM, clifford jackson cliffordjackson...@msn.com wrote: Dave, what about storage capacity for large data bases and performance. Date: Thu, 21 Apr 2011 10:17:46 -0500 From: d...@vsoft-software.com Subject: Re: DB2 running in a Linux enviornment To: IBMVM@LISTSERV.UARK.EDU Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
Re: DB2 running in a Linux enviornment
hehehe, with some troubles too ;) but nothing that listeners can't help with great informations. By the way: THANKS for all peoples that help me A LOT recently. On Thu, Apr 21, 2011 at 1:06 PM, Gentry, Stephen stephen.gen...@lafayettelife.com wrote: Yeah, I guess you would have great performance. 8-) Thanks for the info. Steve *From:* The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] *On Behalf Of *Rogério Soares *Sent:* Thursday, April 21, 2011 12:02 PM *To:* IBMVM@LISTSERV.UARK.EDU *Subject:* Re: DB2 running in a Linux enviornment Actually we running with Z196 with Z/VM 6.1, on a lpar with 200GB of Storage and 20 IFLS On Thu, Apr 21, 2011 at 12:52 PM, Gentry, Stephen stephen.gen...@lafayettelife.com wrote: Rogério, what mainframe/hardware are you running this on? IFL? z/VM? Thanks, Steve *From:* The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] *On Behalf Of *Rogério Soares *Sent:* Thursday, April 21, 2011 11:38 AM *To:* IBMVM@LISTSERV.UARK.EDU *Subject:* Re: DB2 running in a Linux enviornment Cliff, We have about 15 z/Linux servers running db2 V9.5 and V9.7 servers between 4 and 6 GB of storage, using Luns and with No File System cache db2 option enable, with REORDER option off to this servers.. We have experiemented great performances. On Thu, Apr 21, 2011 at 12:32 PM, clifford jackson cliffordjackson...@msn.com wrote: Dave, what about storage capacity for large data bases and performance. Date: Thu, 21 Apr 2011 10:17:46 -0500 From: d...@vsoft-software.com Subject: Re: DB2 running in a Linux enviornment To: IBMVM@LISTSERV.UARK.EDU Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
Re: DB2 running in a Linux enviornment
While I have no direct, hands on knowledge of DB2 on zLinux, I *can* state that Oracle runs very well in such an environment, and can serve out very large databases with very good to excellent performance. A bit of system's tuning is required, of course, but it's well worth the effort. Note that DB2 for z/VM runs in a CMS based environment, which is 31-bit, while the zLinux environment is 64-bit. I believe DB2 for zLinux is also 64-bit capable, allowing bigger databases in storage, etc. DJ On 04/21/2011 10:32 AM, clifford jackson wrote: Dave, what about storage capacity for large data bases and performance. Date: Thu, 21 Apr 2011 10:17:46 -0500 From: d...@vsoft-software.com Subject: Re: DB2 running in a Linux enviornment To: IBMVM@LISTSERV.UARK.EDU Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
Re: DB2 running in a Linux enviornment
Optimal use of personnel Efficient overcommitment of resources Conservation of limited LPAR resource (even on the biggest boxes, you can only have so many) Network efficiency and redundancy Built in automation function (PROP) Rapid recovery using standard tools (ADRDSSU lets you put the whole environment back with the same tools you use for z/OS if you have it - cuts recovery time substantially) Simple production of security zones Need I continue? From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of clifford jackson Sent: Thursday, April 21, 2011 11:13 AM To: IBMVM@LISTSERV.UARK.EDU Subject: DB2 running in a Linux enviornment what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393
Re: DB2 running in a Linux enviornment
One of my customers is very happy with the replacement of his old DB2/VM with UDB under Linux under z/VM. - better performance - better management tools, more suited for 24/24 7/7 2011/4/21 Dave Jones d...@vsoft-software.com Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544 -- Kris Buelens, IBM Belgium, VM customer support
Re: DB2 running in a Linux enviornment
Cliff, To add to this, the JDBC drivers for DB2 under z/VM are not being upgraded, either. This causes a problem with some 3rd party software connecting to the database. Nora Graves nora.e.gra...@irs.gov Main IRS, Room 6531 (202) 622-6735 Fax (202) 622-3123 SE:W:CAR:MP:D:KS:BRSI -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Dave Jones Sent: Thursday, April 21, 2011 11:18 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: DB2 running in a Linux enviornment Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
Re: DB2 running in a Linux enviornment
FYI.. DB2 under VM still has periodic (every 18 months or so) new releases and is actively supported. Tony Pignataro From: clifford jackson cliffordjackson...@msn.com To: IBMVM@LISTSERV.UARK.EDU Date: 04/21/2011 11:38 AM Subject:Re: DB2 running in a Linux enviornment Sent by:The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU Dave, what about storage capacity for large data bases and performance. Date: Thu, 21 Apr 2011 10:17:46 -0500 From: d...@vsoft-software.com Subject: Re: DB2 running in a Linux enviornment To: IBMVM@LISTSERV.UARK.EDU Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544