Db2 Gurus,



We are trying to implement DPF (database partitioning Feature) at our
site and having problems allocating shared memory.



It' a 64 bit instance, 8 logical partitions all residing on one machine
with 8 gigs of RAM. Below is the configuration:



Machine:



[[Email Address Removed] ~]$ uname -a

Linux qa-devdb2 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006
x86_64 x86_64 x86_64 GNU/Linux



Db2level:



DB21085I Instance "d2swnrxb" uses "64" bits and DB2 code release
"SQL08027"

with level identifier "03080106".

Informational tokens are "DB2 v8.1.3.128", "s061108", "MI00180", and
FixPak

"14".

Product is installed at "/opt/IBM/db2/V8.1".



Appgroup mem parameters are as below:



Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 64000

Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 22

Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 800

Default application heap (4KB) (APPLHEAPSZ) = 256

Percent. of lock lists per application (MAXLOCKS) = 30

Max number of active applications (MAXAPPLS) = 80

Average number of active applications (AVG_APPLS) = 5

Max DB files open per application (MAXFILOP) = 256



We start seeing memory allocation errors with the error code as below:

SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019



I am sure we have got free memory available on the OS side.



[[Email Address Removed] ~]$ free -mt

total used free shared buffers
cached

Mem: 7817 5857 1959 0 43
5384

-/+ buffers/cache: 429 7387

Swap: 16386 0 16386

Total: 24204 5857 18346



Please advice.



Thanks,



-- Mukul





**************************************************************************

DemandTec Email Notice

This email and any attachments may contain confidential and/or proprietary information and is intended solely for the use of the addressee. If you are not the intended recipient we request that you notify us via email or telephone and delete all copies of the message from your systems. Additionally, although DemandTec has taken reasonable precautions to ensure the security of this email and any attachments, we encourage you to take similar precautions and accept no liability for any loss or damage resulting from its use.
DemandTec, 1 Circle Star Way, Suite 200, San Carlos, CA 94070, 650-226-4600

DB2 & UDB email list listserv db2-l LazyDBA home page