TWiki>
Resc Web>TechnicalNotes>InformixSpatialEvaluation>UsefulInformixCommands (16 Jun 2004, JonBlower)EditAttach
Resc Web>TechnicalNotes>InformixSpatialEvaluation>UsefulInformixCommands (16 Jun 2004, JonBlower)EditAttachUseful 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 |
Edit | Attach | Print version | History: r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r1 - 16 Jun 2004 - 16:03:27 - JonBlower
ReSC Web
Welcome page
Search
Changes
Notifications
Statistics
Preferences
Users
Groups
ESSCSeminars |
|
Copyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors. Ideas, requests, problems regarding TWiki? Send feedback