Unix Technical Forum

Which OS is the best option to install DB2 Universal DataBase Workgroup Server Unlimited Edition?

This is a discussion on Which OS is the best option to install DB2 Universal DataBase Workgroup Server Unlimited Edition? within the DB2 forums, part of the Database Server Software category; -->...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 05:54 PM
ja
 
Posts: n/a
Default Which OS is the best option to install DB2 Universal DataBase Workgroup Server Unlimited Edition?


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-26-2008, 05:54 PM
Mark A
 
Posts: n/a
Default Re: Which OS is the best option to install DB2 Universal DataBase Workgroup Server Unlimited Edition?

"ja" <ja@socal.rr.com> wrote in message
news:5qld90d05e7ggr975qdm2kt7ecoe4jr1il@4ax.com...
>

Works well on all supported OS's (Windows, UNIX, Linux). It may depend
somewhat on how much memory you have since there are different DB2 limits
for each if you are using 32 bit versions.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-26-2008, 05:55 PM
ja
 
Posts: n/a
Default Re: Which OS is the best option to install DB2 Universal DataBase Workgroup Server Unlimited Edition?

Well, I am getting a server with the following specs:
dual xeon 2.8 mhz
4gb of ram

By comparing win2k server and linux, which one is a better option as
far as speed goes?








On Mon, 3 May 2004 17:57:21 -0600, "Mark A" <ma@switchboard.net>
wrote:

>"ja" <ja@socal.rr.com> wrote in message
>news:5qld90d05e7ggr975qdm2kt7ecoe4jr1il@4ax.com.. .
>>

>Works well on all supported OS's (Windows, UNIX, Linux). It may depend
>somewhat on how much memory you have since there are different DB2 limits
>for each if you are using 32 bit versions.
>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-26-2008, 05:55 PM
Mark A
 
Posts: n/a
Default Re: Which OS is the best option to install DB2 Universal DataBase Workgroup Server Unlimited Edition?

"ja" <ja@socal.rr.com> wrote in message
news:3vhf90l1klmtuubdo84p1ie7mpjnast4vo@4ax.com...
> Well, I am getting a server with the following specs:
> dual xeon 2.8 mhz
> 4gb of ram
>
> By comparing win2k server and linux, which one is a better option as
> far as speed goes?
>

I believe that DB2 can address more memory on Windows 2K (important for DB2
Buffer Pools) than Linux. I may be wrong, but I think W2K DB2 memory limit
is about 3GB and Linux is closer to 1 GB.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 02-26-2008, 05:55 PM
Larry
 
Posts: n/a
Default Re: Which OS is the best option to install DB2 Universal DataBaseWorkgroup Server Unlimited Edition?

That brings up an interesting question. Is he running 32-bit or 64-bit
DB2? 64-bit lifts any addressability limitations. And I think the 32-bit
limit on Linux is actually about 1.7GB. Can't remember what it is on Win2k.

Larry Edelstein

Mark A wrote:

> "ja" <ja@socal.rr.com> wrote in message
> news:3vhf90l1klmtuubdo84p1ie7mpjnast4vo@4ax.com...
>
>>Well, I am getting a server with the following specs:
>>dual xeon 2.8 mhz
>>4gb of ram
>>
>>By comparing win2k server and linux, which one is a better option as
>>far as speed goes?
>>

>
> I believe that DB2 can address more memory on Windows 2K (important for DB2
> Buffer Pools) than Linux. I may be wrong, but I think W2K DB2 memory limit
> is about 3GB and Linux is closer to 1 GB.
>
>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 02-26-2008, 05:55 PM
Mark A
 
Posts: n/a
Default Re: Which OS is the best option to install DB2 Universal DataBase Workgroup Server Unlimited Edition?

"Larry" <Larry@nospam.net> wrote in message
news:8FWlc.130345$Gd3.31593249@news4.srv.hcvlny.cv .net...
> That brings up an interesting question. Is he running 32-bit or 64-bit
> DB2? 64-bit lifts any addressability limitations. And I think the 32-bit
> limit on Linux is actually about 1.7GB. Can't remember what it is on

Win2k.
>
> Larry Edelstein
>

Can someone run 64-bit DB2 on Windows 2000?


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 02-26-2008, 05:55 PM
Blair Adamache
 
Posts: n/a
Default Re: Which OS is the best option to install DB2 Universal DataBaseWorkgroup Server Unlimited Edition?

For 64-bit DB2 on Windows, you need one of:
Windows XP, Windows .Net, Windows 2003

Mark A wrote:

> "Larry" <Larry@nospam.net> wrote in message
> news:8FWlc.130345$Gd3.31593249@news4.srv.hcvlny.cv .net...
>
>>That brings up an interesting question. Is he running 32-bit or 64-bit
>>DB2? 64-bit lifts any addressability limitations. And I think the 32-bit
>>limit on Linux is actually about 1.7GB. Can't remember what it is on

>
> Win2k.
>
>>Larry Edelstein
>>

>
> Can someone run 64-bit DB2 on Windows 2000?
>
>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 02-26-2008, 05:55 PM
Blair Adamache
 
Posts: n/a
Default Re: Which OS is the best option to install DB2 Universal DataBaseWorkgroup Server Unlimited Edition?

The limit for DB2 shared memory on 32-bit Windows is 3 GB (larger if you
use AWE).

The limit on 32-bit Linux is tis about 2.2 GB with
SuSE SLES 8 service pack 2 and DB2 v8.1 FixPak 2 or later.

Larry wrote:

> That brings up an interesting question. Is he running 32-bit or 64-bit
> DB2? 64-bit lifts any addressability limitations. And I think the 32-bit
> limit on Linux is actually about 1.7GB. Can't remember what it is on Win2k.
>
> Larry Edelstein
>
> Mark A wrote:
>
>> "ja" <ja@socal.rr.com> wrote in message
>> news:3vhf90l1klmtuubdo84p1ie7mpjnast4vo@4ax.com...
>>
>>> Well, I am getting a server with the following specs:
>>> dual xeon 2.8 mhz
>>> 4gb of ram
>>>
>>> By comparing win2k server and linux, which one is a better option as
>>> far as speed goes?
>>>

>>
>> I believe that DB2 can address more memory on Windows 2K (important
>> for DB2
>> Buffer Pools) than Linux. I may be wrong, but I think W2K DB2 memory
>> limit
>> is about 3GB and Linux is closer to 1 GB.
>>
>>

>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 02-26-2008, 05:55 PM
Mark A
 
Posts: n/a
Default Re: Which OS is the best option to install DB2 Universal DataBase Workgroup Server Unlimited Edition?

"Blair Adamache" <badamache@2muchspam.yahoo.com> wrote in message
news:c7aqrt$ddk$1@hanover.torolab.ibm.com...
> The limit for DB2 shared memory on 32-bit Windows is 3 GB (larger if you
> use AWE).
>
> The limit on 32-bit Linux is tis about 2.2 GB with
> SuSE SLES 8 service pack 2 and DB2 v8.1 FixPak 2 or later.
>

Any idea about RedHat?


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 02-26-2008, 05:56 PM
Blair Adamache
 
Posts: n/a
Default Re: Which OS is the best option to install DB2 Universal DataBaseWorkgroup Server Unlimited Edition?

Well I've heard about something called "4GB/4GB split kernel" that
should allow you to do 3 GB - on RH and SuSE, but I have no idea if IBM
has ever tested this. Perhaps a linux guru (bb?) can enlighten us.

Mark A wrote:

> "Blair Adamache" <badamache@2muchspam.yahoo.com> wrote in message
> news:c7aqrt$ddk$1@hanover.torolab.ibm.com...
>
>>The limit for DB2 shared memory on 32-bit Windows is 3 GB (larger if you
>>use AWE).
>>
>>The limit on 32-bit Linux is tis about 2.2 GB with
>>SuSE SLES 8 service pack 2 and DB2 v8.1 FixPak 2 or later.
>>

>
> Any idea about RedHat?
>
>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:49 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com