.

This device server is certified as a reference implementation.

Development status: Released
Information status: New
Repository: https://github.com/tango-controls/TangoDatabase
Contact:



Class Description


This class manage the TANGO database.

Family: System

Key words:

Platform: All Platforms

Language: Cpp

License:

Contact:

Hardware


Manufacturer: none

Bus: Not Applicable

Class interface


Attributes:

Name Description
Timing_infoSpectrum: DevString
Timing_indexSpectrum: DevString
Timing_callsSpectrum: DevDouble
Timing_maximumSpectrum: DevDouble
Timing_minimumSpectrum: DevDouble
Timing_averageSpectrum: DevDouble
StoredProcedureReleaseScalar: DevString

Commands:

Name Description
DbGetForwardedAttributeListForDeviceInput: DevString
The specified device name
Output: DevVarStringArray
argout[n] : device name argout[n+1] :the forwardef attribute argout[n+2] :the root attribute (__root_att)
Get the list of devices using forwarded attribute(s) from specified device
DbGetDevicePipePropertyHistInput: DevVarStringArray
Str[0] = Device name Str[1] = Pipe name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Pipe name Str[1] = Property name Str[2] = date Str[3] = Property value number (array case) Str[4] = Property value 1 Str[n] = Property value n
Retrieve device pipe property history
DbGetClassPipePropertyHistInput: DevVarStringArray
Str[0] = Tango class Str[1] = Pipe name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Pipe name Str[1] = Property name Str[2] = date Str[3] = Property value number (array case) Str[4] = Property value 1 Str[n] = Property value n
Retrieve Tango class pipe property history
DbPutDevicePipePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Pipe number Str[2] = Pipe name Str[3] = Property number Str[4] = Property name Str[5] = Property value number (array case) Str[6] = Property value 1 Str[n] = Property value n (array case)
Output: DevVoid
Create/Update device pipe property(ies) in database
DbPutClassPipePropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Pipe number Str[2] = Pipe name Str[3] = Property number Str[4] = Property name Str[5] = Property value number (array case) Str[5] = Property value 1 Str[n] = Property value n (array case)
Output: DevVoid
Create/Update class pipe property(ies) in database
DbDeleteAllDevicePipePropertyInput: DevVarStringArray
str[0] = device name Str[1]...str[n] = pipe name(s)
Output: DevVoid
Delete all pipe properties for the specified device pipe(s)
DbGetDevicePipeListInput: DevVarStringArray
Str[0] = Device name Str[1] = Wildcard
Output: DevVarStringArray
Pipe name list
Return list of pipes matching the wildcard for the specified device
DbGetClassPipeListInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Pipe name filter (eg: pip*)
Output: DevVarStringArray
Str[0] = Class pipe name Str[n] = Class pipe name
Get pipe list for a given Tango class with a specified filter
DbDeleteDevicePipePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Pipe name Str[2] = Property name Str[n] = Property name
Output: DevVoid
Delete device pipe properties from database
DbDeleteClassPipePropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Pipe name Str[2] = Property name Str[n] = Property name
Output: DevVoid
Delete class pipe properties from database
DbDeleteDevicePipeInput: DevVarStringArray
Str[0] = Device name Str[1] = Pipe name
Output: DevVoid
Delete device pipe properties from database
DbDeleteClassPipeInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Pipe name
Output: DevVoid
Delete a class pipe and all its properties from database
DbGetDevicePipePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Pipe name Str[n] = Pipe name
Output: DevVarStringArray
Str[0] = Device name Str[1] = Pipe property number Str[2] = Pipe property 1 name Str[3] = Pipe property 1 value number (array case) Str[4] = Pipe property 1 value Str[n] = Pipe property 1 value (array case) Str[n + 1] = Pipe property 2 name Str[n + 2] = Pipe property 2 value number (array case) Str[n + 3] = Pipe property 2 value Str[n + m] = Pipe property 2 value (array case)
Retrieve device pipe properties
DbGetClassPipePropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Pipe name Str[n] = Pipe name
Output: DevVarStringArray
Str[0] = Tango class name Str[1] = Pipe property number Str[2] = Pipe property 1 name Str[3] = Pipe property 1 value number (array case) Str[4] = Pipe property 1 value Str[n] = Pipe property 1 value (array case) Str[n + 1] = Pipe property 2 name Str[n + 2] = Pipe property 2 value number (array case) Str[n + 3] = Pipe property 2 value Str[n + m] = Pipe property 2 value (array case)
Retrieve class pipe properties
DbRenameServerInput: DevVarStringArray
s[0] = old device server name (exec/instance) s[1] = new device server name (exec/instance)
Output: DevVoid
Rename a device server process
DbGetAliasAttributeInput: DevString
The attribute alias
Output: DevString
The attribute name (dev_name/att_name)
Get the attribute name from the given alias. If the given alias is not found in database, returns an empty string
DbGetAttributeAlias2Input: DevString
The attribute name (dev_name/att_name)
Output: DevString
The attribute alias name (or empty string)
Get the attribute alias from the attribute name. Returns one empty string if nothing found in database
DbGetCSDbServerListInput: DevVoid
Output: DevVarStringArray
List of host:port with one element for each database server
Get a list of host:port for all database server defined in the control system
DbMySqlSelectInput: DevString
MySql Select command
Output: DevVarLongStringArray
MySql Select command result - svalues : select results - lvalue[n] : =0 if svalue[n] is null else =1 (last lvalue -1) is number of rows, (last lvalue) is number of fields
This is a very low level command. It executes the specified SELECT command on TANGO database and returns its result without filter.
DbDeleteAllDeviceAttributePropertyInput: DevVarStringArray
str[0] = device name Str[1]...str[n] = attribute name(s)
Output: DevVoid
Delete all attribute properties for the specified device attribute(s)
DbGetDataForServerCacheInput: DevVarStringArray
Elt[0] = DS name (exec_name/inst_name), Elt[1] = Host name
Output: DevVarStringArray
All the data needed by the device server during its startup sequence. Precise list depend on the device server
This command returns all the data needed by a device server process during its startup sequence. The aim of this command is to minimize database access during device server startup sequence.
ResetTimingValuesInput: DevVoid
Output: DevVoid
Reset the timing attribute values.
DbUnExportServerInput: DevString
Device server name (executable/instance)
Output: DevVoid
Mark all devices belonging to a specified device server process as non exported
DbUnExportEventInput: DevString
name of event channel or factory to unexport
Output: DevVoid
Mark one event channel as non exported in database
DbUnExportDeviceInput: DevString
Device name
Output: DevVoid
Mark a device as non exported in database
DbPutServerInfoInput: DevVarStringArray
server info
Output: DevVoid
Update server info including host, mode and level
DbPutPropertyInput: DevVarStringArray
Str[0] = Object name Str[1] = Property number Str[2] = Property name Str[3] = Property value number Str[4] = Property value 1 Str[n] = Property value n ....
Output: DevVoid
Create / Update free object property(ies)
DbPutDevicePropertyInput: DevVarStringArray
Str[0] = Tango device name Str[1] = Property number Str[2] = Property name Str[3] = Property value number Str[4] = Property value 1 Str[n] = Property value n ....
Output: DevVoid
Create / Update device property(ies)
DbPutDeviceAttributeProperty2Input: DevVarStringArray
Str[0] = Device name Str[1] = Attribute number Str[2] = Attribute name Str[3] = Property number Str[4] = Property name Str[5] = Property value number (array case) Str[5] = Property value 1 Str[n] = Property value n (array case) .....
Output: DevVoid
Put device attribute property. This command adds the possibility to have attribute property which are arrays. Not possible with the old DbPutDeviceAttributeProperty command. This old command is not deleted for compatibility reasons.
DbPutDeviceAttributePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Attribute number Str[2] = Attribute name Str[3] = Property number Str[4] = Property name Str[5] = Property value .....
Output: DevVoid
Create/Update device attribute property(ies) in database
DbPutDeviceAliasInput: DevVarStringArray
Str[0] = device name Str[1] = alias name
Output: DevVoid
Define alias for a given device name
DbPutClassPropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Property number Str[2] = Property name Str[3] = Property value number Str[4] = Property value 1 Str[n] = Property value n ....
Output: DevVoid
Create / Update class property(ies)
DbPutClassAttributeProperty2Input: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute number Str[2] = Attribute name Str[3] = Property number Str[4] = Property name Str[5] = Property value number (array case) Str[5] = Property value 1 Str[n] = Property value n (array case) .....
Output: DevVoid
This command adds support for array properties compared to the previous one called DbPutClassAttributeProperty. The old comman is still there for compatibility reason
DbPutClassAttributePropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute number Str[2] = Attribute name Str[3] = Property number Str[4] = Property name Str[5] = Property value .....
Output: DevVoid
Create/Update class attribute property(ies) in database
DbPutAttributeAliasInput: DevVarStringArray
Str[0] = attribute name Str[1] = attribute alias
Output: DevVoid
Define an alias for an attribute
DbInfoInput: DevVoid
Output: DevVarStringArray
Miscellaneous info like: - Device defined in database - Device marked as exported in database - Device server process defined in database - Device server process marked as exported in database - Device properties defined in database - Class properties defined in database - Device attribute properties defined in database - Class attribute properties defined in database - Object properties defined in database
Get miscellaneous numbers on information stored in database
DbImportEventInput: DevString
name of event channel or factory
Output: DevVarLongStringArray
export information e.g. IOR
Get event channel info from database
DbImportDeviceInput: DevString
Device name (or alias)
Output: DevVarLongStringArray
Str[0] = device name Str[1] = CORBA IOR Str[2] = device version Str[3] = device server process name Str[4] = host name Str[5] = Tango class name Lg[0] = Exported flag Lg[1] = Device server process PID
Import a device from the database
DbGetServerNameListInput: DevString
wildcard for server names.
Output: DevVarStringArray
server names found.
Returns the list of server names found for the wildcard specified. It returns only the server executable name without instance name as DbGetServerList.
DbGetServerListInput: DevString
The filter
Output: DevVarStringArray
Device server process name list
Get list of device server process defined in database with name matching the specified filter
DbGetServerInfoInput: DevString
server name
Output: DevVarStringArray
server info
Get info about host, mode and level for specified server
DbGetPropertyListInput: DevVarStringArray
Str[0] = Object name Str[1] = filter
Output: DevVarStringArray
Property name list
Get list of property defined for a free object and matching the specified filter
DbGetPropertyHistInput: DevVarStringArray
Str[0] = Object name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Property name Str[1] = date Str[2] = Property value number (array case) Str[3] = Property value 1 Str[n] = Property value n
Retrieve object property history
DbGetPropertyInput: DevVarStringArray
Str[0] = Object name Str[1] = Property name Str[n] = Property name
Output: DevVarStringArray
Str[0] = Object name Str[1] = Property number Str[2] = Property name Str[3] = Property value number (array case) Str[4] = Property value 1 Str[n] = Property value n (array case) Str[n + 1] = Property name Str[n + 2] = Property value number (array case) Str[n + 3] = Property value 1 Str[n + m] = Property value m
Get free object property
DbGetObjectListInput: DevString
The filter
Output: DevVarStringArray
Object name list
Get list of free object defined in database with name matching the specified filter
DbGetInstanceNameListInput: DevString
Server name
Output: DevVarStringArray
The instance names found for specified server.
Returns the instance names found for specified server.
DbGetHostServersInfoInput: DevString
Host name
Output: DevVarStringArray
Server info for all servers running on specified host
Get info about all servers running on specified host, name, mode and level
DbGetHostServerListInput: DevString
The filter
Output: DevVarStringArray
Device server process name list
Get list of device server process name running on host with name matching the specified filter
DbGetHostListInput: DevString
The filter
Output: DevVarStringArray
Host name list
Get host list with name matching the specified filter
DbGetExportdDeviceListForClassInput: DevString
Class name
Output: DevVarStringArray
Device exported list
Query the database for device exported for the specified class.
DbGetDeviceServerClassListInput: DevString
device server process name
Output: DevVarStringArray
list of classes for this device server
Get list of Tango classes for a device server
DbGetDevicePropertyListInput: DevVarStringArray
Str[0] = device name Str[1] = Filter
Output: DevVarStringArray
Property name list
Get property list belonging to the specified device and with name matching the specified filter
DbGetDevicePropertyHistInput: DevVarStringArray
Str[0] = Device name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Property name Str[1] = date Str[2] = Property value number (array case) Str[3] = Property value 1 Str[n] = Property value n
Retrieve device property history
DbGetDevicePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Property name Str[n] = Property name
Output: DevVarStringArray
Str[0] = Device name Str[1] = Property number Str[2] = Property name Str[3] = Property value number (array case) Str[4] = Property value 1 Str[n] = Property value n (array case) Str[n + 1] = Property name Str[n + 2] = Property value number (array case) Str[n + 3] = Property value 1 Str[n + m] = Property value m
DbGetDeviceMemberListInput: DevString
The filter
Output: DevVarStringArray
Device names member list
Get a list of device name members for device name matching the specified filter
DbGetDeviceWideListInput: DevString
filter
Output: DevVarStringArray
list of exported devices
Get a list of devices whose names satisfy the filter.
DbGetDeviceListInput: DevVarStringArray
argin[0] : server name argin[1] : class name
Output: DevVarStringArray
The list of devices for specified server and class.
Get a list of devices for specified server and class.
DbGetDeviceInfoInput: DevString
Device name
Output: DevVarLongStringArray
Str[0] = Device name Str[1] = CORBA IOR Str[2] = Device version Str[3] = Device Server name Str[4] = Device Server process host name Str[5] = Started date (or ? if not set) Str[6] = Stopped date (or ? if not set) Str[7] = Device class Lg[0] = Device exported flag Lg[1] = Device Server process PID (or -1 if not set)
Returns info from DbImportDevice and started/stopped dates.
DbGetDeviceFamilyListInput: DevString
The wildcard
Output: DevVarStringArray
Family list
Get a list of device name families for device name matching the specified wildcard
DbGetDeviceExportedListInput: DevString
filter
Output: DevVarStringArray
list of exported devices
Get a list of exported devices whose names satisfy the filter (wildcard is
DbGetDeviceDomainListInput: DevString
The wildcard
Output: DevVarStringArray
Device name domain list
Get list of device domain name matching the specified
DbGetDeviceClassListInput: DevString
Device server process name
Output: DevVarStringArray
Str[0] = Device name Str[1] = Tango class Str[n] = Device name Str[n + 1] = Tango class
Get Tango classes/device list embedded in a specific device server
DbGetDeviceAttributePropertyHistInput: DevVarStringArray
Str[0] = Device name Str[1] = Attribute name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Attribute name Str[1] = Property name Str[2] = date Str[3] = Property value number (array case) Str[4] = Property value 1 Str[n] = Property value n
Retrieve device attribute property history
DbGetDeviceAttributeProperty2Input: DevVarStringArray
Str[0] = Device name Str[1] = Attribute name Str[n] = Attribute name
Output: DevVarStringArray
Str[0] = Device name Str[1] = Attribute property number Str[2] = Attribute property 1 name Str[3] = Attribute property 1 value number (array case) Str[4] = Attribute property 1 value Str[n] = Attribute property 1 value (array case) Str[n + 1] = Attribute property 2 name Str[n + 2] = Attribute property 2 value number (array case) Str[n + 3] = Attribute property 2 value Str[n + m] = Attribute property 2 value (array case)
Retrieve device attribute properties. This command has the possibility to retrieve device attribute properties which are arrays. It is not possible with the old DbGetDeviceAttributeProperty command. Nevertheless, the old command has not been deleted for compatibility reason
DbGetDeviceAttributePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Attribute name Str[n] = Attribute name
Output: DevVarStringArray
Str[0] = Device name Str[1] = Attribute property number Str[2] = Attribute property 1 name Str[3] = Attribute property 1 value Str[n + 1] = Attribute property 2 name Str[n + 2] = Attribute property 2 value
Get device attribute property(ies) value
DbGetDeviceAttributeListInput: DevVarStringArray
Str[0] = Device name Str[1] = Wildcard
Output: DevVarStringArray
attribute name list
Return list of attributes matching the wildcard for the specified device
DbGetDeviceAliasListInput: DevString
The filter
Output: DevVarStringArray
Device alias list
Get device alias name with a specific filter
DbGetDeviceAliasInput: DevString
The device name
Output: DevString
The alias found
Return alias for device name if found.
DbGetClassPropertyListInput: DevString
The filter
Output: DevVarStringArray
Property name list
Get property list for a given Tango class with a specified filter
DbGetClassPropertyHistInput: DevVarStringArray
Str[0] = Tango class Str[1] = Property name
Output: DevVarStringArray
Str[0] = Property name Str[1] = date Str[2] = Property value number (array case) Str[3] = Property value 1 Str[n] = Property value n
Retrieve Tango class property history
DbGetClassPropertyInput: DevVarStringArray
Str[0] = Tango class Str[1] = Property name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Tango class Str[1] = Property number Str[2] = Property name Str[3] = Property value number (array case) Str[4] = Property value Str[n] = Propery value (array case) ....
DbGetClassListInput: DevString
Filter
Output: DevVarStringArray
Class list
Get Tango class list with a specified filter
DbGetClassInheritanceForDeviceInput: DevString
Device name
Output: DevVarStringArray
Classes off the specified device. [0] - is the class of the device. [1] - is the class from the device class is inherited. ........and so on
Get class inheritance for the specified device.
DbGetClassForDeviceInput: DevString
Device name
Output: DevString
Device Tango class
Get Tango class for the specified device.
DbGetClassAttributePropertyHistInput: DevVarStringArray
Str[0] = Tango class Str[1] = Attribute name Str[2] = Property name
Output: DevVarStringArray
Str[0] = Attribute name Str[1] = Property name Str[2] = date Str[3] = Property value number (array case) Str[4] = Property value 1 Str[n] = Property value n
Retrieve Tango class attribute property history
DbGetClassAttributeProperty2Input: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute name Str[n] = Attribute name
Output: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute property number Str[2] = Attribute property 1 name Str[3] = Attribute property 1 value number (array case) Str[4] = Attribute property 1 value Str[n] = Attribute property 1 value (array case) Str[n + 1] = Attribute property 2 name Str[n + 2] = Attribute property 2 value number (array case) Str[n + 3] = Attribute property 2 value Str[n + m] = Attribute property 2 value (array case)
This command supports array property compared to the old command called DbGetClassAttributeProperty. The old command has not been deleted from the server for compatibility reasons.
DbGetClassAttributePropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute name Str[n] = Attribute name
Output: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute property number Str[2] = Attribute property 1 name Str[3] = Attribute property 1 value Str[n + 1] = Attribute property 2 name Str[n + 2] = Attribute property 2 value
Get Tango class property(ies) value
DbGetClassAttributeListInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute name filter (eg: att*)
Output: DevVarStringArray
Str[0] = Class attribute name Str[n] = Class attribute name
Get attrilute list for a given Tango class with a specified filter
DbGetAttributeAliasListInput: DevString
attribute alias filter string (eg: att*)
Output: DevVarStringArray
attribute aliases
Get attribute alias list for a specified filter
DbGetAttributeAliasInput: DevString
The attribute alias name
Output: DevString
The attribute name (device/attribute)
Get the attribute name for the given alias. If alias not found in database, returns an empty string.
DbGetAliasDeviceInput: DevString
Alias name
Output: DevString
Device name
Get device name from its alias.
DbExportEventInput: DevVarStringArray
Str[0] = event channel name (or factory name) Str[1] = CORBA IOR Str[2] = Notifd host name Str[3] = Notifd pid Str[4] = Notifd version
Output: DevVoid
Export Event channel to database
DbExportDeviceInput: DevVarStringArray
Str[0] = Device name Str[1] = CORBA IOR Str[2] = Device server process host name Str[3] = Device server process PID or string ``null`` Str[4] = Device server process version
Output: DevVoid
Export a device to the database
DbDeleteServerInfoInput: DevString
Device server name
Output: DevVoid
delete info related to a Tango devvice server process
DbDeleteServerInput: DevString
Device server name
Output: DevVoid
Delete server from the database but dont delete device properties
DbDeletePropertyInput: DevVarStringArray
Str[0] = Object name Str[1] = Property name Str[n] = Property name
Output: DevVoid
Delete free property from database
DbDeleteDevicePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Property name Str[n] = Property name
Output: DevVoid
Delete device property(ies)
DbDeleteDeviceAttributePropertyInput: DevVarStringArray
Str[0] = Device name Str[1] = Attribute name Str[2] = Property name Str[n] = Property name
Output: DevVoid
delete a device attribute property from the database
DbDeleteDeviceAttributeInput: DevVarStringArray
Str[0] = Device name Str[1] = Attribute name
Output: DevVoid
Delete device attribute properties from database
DbDeleteDeviceAliasInput: DevString
device alias name
Output: DevVoid
Delete a device alias.
DbDeleteDeviceInput: DevString
device name
Output: DevVoid
Delete a device from database
DbDeleteClassPropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Property name Str[n] = Property name
Output: DevVoid
Delete class properties from database
DbDeleteClassAttributePropertyInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute name Str[2] = Property name Str[n] = Property name
Output: DevVoid
delete class attribute properties from database
DbDeleteClassAttributeInput: DevVarStringArray
Str[0] = Tango class name Str[1] = Attribute name
Output: DevVoid
delete a class attribute and all its properties from database
DbDeleteAttributeAliasInput: DevString
Attriibute alias name.
Output: DevVoid
Delete an attribute alias.
DbAddServerInput: DevVarStringArray
Str[0] = Full device server name Str[1] = Device(s) name Str[2] = Tango class name Str[n] = Device name Str[n + 1] = Tango class name
Output: DevVoid
Create a device server process entry in database
DbAddDeviceInput: DevVarStringArray
Str[0] = Full device server process name Str[1] = Device name Str[2] = Tango class name
Output: DevVoid
Add a Tango class device to a specific device server
StatusInput: DevVoid
Output: ConstDevString
Status description
This command gets the device status (stored in its <i>device_status</i> data member) and returns it to the caller.
StateInput: DevVoid
Output: State
State Code
This command gets the device state (stored in its <i>device_state</i> data member) and returns it to the caller.

Pipes:

Properties:

README

Tango Database server README
============================

This file contains information on installing/upgrading the Tango database
server. This guide assumes that a MySQL daemon runs on the machine you
want to install the database and that the DB server has history capabilities
(Release_2_9 or higher).
Note: You need jive 3.3 or higher to be able to access history.

------------------------------------------------------------------------
Starting from scratch
------------------------------------------------------------------------

#Launch the mysql client

mysql -u[user] -p[password]

#Create the tango scheme, add the declaration of the DB server and
#initialise history tables.

mysql>source tango_create.sql

# Set-up the environment variables MYSQL_USER and MYSQL_PASSWORD
# or prepare the my.cnf (mysql configuration file) file to specify
# the mysql user and its password to be used to connect to the database.

# The user is root without a password
export MYSQL_USER=root

#Now, you should be able to launch the DB server

Databaseds 2 -ORBendPoint giop:tcp:[hostname]:[port]

#To test if the DB server is working fine, you can launch jive

export TANGO_HOST=[hostname]:[port]
jive

------------------------------------------------------------------------
How to upgrade the DB scheme. This section descrbies what you have to do
if you already use a DB server running with an old scheme (without history
tables)
------------------------------------------------------------------------

#Launch the mysql client

mysql -u[user] -p[password]

#Check if the database scheme has already history tables

mysql>show tables;

#If the scheme already has history tables, you should see the 6 following
#tables
+--------------------------------+
| Tables_in_tango |
+--------------------------------+
| ... |
| history_ids |
| property_attribute_class_hist |
| property_attribute_device_hist |
| property_class_hist |
| property_device_hist |
| property_hist |
| ... |
+--------------------------------+

#Note: If your database server stops with the following exception,that means
#that you don't have the correct scheme.

Received a CORBA::Exception
Tango exception
Severity = ERROR
Error reason = DB_SQLError
Desc : Failed to query TANGO database (error=Table 'tango.property_device_hist' doesn't exist)
Origin : DataBase::check_history_tables()

#If you don't have the history scheme:
#Use the db_init_history program to create/initialise history tables.
#This program will create and fill the history tables with the current
#dababase property values (to initialize the first value of the
#property history). This tool does not affect old tables, that means
#that even if you run this tool, you will still be able to launch
#an old release of the DB server.

db_init_history [user] [password]

#Now, you should be able to launch the DB server

Databaseds 2 -ORBendPoint giop:tcp:[hostname]:[port]

#To test if the DB server is working fine, you can launch jive

export TANGO_HOST=[hostname]:[port]
jive

------------------------------------------------------------------------
How to change the history depth (Number of value kept in the property history)
------------------------------------------------------------------------

You can set the property history depth by setting the "historyDepth" device
property of the DB server. The default value is 10.
Note that you have to launch the DB server in order to be able to configure
this property with Jive and then to restart the DB server to take change into
account.

Jan. 5, 2017, Andy Gotz
Add:
The device server has been added to catalogue.
Added by:agotz on:5 Jan 2017, 1:41 p.m.