系统要求GBase 8s 产品支持多种处理器平台除国际主流的 x86_64 处理器包括 Intel 和 AMD外全面支持飞腾、鲲鹏、龙芯、兆芯、海光、申威等国产处理器。GBase 8s 产品可以运行于多款操作系统包括RHEL和CentOS等Linux操作系统、统信UOS、麒麟、欧拉等国产操作系统。内核参数调整hostname: gbase8CentOS Linux release 7.9.2009 (Core)cat /etc/sysctl.conf EOF kernel.shmmax 4398046511104 kernel.shmall 4294967296 kernel.shmmni 4096 kernel.sem 100 32000 1024 2048 vm.swappiness 0 EOFcat /etc/security/limits.conf EOF * soft nproc 40960 * hard nproc 81920 root soft nproc unlimited * soft nofile 102400 * hard nofile 204800 root soft nofile unlimited EOF环境准备cat /etc/hosts EOF 192.168.111.130 gbase8 EOFdisable_selinuxdisable_FWRequired RPMyum install net-tools -y yum install unzip -y yum install libnsl -y yum install -y java-1.8.0-openjdk.x86_64 yum install ksh -yyum install tree -yyum install lrzsz -ysu -c yum install java-1.8.0-openjdk-devel.x86_64create Gbase user groupgroupadd -g 1000 gbasedbt useradd -g gbasedbt -d /home/gbasedbt -m -s /bin/bash gbasedbt passwd gbasedbtcat .bash_profile EOF export GBASEDBTDIR/opt/gbase export GBASEDBTSERVERgbase8 export ONCONFIGonconfig.$GBASEDBTSERVER export GBASEDBTSQLHOSTS/opt/gbase/etc/sqlhosts export PATH$GBASEDBTDIR/bin:${PATH} export DB_LOCALEzh_CN.utf8 export CLIENT_LOCALEzh_CN.utf8 export GL_USEGLU1 export DBDATEY4MD- export DBACCESS_SHOW_TIME1 EOF注GBASEDBTSERVER instance name (sqlhost) DBSERVERNAME (onconfig)create DB foldermkdir -p /data/gbase chmod 755 /data chmod 755 /data/gbase chown gbasedbt:gbasedbt /data/gbase su - gbasedbt cd /data/gbase以 root 身份登录创建rootdbs数据库空间文件rootdbs必须660create datafile folderspvcreate /dev/sdb vgcreate vgdata /dev/sdb lvcreate -n lvrootchk -L 1050M vgdata lvcreate -n lvplogchk -L 1050M vgdata lvcreate -n lvllogchk -L 1050M vgdata lvcreate -n lvtempchk01 -L 1050M vgdata lvcreate -n lvsbspace01 -L 1050M vgdata lvcreate -n lvdatachk01 -L 1050M vgdata cd /dev/vgdata chown gbasedbt:gbasedbt lv* chmod 0660 lv* mkdir -p /data/gbase chmod 775 /data chmod 775 /data/gbase chown gbasedbt:gbasedbt /data/gbase cd /data/gbase ln -s /dev/vgdata/lvrootchk rootchk ln -s /dev/vgdata/lvplogchk plogchk ln -s /dev/vgdata/lvllogchk llogchk ln -s /dev/vgdata/lvtempchk01 tempchk01 ln -s /dev/vgdata/lvsbspace01 sbspace01 ln -s /dev/vgdata/lvdatachk01 datachk01[rootgbase8 ~]# pvcreate /dev/sdb Physical volume /dev/sdb successfully created. [rootgbase8 ~]# vgcreate vgdata /dev/sdb Volume group vgdata successfully created [rootgbase8 ~]# lvcreate -n lvrootchk -L 1050M vgdata Rounding up size to full physical extent 1.03 GiB Logical volume lvrootchk created. [rootgbase8 ~]# lvcreate -n lvplogchk -L 1050M vgdata Rounding up size to full physical extent 1.03 GiB Logical volume lvplogchk created. [rootgbase8 ~]# lvcreate -n lvplogchk -L 1050M vgdata Rounding up size to full physical extent 1.03 GiB Logical Volume lvplogchk already exists in volume group vgdata [rootgbase8 ~]# lvcreate -n lvllogchk -L 1050M vgdata Rounding up size to full physical extent 1.03 GiB Logical volume lvllogchk created. [rootgbase8 ~]# lvcreate -n lvtempchk01 -L 1050M vgdata Rounding up size to full physical extent 1.03 GiB Logical volume lvtempchk01 created. [rootgbase8 ~]# lvcreate -n lvsbspace01 -L 1050M vgdata Rounding up size to full physical extent 1.03 GiB Logical volume lvsbspace01 created. [rootgbase8 ~]# lvcreate -n lvdatachk01 -L 1050M vgdata Rounding up size to full physical extent 1.03 GiB Logical volume lvdatachk01 created. [rootgbase8 ~]# cd /dev/vgdata/ [rootgbase8 vgdata]# ll total 0 lrwxrwxrwx 1 root root 7 Jul 9 14:09 lvdatachk01 - ../dm-8 lrwxrwxrwx 1 root root 7 Jul 9 14:08 lvllogchk - ../dm-5 lrwxrwxrwx 1 root root 7 Jul 9 14:06 lvplogchk - ../dm-4 lrwxrwxrwx 1 root root 7 Jul 9 14:06 lvrootchk - ../dm-3 lrwxrwxrwx 1 root root 7 Jul 9 14:08 lvsbspace01 - ../dm-7 lrwxrwxrwx 1 root root 7 Jul 9 14:08 lvtempchk01 - ../dm-6 [rootgbase8 vgdata]# chown gbasedbt:gbasedbt lv* [rootgbase8 vgdata]# chmod 0660 lv* [rootgbase8 vgdata]# ll total 0 lrwxrwxrwx 1 root root 7 Jul 9 14:09 lvdatachk01 - ../dm-8 lrwxrwxrwx 1 root root 7 Jul 9 14:08 lvllogchk - ../dm-5 lrwxrwxrwx 1 root root 7 Jul 9 14:06 lvplogchk - ../dm-4 lrwxrwxrwx 1 root root 7 Jul 9 14:06 lvrootchk - ../dm-3 lrwxrwxrwx 1 root root 7 Jul 9 14:08 lvsbspace01 - ../dm-7 lrwxrwxrwx 1 root root 7 Jul 9 14:08 lvtempchk01 - ../dm-6 #Nothing change? [rootgbase8 gbase]# ln -s /dev/vgdata/lvrootchk rootchk [rootgbase8 gbase]# ln -s /dev/vgdata/lvplogchk plogchk [rootgbase8 gbase]# ln -s /dev/vgdata/lvllogchk llogchk [rootgbase8 gbase]# ln -s /dev/vgdata/lvtempchk01 tempchk01 [rootgbase8 gbase]# ln -s /dev/vgdata/lvsbspace01 sbspace01 [rootgbase8 gbase]# ln -s /dev/vgdata/lvdatachk01 datachk01 [rootgbase8 gbase]# chown gbasedbt:gbasedbt * [rootgbase8 gbase]# ll total 0 lrwxrwxrwx 1 root root 23 Jul 9 14:16 datachk01 - /dev/vgdata/lvdatachk01 lrwxrwxrwx 1 root root 21 Jul 9 14:15 llogchk - /dev/vgdata/lvllogchk lrwxrwxrwx 1 root root 21 Jul 9 14:15 plogchk - /dev/vgdata/lvplogchk lrwxrwxrwx 1 root root 21 Jul 9 14:15 rootchk - /dev/vgdata/lvrootchk lrwxrwxrwx 1 root root 23 Jul 9 14:16 sbspace01 - /dev/vgdata/lvsbspace01 lrwxrwxrwx 1 root root 23 Jul 9 14:15 tempchk01 - /dev/vgdata/lvtempchk01Install Gbase DB# cd /software # tar -xvf GBase8sV8.8_TL_3.5.1_x86_64.tar # ./ids_install -i silent -DLICENSE_ACCEPTEDTRUE -DUSER_INSTALL_DIR/opt/gbase # ls /opt/gbase/ aaodir etc gls release tmp bin extend incl RUNasroot.installserver uninstall dbssodir GBase_GLS_Install_07_05_2024_16_13_54.log isa sbin demo GBase_Install_07_05_2024_16_14_00.log lib SDK doc GBase_Software_Bundle_Install_07_05_2024_16_13_48.log msg sslconfigure DBsu - gbasedbt cd $GBASEDBTDIR/etc cp onconfig.std onconfig.gbase8onconfig 配置ROOTPATH /opt/gbase/dbs/rootdbs # 系统数据库文件存储空间路径 SERVERNUM 1 # 实例编号多实例中每个实例编号要唯一 DBSERVERNAME gbase8 # 数据库服务器实例名称 LTAPEDEV /dev/null # 用于逻辑日志备份的磁带的设备路径如不备份可以指定为/dev/null如需要备份需要将其指定其它任意目录 # 其它主要参数 #ROOTPATH /data/gbase/rootchk # ROOTDBS 路径 ROOTSIZE 1024000 # ROOTDBS 大小 PHYSBUFF 1024 # 物理日志缓存 LOGBUFF 1024 # 逻辑日志缓存 DBSPACETEMP tempdbs01 # 默认的临时数据库空间 SBSPACENAME sbspace01 # 默认的智能大对象空间 #DBSERVERNAME gbase01 # 实例名称 NETTYPE soctcp,1,100,NET # 网络连接 MULTIPROCESSOR 1 # 启用多 CPU VPCLASS cpu,num2,noage # CPU VP 数量 CLEANERS 32 # 页清理数量 LOCKS 2000000 # 初始锁的数量 DEF_TABLE_LOCKMODE row # 默认锁的类型 SHMVIRTSIZE 512000 # 虚拟内存大小 # LTAPEDEV /dev/null # 逻辑日志备份目录 STACKSIZE 2048 # 堆栈大小 ALLOW_NEWLINE 1 # 允许字符型字段换行 DS_TOTAL_MEMORY 1024000 # 决策性操作使用的内存 DS_NONPDQ_QUERY_MEM 256000 # 非决策性操作使用的内存 TEMPTAB_NOLOG 1 # 指定临时表不使用日志 DUMPSHMEM 0 # 不 DUMP 内存sqlhosts配置# cp sqlhosts.std sqlhosts # vi sqlhosts #demo_on onipcshm on_hostname on_servername # 实例名称 网络协议 IP 地址 端口号 gbase8 onsoctcp 0.0.0.0 9088其它配置配置内部用户使用的 allowed.surrogatesmkdir -p /etc/gbasedbt chmod 755 /etc/gbasedbt echo USERS:daemon /etc/gbasedbt/allowed.surrogates chmod 644 /etc/gbasedbt/allowed.surrogates more /etc/gbasedbt/allowed.surrogates指定使用 daemon 用户为代理用户USERS:daemon初始化DB​oninit -ivy​‼️ -i 参数仅限第一次初始化数据库实例时使用后期启动时应使用 oninit。# oninit -ivy Your evaluation license will expire on 2025-07-05 00:00:00 Reading configuration file /opt/gbase/etc/onconfig.gbase8...succeeded Creating /GBASEDBTTMP/.infxdirs...succeeded Allocating and attaching to shared memory...succeeded Creating resident pool 4310 kbytes...succeeded Creating infos file /opt/gbase/etc/.infos.gbase8...succeeded Linking conf file /opt/gbase/etc/.conf.gbase8...succeeded Initializing rhead structure...rhlock_t 16384 (512K)... rlock_t (2656K)... Writing to infos file...succeeded Initialization of Encryption...succeeded Initializing ASF...succeeded Initializing Dictionary Cache and SPL Routine Cache...succeeded Bringing up ADM VP...succeeded Creating VP classes...succeeded Forking main_loop thread...succeeded Initializing DR structures...succeeded Forking 1 soctcp listener threads...succeeded Starting tracing...succeeded Initializing 8 flushers...succeeded Initializing log/checkpoint information...succeeded Initializing dbspaces...succeeded Opening primary chunks...succeeded Validating chunks...succeeded Creating database partition...succeeded Initialize Async Log Flusher...succeeded Starting B-tree Scanner...succeeded Init ReadAhead Daemon...succeeded Init DB Util Daemon...succeeded Initializing DBSPACETEMP list...succeeded Init Auto Tuning Daemon...succeeded Checking database partition index...succeeded Initializing dataskip structure...succeeded Checking for temporary tables to drop...succeeded Updating Global Row Counter...succeeded Forking onmode_mon thread...succeeded Creating periodic thread...succeeded Creating periodic thread...succeeded Starting scheduling system...succeeded Verbose output complete: mode 5检查数据库状态检查侦听确认已经启动$ onstat -g ntt Your evaluation license will expire on 2025-07-05 00:00:00 On-Line -- Up 3 days 16:17:22 -- 199732 Kbytes global network information: #netscb connects read write q-free q-limits q-exceed alloc/max 2/ 3 11 4325 4324 2/ 2 135/ 10 0/ 0 2/ 2 Individual thread network information (times): netscb thread name sid open read write address 45a2c290 soctcplst 3 17:47:23 18:13:07 0.0.0.0|9088|soctcp 07/05/24 07/05/24 45a24768 soctcppoll 2 17:47:24 07/05/24查询数据库运行日志 online.log4 个 sys 开头的系统库均已经创建完成表示实例初始化完成。$ grep sys /opt/gbase/online.log 07/05/24 17:47:24 Building sysmaster database ... 07/05/24 17:47:41 sysmaster database built successfully. 07/05/24 17:47:41 sysutils database built successfully. 07/05/24 17:47:41 sysuser database built successfully. 07/05/24 17:47:48 Building sysadmin database ... 07/05/24 17:47:49 sysadmin database built successfully.数据库优化增加数据库空间刚初始化的实例仅有一个根数据库空间 rootdbs。实际业务环境需要有独立的物理日志、逻辑日志、临时数据库空间、智能大对象空间和业务数据库空间。$ onstat -d Your evaluation license will expire on 2025-07-05 00:00:00 On-Line -- Up 3 days 16:44:46 -- 199732 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 44fb6028 1 0x40001 1 1 2048 N BA gbasedbt rootdbs 1 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 44fb6258 1 1 0 150000 76209 PO-B-- /opt/gbase/dbs/rootdbs 1 active, 32766 maximum NOTE: The values in the size and free columns for DBspace chunks are displayed in terms of pgsize of the DBspace to which they belong. Expanded chunk capacity mode: always通过 onspaces 创建相应的空间# 物理日志使用的数据库空间,名称为plogdbs大小为1GB onspaces -c -d plogdbs -p /data/gbase/plogchk -o 0 -s 1024000 # 逻辑日志使用的数据库空间 onspaces -c -d llogdbs -p /data/gbase/llogchk -o 0 -s 1024000 # 临时数据库空间 onspaces -c -d tempdbs01 -t -k 16 -p /data/gbase/tempchk01 -o 0 -s 1024000 # 智能大对象空间 onspaces -c -S sbspace01 -p /data/gbase/sbspace01 -o 0 -s 1024000 # 业务使用的数据库空间 onspaces -c -d datadbs01 -k 16 -p /data/gbase/datachk01 -o 0 -s 1024000[rootgbase8 gbase]# su - gbasedbt Last login: Tue Jul 9 12:17:26 CST 2024 on pts/0 [gbasedbtgbase8 ~]$ onspaces -c -d plogdbs -p /data/gbase/plogchk -o 0 -s 1024000 Your evaluation license will expire on 2025-07-05 00:00:00 Verifying physical disk space, please wait ... Space successfully added. ** WARNING ** A level 0 archive of Root DBSpace will need to be done. [gbasedbtgbase8 ~]$ onspaces -c -d llogdbs -p /data/gbase/llogchk -o 0 -s 1024000 Your evaluation license will expire on 2025-07-05 00:00:00 Verifying physical disk space, please wait ... Space successfully added. ** WARNING ** A level 0 archive of Root DBSpace will need to be done. [gbasedbtgbase8 ~]$ onspaces -c -d tempdbs01 -t -k 16 -p /data/gbase/tempchk01 -o 0 -s 1024000 Your evaluation license will expire on 2025-07-05 00:00:00 Verifying physical disk space, please wait ... Space successfully added. [gbasedbtgbase8 ~]$ onspaces -c -S sbspace01 -p /data/gbase/sbspace01 -o 0 -s 1024000 Your evaluation license will expire on 2025-07-05 00:00:00 Verifying physical disk space, please wait ... Space successfully added. ** WARNING ** A level 0 archive of Root DBSpace will need to be done. [gbasedbtgbase8 ~]$ onspaces -c -d datadbs01 -k 16 -p /data/gbase/datachk01 -o 0 -s 1024000 Your evaluation license will expire on 2025-07-05 00:00:00 Verifying physical disk space, please wait ... Space successfully added. ** WARNING ** A level 0 archive of Root DBSpace will need to be done. [gbasedbtgbase8 ~]$ onstat -d Your evaluation license will expire on 2025-07-05 00:00:00 On-Line -- Up 02:24:09 -- 346516 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name 44fb6028 1 0x60001 1 1 2048 N BA gbasedbt rootdbs 4e7c7678 2 0x60001 2 1 2048 N BA gbasedbt plogdbs 4e7c7da0 3 0x60001 3 1 2048 N BA gbasedbt llogdbs 4e799570 4 0x42001 4 1 16384 N TBA gbasedbt tempdbs01 4e7c2d58 5 0x68001 5 1 2048 N SBA gbasedbt sbspace01 4e8ee5b0 6 0x60001 6 1 16384 N BA gbasedbt datadbs01 6 active, 2047 maximum Chunks address chunk/dbs offset size free bpages flags pathname 44fb6258 1 1 0 150000 76199 PO-B-- /opt/gbase/dbs/rootdbs 4e7c2028 2 2 0 512000 511947 PO-B-- /data/gbase/plogchk 4e798028 3 3 0 512000 511947 PO-B-- /data/gbase/llogchk 4e7bf028 4 4 0 64000 63947 PO-B-- /data/gbase/tempchk01 4e79d028 5 5 0 512000 477465 477465 POSB-- /data/gbase/sbspace01 Metadata 34482 25659 34482 4e8f0028 6 6 0 64000 63947 PO-B-- /data/gbase/datachk01 6 active, 32766 maximum NOTE: The values in the size and free columns for DBspace chunks are displayed in terms of pgsize of the DBspace to which they belong. Expanded chunk capacity mode: always将物理日志从根数据库空间移到物理日志专用的数据库空间# 移动物理日志并改变大小 onparams -p -s 1000000 -d plogdbs -y[gbasedbtgbase8 ~]$ onparams -p -s 1000000 -d plogdbs -y Your evaluation license will expire on 2025-07-05 00:00:00 Log operation started. To monitor progress, use the onstat -l command. ** WARNING ** Because the physical log has been modified, a level 0 archive must be taken of the following spaces before an incremental archive will be permitted for them: rootdbs plogdbs (see Database Server Administrators manual) [gbasedbtgbase8 ~]$ onstat -l Your evaluation license will expire on 2025-07-05 00:00:00 On-Line -- Up 02:28:50 -- 346516 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 3 64 175 19 9.21 phybegin physize phypos phyused %used 2:53 500000 0 3 0.00 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-1 0 32 1809 192 117 9.4 1.6 Subsystem numrecs Log Space used OLDRSAM 1785 224860 SBLOB 5 252 HA 19 836 address number flags uniqid begin size used %used 45101f88 1 U-B---- 7 1:25263 5000 5000 100.00 44ee7f30 2 U-B---- 8 1:30263 5000 5000 100.00 44ee7f98 3 U-B---- 9 1:35263 5000 5000 100.00 44fb6f30 4 U-B---- 10 1:40263 5000 5000 100.00 44fb6f98 5 U-B---- 11 1:45263 5000 5000 100.00 450e6050 6 U---C-L 12 1:50263 5000 2019 40.38 6 active, 6 total将逻辑日志文件从根数据库空间移到逻辑日志专用的数据库空间默认初始化时有 6 个逻辑日志文件位于 rootdbs 上逻辑日志只有已经备份或者新加未使用的情况下才能删除同时整个实例中不能少于 3 个逻辑日志。按照这样的规则在逻辑日志专用的数据库空间上创建新的逻辑日志文件然后将当前的逻辑日志移动到逻辑日志专用的数据库空间上删除在rootdbs 上的逻辑日志文件以达到移动逻辑日志的目的。# 在 llogdbs 上增加 10 个逻辑日志每个大小是 100MB for i in {1..10} do echo Logic log $i onparams -a -d llogdbs -s 100000 done # 切换当前逻辑日志到 uniqid 7 上逻辑日志文件上 onmde -l$ for i in {1..7}; do echo Logic log $i; onparams -a -d llogdbs -s 100000; done Logic log 1 Your evaluation license will expire on 2025-07-05 00:00:00 Log operation started. To monitor progress, use the onstat -l command. Logical log successfully added. Logic log 2 Your evaluation license will expire on 2025-07-05 00:00:00 Log operation started. To monitor progress, use the onstat -l command. Logical log successfully added. Logic log 3 Your evaluation license will expire on 2025-07-05 00:00:00 Log operation started. To monitor progress, use the onstat -l command. Logical log successfully added. Logic log 4 Your evaluation license will expire on 2025-07-05 00:00:00 Log operation started. To monitor progress, use the onstat -l command. Logical log successfully added. Logic log 5 Your evaluation license will expire on 2025-07-05 00:00:00 Log operation started. To monitor progress, use the onstat -l command. Logical log successfully added. Logic log 6 Your evaluation license will expire on 2025-07-05 00:00:00 Log operation started. To monitor progress, use the onstat -l command. Logical log successfully added. Logic log 7 Your evaluation license will expire on 2025-07-05 00:00:00 Log operation started. To monitor progress, use the onstat -l command. Logical log successfully added. $ onstat -l Your evaluation license will expire on 2025-07-05 00:00:00 On-Line -- Up 03:28:36 -- 346516 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 0 64 272 36 7.56 phybegin physize phypos phyused %used 2:53 500000 97 0 0.00 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-2 0 32 2624 284 184 9.2 1.5 Subsystem numrecs Log Space used OLDRSAM 2586 304972 SBLOB 5 252 HA 33 1452 address number flags uniqid begin size used %used 45101f88 1 U-B---- 7 1:25263 5000 5000 100.00 44ee7f30 2 U-B---- 8 1:30263 5000 5000 100.00 44ee7f98 3 U-B---- 9 1:35263 5000 5000 100.00 44fb6f30 4 U-B---- 10 1:40263 5000 5000 100.00 44fb6f98 5 U-B---- 11 1:45263 5000 5000 100.00 450e6050 6 U-B---- 12 1:50263 5000 2079 41.58 4e52d028 7 U---C-L 13 3:53 50000 32 0.06 4ea6cec8 8 A------ 0 3:50053 50000 0 0.00 4e52d090 9 A------ 0 3:100053 50000 0 0.00 4ea6cf30 10 A------ 0 3:150053 50000 0 0.00 4ea6cfa0 11 A------ 0 3:200053 50000 0 0.00 4e52ddc8 12 A------ 0 3:250053 50000 0 0.00 4e52de48 13 A------ 0 3:300053 50000 0 0.00 4e52ded0 14 A------ 0 3:350053 50000 0 0.00 4e52df60 15 A------ 0 3:400053 50000 0 0.00 4e798d58 16 A------ 0 3:450053 50000 0 0.00 16 active, 16 total# 删除 number 1 至 6 的逻辑日志文件 for i in {1..6} do onparams -d -l $i -y done[gbasedbtgbase8 ~]$ for ((i0;i6;i)) do onparams -d -l $i -y done Your evaluation license will expire on 2025-07-05 00:00:00 Logical log 1 successfully dropped. Your evaluation license will expire on 2025-07-05 00:00:00 Logical log 2 successfully dropped. Your evaluation license will expire on 2025-07-05 00:00:00 Logical log 3 successfully dropped. Your evaluation license will expire on 2025-07-05 00:00:00 Logical log 4 successfully dropped. Your evaluation license will expire on 2025-07-05 00:00:00 Logical log 5 successfully dropped. Your evaluation license will expire on 2025-07-05 00:00:00 Logical log 6 successfully dropped. [gbasedbtgbase8 ~]$ onstat -l Your evaluation license will expire on 2025-07-05 00:00:00 On-Line -- Up 03:53:15 -- 346516 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 0 64 379 50 7.58 phybegin physize phypos phyused %used 2:53 500000 204 0 0.00 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-3 0 32 3792 449 323 8.4 1.4 Subsystem numrecs Log Space used OLDRSAM 3744 425376 SBLOB 5 252 HA 43 1892 address number flags uniqid begin size used %used 4e52d028 7 U-B---- 29 3:53 50000 4 0.01 4ea6cec8 8 U-B---- 30 3:50053 50000 5 0.01 4e52d090 9 U---C-L 31 3:100053 50000 32 0.06 4ea6cf30 10 F------ 0 3:150053 50000 0 0.00 4ea6cfa0 11 F------ 0 3:200053 50000 0 0.00 4e52ddc8 12 F------ 0 3:250053 50000 0 0.00 4e52de48 13 F------ 0 3:300053 50000 0 0.00 4e52ded0 14 F------ 0 3:350053 50000 0 0.00 4e52df60 15 F------ 0 3:400053 50000 0 0.00 4e798d58 16 F------ 0 3:450053 50000 0 0.00关闭 sysadmin 库运行如非必要可以关闭 sysadmin 库运行。使用 gbasedbt 用户登陆在$GBASEDBTDIR/etc/sysadmin 目录下创建一个普通文件 stop数据库重启后将不会再运行 sysadmin 中指定的任务。su - gbasedbt cd $GBASEDBTDIR/etc/sysadmin touch stop onmode -ky onstat oninit -vy onstat -g sql[gbasedbtgbase8 ~]$ onstat -g sql Your evaluation license will expire on 2025-07-05 00:00:00 On-Line -- Up 03:56:21 -- 346516 Kbytes Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 27 sysadmin DR Wait 5 0 0 - Off 26 sysadmin DR Wait 5 0 0 - Off 25 sysadmin DR Wait 5 0 0 - Off 24 sysadmin CR Not Wait 0 0 - Off [gbasedbtgbase8 sysadmin]$ touch stop [gbasedbtgbase8 sysadmin]$ onmode -ky Your evaluation license will expire on 2025-07-05 00:00:00 [gbasedbtgbase8 sysadmin]$ onstat Your evaluation license will expire on 2025-07-05 00:00:00 shared memory not initialized for GBASEDBTSERVER gbase8 [gbasedbtgbase8 sysadmin]$ oninit -vy [gbasedbtgbase8 sysadmin]$ onstat -g sql Your evaluation license will expire on 2025-07-05 00:00:00 On-Line -- Up 00:00:18 -- 338324 Kbytes备份前提​onpsm -D list​The Informix Primary Storage Manager catalog is not present in the /opt/informix/etc/psm/ directory. The system will try to create it. Informix Primary Storage Manager catalog creation in the /opt/informix/etc/psm/ directory succeeded. Informix Primary Storage Manager Device List Type Prio Block/Size (MB) Pool Name Device Name FILE LOW --/-- DBSPOOL /opt/informix/backups FILE LOW --/-- LOGPOOL /opt/informix/backups其它问题主机重启后/dev/dm*权限会变成root:root现需要手工更改后期可以使用udev