DB2 user space 調整

Administrator
ITM@Admin


至DB2 GUI控制中心 -> 右鍵要增加容量的DB
管理儲存體 -> 新增自動儲存體 -> 增加位置 

db2 connect to database_name

db2 alter database add storage on 'd:\'

db2 connect reset

db2 connect to database_name 

db2 ALTER TABLESPACE tablespace_name REBALANCE

ITM CEC Base agent issue

ITM CEC Base agent重啟後，ITM無法顯示CEC的數據，解決步驟如下：

STEPS TO RECYCLE THE SHARED MEMORY:
1. Stop all the processes which use the SPMI shared library
(xmservd,filtd, xmperf, 3dmon, ptxrlog, harmd, topas, any PSSP process)
if they are currently running your AIX LPAR. 

2. Stop the ITM system P agents (PX, PK, PH) that you have running on
this system. 

3. To find if any zombie processes are running on your machine.
a. Run
# ps -ef | grep Provider
Kill each one of them "kill <pid> 

b. Run
ps -ef | grep kpkagent
ps -ef | grep kpxagent
ps -ef | grep kphagent
Kill each one of them "kill <pid>" 

c. Check if there are any defunct processes
"ps -ef | grep defunct" 

4. Kill the processes that are using the shared memory. 
genld -l | grep -p Spmi 

5. Run "ipcs -m" command and check for any segment "KEY" that begins
with '0x78', as listed below:
T ID KEY
m 0 0xc76283cc
m 1 0x78002323
If there are any such segments starting with 0x78, make sure the process
which uses those shared segments is stopped (or terminate it with kill
command) 

6. Then run: "ipcrm -m <ID #>" to clear the shared memory segments. 

7. Run "slibclean"

8. Restart system P agents - PH PX PK