DB2: memory

 db2 list db directory

db2 get dbm cfg | grep -i instance

exit

db2 update dbm cfg using INSTANCE_MEMORY 1572864 immediate

db2 terminate; db2 force applications all; db2stop force; db2start

free -m

db2 get dbm cfg | grep instance



Configuring memory and memory heaps - IBM Documentation

https://www.ibm.com/docs/en/db2/11.5.x?topic=overview-configuring-memory-memory-heaps


a single parameter, instance_memory, to specify all of the memory that the database manager is allowed to allocate from its private and shared


the db2mtrk command to monitor heap usage and the ADMIN_GET_MEM_USAGE table function to query overall memory consumption

>db2mtrk  -a




Note: The DBMCFG and DBCFG administrative views retrieve database manager configuration parameter information for the currently connected database for all database partitions. For the mon_heap_sz, stmtheap, and stat_heap_sz configuration parameters, the DEFERRED_VALUE column on this view does not persist across database activations. That is, when you issue the get dbm cfg show detail or get db cfg show detail command, the output from the query shows updated (in memory) values.



As part of the move to simplified memory configuration, the following elements have been deprecated:

  • Configuration parameters appgroup_mem_sz, groupheap_ratio, and app_ctl_heap_sz. These configuration parameters are replaced with the new appl_memory configuration parameter.
  • The -p parameter of the db2mtrk memory tracker command. This option, which lists private agent memory heaps, is replaced with the -a parameter, which lists all application memory consumption.






Comments

Post a Comment

Popular posts from this blog

Oracle: To clean up WRI$_ADV_OBJECTS

 set linesize 200; select segment_name, segment_type, bytes from dba_segments where tablespace_name='SYSAUX' order by bytes asc; COL OCCUPANT_NAME FORMAT A30 SELECT OCCUPANT_NAME,SPACE_USAGE_KBYTES FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC; COL SEGMENT_NAME FORMAT A30 COL OWNER FORMAT A10 COL TABLESPACE_NAME FORMAT A10 COL SEGMENT_TYPE FORMAT A15 SELECT * FROM (SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,BYTES/1024/1024 "SIZE(MB)",SEGMENT_TYPE FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='SYSAUX' ORDER BY BYTES DESC) WHERE ROWNUM<=10; 1.  automatic clean-up default 31 days           SELECT dbms_stats.get_stats_history_availability from Dual; 2. modify retention policy        exec  dbms_stats.alter_stats_history_retention (14); 3. a manual cleaning  exec dbms_stats.purge_stats (sysdate-14);   ALTER TABLE WRI$_ADV_OBJECTS MOVE; ALTER INDEX WRI$_ADV_OBJECTS_IDX_01 REBUILD; ALTER INDEX WRI$_ADV_OBJECTS_IDX_02 R...
Read more