HP UX 11i, db2 v8.2
kernel parameters of HPUX such as shmmax had been changed to MEM*0.9, about
3.6g.
when I create a partitioned db(4 partitions)on the server, warning raised
saying that not enough memory for bufferpool use. when I lower the user of
bufferpool to only 8000(8k page),error vanished.
4G memory in total, but it seems that I can only use very little of them.
the HP UX is 64bit, db2 instance is 32 bits.
can you help me on the very problem? thank you~~
2  1934 
"Hardy" <We***********@acc.com> wrote in message
news:cs***********@mail.cn99.com... HP UX 11i, db2 v8.2
kernel parameters of HPUX such as shmmax had been changed to MEM*0.9,
about 3.6g.
when I create a partitioned db(4 partitions)on the server, warning raised
saying that not enough memory for bufferpool use. when I lower the user of
bufferpool to only 8000(8k page),error vanished.
4G memory in total, but it seems that I can only use very little of them.
the HP UX is 64bit, db2 instance is 32 bits.
can you help me on the very problem? thank you~~
You can only have about 1GB bufferpools for 32 bit DB2 instances on HP-UX.
This number varies by OS, and allows slightly more for AIX and Solaris. The
exact number seems to be a bit of voodoo.
I have no idea why you have to go to only 8000 8K pages however. I would
open a problem with IBM support.
en, I have open a PMR and I'll paste the final result when it's over. thank
you, Mark:)
"Mark A" <no****@nowhere.com> дÈëÓʼþ
news:Wv********************@comcast.com... "Hardy" <We***********@acc.com> wrote in message
news:cs***********@mail.cn99.com... HP UX 11i, db2 v8.2
kernel parameters of HPUX such as shmmax had been changed to MEM*0.9, about 3.6g.
when I create a partitioned db(4 partitions)on the server, warning
raised saying that not enough memory for bufferpool use. when I lower the user
of bufferpool to only 8000(8k page),error vanished.
4G memory in total, but it seems that I can only use very little of
them. the HP UX is 64bit, db2 instance is 32 bits.
can you help me on the very problem? thank you~~
You can only have about 1GB bufferpools for 32 bit DB2 instances on HP-UX.
This number varies by OS, and allows slightly more for AIX and Solaris.
The exact number seems to be a bit of voodoo.
I have no idea why you have to go to only 8000 8K pages however. I would
open a problem with IBM support.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Oliver Hoehle |
last post by:
Hello!
I tried to get my J2EE app working with DB2 for several days and now
it seems to work, but... (Tomcat 5.0.19 on NT 4.0 with J2SDK 1.4.1_02)
1) Declaring the DB2-datasource in...
|
by: David Nedrow |
last post by:
I'm trying to set up the cyrus imap server using PostgreSQL as the
authentication backend.
Currently, the issue I'm having is that I'm unable to connect via psql
on the loopback address...
|
by: Susemail |
last post by:
Is this good advice?
IDENT Authentication failed for user "postgres"
This error has everything to do with the way distros set up access rights for
postgres. They are way too restrictive and...
|
by: Si Chen |
last post by:
Hello.
It seems that every time I make a change to pg_hba.conf, I have to
restart the database server for the new authentication to take effect.
Is there a way to have the server use the new...
|
by: Raymond O'Donnell |
last post by:
Hello all,
I've installed the new Win32 version of 8.0-beta1, running as a
service. When I connect to it using pgAdmin III and attempt to list
databases, I get an error: 'Column "datpath" does...
|
by: coaxfiber |
last post by:
Hi guys, my problem is when I installing the Apache v2.2.4 as my local server to run my php, and then run the test configuration, it tells me this error:
httpd.exe: Syntax error on line 152 of...
|
by: dsudhakara |
last post by:
In my queues.conf file my text message are stored here .I want to retrieve particular campaign modify some words in particular campaign and return to save the same queues.conf file .Plz give me...
|
by: smitty1e |
last post by:
Just a fun exercise to unify some of the major input methods for a
script into a single dictionary.
Here is the output, given a gr.conf file in the same directory with
the contents stated below:
...
|
by: jodleren |
last post by:
Hi!
It seems like I have a problem with httpd.conf...
I have a folder named "icons", and when using <img src="icons/....
then it gets some from some apache icons folder...
I found a site...
|
by: gjain123 |
last post by:
Hi all,
I am using netbeans as IDE and glassfish as app server for my web application.
At runtime it needs some dll files and .conf file. Now the question is:
1. How should I package the .conf...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
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,...
| |
