Server administration (from the command-line)

HCL OneDB includes utilities and applications that you can use to perform administrative tasks and capture information about configuration and performance.

onstat : Use this command to take snapshots of different conditions on your database server,

  • Monitor users (onstat -u),
  • transactions (onstat -x),
  • Locks (onstat -k),
  • Lgical logs (onstat -l),
  • Dbspaces & chunks (onstat -d),
  • View configuration (onstat -c) and many more.

onmode: Use this command to take different actions over the database server like:

  • Shutdown the server (onmode -ky),
  • Create a checkpoint (onmode -c),
  • Advance to next logical log (onmode -l),
  • Dynamically change some configuration parameters (onmode -wm|wf) ,
  • Put server in administration mode (onmode -j),
  • Block/unblock the server (onmode -c block|unblock),
  • Start up or remove virtual processors of a specific class (onmode -p +# class),
  • Dynamic listen thread control (onmode -P [start|stop|restart] <servername>),
  • Kill a specific session (onmode -z <sesid>) and many more.

onspaces: Use this command to manage storage spaces. HCL OneDB stores data in disks chunks that belongs to DBspaces, BLOBspaces, SBLOBspaces, temporary DBspaces. Use this command to:

  • Add a chunk to DBspace / BLOBspace / SBLOBspace (onspaces -a <spacename>…..),
  • Create DBspace / BLOBspace / SBLOBspace / PLOGspace (onspaces -c -d <spacename>….),
  • Drop an empty chunk / DBspace / BLOBspace / SBLOBspace (onspaces -d <spacename>…) and many more.

onparams: Use this command to manage logical logs , physical log and buffer pools. You can:

  • Add a logical log (onparams -a -d <dbspace>…),
  • Add a buffer pool (onparams -b -g size …),
  • Move the physical log to a different location / size (onparams -p -s <size> -d <dbspace>…) and many more.

oncheck: Use this command to check specific disk structures for inconsistencies, repair inconsistent index structures, and display information about disk structures. You can check:

  • Reserved pages (oncheck -pr / cr),
  • System catalogs (oncheck -pc / cc),
  • Chunk free list (oncheck -pe / ce),
  • Data pages (oncheck -cd / cD),
  • Index pages (oncheck -ci / cI) and many more.

onaudit: Use this command to configure auditing on the database server.

dbschema: Use this command to create a file with SQL commands to create table(s) / view(s) / database.

dbexport / dbimport: Use these commands unload / load a database from text files with included dbschema

dbaccess: Use this command to get a a user interface for entering, running, and debugging Structured Query Language (SQL) statements and Stored Procedure Language (SPL) routines.

finderr: Use this command to look up a specific error code and display the corresponding error text.