HP R4.2 att, cron, cron, dbcheck, dbcheck, explain, dbcheck, root cron, /vs/bin/util/croncdh, Monitoring the Database, 5 Database Administration

5 Database Administration Monitoring the Database

The dbcheck	The dbcheck command checks space usage and rollback segment growth.
Command
	dbcheck Command Options
	The dbcheck command has three different options:
	• -iinstalls 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 -ioption 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.
	• -rremoves any cron entry set up by the -ioption
	• [-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.

UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 248