Добрый день.

А практически чистая (одна пустая база и та не используется) DB2 Express-C V9.1 for Linux должна сходу при отъедать 400 метров оперативки или я что-то неправильно где-то крутанул?
Реальная статистика:



Мне хостинг гарантирует только 256Мб, естественно, что при таком раскладе кажде мое действие выливается в нехватку памяти. Можно ли как-то подкрутить DB2 чтобы все укладывалось в разумные рамки при моих условиях существования на вышеобозначенном сервере?

тлгдшлщмсмотри в сторону DBHEAPSIZE, Bufferpools, Self Tuning Memory Management (Он то у тебя и расширяет БД до 500 мегов)

db2 update db cfg for sample
db2 update dbm cfg

Для данной базы:

Self tuning memory (SELF_TUNING_MEM) = OFF Size of database shared memory (4KB) (DATABASE_MEMORY) = 1000 Database memory threshold (DB_MEM_THRESH) = 10 Max storage for lock list (4KB) (LOCKLIST) = 100 Percent. of lock lists per application (MAXLOCKS) = 60 Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC Sort list heap (4KB) (SORTHEAP) = AUTOMATIC Database heap (4KB) (DBHEAP) = 1200 Catalog cache size (4KB) (CATALOGCACHE_SZ) = 260 Log buffer size (4KB) (LOGBUFSZ) = 8 Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000 Buffer pool size (pages) (BUFFPAGE) = 200 Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 30000 Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70 Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 128 SQL statement heap (4KB) (STMTHEAP) = 2048 Default application heap (4KB) (APPLHEAPSZ) = 256 Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384

Вроде бы запределов никаких нет. Какие-то вещи я подкрутил, но эффекта нет.

Mark BarinsteinДобрый день.

Есть утилита db2pd.
У нее много всяких ключей, в том числе и про распределение памяти.
Позапускайте ее и увидите, что же так памяти много жрет.

А что-то вообще странно, вроде запускается эта программка, но как-то без признаков жизни. Поперебирал ключи из хелпа, и ничего, в ответ ничего не выдает.

Реально хоть что-то заработало только тогда, когда системе позволили скушать гиг памяти.
И то, какие-то там предупреждения еще выдавала, что, мол, маловато будет, в виде исключения запускаюсь.

тлгдшлщмОтключи STMM

Что такое STMM? Самонастройка потребление памяти? Вроде по приведенной таблице уже отключена.

Это просто беда какая-то, даже уже попробовал дать команду:
db2 autoconfigure using MEM_PERCENT 4 apply db and dbm

Полностью машину перезагрузил, хоть бы на байт DB2 стала памяти меньше кушать.

На машине 6 гигов, 4% будет 240 Мб, мне бы желательно в них вложиться.

Кто еще чем поможет? STMM полностью отключил по данным вышеуказанной статьи, ни на байт меньше не стало.
Я вообще просуммировал все циферки в конфигах и умножил их на 4Кб, даже близко не получаются те сотни метров, которые съедаются в первую же секунду после команды db2start.

А почему так много одиннаковых процессов? И почему они столько памяти жрут? Напомню: это проценты от 6Гб памяти. Состояние: только что перезагрузиличь и сделали db2start. Все, больше ничего!!! Ни одного клиента. Всего одна ПУСТАЯ база данных, без таблиц вообще. Ну как так?

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND24425 db2inst1 16 0 149m 23m 147m S 0.0 0.4 0:00.00 db2sysc24412 db2inst1 16 0 149m 23m 147m S 0.0 0.4 0:00.07 db2sysc27896 db2inst1 16 0 149m 23m 147m S 0.0 0.4 0:00.00 db2sysc24421 db2inst1 20 0 149m 23m 147m S 0.0 0.4 0:00.00 db2sysc24420 db2inst1 20 0 149m 23m 147m S 0.0 0.4 0:00.00 db2sysc24427 db2inst1 17 0 180m 22m 137m S 0.0 0.4 0:00.36 db2fmp24419 db2inst1 16 0 149m 21m 147m S 0.0 0.4 0:00.00 db2sysc24417 db2inst1 18 0 149m 21m 147m S 0.0 0.4 0:00.00 db2sysc24416 root 16 0 148m 21m 147m S 0.0 0.3 0:00.00 db2sysc24413 root 23 0 146m 19m 145m S 0.0 0.3 0:00.00 db2sysc24414 root 23 0 146m 19m 145m S 0.0 0.3 0:00.00 db2sysc24415 root 23 0 146m 19m 145m S 0.0 0.3 0:00.00 db2sysc24408 root 20 0 146m 19m 145m S 0.0 0.3 0:00.41 db2sysc22144 db2inst1 15 0 51488 10m 36m S 0.0 0.2 0:00.07 db222146 db2inst1 16 0 53736 9388 38m S 0.0 0.2 0:00.05 db2bp10099 root 16 0 53392 8056 38m S 0.0 0.1 0:00.03 db2bp 8148 root 16 0 57220 5504 15m S 0.0 0.1 0:00.06 db2dasrrm 8121 root 16 0 16200 5436 15m S 0.0 0.1 0:00.05 db2fmd 8106 root 15 0 7644 3668 7256 S 0.3 0.1 0:00.59 db2fmcd

db2 => get dbm cfg Database Manager Configuration Node type = Database Server with local and remote clients Database manager configuration release level = 0x0b00 CPU speed (millisec/instruction) (CPUSPEED) = 3.385134e-07 Max number of concurrently active databases (NUMDB) = 1 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 Default database monitor switches Buffer pool (DFT_MON_BUFPOOL) = OFF Lock (DFT_MON_LOCK) = OFF 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) = ON 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 Database manager authentication (AUTHENTICATION) = SERVER 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) = 90 Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 0 Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0 Size of instance shared memory (4KB) (INSTANCE_MEMORY) = 1200 Backup buffer default size (4KB) (BACKBUFSZ) = 1024 Restore buffer default size (4KB) (RESTBUFSZ) = 1024 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 Max number of existing agents (MAXAGENTS) = 200 Agent pool size (NUM_POOLAGENTS) = 200 Initial number of agents in pool (NUM_INITAGENTS) = 0 Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS Max number of client connections (MAX_CONNECTIONS) = MAX_COORDAGENTS Keep fenced process (KEEPFENCED) = YES Number of pooled fenced processes (FENCED_POOL) = 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) = 50055 Discovery mode (DISCOVER) = SEARCH Discover server instance (DISCOVER_INST) = ENABLE Maximum query degree of parallelism (MAX_QUERYDEGREE) = 1 Enable intra-partition parallelism (INTRA_PARALLEL) = NO No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC db2start/db2stop timeout (min) (START_STOP_TIME) = 10

db2 => get db cfg for mydb Database Configuration for Database mydb Database configuration release level = 0x0b00 Database release level = 0x0b00 Database territory = RU Database code page = 1208 Database code set = UTF-8 Database country/region code = 7 Database collating sequence = IDENTITY Alternate collating sequence (ALT_COLLATE) = Database page size = 4096 Dynamic SQL Query management (DYN_QUERY_MGMT) = DISABLE 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 Backup pending = NO Database is consistent = YES Rollforward pending = NO Restore pending = NO Multi-page file allocation enabled = YES Log retain for recovery status = NO User exit for logging status = NO Self tuning memory (SELF_TUNING_MEM) = ON Size of database shared memory (4KB) (DATABASE_MEMORY) = COMPUTED Database memory threshold (DB_MEM_THRESH) = 10 Max storage for lock list (4KB) (LOCKLIST) = AUTOMATIC Percent. of lock lists per application (MAXLOCKS) = AUTOMATIC Package cache size (4KB) (PCKCACHESZ) = AUTOMATIC Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC Sort list heap (4KB) (SORTHEAP) = AUTOMATIC Database heap (4KB) (DBHEAP) = 2558 Catalog cache size (4KB) (CATALOGCACHE_SZ) = 260 Log buffer size (4KB) (LOGBUFSZ) = 98 Utilities heap size (4KB) (UTIL_HEAP_SZ) = 52949 Buffer pool size (pages) (BUFFPAGE) = 1000 Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 30000 Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70 Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 128 SQL statement heap (4KB) (STMTHEAP) = 2048 Default application heap (4KB) (APPLHEAPSZ) = 256 Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384 Interval for checking deadlock (ms) (DLCHKTIME) = 10000 Lock timeout (sec) (LOCKTIMEOUT) = -1 Changed pages threshold (CHNGPGS_THRESH) = 80 Number of asynchronous page cleaners (NUM_IOCLEANERS) = AUTOMATIC Number of I/O servers (NUM_IOSERVERS) = AUTOMATIC Index sort flag (INDEXSORT) = YES Sequential detect flag (SEQDETECT) = YES Default prefetch size (pages) (DFT_PREFETCH_SZ) = AUTOMATIC Track modified pages (TRACKMOD) = OFF Default number of containers = 1 Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32 Max number of active applications (MAXAPPLS) = AUTOMATIC Average number of active applications (AVG_APPLS) = AUTOMATIC Max DB files open per application (MAXFILOP) = 64 Log file size (4KB) (LOGFILSIZ) = 1024 Number of primary log files (LOGPRIMARY) = 13 Number of secondary log files (LOGSECOND) = 4 Changed path to log files (NEWLOGPATH) = Path to log files = /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/ Overflow log path (OVERFLOWLOGPATH) = Mirror log path (MIRRORLOGPATH) = First active log file = Block log on disk full (BLK_LOG_DSK_FUL) = 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) = 520 Log retain for recovery enabled (LOGRETAIN) = OFF User exit for logging enabled (USEREXIT) = OFF HADR database role = STANDARD HADR local host name (HADR_LOCAL_HOST) = HADR local service name (HADR_LOCAL_SVC) = HADR remote host name (HADR_REMOTE_HOST) = HADR remote service name (HADR_REMOTE_SVC) = HADR instance name of remote server (HADR_REMOTE_INST) = HADR timeout value (HADR_TIMEOUT) = 120 HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC First log archive method (LOGARCHMETH1) = OFF 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) = OFF 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 TSM management class (TSM_MGMTCLASS) = TSM node name (TSM_NODENAME) = TSM owner (TSM_OWNER) = TSM password (TSM_PASSWORD) = Automatic maintenance (AUTO_MAINT) = ON Automatic database backup (AUTO_DB_BACKUP) = OFF Automatic table maintenance (AUTO_TBL_MAINT) = ON Automatic runstats (AUTO_RUNSTATS) = ON Automatic statistics profiling (AUTO_STATS_PROF) = OFF Automatic profile updates (AUTO_PROF_UPD) = OFF Automatic reorganization (AUTO_REORG) = OFF

А select * from syscat.bufferpools не дам, потому как для этого сперва коннект сделать надо, а у меня памяти не хватает.