> CREATE DATABASE fgedudb IN datadbs WITH LOG;

Database created.

> DATABASE fgedudb;

Database closed.
Database selected.

> CREATE TABLE fgedu_users (
> user_id SERIAL,
> username VARCHAR(50) NOT NULL,
> password VARCHAR(100) NOT NULL,
> email VARCHAR(100),
> created_at DATETIME YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND,
> updated_at DATETIME YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND,
> PRIMARY KEY (user_id),
> UNIQUE (username)
> ) IN datadbs;

Table created.

> CREATE INDEX idx_users_email ON fgedu_users (email) IN indexdbs;

Index created.

> CREATE TABLE fgedu_orders (
> order_id SERIAL,
> user_id INTEGER NOT NULL,
> order_no VARCHAR(50) NOT NULL,
> amount DECIMAL(12,2) NOT NULL,
> status VARCHAR(20) DEFAULT ‘pending’,
> created_at DATETIME YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND,
> PRIMARY KEY (order_id),
> FOREIGN KEY (user_id) REFERENCES fgedu_users (user_id)
> ) IN datadbs;

Table created.

> CREATE INDEX idx_orders_user ON fgedu_orders (user_id) IN indexdbs;

Index created.

> CREATE INDEX idx_orders_status ON fgedu_orders (status) IN indexdbs;

Index created.

> INSERT INTO fgedu_users (username, password, email) VALUES (‘admin’, ‘password123’, ‘admin@fgedu.net.cn’);

1 row(s) inserted.

> INSERT INTO fgedu_orders (user_id, order_no, amount, status) VALUES (1, ‘ORD001’, 100.00, ‘completed’);

1 row(s) inserted.

> SELECT * FROM fgedu_users;

user_id 1
username admin
password password123
email admin@fgedu.net.cn
created_at 2026-04-04 10:00:00
updated_at 2026-04-04 10:00:00

1 row(s) retrieved.

> exit;

IBM Informix Dynamic Server Version 14.10.FC4DE — On-Line — Up 1 days 10:00:00 — 655360 Kbytes

Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
10000 15000 500000 98.00 5000 8000 200000 97.50

isamtot open start read write rewrite delete commit rollbk
100000 500 10000 50000 10000 5000 2000 10000 100

gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0

# 更新统计信息
$ dbaccess fgedudb –

Database selected.

> UPDATE STATISTICS HIGH FOR TABLE fgedu_users;

Statistics updated.

> UPDATE STATISTICS HIGH FOR TABLE fgedu_orders;

Statistics updated.

> exit;

Database closed.

# 查看缓冲区命中率
$ onstat -B | head -20

IBM Informix Dynamic Server Version 14.10.FC4DE — On-Line — Up 1 days 10:00:00 — 655360 Kbytes

Buffer pool profile (default pool)
buffer size (K) = 2
buffers = 500000
used = 10000
#hashbuckets = 125000
hashbuckets = 125001
lru list = 4
lru length = 10000
flush list = 1
flush length = 1000
hash hits = 5000000
hash misses = 10000
hit ratio = 99.80%

# 查看锁信息
$ onstat -k

IBM Informix Dynamic Server Version 14.10.FC4DE — On-Line — Up 1 days 10:00:00 — 655360 Kbytes

Locks
address wtlist owner lklist type tblsnum rowid key#
0x4c005000 0 0x4c006000 0 HDR+IX 100002 0 0
0x4c005100 0 0x4c006000 0x4c005000 HDR+X 100002 205 0

2 active, 200000 maximum, 100 hash buckets

#!/bin/bash
export INFORMIXDIR=/opt/informix
export INFORMIXSERVER=fgedudb01
export ONCONFIG=onconfig.fgedudb
export PATH=$INFORMIXDIR/bin:$PATH

LOG_FILE=/home/informix/logs/monitor.log
DATE=$(date ‘+%Y-%m-%d %H:%M:%S’)

echo “=== $DATE ===” >> $LOG_FILE

# 检查数据库状态
STATUS=$($INFORMIXDIR/bin/onstat – 2>&1 | head -1)
echo “Status: $STATUS” >> $LOG_FILE

# 检查会话数
SESSIONS=$($INFORMIXDIR/bin/onstat -g ses 2>&1 | grep -c “sqlexec”)
echo “Sessions: $SESSIONS” >> $LOG_FILE

# 检查锁等待
LOCKS=$($INFORMIXDIR/bin/onstat -k 2>&1 | grep “active” | awk ‘{print $1}’)
echo “Active Locks: $LOCKS” >> $LOG_FILE

# 检查磁盘空间
$INFORMIXDIR/bin/onstat -d 2>&1 | grep -E “^Chunks” >> $LOG_FILE

# 检查日志空间
$INFORMIXDIR/bin/onstat -l 2>&1 | grep -E “%used” >> $LOG_FILE

echo “” >> $LOG_FILE

# 设置脚本权限
$ chmod +x /home/informix/scripts/informix_monitor.sh

# 配置定时任务
$ crontab -e

# 添加以下内容
*/5 * * * * /home/informix/scripts/informix_monitor.sh

# 验证定时任务
$ crontab -l
*/5 * * * * /home/informix/scripts/informix_monitor.sh

# 手动执行监控
$ /home/informix/scripts/informix_monitor.sh

# 查看监控日志
$ cat /home/informix/logs/monitor.log

=== 2026-04-04 10:00:00 ===
Status: IBM Informix Dynamic Server Version 14.10.FC4DE — On-Line — Up 1 days 10:00:00 — 655360 Kbytes
Sessions: 5
Active Locks: 2
Chunks
address chunk/dbs offset size free bpages flags pathname
Active Locks: 2
%used