Useful commands

onstat - Gives the status of the databases
onstat -m Prints the last few messages and the location of the message log: good for diagnostics
onstat -d Prints the size of the db spaces
dbaccess text-based interface to the database
dbaccess - - Run database commands from the command line
dbaccess <name of db> <script> Runs the SQL file <script> against the given database
dbaccess - <script> Runs the given SQL file (good for creating databases)
dbschema -d <name of db> Prints out the schema for the given database (doesn't print out data)
dbexport <name of db> Exports the given database to a directory called <name of db>
finderr <errnum> Describes the error with the given number
   
onmode -ky Shuts down the database
oninit Starts up the database

-- JonBlower - 16 Jun 2004

Topic revision: r1 - 16 Jun 2004 - 16:03:27 - JonBlower
 
Copyright © 2008-2014 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback

escort ankara escort beylikduzu escort istanbul escort eskisehir escort bursa