NAME¶

db - Supportconfig Analysis Database Tool

SYNOPSIS¶

db [OPTIONS]

DESCRIPTION¶

The db command is used for database maintenance. It is run as the scdiag user, but can be run as root too.

OPTIONS¶

help

Show this help screen.

check

Checks, optimizes and repairs tables

empty

Truncates Archives and Results, resets Agents and AgentWorkers

backup

Creates a mysqldump file of the ServerDiagnostics database

cmd query

Supports a custom query

import file

Imports the file a MySQL file

old integer

Deletes old archives greater than integer days old

del integer

Deletes archive with integer ArchiveID

reset agents

Activates all agents and clears the agent threads

report int

Creates an HTML report file for Archive ID int.

pending [integer]

Shows pending archives with optional integer row limit

active [integer]

Shows active archives with optional integer row limit

done [integer]

Shows completed archives with optional integer row limit

error [integer]

Shows errored archives with optional integer row limit

archive reset integer

Resets an archive to be analyzed again. The archive's results are deleted and the archive is set to a New state.

archive ignore integer

Sets the archive state to error with Archive ID integer. The worker threads are cleaned up.

archive done integer

Sets the archive state to done with Archive ID integer.

workers add integer on agent_id

Increases the number of agent threads by integer amount on the agent with ID agent_id.

workers del integer on agent_id

Decreases the number of agent threads by integer amount on the agent with ID agent_id.

AUTHOR¶

Jason Record <jrecord@suse.com>

COPYRIGHT¶

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, see <http://www.gnu.org/licenses/>.

SEE ALSO¶

sdbroker(8)