启动和停止数据库(Gbase 8s)
1. 数据库状态
onstat -
2. 启动数据库
-
-v
Verbose mode: prints all initialization messages. -
-y
Respond yes to all prompts
启动数据库
oninit -vy
查看 oninit 帮助
oninit --
Usage: oninit { -[ijpsy] } |
{ -SDS=<alias> }
-i Initialize disk space and shared memory, leave in on-line mode.
-j Initialize shared memory, leave in administration mode.
-p Do not reclaim temporary tables.
-s Initialize shared memory, leave in quiescent mode.
-y Respond yes to all prompts
-SDS=<alias> Define SDS Primary server alias.
-S Start database server in standard mode; disables HDR.
-D Prevent both ER and HDR from initializing.
-U Specifies a list of users who can access IDS in administration mode.
-v Verbose mode: prints all initialization messages.
-w Wait until server is initialized successfully.
-t Test startup: adjust configuration, print all parameters, and exit.
3. 停止数据库
-
-k
Shutdown completely -
-y
Do not require confirmation
停止数据库
onmode -k
等待用户未提交的事务提交后,再关闭数据库
onmode -s
onmode -k
用户未提交的事务回滚衙,再关闭数据库
onmode -u
onmode -k
查看 onmode 帮助
$ onmode
Your evaluation license will expire on 2024-10-18 00:00:00
usage: onmode [-abBCCcDdFIjklMmnOPpQRrSsuWYyZz] |
[-wf <onconfig parameter>=<value>] |
[-wm <onconfig parameter>=<value>]
-a <kbytes> Increase shared memory segment size.
-b <version> Revert Database Server disk structures.
-BC [1|2] Change server large chunk mode
-c [block | unblock] Do Checkpoint. Block or unblock server.
-C {start <count>|stop <count>|threshold <size>|
duration <seconds>|rangesize <size>|alice <mode>|
compression <low|med|high|default>} Tune B-tree scanner.
-D <max PDQ priority allowed>
-d {standard|{primary|secondary <servername>}} set DR server type
DR secondary only:
{idxauto {on|off}} set DR automatic index repair mode
{index <database>:[owner.]<tablename>#<indexname>} DR repair index
{add RSS <servername> <optional password>} add RSS server
{change RSS <servername> <password>} change RSS server password
{delete RSS <servername>} remove RSS server definition
{RSS <source Node> <optional password>} set RSS server type
{set SDS primary <alias> [force]} define SDS primary server alias
{clear SDS primary <alias> [force]} remove SDS primary server alias
{make primary <alias> [force]} make server into the MACH11 primary
-e {on|off|enable|flush} configure or flush shared statement cache.
-F Free unused memory segments
-I stop verbose error trapping
-I <iserrno> [<session ID>] trap specified error for session ID
-j Change to administration mode
-k Shutdown completely
-l Force to next logical log
-M <decision support memory in kbytes>
-m Go to multi-user on-line
-n Set shared memory buffer cache to non-resident
-O Override space down blocking a checkpoint
-P [start|stop|restart] <servername> dynamic listen thread control
-p <+-#> <class> Start up or remove virtual processors of
a specific class
-Q <max # decision support queries>
-R Rebuild the /GBASEDBTDIR/etc/.infos.DBSERVERNAME file
-r Set shared memory buffer cache to resident
-S <max # decision support scans>
-s Change to quiescent mode
-u Change to quiescent mode and kill all attached sessions
-W {STMT_CACHE_NOLIMIT {0|1} | STMT_CACHE_HITS <#>} Sets ssc
parameters.
-wf <onconfig parameter>=<value> Update the value
of the specified configuration parameter and save
the new value to the onconfig file.
-wm <onconfig parameter>=<value> Update the value of
the specified configuration parameter without saving
the new value to the onconfig file. The new value is
written to server memory only and will not be retained
once the server is restarted.
-wi <full path> Import tunable configuration parameters
from the specified file.
-we <full path> Export all configuration parameters to
the specified file.
-y Do not require confirmation
-Y <sid> <0|1|2> [filename] Set or unset dynamic explain
0=off 1=plan + statistics on 2=only plan on
filename is a valid argument only when setting the
dynamic explain or dynamic explain statistics on
-Z <address> heuristically complete specified transaction
-z <sid> Kill specified session id
-cache surrogates Reload entries from the surrogates file /etc/gbasedbt/allowed.surrogates into
the surrogate cache
最后修改时间:2023-11-08 08:59:20
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




