GBase 8t / informix 实例自动初始化脚本
大家好
很多小伙伴反映 GBase 8t的初始化数据库实例太繁琐了,很难快速上手。针对初学者的需求,最近写了一个 GBase 8t / informix 实例自动初始化实例脚本,请大家测试使用。有问题可以反馈给我。
再也不用安装数据库时选择自动创建实例了。本脚本采用交互式工作方式,提供初始化实例时的常用选项,并根据主机CPU/内存配置自动给出默认值建议。数据空间为自动扩展模式。对于初学者来说,可以一路按回车键选择默认值完成数据库的初始化,并获得较好的性能。
脚本是短时间内完成的,健壮性还比较差,所以请大家多多测试。
脚本会使用默认字符集建立gbasedb的数据库,并给出JDBC连接方式。
下面是我全使用默认值建立实例的过程:
[informix@localhost tmp]$ sh GBaseInit.sh
Initializing Program...OK
ENTER THE INSTANCE INFORMATION or PRESS
ENTER GBASE INSTANCE NAME (INFORMIXSERVER) [Default:gbaseserver]:
GBASE INSTALL FOLDER LIST:
(1) /home/informix
(2) /home/gbase
CHOOSE GBASE INSTALL FOLDER (INFORMIXDIR) [Default:/home/informix]:
CHOOSE SERVICE IP ADDRESS FROM THE LIST:
(1) 192.168.2.66
(2) 127.0.0.1
ENTER THE NUMBER FOR YOUR CHOICE [Default:192.168.2.66]:
SPECIFY THE PORT NUMBER FOR GBASE [Default:9088]:
ENTER THE DATA SPACE PATH [Default:/home/informix/gbaseserver_dbs]:
ENTER THE LOGICAL LOG DBSPACE SIZE(MB) [Default:1024]:
ENTER THE PHYSICAL LOG DBSPACE SIZE(MB) [Default:1024]:
ENTER THE SMART LOB DBSPACE SIZE(MB) [Default:256]:
ENTER THE TEMPORARY DBSPACE SIZE(MB) [Default:256]:
ENTER THE NUMBER OF DATA DBSPACES [Default:1]:
Summary: Instance Name: gbaseserver
GBase Install Directory: /home/informix
IP Address: 192.168.2.66
Logical Log Space Size: 1024MB
Physical Log Space Size: 1024MB
Temp DBSpace Size: 256MB
Smart Lob Space Size: 256MB
Temp DBSpace Size: 256MB
The Number of Data DBSpace: 1
Enter "Y" to Start initializing database, or Enter "N" to Edit Again: y
Touching Chunks...OK
Create sqlhosts File: /home/informix/etc/sqlhosts.gbaseserver ...OK
Setting Parameters in /home/informix/etc/onconfig.gbaseserver :
ROOTPATH.ROOTPATH.DBSERVERNAME.SBSPACENAME.SYSSBSPACENAME.DBSPACETEMP.LOGFILES.MULTIPROCESSOR.VPCLASS.NETTYPE.CLEANERS.DEF_TABLE_LOCKMODE.DIRECT_IO.LOCKS.TAPEDEV.LTAPEDEV.DS_MAX_QUERIES.DS_TOTAL_MEMORY.DS_NONPDQ_QUERY_MEM.PHYSBUFF.LOGBUFF.AUTO_TUNE.SERVERNUM.AUTO_CKPTS.ALLOW_NEWLINE.TEMPTAB_NOLOG.DUMPSHMEM.USEOSTIME.STACKSIZE.ON_RECVRY_THREADS.OFF_RECVRY_THREADS.USELASTCOMMITTED.SHMVIRTSIZE.SHMADD.INFORMIXCONTIME.BUFFERPOOL2K.BUFFERPOOL16K...OK
Initializing Root DBSpace & Share Memory...OK
Creating system database........OK
Creating Logical Log Dbspace...OK
Creating Physical Log Dbspace...OKCreating Smart Lob Dbspace...OKCreating Temp Dbspace...OK
Creating Data Dbspaces.1...OK
Shutting down dbScheduler...OK
Moving Physical Log...OK
Adding 20 Logical Logs:Logical Log: 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20...OK
Setting Data Chunks Extendable...OK
Cleaning logical logs in rootdbs.........OK
Database restarting.......OK
Creating database: gbasedb...OK
GBase JDBC Driver: /home/informix/jdbc/lib/ifxjdbc.jar
Now you can use this URL to connect to gbasedb:
jdbc:informix-sqli://192.168.2.66:9088/gbasedb:INFORMIXSERVER=gbaseserver;
GBase Initializing Finished!
Initialize log file : ./InitGBaseDB_201602100143.log
Press
Killed (core dumped)[root@localhost tmp]#