Filter
Top Products
5 Database Administration Monitoring the Database
UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 248
The dbcheck
Command
The dbcheck command checks space usage and rollback segment growth.
dbcheck Command Options
The dbcheck command has three different options:
• -i installs cron entries and error messages. The cron job can be placed in
either the root cron file or added to the end of /vs/bin/util/croncdh job
that runs once a day. The -i option also asks if you want new error
messages added to the att errors file along with explanations used with
the explain command. This installation only needs to be run if you want
the warnings to show up in the system message log or you want to
schedule automatic checking at regular intervals.
• -r removes any cron entry set up by the -i option
• [-w n[,m]][-s][-e][-m user[~user...]] checks database space against
user-set thresholds. The following occurs:
~ Free space is checked against the user set threshold n, 15% default
~ Rollback segment growth is checked against the user set threshold m,
20% default
When executed, the dbcheck command generates the appropriate
warnings (see below) if the database falls below n percent free or if the
rollback segments grow to be more than m percent of the total database
size.