JBoss

JMX MBean View
Back to Agent View Refresh MBean View

MBean description:

Query based FileCopy Service.
Provides automatic trigger of FileCopy service that fulfills criteria defined by an SQL Query.

The SQL statement must be defined with following rules:

1) Series.pk must be the first column of the select statement.
2) The where clause should contain a Series.updated_time.

List of MBean attributes:

Name Type Access Value Description
PollInterval java.lang.String RW Interval for polling for series to trigger FileCopy. The interval can be specified in seconds (##s) or minutes (##m). NEVER = disable this FileCopyByQuery service.
Query java.lang.String RW SQL statement to filter series for FileCopy.

Default Query to find series that are stored (series_status=0) and has no copy in NEARLINE filesystem (pk=2):
SELECT DISTINCT series.pk FROM series, instance, files WHERE series.series_status = 0 AND series.pk = instance.series_fk AND instance.pk = files.instance_fk AND series.updated_time < ? AND NOT EXISTS (SELECT pk FROM files WHERE files.instance_fk=instance.pk AND files.filesystem_fk=2)
Note: The first column in the SELECT statement must be: series.pk!
If limit > 0 the SQL statement is extended with:
1) a database specific LIMIT
2) a 'series.pk > ?' as first criteria in WHERE clause (if sql hasn't already a 'pk > ?')
3) an 'ORDER BY series.pk' (if sql hasn't already a 'ORDER BY')
LastQueryCheckResult java.lang.String R NOT CHECKED Result of last check of Query statement.
If there is an error no automatic forward will be perfromed until the Query is corrected.
Delay java.lang.String RW Delay in seconds (##s), minutes (##m) or hours (##h) for which a series must be unchanged before forward is triggered. Use NONE to disable parameter setting of Prepared Statement! (This would be necessary if your SQL statement doesn't contain a '?')
Limit int RW Limit number of series for forwarding in one step.
This will add database specfic limit statements to the Query! Set this to 0 if the query already contains a limitation.
FetchSize int RW JDBC Fetch size. (-1 means: use Limit)
isRunning boolean R False Current state if a FileCopy task is running. Used to avoid concurrency!
LastSeriesPk long R 0 Last used Series.pk. Used as additional query parameter (SERIES.pk > lastPk) if a Limit > 0 is specified!
TimerIDFilecopyByQuery java.lang.String RW Used internally. Do NOT modify.
FilecopyServiceName javax.management.ObjectName RW View MBean Used internally. Do NOT modify.
SchedulerServiceName javax.management.ObjectName RW View MBean Used internally. Do NOT modify.
Name java.lang.String R FileCopyByQueryService The class name of the MBean
State int R 3 The status of the MBean
StateString java.lang.String R Started The status of the MBean in text form

List of MBean operations:

void create()

Standard MBean lifecycle method

void start()

The start lifecycle operation

void stop()

The stop lifecycle operation

void destroy()

The destroy lifecycle operation

void jbossInternalLifecycle()

The detyped lifecycle operation (for internal use only)

Param ParamType ParamValue ParamDescription
method java.lang.String The lifecycle operation

int checkFilecopy()

Check for series and schedule FileCopy requests for these.
Return number of FileCopyOrders that are scheduled.

java.lang.String showSQL()

Show actual SQL statement as it will be used to find series.