473,836 Members | 1,625 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

database Share Memory Limit (2 GB ) in a Instance is total of all Db shared memory of all databases in a single Instance!!

Hi ,

Appreciate if someone can clarify if database Share Memory Limit
(2 GB ) in Unix 32 bit boxes is the top limit for all the databases
put together in a database or is it for each of the database in an
Instance
Thanks & regards
sadanjan

Jul 21 '06 #1
3 3153

sa******@gmail. com wrote:
Hi ,

Appreciate if someone can clarify if database Share Memory Limit
(2 GB ) in Unix 32 bit boxes is the top limit for all the databases
put together in a database or is it for each of the database in an
Instance
Thanks & regards
sadanjan
Hi Sadanjan,

This limit is per-database, you can have multiple active databases,
with each database using the 2GB limit on UNIX 32-bit instances (on
Windows 32-bit, the overall sum of memory used by DB2 is limited to the
2GB virtual memory limit, or 3GB using the special /3GB boot option).
However, depending on your particular OS (AIX/Linux/Solaris/HP-UX), you
might need to do some OS and DB2 tuning to be able to actually allocate
the full 2GB for the database. Also, this will limit the amount of
instance-wide shared memory (INSTANCE_MEMOR Y), and private memory
(stmtheap, applheapsz, etc) that can be allocated. If your databases
are already pushing close to this limit, you're probably better off
using the 64-bit version of DB2.

Cheers,
Liam.

Jul 21 '06 #2
"Liam Finnie" <lf*****@ca.ibm .comwrote in message
news:11******** **************@ b28g2000cwb.goo glegroups.com.. .
>
Hi Sadanjan,

This limit is per-database, you can have multiple active databases,
with each database using the 2GB limit on UNIX 32-bit instances (on
Windows 32-bit, the overall sum of memory used by DB2 is limited to the
2GB virtual memory limit, or 3GB using the special /3GB boot option).
However, depending on your particular OS (AIX/Linux/Solaris/HP-UX), you
might need to do some OS and DB2 tuning to be able to actually allocate
the full 2GB for the database. Also, this will limit the amount of
instance-wide shared memory (INSTANCE_MEMOR Y), and private memory
(stmtheap, applheapsz, etc) that can be allocated. If your databases
are already pushing close to this limit, you're probably better off
using the 64-bit version of DB2.

Cheers,
Liam.
I believe that the 2GB limit is per instance not per database. However, you
can easily have more than one instance per server.
Jul 21 '06 #3
No the limit is per db.
It's the Global Shared Memory of the db that is limited by the 2GB.
If memory serves, the limit is actually 1.75 GB for single node, single
processor. 1.5 GB if either Database Partionning Facility or Synetric Muti
Processor enabled (Poof! there went another 256MB segment). A look at the
Quick Beginnings specifies all of this for each OS and its versions.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Mark A" <no****@nowhere .coma écrit dans le message de news:
Y9************* *************** **@comcast.com...
"Liam Finnie" <lf*****@ca.ibm .comwrote in message
news:11******** **************@ b28g2000cwb.goo glegroups.com.. .
>>
Hi Sadanjan,

This limit is per-database, you can have multiple active databases,
with each database using the 2GB limit on UNIX 32-bit instances (on
Windows 32-bit, the overall sum of memory used by DB2 is limited to the
2GB virtual memory limit, or 3GB using the special /3GB boot option).
However, depending on your particular OS (AIX/Linux/Solaris/HP-UX), you
might need to do some OS and DB2 tuning to be able to actually allocate
the full 2GB for the database. Also, this will limit the amount of
instance-wide shared memory (INSTANCE_MEMOR Y), and private memory
(stmtheap, applheapsz, etc) that can be allocated. If your databases
are already pushing close to this limit, you're probably better off
using the 64-bit version of DB2.

Cheers,
Liam.

I believe that the 2GB limit is per instance not per database. However,
you can easily have more than one instance per server.
Jul 22 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3896
by: Google Mike | last post by:
I'm using PHP 4.2.2 on RH9 Linux (with Progeny.com updates, in case you're wondering). I was using shared memory (shm* API) a great deal in my web applications because I have 1GB of RAM on this system. By using shared memory, I can optimize web pages a little by not having to hit the database every time I want to regurgitate a somewhat-static reference table. You may be familiar with the API that looks like this: $key = 'My Key';
5
4845
by: CristianMori | last post by:
Hi there Is there a way in .NET to do shared memories between applications running on the same machine? Thanks
12
5549
by: Jeremy | last post by:
Hi all, I'm getting very confused about how DB2 uses shared memory and I wonder if someone could clarify matters for me, please ? We are running 32bit DB2 V7.2 FP9 under AIX 4.3.3 on a machine with 64 Gb of memory with a single non-partitioned database using extended storage and with intra-parallelism enabled. I've been experimenting with changing various parameters in an attempt
5
7088
by: Jim | last post by:
Hello, I have a broken server that we are going to be moving off to a new server with a new version of DB2 but here is what I have right now: RedHat 7.0 (2.2.24smp) DB2 v6.1.0.40 I am getting this error when I try to run the command 'db2 "backup database dbname online to /opt/BACKUP"' on my 3 databases: SQL1042C An unexpected system error occurred. SQLSTATE=58004
1
1652
by: Jonathan & Maricel Espejo | last post by:
Hi, Could somebody confirm what is the maximum size of shared memory that can be allocated for DB2 on Windows 2000 Servers. I heard that its about 2GB. Is the 2GB shared memory limit applies to what per DATABASE or per INSTANCE? Your input would be highly appreciated. Regards, Maricel
5
1369
by: Ian Bell | last post by:
What is the current thinking on the best way to solve the shared memory problem? Ian -- Ian Bell
4
1993
by: Zeya | last post by:
I am executing OSQL using System.Diagnostic.Process with the following parameters: -S <servername> -E -Q "BACKUP DATABASE <databasename> to DISK='E:\Temp\Now.bak'" This works from command line but when I execute this from my ASP.Net app it shows this error: SSL Security error
1
1827
by: ggnanaraj | last post by:
On Unix, how can we calculate the shared memory currently being used by the database instance. Reason for this is that we have a limit to the size of shared memory that can be configured for use by the database. eg., Linux 1.74 GB per instance; Solaris 3.5 GB, etc... TIA.
2
4501
by: oopsatwork | last post by:
Ok...so, I have been outside of the C world for a _very_ long time...but not so long as to remember how to do multidimensional arrays. So, let me state that I know how to malloc pointers to pointers and then malloc my data space. This question is NOT about that. I need to keep a dynamically sized (a result of command line options) matrix in a shared memory segment created via shmget and attached via shmat. My first instinct was to do...
0
9658
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10828
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10244
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9364
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7775
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5814
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4444
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4004
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3103
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.