Command Usage: samadmin v8_1_5 samadmin remove meaningless dimensions
|  |
Command Description:
As SAM was migrated to experiments other than D0, the D0 database
was used as the "starting point" for populating the initial SAM
database of these experiments. In some cases, this resulted in
d0-specific data being incorporated into a non-d0 experiments'
data.
In particular, databases created before Spring 2005 contain
valid dimension names from the D0 database, which
includes two classes of dimensions that are not valid for
other experiments:
a) parameter-specific dimensions valid for the d0-specific
registered parameterCategories and parameterTypes,
but not valid for other experiments' parameters.
example: ROOT-TUPLE.D0RELEASE
b) dimensions related to ONLINE_RUN data, which is stored
in sam-related tables for D0, but not for other
experiments.
example: SOLENOID_POLARITY
This command will cleanup the list of valid dimensions
so that:
a) dimensions that reference non-existent tables
are removed (such as the d0-specific dimensions that
reference ONLINE_RUN-related tables)
b) dimensions that reference non-existent paramCategories
and/or paramTypes will be removed.
It should need to be run at most once per db. It does not
hurt to run it again, but... well, it won't do much except
waste time.
This command requires sam_idl_pylib v6_8_0_0+ on the local client,
and will only work against a sam_db_srv running a v6_8+ sam_dimension_server_prototype.
Usage:
samadmin remove meaningless dimensions [--options] [-flags]
Where:
--options:
--connect=<value> # oracle username/password for connecting to this database
--corbaCallTimeout=<value> # time in seconds for CORBA method calls to return before timing out (default: 0; zero implies no timeout)
--retryInterval=<value> # retry interval base in seconds; will multiply this base times retryCount (default: 5)
--retryJitter=<value> # retry jitter, random jitter added to base retry interval times retryCount (default: 5)
--retryMaxCount=<value> # number of times to retry CORBA calls for retriable exceptions (default: 25; zero implies no retries)
-flags:
-c # automatically close all servants after each method call
-d # debug mode
-s # retrySilently mode (do not issue messages to stderr on proxy retries)
-t # time-it mode (print additional info on timings)
-v # verbose mode
Required Data Types:
connect : string
corbaCallTimeout : int
retryInterval : int
retryJitter : int
retryMaxCount : int
You may omit "-c" if the $SAM_PYAPI_AUTO_CLOSE_SERVANTS environmental variable is set.
You may omit "--connect=<value>" if the $SAM_ORACLE_CONNECT environmental variable is set.
You may omit "--corbaCallTimeout=<value>" if the $SAM_PYAPI_CORBA_CALL_TIMEOUT environmental variable is set.
You may omit "--retryInterval=<value>" if the $SAM_PYAPI_RETRY_INTERVAL environmental variable is set.
You may omit "--retryJitter=<value>" if the $SAM_PYAPI_RETRY_JITTER environmental variable is set.
You may omit "--retryMaxCount=<value>" if the $SAM_PYAPI_RETRY_MAX_COUNT environmental variable is set.
You may omit "-s" if the $SAM_PYAPI_RETRY_SILENTLY environmental variable is set.
UNIX ExitStatus:
Success : 0
Unhandled exceptions : 127
See Also: