Topic
19 replies Latest Post - ‏2013-08-07T09:29:52Z by MohsinMansur
SystemAdmin
SystemAdmin
17917 Posts
ACCEPTED ANSWER

Pinned topic Help to Configuring Memory parameter

‏2012-02-29T10:00:37Z |
Could anybody help me to set right value for batter utilization of available memory. i have 8 GB of RAM on 32 bit Linux machine, but still some time its creating problem with Shared memory or Private Memory

2012-01-16-07.40.08.364175+000 E1075491386G1467 LEVEL: Error (OS)
PID : 9565 TID : 125823888 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-61898 APPID: *LOCAL.db2inst1.120116074014
AUTHID : DB2INST1
EDUID : 1165 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
CALLED : OS, -, mmap OSERR: ENOMEM (12)
MESSAGE : Private memory and/or virtual address space exhausted, or data ulimit
exceeded
DATA #1 : Soft data resource limit, PD_TYPE_RLIM_DATA_CUR, 4 bytes
4294967295
DATA #2 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
1245184
DATA #3 : Current set size, PD_TYPE_SET_SIZE, 4 bytes
338690048
CALLSTCK:
[0] 0xB5DF676A sqloLogMemoryCondition. + 0x1CC
[1] 0xB69A7505 sqlogmblkEx + 0x58F
[2] 0xB48F448D _Z23sqlm_buffer_postprocessPcjhP5sqlcaS_ss + 0x4DF
[3] 0xB4922551 _Z15sqlmonssbackendP12SQLE_DB2RA_T + 0x40D
[4] 0xB47E8A17 _Z8sqlesrvrP14db2UCinterface + 0x563
[5] 0xB47F5FF1 _Z19sqleMappingFnServerP5sqldaP5sqlca + 0x365
[6] 0xB483A29F _Z19sqlerKnownProcedureiPcPiP5sqldaS2_P13sqlerFmpTableP8sqeAgentP5sqlca + 0x20B
[7] 0xB483C2B5 _Z11sqlerCallDLP14db2UCinterfaceP9UCstpInfo + 0x449
[8] 0xB48B7ED2 _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x7D6
[9] 0xB697A772 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x62

2012-01-16-07.40.08.371905+000 E1075492854G691 LEVEL: Warning
PID : 9565 TID : 125823888 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-61898 APPID: *LOCAL.db2inst1.120116074014
AUTHID : DB2INST1
EDUID : 1165 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
DATA #1 : <preformatted>
Out of memory failure for Private Heap.
Requested block size : 1205300 bytes.
Physical heap size : 1376256 bytes.
Configured heap size : 2147483648 bytes.
Unreserved memory used by heap : 0 bytes.
Unreserved memory left in set : 0 bytes.
2012-02-28-11.59.00.065745+000 I1115850024G568 LEVEL: Severe
PID : 11695 TID : 58715024 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : REPORTS
APPHDL : 0-10425 APPID: GA00005A.OAD0.11D6C8115924
AUTHID : DB2INST1
EDUID : 3278 EDUNAME: db2agent (REPORTS)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:20
RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.

2012-02-28-11.59.11.712377+000 E1115850593G944 LEVEL: Warning
PID : 11695 TID : 116386704 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : REPORTS
APPHDL : 0-12220 APPID: GA00005A.ODD0.11D6C8115935
AUTHID : DB2INST1
EDUID : 3259 EDUNAME: db2agent (REPORTS)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
185073664


current values-------------------


Shared Memory Limits
max number of segments = 4096
max seg size (kbytes) = 4194303
max total shared memory (kbytes) = 1073741824
min seg size (bytes) = 1


Semaphore Limits
max number of arrays = 1024
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 32
semaphore max value = 32767


Messages: Limits
max queues system wide = 1024
max size of message (bytes) = 65536
default max size of queue (bytes) = 65536

Database Configuration for Database db1

Database configuration release level = 0x0d00
Database release level = 0x0d00

Database territory = GB
Database code page = 923
Database code set = ISO885915
Database country/region code = 44
Database collating sequence = UNIQUE
Alternate collating sequence (ALT_COLLATE) =
Number compatibility = OFF
Varchar2 compatibility = OFF
Date compatibility = OFF
Database page size = 4096

Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE

Statement concentrator (STMT_CONC) = OFF

Discovery support for this database (DISCOVER_DB) = ENABLE

Restrict access = NO
Default query optimization class (DFT_QUERYOPT) = 5
Degree of parallelism (DFT_DEGREE) = 1
Continue upon arithmetic exceptions (DFT_SQLMATHWARN) = NO
Default refresh age (DFT_REFRESH_AGE) = 0
Default maintained table types for opt (DFT_MTTB_TYPES) = SYSTEM
Number of frequent values retained (NUM_FREQVALUES) = 10
Number of quantiles retained (NUM_QUANTILES) = 20

Decimal floating point rounding mode (DECFLT_ROUNDING) = ROUND_HALF_EVEN

Backup pending = NO

All committed transactions have been written to disk = NO
Rollforward pending = NO
Restore pending = NO

Multi-page file allocation enabled = NO

Log retain for recovery status = RECOVERY
User exit for logging status = YES

Self tuning memory (SELF_TUNING_MEM) = OFF
Size of database shared memory (4KB) (DATABASE_MEMORY) = AUTOMATIC(78320)
Database memory threshold (DB_MEM_THRESH) = 10
Max storage for lock list (4KB) (LOCKLIST) = 10000
Percent. of lock lists per application (MAXLOCKS) = 70
Package cache size (4KB) (PCKCACHESZ) = (MAXAPPLS*8)
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 5000
Sort list heap (4KB) (SORTHEAP) = 256

Database heap (4KB) (DBHEAP) = AUTOMATIC(8000)
Catalog cache size (4KB) (CATALOGCACHE_SZ) = (MAXAPPLS*5)
Log buffer size (4KB) (LOGBUFSZ) = 8
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 30000
Buffer pool size (pages) (BUFFPAGE) = 1000
SQL statement heap (4KB) (STMTHEAP) = 5120
Default application heap (4KB) (APPLHEAPSZ) = AUTOMATIC(32000)
Application Memory Size (4KB) (APPL_MEMORY) = AUTOMATIC(10016)
Statistics heap size (4KB) (STAT_HEAP_SZ) = AUTOMATIC(4384)

Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Lock timeout (sec) (LOCKTIMEOUT) = -1

Changed pages threshold (CHNGPGS_THRESH) = 60
Number of asynchronous page cleaners (NUM_IOCLEANERS) = AUTOMATIC(7)
Number of I/O servers (NUM_IOSERVERS) = AUTOMATIC(6)
Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC

Track modified pages (TRACKMOD) = ON

Default number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32

Max number of active applications (MAXAPPLS) = AUTOMATIC(367)
Average number of active applications (AVG_APPLS) = AUTOMATIC(1)
Max DB files open per application (MAXFILOP) = 30720

Log file size (4KB) (LOGFILSIZ) = 10000
Number of primary log files (LOGPRIMARY) = 3
Number of secondary log files (LOGSECOND) = 2
Changed path to log files (NEWLOGPATH) =
Path to log files = /db2/databases/msging/db2inst1/NODE0000/SQL00001/SQLOGDIR/
Overflow log path (OVERFLOWLOGPATH) = /backup/db2_archivelogs/MSGING/NODE0000/
Mirror log path (MIRRORLOGPATH) = /backup/db2_mirrorlogs/msging/NODE0000/
First active log file = S0031090.LOG
Block log on disk full (BLK_LOG_DSK_FUL) = NO
Block non logged operations (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0

Group commit count (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
Log retain for recovery enabled (LOGRETAIN) = RECOVERY
User exit for logging enabled (USEREXIT) = ON

HADR database role = STANDARD
HADR local host name (HADR_LOCAL_HOST) =
HADR local service name (HADR_LOCAL_SVC) = 55003
HADR remote host name (HADR_REMOTE_HOST) =
HADR remote service name (HADR_REMOTE_SVC) = 55004
HADR instance name of remote server (HADR_REMOTE_INST) = db2inst1
HADR timeout value (HADR_TIMEOUT) = 3
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC
HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 120

First log archive method (LOGARCHMETH1) = USEREXIT
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY) = 20
Vendor options (VENDOROPT) =

Auto restart enabled (AUTORESTART) = ON
Index re-creation time and redo index build (INDEXREC) = SYSTEM (RESTART)
Log pages during index build (LOGINDEXBUILD) = ON
Default number of loadrec sessions (DFT_LOADREC_SES) = 1
Number of database backups to retain (NUM_DB_BACKUPS) = 12
Recovery history retention (days) (REC_HIS_RETENTN) = 366
Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = OFF

TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =

Automatic maintenance (AUTO_MAINT) = OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
Automatic statement statistics (AUTO_STMT_STATS) = OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = OFF

Auto-Revalidation (AUTO_REVAL) = DISABLED
Currently Committed (CUR_COMMIT) = DISABLED
CHAR output with DECIMAL input (DEC_TO_CHAR_FMT) = V95
Enable XML Character operations (ENABLE_XMLCHAR) = YES
WLM Collection Interval (minutes) (WLM_COLLECT_INT) = 0
Monitor Collect Settings
Request metrics (MON_REQ_METRICS) = NONE
Activity metrics (MON_ACT_METRICS) = NONE
Object metrics (MON_OBJ_METRICS) = NONE
Unit of work events (MON_UOW_DATA) = NONE
Lock timeout events (MON_LOCKTIMEOUT) = NONE
Deadlock events (MON_DEADLOCK) = NONE
Lock wait events (MON_LOCKWAIT) = NONE
Lock wait event threshold (MON_LW_THRESH) = 5000000
Number of package list entries (MON_PKGLIST_SZ) = 32
Lock event notification level (MON_LCK_MSG_LVL) = 1

SMTP Server (SMTP_SERVER) =
SQL conditional compilation flags (SQL_CCFLAGS) =
Section actuals setting (SECTION_ACTUALS) = NONE
Updated on 2012-02-29T13:17:55Z at 2012-02-29T13:17:55Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    17917 Posts
    ACCEPTED ANSWER

    Re: Help to Configuring Memory parameter

    ‏2012-02-29T13:17:51Z  in response to SystemAdmin
    Hi,

    My personal advise is to activate the Self Tunning Memory (STMM) and change to automatic.

    Also, it would be good to change the buffer pools to automatic, in order to be managed by the STMM.

    Depending on the db2 version, and kernel version, the database will take or release memory to the OS, depending on the charge.

    Take a look at the STMM, and configure it correctly, because I saw that most of the parameters are automatic, but not the STMM.
  • SystemAdmin
    SystemAdmin
    17917 Posts
    ACCEPTED ANSWER

    Re: Help to Configuring Memory parameter

    ‏2012-02-29T13:17:55Z  in response to SystemAdmin
    Hi,

    My personal advise is to activate the Self Tunning Memory (STMM) and change to automatic.

    Also, it would be good to change the buffer pools to automatic, in order to be managed by the STMM.

    Depending on the db2 version, and kernel version, the database will take or release memory to the OS, depending on the charge.

    Take a look at the STMM, and configure it correctly, because I saw that most of the parameters are automatic, but not the STMM.
    • MohsinMansur
      MohsinMansur
      9 Posts
      ACCEPTED ANSWER

      Re: Help to Configuring Memory parameter

      ‏2013-07-26T10:46:23Z  in response to SystemAdmin

      Hi I have activated the STMM . But its still giving the same error. Please adivice.

      • db2inst1024
        db2inst1024
        40 Posts
        ACCEPTED ANSWER

        Re: Help to Configuring Memory parameter

        ‏2013-07-29T10:34:09Z  in response to MohsinMansur

        db2diag.log says:

        The configured DATABASE_MEMORY plus desired overflow may have
        exceeded INSTANCE_MEMORY or the maximum shared memory on the system.

        check your dbm cfg INSTANCE_MEMORY parameter

        • MohsinMansur
          MohsinMansur
          9 Posts
          ACCEPTED ANSWER

          Re: Help to Configuring Memory parameter

          ‏2013-07-29T10:54:22Z  in response to db2inst1024

          Thank for the reply.

          The  DATABASE_MEMORY alerts seems to be stopped but the i am getting the following error. can you let me know what could be the root cause of it and how i can overcome it.

           

          2013-07-25-15.30.14.752469+060 E596883849G1458    LEVEL: Error (OS)

          PID     : 30140                TID  : 478145424   PROC : db2sysc

          INSTANCE: db2inst1             NODE : 000

          APPHDL  : 0-585                APPID: *LOCAL.db2inst1.130725143032

          AUTHID  : DB2INST1

          EDUID   : 1220                 EDUNAME: db2agent (instance)

          FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100

          CALLED  : OS, -, mmap                             OSERR: ENOMEM (12)

          MESSAGE : Private memory and/or virtual address space exhausted, or data ulimit

                    exceeded

          DATA #1 : Soft data resource limit, PD_TYPE_RLIM_DATA_CUR, 4 bytes

          4294967295

          DATA #2 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes

          175702016

          DATA #3 : Current set size, PD_TYPE_SET_SIZE, 4 bytes

          237371392

          CALLSTCK:

            [0] 0xB5DF776A sqloLogMemoryCondition. + 0x1CC

            [1] 0xB69A8505 sqlogmblkEx + 0x58F

            [2] 0xB482ACEA sqledConvertDDtoSqlda + 0x1162

            [3] 0xB483D000 _Z11sqlerCallDLP14db2UCinterfaceP9UCstpInfo + 0x194

            [4] 0xB48B8ED2 _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x7D6

            [5] 0xB697B772 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x62

            [6] 0xB48A67CF _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface + 0x2A1

            [7] 0xB489EDC3 /home/db2inst1/sqllib/lib32/libdb2e.so.1 + 0x1312DC3

            [8] 0xB48A3A4C /home/db2inst1/sqllib/lib32/libdb2e.so.1 + 0x1317A4C

            [9] 0xB48A1CAF /home/db2inst1/sqllib/lib32/libdb2e.so.1 + 0x1315CAF

          • db2inst1024
            db2inst1024
            40 Posts
            ACCEPTED ANSWER

            Re: Help to Configuring Memory parameter

            ‏2013-07-29T11:05:28Z  in response to MohsinMansur

            MESSAGE : Private memory and/or virtual address space exhausted, or data ulimit exceeded

            It seems like your instance INSTANCE_MEMORY parameter exceeded available memory.

            Can you please provide here output of

            db2 get dbm cfg

            ulimit -a

             

            and the amount of memory on the server.

            • MohsinMansur
              MohsinMansur
              9 Posts
              ACCEPTED ANSWER

              Re: Help to Configuring Memory parameter

              ‏2013-07-29T11:12:14Z  in response to db2inst1024
                       Database Manager Configuration
               
                   Node type = Database Server with local and remote clients
               
               Database manager configuration release level            = 0x0d00
               
               CPU speed (millisec/instruction)             (CPUSPEED) = 2.794703e-07
               
               Max number of concurrently active databases     (NUMDB) = 10
               Federated Database System Support           (FEDERATED) = NO
               Transaction processor monitor name        (TP_MON_NAME) =
               
               Default charge-back account           (DFT_ACCOUNT_STR) =
               
               Java Development Kit installation path       (JDK_PATH) = /home/db2inst1/sqllib/java/jdk32
               
               Diagnostic error capture level              (DIAGLEVEL) = 3
               Notify Level                              (NOTIFYLEVEL) = 3
               Diagnostic data directory path               (DIAGPATH) = /home/db2inst1/sqllib/db2dump
               Size of rotating db2diag & notify logs (MB)  (DIAGSIZE) = 0
               
               Default database monitor switches
                 Buffer pool                         (DFT_MON_BUFPOOL) = OFF
                 Lock                                   (DFT_MON_LOCK) = ON
                 Sort                                   (DFT_MON_SORT) = OFF
                 Statement                              (DFT_MON_STMT) = OFF
                 Table                                 (DFT_MON_TABLE) = OFF
                 Timestamp                         (DFT_MON_TIMESTAMP) = ON
                 Unit of work                            (DFT_MON_UOW) = OFF
               Monitor health of instance and databases   (HEALTH_MON) = OFF
               
               SYSADM group name                        (SYSADM_GROUP) = DB2IADM1
               SYSCTRL group name                      (SYSCTRL_GROUP) =
               SYSMAINT group name                    (SYSMAINT_GROUP) =
               SYSMON group name                        (SYSMON_GROUP) =
               
               Client Userid-Password Plugin          (CLNT_PW_PLUGIN) =
               Client Kerberos Plugin                (CLNT_KRB_PLUGIN) =
               Group Plugin                             (GROUP_PLUGIN) =
               GSS Plugin for Local Authorization    (LOCAL_GSSPLUGIN) =
               Server Plugin Mode                    (SRV_PLUGIN_MODE) = UNFENCED
               Server List of GSS Plugins      (SRVCON_GSSPLUGIN_LIST) =
               Server Userid-Password Plugin        (SRVCON_PW_PLUGIN) =
               Server Connection Authentication          (SRVCON_AUTH) = NOT_SPECIFIED
               Cluster manager                           (CLUSTER_MGR) =
               
               Database manager authentication        (AUTHENTICATION) = SERVER
               Alternate authentication           (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
               Cataloging allowed without authority   (CATALOG_NOAUTH) = NO
               Trust all clients                      (TRUST_ALLCLNTS) = YES
               Trusted client authentication          (TRUST_CLNTAUTH) = CLIENT
               Bypass federated authentication            (FED_NOAUTH) = NO
               
               Default database path                       (DFTDBPATH) = /home/db2inst1
               
               Database monitor heap size (4KB)          (MON_HEAP_SZ) = AUTOMATIC(90)
               Java Virtual Machine heap size (4KB)     (JAVA_HEAP_SZ) = 2048
               Audit buffer size (4KB)                  (AUDIT_BUF_SZ) = 0
               Size of instance shared memory (4KB)  (INSTANCE_MEMORY) = AUTOMATIC(1000000)
               Backup buffer default size (4KB)            (BACKBUFSZ) = 1024
               Restore buffer default size (4KB)           (RESTBUFSZ) = 1024
               
               Agent stack size                       (AGENT_STACK_SZ) = 256
               Sort heap threshold (4KB)                  (SHEAPTHRES) = 0
               
               Directory cache support                     (DIR_CACHE) = YES
               
               Application support layer heap size (4KB)   (ASLHEAPSZ) = 15
               Max requester I/O block size (bytes)         (RQRIOBLK) = 32767
               Query heap size (4KB)                   (QUERY_HEAP_SZ) = 1000
               
               Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
               
               Priority of agents                           (AGENTPRI) = SYSTEM
               Agent pool size                        (NUM_POOLAGENTS) = AUTOMATIC(100)
               Initial number of agents in pool       (NUM_INITAGENTS) = 0
               Max number of coordinating agents     (MAX_COORDAGENTS) = AUTOMATIC(200)
               Max number of client connections      (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS)
               
               Keep fenced process                        (KEEPFENCED) = YES
               Number of pooled fenced processes         (FENCED_POOL) = AUTOMATIC(MAX_COORDAGENTS)
               Initial number of fenced processes     (NUM_INITFENCED) = 0
               
               Index re-creation time and redo index build  (INDEXREC) = RESTART
               
               Transaction manager database name         (TM_DATABASE) = 1ST_CONN
               Transaction resync interval (sec)     (RESYNC_INTERVAL) = 180
               
               SPM name                                     (SPM_NAME) =
               SPM log size                          (SPM_LOG_FILE_SZ) = 256
               SPM resync agent limit                 (SPM_MAX_RESYNC) = 20
               SPM log path                             (SPM_LOG_PATH) =
               
               TCP/IP Service name                          (SVCENAME) = db2c_db2inst1
               Discovery mode                               (DISCOVER) = SEARCH
               Discover server instance                (DISCOVER_INST) = ENABLE
               
               SSL server keydb file                   (SSL_SVR_KEYDB) =
               SSL server stash file                   (SSL_SVR_STASH) =
               SSL server certificate label            (SSL_SVR_LABEL) =
               SSL service name                         (SSL_SVCENAME) =
               SSL cipher specs                      (SSL_CIPHERSPECS) =
               SSL versions                             (SSL_VERSIONS) =
               SSL client keydb file                  (SSL_CLNT_KEYDB) =
               SSL client stash file                  (SSL_CLNT_STASH) =
               
               Maximum query degree of parallelism   (MAX_QUERYDEGREE) = ANY
               Enable intra-partition parallelism     (INTRA_PARALLEL) = NO
               
               No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(1024)
               No. of int. communication channels   (FCM_NUM_CHANNELS) = AUTOMATIC(512)
               db2start/db2stop timeout (min)        (START_STOP_TIME) = 10
               
               
               
               
               
               
              ulimit -a
               
              core file size          (blocks, -c) 0
              data seg size           (kbytes, -d) unlimited
              scheduling priority             (-e) 0
              file size               (blocks, -f) unlimited
              pending signals                 (-i) 127885
              max locked memory       (kbytes, -l) 32
              max memory size         (kbytes, -m) unlimited
              open files                      (-n) 1024
              pipe size            (512 bytes, -p) 8
              POSIX message queues     (bytes, -q) 819200
              real-time priority              (-r) 0
              stack size              (kbytes, -s) 10240
              cpu time               (seconds, -t) unlimited
              max user processes              (-u) 127885
              virtual memory          (kbytes, -v) unlimited
              file locks                      (-x) unlimited
               
               
               
               
               db2pd -dbptnmem
               
              Database Partition 0 -- Active -- Up 11 days 11:30:04
               
              Database Partition Memory Controller Statistics
               
              Controller Automatic: Y
              Memory Limit:         4000000 KB
              Current usage:        2710144 KB
              HWM usage:            2719168 KB
              Cached memory:        677952 KB
               

              We are running 8 databases under single db2 instance.

               
              • db2inst1024
                db2inst1024
                40 Posts
                ACCEPTED ANSWER

                Re: Help to Configuring Memory parameter

                ‏2013-07-29T11:46:40Z  in response to MohsinMansur

                We are running 8 databases under single db2 instance.

                OK, It explains a lot.

                Pleas take a look at the DB2 memory model http://www.ibm.com/developerworks/data/library/techarticle/dm-0406qi/#N10A2B

                On 32-bit systems, INSTANCE_MEMORY configuration parameter has limit of 1000000 4K pages.

                My suggestion is:

                db2 get dbm cfg shows your instance has already reached it. It can not grow anymore to keep all yours 8 databases shared memory areas (DATABASE_MEMORY parameter).

                When you set DATABASE_MEMORY to AUTOMATIC for several databases, it is very probably to meet memory problems.

                Can please provide results of db2mtrk -i -d -v command?

                • MohsinMansur
                  MohsinMansur
                  9 Posts
                  ACCEPTED ANSWER

                  Re: Help to Configuring Memory parameter

                  ‏2013-07-29T12:01:41Z  in response to db2inst1024

                  Thanks for the reply.

                  But  the db2pd -dbptnmem shows  the Current usage is   2710144 KB . which is only 2.58 GB. and we have 1000000 * 4  KB , which is 4GB  as instance memory available.  what does that mean?

                  results of db2mtrk -i -d -v command is:

                  Tracking Memory on: 2013/07/29 at 12:56:21

                   

                  Memory for instance

                   

                     Other Memory is of size 37879808 bytes

                     FCMBP Heap is of size 786432 bytes

                     Database Monitor Heap is of size 1638400 bytes

                     Total: 40304640 bytes

                   

                  Memory for database: VOICE

                   

                     Backup/Restore/Util Heap is of size 65536 bytes

                     Package Cache is of size 3538944 bytes

                     Other Memory is of size 131072 bytes

                     Catalog Cache Heap is of size 1638400 bytes

                     Buffer Pool Heap (1) is of size 4521984 bytes

                     Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes

                     Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes

                     Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes

                     Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes

                     Shared Sort Heap is of size 851968 bytes

                     Lock Manager Heap is of size 22216704 bytes

                     Database Heap is of size 16252928 bytes

                     Application Heap (31385) is of size 131072 bytes

                     Application Heap (46062) is of size 131072 bytes

                     Application Heap (64254) is of size 131072 bytes

                     Application Heap (64249) is of size 131072 bytes

                     Application Heap (58775) is of size 131072 bytes

                     Application Heap (54678) is of size 131072 bytes

                     Application Heap (26521) is of size 131072 bytes

                     Application Heap (26516) is of size 196608 bytes

                     Application Heap (26515) is of size 196608 bytes

                     Application Heap (25563) is of size 131072 bytes

                     Application Heap (24184) is of size 131072 bytes

                     Application Heap (12836) is of size 131072 bytes

                     Application Heap (4991) is of size 131072 bytes

                     Application Heap (4969) is of size 131072 bytes

                     Application Heap (565) is of size 131072 bytes

                     Application Heap (483) is of size 131072 bytes

                     Application Heap (482) is of size 131072 bytes

                     Application Heap (477) is of size 131072 bytes

                     Application Heap (21) is of size 65536 bytes

                     Application Heap (20) is of size 65536 bytes

                     Application Heap (19) is of size 65536 bytes

                     Application Heap (18) is of size 65536 bytes

                     Application Heap (17) is of size 65536 bytes

                     Application Heap (16) is of size 65536 bytes

                     Application Heap (15) is of size 65536 bytes

                     Application Heap (14) is of size 65536 bytes

                     Application Heap (13) is of size 65536 bytes

                     Application Heap (12) is of size 65536 bytes

                     Application Heap (11) is of size 131072 bytes

                     Application Heap (10) is of size 65536 bytes

                     Application Heap (9) is of size 65536 bytes

                     Application Heap (8) is of size 65536 bytes

                     Applications Shared Heap is of size 3670016 bytes

                     Total: 58654720 bytes

                   

                  Memory for database: VOICEREC

                   

                     Backup/Restore/Util Heap is of size 65536 bytes

                     Package Cache is of size 2162688 bytes

                     Other Memory is of size 131072 bytes

                     Catalog Cache Heap is of size 262144 bytes

                     Buffer Pool Heap (1) is of size 4521984 bytes

                     Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes

                     Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes

                     Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes

                     Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes

                     Shared Sort Heap is of size 327680 bytes

                     Lock Manager Heap is of size 22216704 bytes

                     Database Heap is of size 13959168 bytes

                     Application Heap (279) is of size 131072 bytes

                     Application Heap (64248) is of size 131072 bytes

                     Application Heap (63387) is of size 131072 bytes

                     Application Heap (62350) is of size 131072 bytes

                     Application Heap (62055) is of size 131072 bytes

                     Application Heap (26522) is of size 131072 bytes

                     Application Heap (8772) is of size 131072 bytes

                     Application Heap (5508) is of size 131072 bytes

                     Application Heap (492) is of size 131072 bytes

                     Application Heap (481) is of size 131072 bytes

                     Application Heap (36) is of size 65536 bytes

                     Application Heap (35) is of size 65536 bytes

                     Application Heap (34) is of size 65536 bytes

                     Application Heap (33) is of size 65536 bytes

                     Application Heap (32) is of size 65536 bytes

                     Application Heap (31) is of size 65536 bytes

                     Application Heap (30) is of size 65536 bytes

                     Application Heap (29) is of size 65536 bytes

                     Application Heap (28) is of size 65536 bytes

                     Application Heap (27) is of size 131072 bytes

                     Application Heap (26) is of size 65536 bytes

                     Application Heap (25) is of size 65536 bytes

                     Application Heap (24) is of size 65536 bytes

                     Applications Shared Heap is of size 983040 bytes

                     Total: 49152000 bytes

                   

                  Memory for database: MSGING

                   

                     Backup/Restore/Util Heap is of size 131072 bytes

                     Package Cache is of size 5177344 bytes

                     Other Memory is of size 131072 bytes

                     Catalog Cache Heap is of size 1769472 bytes

                     Buffer Pool Heap (1) is of size 4521984 bytes

                     Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes

                     Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes

                     Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes

                     Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes

                     Shared Sort Heap is of size 2490368 bytes

                     Lock Manager Heap is of size 112525312 bytes

                     Database Heap is of size 19136512 bytes

                     Application Heap (58199) is of size 131072 bytes

                     Application Heap (826) is of size 131072 bytes

                     Application Heap (827) is of size 131072 bytes

                     Application Heap (725) is of size 131072 bytes

                     Application Heap (698) is of size 131072 bytes

                     Application Heap (439) is of size 131072 bytes

                     Application Heap (64831) is of size 131072 bytes

                     Application Heap (64825) is of size 131072 bytes

                     Application Heap (64763) is of size 131072 bytes

                     Application Heap (64607) is of size 131072 bytes

                     Application Heap (64389) is of size 131072 bytes

                     Application Heap (63705) is of size 131072 bytes

                     Application Heap (61419) is of size 131072 bytes

                     Application Heap (35305) is of size 131072 bytes

                     Application Heap (33112) is of size 131072 bytes

                     Application Heap (14247) is of size 131072 bytes

                     Application Heap (38405) is of size 131072 bytes

                     Application Heap (38402) is of size 131072 bytes

                     Application Heap (38401) is of size 131072 bytes

                     Application Heap (38398) is of size 131072 bytes

                     Application Heap (13326) is of size 131072 bytes

                     Application Heap (13320) is of size 131072 bytes

                     Application Heap (13281) is of size 196608 bytes

                     Application Heap (13314) is of size 131072 bytes

                     Application Heap (13300) is of size 131072 bytes

                     Application Heap (13299) is of size 131072 bytes

                     Application Heap (13288) is of size 131072 bytes

                     Application Heap (55553) is of size 131072 bytes

                     Application Heap (7983) is of size 131072 bytes

                     Application Heap (7774) is of size 131072 bytes

                     Application Heap (7762) is of size 131072 bytes

                     Application Heap (5344) is of size 131072 bytes

                     Application Heap (5097) is of size 131072 bytes

                     Application Heap (600) is of size 131072 bytes

                     Application Heap (438) is of size 131072 bytes

                     Application Heap (437) is of size 131072 bytes

                     Application Heap (436) is of size 131072 bytes

                     Application Heap (433) is of size 131072 bytes

                     Application Heap (432) is of size 196608 bytes

                     Application Heap (431) is of size 131072 bytes

                     Application Heap (430) is of size 131072 bytes

                     Application Heap (428) is of size 131072 bytes

                     Application Heap (426) is of size 131072 bytes

                     Application Heap (425) is of size 131072 bytes

                     Application Heap (424) is of size 196608 bytes

                     Application Heap (423) is of size 131072 bytes

                     Application Heap (421) is of size 131072 bytes

                     Application Heap (419) is of size 131072 bytes

                     Application Heap (417) is of size 131072 bytes

                     Application Heap (416) is of size 131072 bytes

                     Application Heap (414) is of size 131072 bytes

                     Application Heap (413) is of size 131072 bytes

                     Application Heap (412) is of size 131072 bytes

                     Application Heap (410) is of size 131072 bytes

                     Application Heap (409) is of size 131072 bytes

                     Application Heap (408) is of size 131072 bytes

                     Application Heap (407) is of size 131072 bytes

                     Application Heap (405) is of size 131072 bytes

                     Application Heap (404) is of size 131072 bytes

                     Application Heap (403) is of size 131072 bytes

                     Application Heap (402) is of size 131072 bytes

                     Application Heap (401) is of size 131072 bytes

                     Application Heap (400) is of size 131072 bytes

                     Application Heap (399) is of size 131072 bytes

                     Application Heap (398) is of size 131072 bytes

                     Application Heap (397) is of size 131072 bytes

                     Application Heap (396) is of size 131072 bytes

                     Application Heap (395) is of size 131072 bytes

                     Application Heap (394) is of size 131072 bytes

                     Application Heap (393) is of size 131072 bytes

                     Application Heap (392) is of size 131072 bytes

                     Application Heap (390) is of size 131072 bytes

                     Application Heap (389) is of size 131072 bytes

                     Application Heap (388) is of size 131072 bytes

                     Application Heap (386) is of size 131072 bytes

                     Application Heap (385) is of size 131072 bytes

                     Application Heap (384) is of size 131072 bytes

                     Application Heap (382) is of size 131072 bytes

                     Application Heap (381) is of size 131072 bytes

                     Application Heap (380) is of size 131072 bytes

                     Application Heap (379) is of size 196608 bytes

                     Application Heap (378) is of size 196608 bytes

                     Application Heap (377) is of size 131072 bytes

                     Application Heap (376) is of size 131072 bytes

                     Application Heap (208) is of size 65536 bytes

                     Application Heap (205) is of size 65536 bytes

                     Application Heap (204) is of size 65536 bytes

                     Application Heap (203) is of size 65536 bytes

                     Application Heap (202) is of size 65536 bytes

                     Application Heap (201) is of size 65536 bytes

                     Application Heap (200) is of size 65536 bytes

                     Application Heap (199) is of size 65536 bytes

                     Application Heap (198) is of size 65536 bytes

                     Application Heap (197) is of size 131072 bytes

                     Application Heap (196) is of size 65536 bytes

                     Application Heap (195) is of size 65536 bytes

                     Application Heap (194) is of size 65536 bytes

                     Applications Shared Heap is of size 7340032 bytes

                     Total: 167772160 bytes

                   

                  Memory for database: IAN

                   

                     Backup/Restore/Util Heap is of size 262144 bytes

                     Package Cache is of size 5046272 bytes

                     Other Memory is of size 131072 bytes

                     Catalog Cache Heap is of size 4325376 bytes

                     Buffer Pool Heap (1) is of size 4521984 bytes

                     Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes

                     Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes

                     Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes

                     Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes

                     Shared Sort Heap is of size 2359296 bytes

                     Lock Manager Heap is of size 22216704 bytes

                     Database Heap is of size 41615360 bytes

                     Application Heap (29442) is of size 131072 bytes

                     Application Heap (764) is of size 196608 bytes

                     Application Heap (735) is of size 131072 bytes

                     Application Heap (131) is of size 196608 bytes

                     Application Heap (187) is of size 196608 bytes

                     Application Heap (169) is of size 196608 bytes

                     Application Heap (185) is of size 196608 bytes

                     Application Heap (65046) is of size 196608 bytes

                     Application Heap (64630) is of size 196608 bytes

                     Application Heap (88) is of size 196608 bytes

                     Application Heap (60864) is of size 131072 bytes

                     Application Heap (45367) is of size 196608 bytes

                     Application Heap (45366) is of size 196608 bytes

                     Application Heap (25771) is of size 131072 bytes

                     Application Heap (25479) is of size 196608 bytes

                     Application Heap (5990) is of size 196608 bytes

                     Application Heap (5877) is of size 196608 bytes

                     Application Heap (5868) is of size 196608 bytes

                     Application Heap (5278) is of size 196608 bytes

                     Application Heap (4959) is of size 196608 bytes

                     Application Heap (4887) is of size 196608 bytes

                     Application Heap (296) is of size 65536 bytes

                     Application Heap (295) is of size 65536 bytes

                     Application Heap (294) is of size 65536 bytes

                     Application Heap (293) is of size 65536 bytes

                     Application Heap (292) is of size 65536 bytes

                     Application Heap (291) is of size 65536 bytes

                     Application Heap (290) is of size 65536 bytes

                     Application Heap (289) is of size 65536 bytes

                     Application Heap (288) is of size 65536 bytes

                     Application Heap (287) is of size 393216 bytes

                     Application Heap (286) is of size 65536 bytes

                     Application Heap (285) is of size 65536 bytes

                     Application Heap (284) is of size 65536 bytes

                     Application Heap (283) is of size 131072 bytes

                     Applications Shared Heap is of size 2818048 bytes

                     Total: 90767360 bytes

                   

                  Memory for database: AUTH

                   

                     Backup/Restore/Util Heap is of size 65536 bytes

                     Package Cache is of size 1048576 bytes

                     Other Memory is of size 131072 bytes

                     Catalog Cache Heap is of size 262144 bytes

                     Buffer Pool Heap (1) is of size 4521984 bytes

                     Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes

                     Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes

                     Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes

                     Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes

                     Shared Sort Heap is of size 327680 bytes

                     Lock Manager Heap is of size 22216704 bytes

                     Database Heap is of size 13893632 bytes

                     Application Heap (30283) is of size 131072 bytes

                     Application Heap (28368) is of size 131072 bytes

                     Application Heap (25773) is of size 131072 bytes

                     Application Heap (25505) is of size 131072 bytes

                     Application Heap (5870) is of size 131072 bytes

                     Application Heap (4960) is of size 131072 bytes

                     Application Heap (4889) is of size 131072 bytes

                     Application Heap (4688) is of size 131072 bytes

                     Application Heap (336) is of size 65536 bytes

                     Application Heap (335) is of size 65536 bytes

                     Application Heap (334) is of size 65536 bytes

                     Application Heap (333) is of size 65536 bytes

                     Application Heap (332) is of size 65536 bytes

                     Application Heap (331) is of size 65536 bytes

                     Application Heap (330) is of size 65536 bytes

                     Application Heap (329) is of size 65536 bytes

                     Application Heap (328) is of size 131072 bytes

                     Application Heap (327) is of size 65536 bytes

                     Application Heap (326) is of size 65536 bytes

                     Application Heap (325) is of size 65536 bytes

                     Application Heap (324) is of size 131072 bytes

                     Applications Shared Heap is of size 917504 bytes

                     Total: 47710208 bytes

                   

                  Memory for database: AUDITING

                   

                     Backup/Restore/Util Heap is of size 65536 bytes

                     Package Cache is of size 1114112 bytes

                     Other Memory is of size 131072 bytes

                     Catalog Cache Heap is of size 196608 bytes

                     Buffer Pool Heap (1) is of size 4521984 bytes

                     Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes

                     Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes

                     Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes

                     Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes

                     Shared Sort Heap is of size 327680 bytes

                     Lock Manager Heap is of size 22216704 bytes

                     Database Heap is of size 14024704 bytes

                     Application Heap (49173) is of size 131072 bytes

                     Application Heap (322) is of size 131072 bytes

                     Application Heap (64554) is of size 131072 bytes

                     Application Heap (61252) is of size 131072 bytes

                     Application Heap (53844) is of size 131072 bytes

                     Application Heap (53841) is of size 131072 bytes

                     Application Heap (25775) is of size 131072 bytes

                     Application Heap (5872) is of size 131072 bytes

                     Application Heap (5356) is of size 131072 bytes

                     Application Heap (4961) is of size 131072 bytes

                     Application Heap (4891) is of size 131072 bytes

                     Application Heap (4700) is of size 131072 bytes

                     Application Heap (365) is of size 65536 bytes

                     Application Heap (364) is of size 65536 bytes

                     Application Heap (363) is of size 65536 bytes

                     Application Heap (362) is of size 65536 bytes

                     Application Heap (361) is of size 65536 bytes

                     Application Heap (360) is of size 65536 bytes

                     Application Heap (359) is of size 65536 bytes

                     Application Heap (358) is of size 65536 bytes

                     Application Heap (357) is of size 131072 bytes

                     Application Heap (356) is of size 65536 bytes

                     Application Heap (355) is of size 65536 bytes

                     Application Heap (354) is of size 65536 bytes

                     Application Heap (353) is of size 131072 bytes

                     Applications Shared Heap is of size 983040 bytes

                     Total: 48431104 bytes

                   

                  Memory for database: BILLING

                   

                     Backup/Restore/Util Heap is of size 65536 bytes

                     Package Cache is of size 1310720 bytes

                     Other Memory is of size 131072 bytes

                     Catalog Cache Heap is of size 393216 bytes

                     Buffer Pool Heap (1) is of size 4521984 bytes

                     Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes

                     Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes

                     Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes

                     Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes

                     Shared Sort Heap is of size 327680 bytes

                     Lock Manager Heap is of size 655360 bytes

                     Database Heap is of size 13959168 bytes

                     Application Heap (312) is of size 131072 bytes

                     Application Heap (64131) is of size 131072 bytes

                     Application Heap (64556) is of size 131072 bytes

                     Application Heap (64393) is of size 131072 bytes

                     Application Heap (61717) is of size 131072 bytes

                     Application Heap (14423) is of size 131072 bytes

                     Application Heap (4989) is of size 131072 bytes

                     Application Heap (634) is of size 131072 bytes

                     Application Heap (534) is of size 65536 bytes

                     Application Heap (533) is of size 65536 bytes

                     Application Heap (532) is of size 65536 bytes

                     Application Heap (531) is of size 65536 bytes

                     Application Heap (530) is of size 65536 bytes

                     Application Heap (529) is of size 65536 bytes

                     Application Heap (528) is of size 65536 bytes

                     Application Heap (527) is of size 65536 bytes

                     Application Heap (526) is of size 131072 bytes

                     Application Heap (525) is of size 65536 bytes

                     Application Heap (524) is of size 65536 bytes

                     Application Heap (523) is of size 65536 bytes

                     Applications Shared Heap is of size 1114112 bytes

                     Total: 26673152 bytes

                   

                  Memory for database: MODULAR

                   

                     Backup/Restore/Util Heap is of size 65536 bytes

                     Package Cache is of size 1769472 bytes

                     Other Memory is of size 131072 bytes

                     Catalog Cache Heap is of size 131072 bytes

                     Buffer Pool Heap (1) is of size 4521984 bytes

                     Buffer Pool Heap (System 32k buffer pool) is of size 851968 bytes

                     Buffer Pool Heap (System 16k buffer pool) is of size 589824 bytes

                     Buffer Pool Heap (System 8k buffer pool) is of size 458752 bytes

                     Buffer Pool Heap (System 4k buffer pool) is of size 393216 bytes

                     Shared Sort Heap is of size 327680 bytes

                     Lock Manager Heap is of size 22216704 bytes

                     Database Heap is of size 13893632 bytes

                     Application Heap (54717) is of size 131072 bytes

                     Application Heap (563) is of size 65536 bytes

                     Application Heap (562) is of size 65536 bytes

                     Application Heap (561) is of size 65536 bytes

                     Application Heap (560) is of size 65536 bytes

                     Application Heap (559) is of size 65536 bytes

                     Application Heap (558) is of size 65536 bytes

                     Application Heap (557) is of size 65536 bytes

                     Application Heap (556) is of size 65536 bytes

                     Application Heap (555) is of size 65536 bytes

                     Application Heap (554) is of size 131072 bytes

                     Application Heap (553) is of size 65536 bytes

                     Application Heap (552) is of size 65536 bytes

                     Application Heap (551) is of size 65536 bytes

                     Application Heap (550) is of size 131072 bytes

                     Applications Shared Heap is of size 786432 bytes

                     Total: 47316992 bytes

                  • db2inst1024
                    db2inst1024
                    40 Posts
                    ACCEPTED ANSWER

                    Re: Help to Configuring Memory parameter

                    ‏2013-07-29T12:38:35Z  in response to MohsinMansur

                    Can you please provide db2level and free -m commands output?

                    Updated on 2013-07-29T12:41:47Z at 2013-07-29T12:41:47Z by db2inst1024
                    • MohsinMansur
                      MohsinMansur
                      9 Posts
                      ACCEPTED ANSWER

                      Re: Help to Configuring Memory parameter

                      ‏2013-07-29T13:09:52Z  in response to db2inst1024
                      DB21085I  Instance "db2inst1" uses "32" bits and DB2 code release "SQL09071"
                      with level identifier "08020107".
                      Informational tokens are "DB2 v9.7.0.1", "s091114", "IP23033", and Fix Pack
                      "1".
                       
                      • db2inst1024
                        db2inst1024
                        40 Posts
                        ACCEPTED ANSWER

                        Re: Help to Configuring Memory parameter

                        ‏2013-07-29T13:18:28Z  in response to MohsinMansur

                        Take a look at http://www-01.ibm.com/support/docview.wss?uid=swg1IC75480

                        OSERR   : ENOMEM (12) "There is not enough memory available
                        now."
                        MESSAGE : Private memory and/or virtual address space exhausted,
                        or data ulimit
                                  exceeded

                         

                        this message is very similar to yours.  Upgrade to current FP8 probably helps.

                        • MohsinMansur
                          MohsinMansur
                          9 Posts
                          ACCEPTED ANSWER

                          Re: Help to Configuring Memory parameter

                          ‏2013-07-29T13:28:25Z  in response to db2inst1024

                          Thanks for your all help. is there any reason why the 4 GB memory is available but still its throwing private memory error.

                          Is the private memory is collection of private heap of all database? or its something else.

                          • db2inst1024
                            db2inst1024
                            40 Posts
                            ACCEPTED ANSWER

                            Re: Help to Configuring Memory parameter

                            ‏2013-07-29T13:50:32Z  in response to MohsinMansur

                            Do you have another memory consumers except DB2 on this server?

                            Can you show 'free -m' command output?

                            • MohsinMansur
                              MohsinMansur
                              9 Posts
                              ACCEPTED ANSWER

                              Re: Help to Configuring Memory parameter

                              ‏2013-07-29T13:55:04Z  in response to db2inst1024

                              No just DB2,

                               free -m

                               

                                           total       used       free     shared    buffers     cached
                              Mem:          7985       7784        200          0        162       6191
                              -/+ buffers/cache:       1430       6554
                              Swap:         1983         68       1915
                               
                              • db2inst1024
                                db2inst1024
                                40 Posts
                                ACCEPTED ANSWER

                                Re: Help to Configuring Memory parameter

                                ‏2013-07-29T14:07:03Z  in response to MohsinMansur

                                There is lot of free memory.

                                It seems like software error. If fixpack will not help, try to create additional instance, as mentioned above.

                                • MohsinMansur
                                  MohsinMansur
                                  9 Posts
                                  ACCEPTED ANSWER

                                  Re: Help to Configuring Memory parameter

                                  ‏2013-07-29T14:22:41Z  in response to db2inst1024

                                  This error does not come always.  Do you think the all configuration parameter is set correct? 

                                  • 9RYQ_Kiran_mk
                                    9RYQ_Kiran_mk
                                    78 Posts
                                    ACCEPTED ANSWER

                                    Re: Help to Configuring Memory parameter

                                    ‏2013-08-07T08:07:16Z  in response to MohsinMansur

                                    DB2 LUW 32 Bit version only supports upto 4GB of RAM.  Kindly cross check the IBM Infocenter once.

                                    • MohsinMansur
                                      MohsinMansur
                                      9 Posts
                                      ACCEPTED ANSWER

                                      Re: Help to Configuring Memory parameter

                                      ‏2013-08-07T09:29:52Z  in response to 9RYQ_Kiran_mk

                                      Hi ,

                                      Yes it does support only 4 GB. but its consuming only 2710144 KB.  then why its still throwing private memory error

                                       db2pd -dbptnmem
                                       
                                      Database Partition 0 -- Active -- Up 11 days 11:30:04
                                       
                                      Database Partition Memory Controller Statistics
                                       
                                      Controller Automatic: Y
                                      Memory Limit:         4000000 KB
                                      Current usage:        2710144 KB
                                      HWM usage:            2719168 KB
                                      Cached memory:        677952 KB