Cheatography
https://cheatography.com
A list of options for the OpenEdge proutil command
This is a draft cheat sheet. It is a work in progress and is not finished yet.
Common Options of Proutil
bigrow |
Format a specified number of BI Clusters in one operation. Example: proutil dbname –C bigrow <# of clusters desired minus 4> |
busy |
Determines if a database is in use by another OpenEdge process. |
Conv1011/conv1112 |
Convert a version 10 database to version 11, or version 11 to version 12. |
dbanalys |
Do a complete analysis of database population and fragmentation for data and indexes. This option is covered in detail in the Performance Tuning chapter. An optional Area name can be specified. Example: proutil dbname –C dbanalys <area name> |
dbipcs |
Display shared memory information for all database Brokers on a Unix system. Not supported on Windows. Example: proutil –C dbipcs |
|
|
cont...
holder |
Determine the mode of operation for a database |
idxbuild |
Rebuild and activate one or more indexes. Offline only. |
idxcheck |
Report index corruption |
idxfix |
Rebuild one or more indexes, or keys. Can be run online or offline. Checks that all keys point to records and that all records have the proper keys |
increaseto |
Increase selected Broker startup parameters (-B, -L, -aibufs, -bibufs, -Mxs) online (new options appearing in new releases). There is no “reduceto” option. |
disablesitereplication |
Disable OpenEdge Replication |
dump/ dumpspecified |
Binary data dump |
enablelargefiles |
Allow database files to exceed the 2gb limit (default in v12) |
enablesitereplication |
Enable OpenEdge Replication |
|
|
cont...
indexmove / idxmove |
Move an index from one Area to another |
iostats |
Report miscellaneous I/O statistics for a database |
load |
Binary data load. |
mvschema |
Separate data from the schema into separate Storage Areas |
tabanalys |
Displays space and fragmentation information for all tables in a database. A subset of the dbanalys option. An optional Area name can be specified |
tablemove |
Move a table from one Area to another |
truncate bi |
Go through crash recovery and then truncate all BI Clusters. Optionally set the BI Cluster size with the –bi option (in 1k units). Optionally set the BI Block size with the –biblocksize option (in 1k units). Example: proutil db –C truncate bi [–bi <cluster size> -biblocksize <block size>] |
updateschema / updatevst |
Update the Metaschema or VST schema for new versions of OpenEdge |
|
