Pardon me if what I am saying is too obvious, but did you remember
db2_all when you updated your db cfg parms?
-Andy Beaton

Mukul Sharma wrote:
> 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
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


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