Re: Assistance with getting DB memory usage over 2 gigs


Hi,
Bigpages or the newer technoloy Hugetlb reduces the number of TLB (
translation lookaside buffer ) misses in Linux and hence increases
performance by a few percent.
This is not supported by the current IDS versions and would not help to
solve your issue.

To really utilize the large memory of your machine we have 64 bit port
available.


The availability of 64-bit computing platforms presents new possibilities
for increased performance of database servers, as well as database
applications.
32-bit platforms have an inherent address-space limitation of 4 gigabytes
(GB). Removal of this 4 GB limit on the address space of database servers
allows for the creation of larger buffer pools, sort heaps, package caches,
and other resources that can consume large amounts of memory.
A 64-bit environment and the ability to address more than 4 GB of memory
can greatly enhance the scalability and performance of databases.
With IDS Version 10.0, we have optimized native 64-bit editions for all
major Linux platforms.


The Linux platforms supported by the new IBM Informix Dynamic Server
Version 10.0 64 BIT VERSION are:


Intel EM64T (X86-64),


AMD64 (64-bit edition for AMD Opteron- and Athlon64-based systems),


POWERB. (IBM eServerb", iSeriesb", and pSeriesB. systems) ,


zSeriesB. (IBM eServer zSeriesB. systems) ,


IA64 (64-bit edition for Intel Itanium-based systems)

Thanks
Sandor

IBM Informix Development Munich




shaun.patrick.wal
lace@xxxxxxxxx
Sent by: To
owner-informix-li informix-list@xxxxxxxx
st@xxxxxxxx cc

Subject
07.09.2005 14:03 Re: Assistance with getting DB
memory usage over 2 gigs

Please respond to
shaun.patrick.wal
lace






I'm going to be trying changing the base address like the note said but
I've seen Oracle sites say something about setting up "bigpages" to get
around the 3 gig user space issue.

Is this something informix can use? I.E. if I set bigpages=4100MB then
would Informix be able to use this for the database?

Let me know if I am off the mark here.
sending to informix-list
.

Relevant Pages

  • Re: Why Informix is Best
    ... When adding raw disk space Oracle zeros out the whole raw disk space ... 2Gb chunks in a few seconds under Informix. ... sysmaster database allows monitor of the database via sql allowing you ... IBM Informix has direct to engineer support whereas Oracle pass you to ...
    (comp.databases.informix)
  • Re: Informix connection to SQL Server
    ... I have a similar question regarding database access from Linux to MS ... Can Informix "serve" up data from other DBMS's as if they were native ...
    (comp.databases.informix)
  • Application crash on IBM AIX 5.2
    ... We have an application that runs under Linux, ... was developed in C++ under linux, it supports both Oracle and Informix ... For database connectivity in oracle it uses OTL (Oracle template ...
    (comp.unix.aix)
  • "Could not determine which columns uniquely identify the rows for tablename"
    ... I am in the process of migrating our MS Access Database to Informix Dynamic ... My test database is on a Linux box (Informix Dynamic server is not ...
    (microsoft.public.vb.database.ado)
  • Could not determine which columns uniquely identify the rows for [Table Name]
    ... I am in the process of migrating our MS Access Database to Informix Dynamic ... My test database is on a Linux box (Informix Dynamic server is not ...
    (microsoft.public.dotnet.framework.adonet)
Loading