暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

启动和停止 Gbase 8s 数据库

原创 xTD 2023-11-08
146

启动和停止数据库(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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

文章被以下合辑收录

评论