If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > 32 cylinder DB2 on aix

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-28-09, 03:47
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
32 cylinder DB2 on aix

G'day. At my current's client site I'm confronted with db2 v8.2.5 32 bit on aix v5.3 64 bit with enough RAM.
I want to increase the various buffer pool sizes as much as possible. My first attempt failed because I assumed (shame on me) that I could configure 3,2Gb of storage.... WRONG! Hello hidden buffer-pools
Then google told me that on aix i can only configure 1,75 Gb. Yep, that's all folks.

What google could not find for me is what do I have to squeeze in that 1,75Gb? Does that include buffer-pools, lock-list, package-cache etc etc.
And what about util_heap-sz, should I reserve space for that memory-object as well?
Frustrating cofiguration: all that RAM unused in the O.S. and disappointing bufferpool hit-rates and nothing you can do about it.
Reply With Quote
  #2 (permalink)  
Old 10-28-09, 04:50
rahul_s80 rahul_s80 is offline
Registered User
 
Join Date: Jul 2006
Location: Pune , India
Posts: 433
see if this tech article helps you out :
The DB2 UDB memory model
__________________
Rahul Singh
Certified DB2 9 DBA / Application Developer
Reply With Quote
  #3 (permalink)  
Old 10-28-09, 06:40
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Quote:
On 32-bit AIX, the 4GB of addressable memory space is broken down to 16 segments, 256MB each
Okay, but I'm on 64 bit AIX with 32 bit DB2. Do the same rules apply?
If so, it leaves me emptyhanded. Not much I can do.
Reply With Quote
  #4 (permalink)  
Old 10-28-09, 06:54
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
double post, sorry

Last edited by dr_te_z; 10-28-09 at 06:58.
Reply With Quote
  #5 (permalink)  
Old 10-28-09, 08:13
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
In v8.2, you could allocate up to 2GB of db shared memory. With 64-bit AIX, 32-bit instance is limited to 32-bit limitations until the instance is converted to 64-bit.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On