# 查看成员状态
db2pd -db FGEDB -members

# 查看CF状态
db2pd -db FGEDB -cf

# 查看集群拓扑
db2pd -db FGEDB -topology

# 查看HADR状态
db2pd -db FGEDB -hadr

# 查看集群资源
db2pd -db FGEDB -cluster

# 集群监控脚本
#!/bin/bash
# cluster_monitor.sh

DBNAME=FGEDB
LOG_FILE=/db2/logs/cluster_monitor_$(date +%Y%m%d).log

echo “=== Cluster Monitor ===” > $LOG_FILE
echo “Time: $(date)” >> $LOG_FILE

# 1. 检查成员状态
echo “1. Member Status:” >> $LOG_FILE
db2pd -db $DBNAME -members >> $LOG_FILE

# 2. 检查CF状态
echo “2. CF Status:” >> $LOG_FILE
db2pd -db $DBNAME -cf >> $LOG_FILE

# 3. 检查集群拓扑
echo “3. Cluster Topology:” >> $LOG_FILE
db2pd -db $DBNAME -topology >> $LOG_FILE

# 4. 检查HADR状态
echo “4. HADR Status:” >> $LOG_FILE
db2pd -db $DBNAME -hadr >> $LOG_FILE

# 5. 检查连接数
echo “5. Connection Count:” >> $LOG_FILE
db2 connect to $DBNAME
db2 “SELECT COUNT(*) FROM sysibmadm.applications” >> $LOG_FILE
db2 connect reset

echo “=== Monitor Complete ===” >> $LOG_FILE

# 监控缓冲池
db2pd -db FGEDB -bufferpools

# 监控锁
db2pd -db FGEDB -locks

# 监控事务
db2pd -db FGEDB -transactions

# 监控日志
db2pd -db FGEDB -logs

# 性能监控脚本
#!/bin/bash
# cluster_perf_monitor.sh

DBNAME=FGEDB

echo “=== Cluster Performance Monitor ===”
echo “Time: $(date)”

# 1. 缓冲池命中率
echo “1. Bufferpool Hit Ratio:”
db2pd -db $DBNAME -bufferpools | grep -A 5 “BP_NAME”

# 2. 锁等待
echo “2. Lock Waits:”
db2pd -db $DBNAME -locks wait

# 3. 活跃事务
echo “3. Active Transactions:”
db2pd -db $DBNAME -transactions | grep -A 10 “APPHDL”

# 4. 日志使用
echo “4. Log Usage:”
db2pd -db $DBNAME -logs | grep -A 5 “LOG”

# 5. 网络延迟
echo “5. Network Latency:”
ping -c 3 db2-member2

echo “=== Performance Monitor Complete ===”

# 添加CF
db2iupdt -add -cf db2-cf2 db2inst1

# 查看扩容状态
db2pd -db FGEDB -members

# 集群扩容脚本
#!/bin/bash
# cluster_expand.sh

NEW_MEMBER=$1

if [ -z “$NEW_MEMBER” ]; then
echo “Usage: $0 ”
exit 1
fi

echo “Adding new member: $NEW_MEMBER”

# 1. 检查新成员连通性
echo “1. Checking connectivity…”
ping -c 3 $NEW_MEMBER

# 2. 添加成员
echo “2. Adding member…”
db2iupdt -add -m $NEW_MEMBER db2inst1

# 3. 验证成员状态
echo “3. Verifying member status…”
db2pd -db FGEDB -members

# 4. 更新负载均衡
echo “4. Updating workload balance…”
db2 connect to FGEDB
db2 “ALTER WORKLOAD BALANCE UPDATE”
db2 connect reset

echo “Member added successfully”

# 移除CF
db2iupdt -drop -cf db2-cf2 db2inst1

# 查看缩容状态
db2pd -db FGEDB -members

# 集群缩容脚本
#!/bin/bash
# cluster_shrink.sh

MEMBER=$1

if [ -z “$MEMBER” ]; then
echo “Usage: $0 ”
exit 1
fi

echo “Removing member: $MEMBER”

# 1. 检查成员状态
echo “1. Checking member status…”
db2pd -db FGEDB -members | grep $MEMBER

# 2. 停止成员
echo “2. Stopping member…”
db2pd -db FGEDB -member $MEMBER -stop

# 3. 移除成员
echo “3. Removing member…”
db2iupdt -drop -m $MEMBER db2inst1

# 4. 验证移除结果
echo “4. Verifying removal…”
db2pd -db FGEDB -members

echo “Member removed successfully”

# 重启故障成员
db2pd -db FGEDB -member -restart

# 重建成员
db2iupdt -drop -m db2-member3 db2inst1
db2iupdt -add -m db2-member3 db2inst1

# 成员故障处理脚本
#!/bin/bash
# member_failure_handling.sh

MEMBER=$1

if [ -z “$MEMBER” ]; then
echo “Usage: $0 ”
exit 1
fi

echo “Handling member failure: $MEMBER”

# 1. 检查成员状态
echo “1. Checking member status…”
MEMBER_STATUS=$(db2pd -db FGEDB -members | grep $MEMBER | awk ‘{print $3}’)

if [ “$MEMBER_STATUS” = “ACTIVE” ]; then
echo “Member is active, no action needed”
exit 0
fi

# 2. 尝试重启成员
echo “2. Restarting member…”
db2pd -db FGEDB -member $MEMBER -restart

sleep 60

# 3. 检查重启结果
echo “3. Checking restart result…”
MEMBER_STATUS=$(db2pd -db FGEDB -members | grep $MEMBER | awk ‘{print $3}’)

if [ “$MEMBER_STATUS” = “ACTIVE” ]; then
echo “Member restarted successfully”
else
echo “Member restart failed, manual intervention required”
fi

# 重启CF
db2pd -db FGEDB -cf -restart

# 切换CF
db2pd -db FGEDB -cf -takeover

# CF故障处理脚本
#!/bin/bash
# cf_failure_handling.sh

echo “Handling CF failure…”

# 1. 检查CF状态
echo “1. Checking CF status…”
CF_STATUS=$(db2pd -db FGEDB -cf | grep “CF_STATE” | awk ‘{print $3}’)

if [ “$CF_STATUS” = “ACTIVE” ]; then
echo “CF is active, no action needed”
exit 0
fi

# 2. 尝试重启CF
echo “2. Restarting CF…”
db2pd -db FGEDB -cf -restart

sleep 60

# 3. 检查重启结果
echo “3. Checking restart result…”
CF_STATUS=$(db2pd -db FGEDB -cf | grep “CF_STATE” | awk ‘{print $3}’)

if [ “$CF_STATUS” = “ACTIVE” ]; then
echo “CF restarted successfully”
else
echo “CF restart failed, attempting takeover…”
db2pd -db FGEDB -cf -takeover
fi