当前位置：首页 >

使用GBase 8s数据库

发布时间：2024/3/26 54 豆豆

生活随笔收集整理的这篇文章主要介绍了使用GBase 8s数据库小编觉得挺不错的,现在分享给大家,帮大家做个参考.

1.1 启动/停止数据库服务

通常情况下，使用 gbasedbt 用户来启动和停止数据库服务。

成功安装数据库 GBase 8s 后，数据库会自动处于启动状态，可通过以下命令检查服务进程是否存在：

[root@localhost opt]# ps -ef|grep oninit

gbasedbt 10830 1 0 19:52 ? 00:00:04 /opt/GBASE/gbase/bin/oninit -vy

root 10831 10830 0 19:52 ? 00:00:00 /opt/GBASE/gbase/bin/oninit -vy

root 10832 10831 0 19:52 ? 00:00:00 /opt/GBASE/gbase/bin/oninit -vy

root 10833 10831 0 19:52 ? 00:00:00 /opt/GBASE/gbase/bin/oninit -vy

root 10834 10831 0 19:52 ? 00:00:00 /opt/GBASE/gbase/bin/oninit -vy

root 10835 10831 0 19:52 ? 00:00:00 /opt/GBASE/gbase/bin/oninit -vy

root 10836 10831 0 19:52 ? 00:00:00 /opt/GBASE/gbase/bin/oninit -vy

root 10837 10831 0 19:52 ? 00:00:00 /opt/GBASE/gbase/bin/oninit -vy

root 10915 10831 0 19:52 ? 00:00:00 /opt/GBASE/gbase/bin/oninit -vy

root 11997 5051 0 20:02 pts/0 00:00:00 grep oninit

以 gbasedbt 用户身份登录后，输入 onmode –ky，可停止数据库服务，示例如下：

[gbasedbt@localhost ~]$ onmode -ky

输入 oninit –vy,启动数据库服务，示例如下：

[gbasedbt@localhost ~]$ oninit -vy

Warning: Parameter's user-configured value was adjusted. (DS_MAX_SCANS)

Warning: Parameter's user-configured value was adjusted. (ONLIDX_MAXMEM)

Reading configuration file '/opt/GBASE/gbase/etc/onconfig.ol_gbasedbt1210'...succeeded

Creating /GBASEDBTTMP/.infxdirs...succeeded

Allocating and attaching to shared memory...succeeded

Creating resident pool 8310 kbytes...succeeded

Creating infos file "/opt/GBASE/gbase/etc/.infos.ol_gbasedbt1210"...succeeded

Linking conf file "/opt/GBASE/gbase/etc/.conf.ol_gbasedbt1210"...succeeded

Initializing rhead structure...rhlock_t 16384 (512K)... rlock_t (5312K)... 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 2 flushers...succeeded

Initializing SDS Server network connections...succeeded

Initializing log/checkpoint information...succeeded

Initializing dbspaces...succeeded

Opening primary chunks...succeeded

Validating chunks...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

Starting scheduling system...succeeded

Verbose output complete: mode = 5

输入 ps -ef|grep oninit 检查数据库服务进程是否存在：

[gbasedbt@localhost ~]$ ps -ef|grep oninit

gbasedbt 12056 1 0 20:14 ? 00:00:00 oninit -vy

root 12057 12056 0 20:14 ? 00:00:00 oninit -vy

root 12058 12057 0 20:14 ? 00:00:00 oninit -vy

root 12059 12057 0 20:14 ? 00:00:00 oninit -vy

root 12060 12057 0 20:14 ? 00:00:00 oninit -vy

root 12061 12057 0 20:14 ? 00:00:00 oninit -vy

root 12062 12057 0 20:14 ? 00:00:00 oninit -vy

root 12063 12057 0 20:14 ? 00:00:00 oninit -vy

root 12064 12057 0 20:14 ? 00:00:00 oninit -vy

gbasedbt 12134 12116 0 20:25 pts/0 00:00:00 grep oninit

1.2 登录数据库

以 gbasedbt 用户身份登录，输入 dbaccess - - 命令进入数据库命令行模式，示例如下：

[gbasedbt@localhost ~]$ dbaccess – -

1.3 创建数据库

在 dbaccess 交互命令行中，执行如下SQL语句，创建数据库，示例如下：

[gbasedbt@localhost~]$ dbaccess - -

> create database gbase8s;

Database created.

总结

以上是生活随笔为你收集整理的使用GBase 8s数据库的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。