FTS diagnosis scripts

This page contains diagnosis scripts for the FTS.

DB schema information script

This script runs on the database schema and collects what schema is running, which of the optional (some not yet released) maintenance packages are installed and some aggregate table counts. It is intended to determine what exactly is installed in the FTS database schema. If you use writer accounts, please run this using the schema owner account.

• db-summary.tar.gz: DB summary script

tar xvfz db-summary.tar.gz

cd db-summary

sqlplus -S username/password@"CONNECTSTRING" @run-summary.sql > dbsummary.log

The part of the script collecting the statistics runs a few full table scans and may take a long time to run and create high load on the DB, depending on how many files you have in the DB. Consequently, you should only run this script if requested.

Please mail the results to fts-support@cern.ch.

Last edit: SteveTraylen on 2007-03-23 - 09:53

Maintainer: GavinMcCance