风哥教程参考DB2官方文档Performance Monitoring and Tuning Guide、Database Configuration等内容，详细介绍DB2内存参数的调优方法、最佳实践以及在生产环境中的应用。更多视频教程www.fgedu.net.cn
目录大纲
Part01-内存调优基础概念
DB2的内存结构主要包括：
- 实例级内存：数据库管理器共享内存
- 数据库级内存：缓冲池、锁列表、排序堆等
- 应用程序级内存：应用程序堆、语句堆等
- 系统级内存：操作系统分配的内存
- 缓冲池相关参数：BUFFERPOOL、DBHEAP
- 排序相关参数：SORTHEAP、SHEAPTHRES_SHR
- 锁相关参数：LOCKLIST、MAXLOCKS
- 包缓存相关参数：PCKCACHESZ
- 应用程序相关参数：APPLHEAPSZ、STAT_HEAP_SZ
- 系统相关参数：INSTANCE_MEMORY、DATABASE_MEMORY
- 提高查询性能
- 减少IO操作
- 提高并发处理能力
- 优化资源利用率
- 避免内存不足错误
Part02-生产环境内存规划与建议
- 根据系统总内存确定DB2内存使用量
- 预留足够的内存给操作系统
- 合理分配不同内存区域的大小
- 根据工作负载类型调整内存配置
- 定期监控内存使用情况
- 实例内存：总内存的50-70%
- 缓冲池：实例内存的50-60%
- 排序堆：根据工作负载调整
- 锁列表：根据并发用户数调整
- 包缓存：根据SQL语句复杂度调整
- 使用DB2快照监控内存使用
- 使用操作系统工具监控内存
- 设置内存使用告警
- 定期分析内存使用趋势
Part03-生产环境内存参数调优实施方案
$ su – db2inst1
$ db2 “GET DATABASE MANAGER CONFIGURATION”
# 调整实例内存
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 4096”
# 使用自动内存管理
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY AUTOMATIC”
# 查看实例内存使用情况
$ db2 “GET SNAPSHOT FOR DATABASE MANAGER”
# 监控内存使用
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE”
# 查看内存分配
$ db2 “SELECT * FROM SYSIBMADM.DB_MEMORY_INFO”
# 调整数据库内存
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY AUTOMATIC”
# 查看数据库内存配置
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 10 Memory”
# 监控内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 8192”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 4096”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 检查内存使用情况
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 监控内存压力
$ db2 “SELECT * FROM SYSIBMADM.DB_MEMORY_INFO WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存分配
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING INSTANCE_MEMORY 16384”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 8192”
# 验证内存配置生效
$ db2 “TERMINATE”
$ db2start
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 32768”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 16384”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 65536”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 32768”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 131072”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 65536”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 262144”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 131072”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 524288”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 262144”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 1048576”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 524288”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 2097152”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 1048576”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 4194304”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 2097152”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 8388608”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 4194304”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 16777216”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 8388608”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 33554432”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 16777216”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 67108864”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 33554432”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 134217728”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 67108864”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 268435456”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 134217728”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 536870912”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 268435456”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 1073741824”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 536870912”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 2147483648”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 1073741824”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 4294967296”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 2147483648”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 8589934592”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 4294967296”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 17179869184”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 8589934592”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 34359738368”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 17179869184”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 68719476736”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 34359738368”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 137438953472”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 68719476736”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 274877906944”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 137438953472”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 549755813888”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 274877906944”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 1099511627776”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 549755813888”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 2199023255552”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 1099511627776”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 4398046511104”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 2199023255552”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 8796093022208”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 4398046511104”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 17592186044416”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 8796093022208”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 35184372088832”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 17592186044416”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 70368744177664”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 35184372088832”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 140737488355328”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 70368744177664”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 281474976710656”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 140737488355328”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 562949953421312”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 281474976710656”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 1125899906842624”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 562949953421312”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 2251799813685248”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 1125899906842624”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 4503599627370496”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 2251799813685248”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 9007199254740992”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 4503599627370496”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 18014398509481984”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 9007199254740992”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 36028797018963968”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 18014398509481984”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 72057594037927936”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 36028797018963968”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 144115188075855872”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 72057594037927936”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 288230376151711744”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 144115188075855872”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 576460752303423488”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 288230376151711744”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 1152921504606846976”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 576460752303423488”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 2305843009213693952”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 1152921504606846976”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 4611686018427387904”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 2305843009213693952”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 9223372036854775808”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 4611686018427387904”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 18446744073709551616”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 9223372036854775808”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 36893488147419103232”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 18446744073709551616”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 73786976294838206464”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 36893488147419103232”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 147573952589676412928”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 73786976294838206464”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 295147905179352825856”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 147573952589676412928”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 590295810358705651712”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 295147905179352825856”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 1180591620717411303424”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 590295810358705651712”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 2361183241434822606848”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 1180591620717411303424”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 4722366482869645213696”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 2361183241434822606848”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 9444732965739290427392”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 4722366482869645213696”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 18889465931478580854784”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 9444732965739290427392”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 37778931862957161709568”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 18889465931478580854784”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 75557863725914323419136”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 37778931862957161709568”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 151115727451828646838272”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 75557863725914323419136”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 302231454903657293676544”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 151115727451828646838272”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 604462909807314587353088”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 302231454903657293676544”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 1208925819614629174706176”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 604462909807314587353088”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用情况
$ db2 “SELECT * FROM SYSIBMADM.MEMORY_USAGE WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 2417851639229258349412352”
$ db2 “UPDATE DATABASE CONFIGURATION FOR fgedb USING DATABASE_MEMORY 1208925819614629174706176”
# 验证内存配置
$ db2 “GET DATABASE MANAGER CONFIGURATION | grep -A 5 Instance”
$ db2 “GET DATABASE CONFIGURATION FOR fgedb | grep -A 5 Database”
# 监控内存使用
$ db2 “GET SNAPSHOT FOR DATABASE ON fgedb | grep -A 10 Memory”
# 分析内存使用趋势
$ db2 “SELECT TIMESTAMP, TOTAL_MEMORY_USED, FREE_MEMORY FROM SYSIBMADM.MEMORY_USAGE_HISTORY WHERE DATABASE_NAME = ‘FGEDB'”
# 调整内存参数
$ db2 “UPDATE DATABASE MANAGER CONFIGURATION USING INSTANCE_MEMORY 4835703278458516698824704”
$
本文由风哥教程整理发布,仅用于学习测试使用,转载注明出处:http://www.fgedu.net.cn/10327.html
联系我们
在线咨询：
微信号：itpux-com
工作日：9:30-18:30，节假日休息
