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.

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

Number of topics: 1

Maintainer: GavinMcCance

Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatgz db-summary.tar.gz r1 manage 2.1 K 2007-01-16 - 10:31 GavinMcCance DB summary script
Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r2 - 2007-03-23 - SteveTraylen
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LCG All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback