在LVM上安装Gbase 8S
系统要求
GBase 8s 产品支持多种处理器平台，除国际主流的 x86_64 处理器（包括 Intel 和 AMD）外，全面支持飞腾、鲲鹏、龙芯、兆芯、海光、申威等国产处理器。
GBase 8s 产品可以运行于多款操作系统，包括：RHEL和CentOS等Linux操作系统、统信UOS、麒麟、欧拉等国产操作系统。
内核参数调整
hostname: gbase8
CentOS 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_selinux
disable_FW
Required RPM
yum 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 -y
yum install lrzsz -y
su -c "yum install java-1.8.0-openjdk-devel.x86_64"
create Gbase user & group
groupadd -g 1000 gbasedbt useradd -g gbasedbt -d /home/gbasedbt -m -s /bin/bash gbasedbt passwd gbasedbtcat >> .bash_profile <<EOF export GBASEDBTDIR=/opt/gbase export GBASEDBTSERVER=gbase8 export ONCONFIG=onconfig.$GBASEDBTSERVER export GBASEDBTSQLHOSTS=/opt/gbase/etc/sqlhosts export PATH=$GBASEDBTDIR/bin:${PATH} export DB_LOCALE=zh_CN.utf8 export CLIENT_LOCALE=zh_CN.utf8 export GL_USEGLU=1 export DBDATE="Y4MD-" export DBACCESS_SHOW_TIME=1 EOF注：GBASEDBTSERVER = instance name (sqlhost) = DBSERVERNAME (onconfig)
create DB folder
mkdir -p /data/gbase chmod 755 /data chmod 755 /data/gbase chown gbasedbt:gbasedbt /data/gbase su - gbasedbt cd /data/gbase以 root 身份登录，创建"rootdbs"数据库空间文件：
rootdbs必须660
create datafile folders
pvcreate /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[root@gbase8 ~]# pvcreate /dev/sdb Physical volume "/dev/sdb" successfully created. [root@gbase8 ~]# vgcreate vgdata /dev/sdb Volume group "vgdata" successfully created [root@gbase8 ~]# lvcreate -n lvrootchk -L 1050M vgdata Rounding up size to full physical extent <1.03 GiB Logical volume "lvrootchk" created. [root@gbase8 ~]# lvcreate -n lvplogchk -L 1050M vgdata Rounding up size to full physical extent <1.03 GiB Logical volume "lvplogchk" created. [root@gbase8 ~]# 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" [root@gbase8 ~]# lvcreate -n lvllogchk -L 1050M vgdata Rounding up size to full physical extent <1.03 GiB Logical volume "lvllogchk" created. [root@gbase8 ~]# lvcreate -n lvtempchk01 -L 1050M vgdata Rounding up size to full physical extent <1.03 GiB Logical volume "lvtempchk01" created. [root@gbase8 ~]# lvcreate -n lvsbspace01 -L 1050M vgdata Rounding up size to full physical extent <1.03 GiB Logical volume "lvsbspace01" created. [root@gbase8 ~]# lvcreate -n lvdatachk01 -L 1050M vgdata Rounding up size to full physical extent <1.03 GiB Logical volume "lvdatachk01" created. [root@gbase8 ~]# cd /dev/vgdata/ [root@gbase8 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 [root@gbase8 vgdata]# chown gbasedbt:gbasedbt lv* [root@gbase8 vgdata]# chmod 0660 lv* [root@gbase8 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? [root@gbase8 gbase]# ln -s /dev/vgdata/lvrootchk rootchk [root@gbase8 gbase]# ln -s /dev/vgdata/lvplogchk plogchk [root@gbase8 gbase]# ln -s /dev/vgdata/lvllogchk llogchk [root@gbase8 gbase]# ln -s /dev/vgdata/lvtempchk01 tempchk01 [root@gbase8 gbase]# ln -s /dev/vgdata/lvsbspace01 sbspace01 [root@gbase8 gbase]# ln -s /dev/vgdata/lvdatachk01 datachk01 [root@gbase8 gbase]# chown gbasedbt:gbasedbt * [root@gbase8 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_ACCEPTED=TRUE -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 DB
su - 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,num=2,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.surrogates
mkdir -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.log，4 个 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[root@gbase8 gbase]# su - gbasedbt Last login: Tue Jul 9 12:17:26 CST 2024 on pts/0 [gbasedbt@gbase8 ~]$ 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. [gbasedbt@gbase8 ~]$ 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. [gbasedbt@gbase8 ~]$ 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. [gbasedbt@gbase8 ~]$ 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. [gbasedbt@gbase8 ~]$ 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. [gbasedbt@gbase8 ~]$ 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[gbasedbt@gbase8 ~]$ 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 Administrator's manual) [gbasedbt@gbase8 ~]$ 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[gbasedbt@gbase8 ~]$ for ((i=0;i<6;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. [gbasedbt@gbase8 ~]$ 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[gbasedbt@gbase8 ~]$ 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 [gbasedbt@gbase8 sysadmin]$ touch stop [gbasedbt@gbase8 sysadmin]$ onmode -ky Your evaluation license will expire on 2025-07-05 00:00:00 [gbasedbt@gbase8 sysadmin]$ onstat Your evaluation license will expire on 2025-07-05 00:00:00 shared memory not initialized for GBASEDBTSERVER 'gbase8' [gbasedbt@gbase8 sysadmin]$ oninit -vy [gbasedbt@gbase8 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