História stránky

...

Kotva

	audit_info
	audit_info

AUDIT_INFO [REINIT [USER|RESGROUP]]

The process without parameters writes out the status of monitoring, or storing of auditing information (see also Object Group - monitoring changes in configuration).
Parameter REINIT USERS causes the writing the current configuration of all objects of *User* type into the monitoring database.
Parameter REINIT RES_GROUP causes the writing the current configuration of necessary objects of *Object group* type into the monitoring database.
In any object type is not stated in the command, both type of objects will be written into the monitoring database.

BACKUP SYSCFG path

Creates a configuration database backup in a directory specified by the parameter path.

Note 1: The backup can be influenced by the setting of parameter ConfigBackUpTimeout.
Note 2: This functionality can not be used for databases built on PostgreSQL. Such databases can be backed up according to this instruction.

BACKUP LOGFILE path

Creates a log database backup in the directory specified by the parameter path.

Note 1: This functionality can not be used for databases built on PostgreSQL. Such databases can be backed up according to this instruction.

BACKUP VALUES path

Creates the backup of the database VALUES. DB in the directory specified by the parameter path.

CFGSYNCHROAUTO ON/OFF

Enables / disables the automatic synchronisation of configuration databases after a new SBS (stand-by server) is connected.

Note 1: The command can be applied to HOT server only.
Note 2: The synchronization can be influenced by the setting of parameter ConfigSynchroTimeout.

CHECK_ARCHIVE

Checks a value type consistency between primary archive object and the archival one and shows the errors (writes it into log). The error is, if the value type of the primary archive object is different than value type of the archival object.

Kotva

	deploy_java_shared
	deploy_java_shared

DEPLOY_JAVA_SHARED

If some files - the external and user libraries for Java, placed in directory %lt;appldirgt;/java/shared are changed, D2000 Server will send these files to all running clients.

DI ON/OFF

Debug Info - shows / hides internal debug information of D2000 Server (only if the process window is displayed on the desktop).

DP ON/OFF

Debug Pipe - enables / disables the displaying of the communication of D2000 Server with client processes (only if the D2000 Server's window is displayed on the desktop).

INSTANCE SET|GET ACTIVE|PREFERRED|USABLE ...

It is used to determine and set the active instance, preferred instance and instance mode in a load-balancing mode.

INSTANCE GET PREFERRED process_name

Shows the number of the preferred process instance.

Kotva

	set_pref_inst
	set_pref_inst

INSTANCE SET PREFERRED process_name instance_number

Sets a preferred process instance.
It is used to set the preferred archive if the archives run as instance (for more information see the chapter Redundant archiving). By default, the instance with minimal number is active.
This parameter can be used also for setting up the D2000 KOM process (for more information see the chapter Redundancy of communication process KOM).

The command writes the number of the preferred instance into the system registers:

HKEY_LOCAL_MACHINE\Software\Ipesoft\D2000V70\cfg_Meno_Aplikacie\Kernel\SELF.ARC_PreferredActiveInstance

Warning: If the preferred value is 0, the process instances are not switched actively while the terminated active instance is started. I.e. when some active instance is finished, other existing instance will be a new active instance. If there are more process instances, the active one will be that with the minimum number. This process instance remains active even if other one is started (it had to be active before termination).

Incorrect termination of the active and preferred instances may change the preferred process instance. If the active instance crashes while other instance is operating, it becomes a new preferred active instance (with the minimum number).

INSTANCE GET ACTIVE process_name

Enables to display the number of active process instance.

Kotva

	set_act_inst
	set_act_inst

INSTANCE SET ACTIVE process_name instance_number

Sets the active instance of given process.
The parameter is used for setting up the active instance of archive process, if all the instances are running as instances (for more information see the chapter Redundant archiving). By default, the instance with minimal number is active.
This parameter can be used also for setting up the D2000 KOM process (for more information see the chapter Redundancy of communication process KOM).

The command switches the active instance of the process.

INSTANCE GET USABLE process_name instance_number

Enables to display '1' if a process of given instance is active in load-balancing mode. If not, then '0'.

Kotva

	set_inst_usable
	set_inst_usable

INSTANCE SET USABLE process_name instance_number 1|0

Sets the instance of process as active or passive in Load balancing mode (see the chapter Redundant archiving - Load balancing).

MESSAGE Message_Text process_name

Broadcasts (sends) a text message to client processes. The process name can be entered as a mask (e.g. *.HIP - for all processes D2000 HI). If the return code is Success, it contains the number of clients, the message from D2000 Server was sent to.

LIC_PostponeLicWrnToUsers
0 až 240 [hod], default 24

Delay of license warnings for common users. The administrators of D2000 will get the license warning always and immediately.

LIC_DoNotAllowConsoleOverLimit
0|1, default 0

When setting 1, the system will not allow to connect consoles (HI) over the scope of license.

LIC_DoNotAllowSysProcOverLimit
0|1, default 0

When setting 1, the system will not allow the system processes (CALC, EVENT, KOM,...) over the scope of license.

RD_SET_HOT serverName

Sets the hot server in the redundant system. The parameter serverName is the name of server within the frame of the redundant group.

Kotva
refresh_licence
refresh_licence
REFRESH_LICENCE

On-line refresh of the information about the licence range (from file LicenceRun.code or LicenceDev.code) and information about the network clients (from file ConsolesInfo.txt). It enables to change the licence range without any need to stop the system - as well as re-reading the list of network clients after it has been manually edited.

Note 1: In redundant systems it is necessary to replace the files LicenceRun.code or LicenceDev.code on all redundant servers.
Note 2: In redundant systems it is necessary to modify the file ConsolesInfo.txt only on the active (HOT) server. The changes will be transferred to all SBS servers.
Note 3: The information about the licence is sent to the client processes when connecting to D2000 Server. For that reason, if the change of licence affects even other processes than D2000 Server, they must be restarted. For example, when a user add a new communication protocol, it influences D2000 CNF process. To enable this protocol in D2000 CNF, it must be restarted. Also, when adding a new communication station and I/O tags with the given protocol to D2000 KOM process, it must be restarted.

RELOAD_PARAMS

Loads all parameters for kernel (except the parameters for saving the monitoring database to the depository). The D2000 System may not be restarted.

RELOAD_SECURITY

Sets the new configuration of Security Policy with no need to restart D2000 System.

REPAIR_ARCHIVE

Checks a value type consistency between primary archive object and archival one. If some error occurs, it will repair it immediately and write information into log. The error is if the value type of the primary archive object is different than value type of the archival object.

RESTART process_name

Stops the given process and then starts it correctly.

Note: If the process is stopped (Stop or Crash status), the command just starts it.

Kotva

	set_load_bal_mode
	set_load_bal_mode

SET_LOAD_BAL_MODE
process_name mode

Activates/deactivates Load balancing mode (see the chapter Redundant archiving - Load balancing).

Example:
SET_LOAD_BAL_MODE SELF.ARC 1 - activates Load balancing mode for SELF.ARC process.

Kotva
show_access_list
show_access_list
SHOW_ACCESS_LIST

The command writes the list of the names registered by the action GETACCESS within the application (with the keyword PUBLIC) into the text console and to the log file (kernel.log) of the process D2000 Server.
The list contains the owner of register name as follows:
computer_name;process_name;event_name/activepicture_name

Example:
ACCESS LIST BEGIN
GETACCESS : "RegisteredName" is locked by : ComputerName;SELF.EVH;E.EventName
GETACCESS : "RegisteredName2" is locked by : ComputerName;ComputerName.HIP;S.PictureName
ACCESS LIST END

SHOW_ARC_STAT
process_name

Shows the statistical information about the running instances of archive - the maximum number and sum of the read requests that are being processed.

Kotva

	show_config
	show_config

SHOW_CONFIG

Shows configuration information of the process D2000 Server.
This information covers:

start parameters of process D2000 Server,
configuration parameters of D2000 system installation common for all applications,
parameters of process D2000 Server specified in Windows registry (specific for running application),
in redundant systems parameters of redundancy specified in Windows registry (specific for running application),
parameters specific for ODBC and OCI versions of process D2000 Server.

Note: By comparing the information, obtained by this tell command, it is possible to find out whether D2000 Server processes in redundant group are configured identically, resp. if any parameter was omitted during migration of application server.

Kotva

	show_dyn_info
	show_dyn_info

SHOW_DYN_INFO object_name or HOBJ

Shows dynamic information on the specified object (list of objects that dynamically or statically use the object) on the text console of the process D2000 Server.

Note: The command is intended to be used mainly for D2000 System diagnostic purposes.

SHOW_DYNO_LIST idFirst idLast

The command dumps the list of current dynamic objects (ID and object name) to the text console of process based on the defined interval.

Note: The command is mainly intended for diagnostic purposes.

SHOW_TRANS_LIST

Lists internal transactions of the D2000 system.

Note: The command is intended to be used mainly for D2000 System diagnostic purposes.

SHUTDOWN D2000

Stops D2000 System.

SHUTDOWN RESTART

Stops D2000 System and restarts the operating system.

SHUTDOWN SHUTDOWN

Stop D2000 system and shutdown operating system.

SHUTDOWN WINNT

Stops D2000 System and restarts the operating system.

START process_name

Starts specified process.

STDOUT output

The command redirects the standard output to new output specified by output.

Example:
D2000 on OpenVMS platform: STDOUT "_TNA2:" (output is redirected to the terminal _TNA2:)
D2000 on Windows platform: STDOUT C:\output.txt (output is redirected to the file output.txt)

Note: If a D2000 process is run on Windows platform as a service, console output is disabled.

STOP process_name [FORCE]

It stops a process. When using the optional parameter FORCE, the termination of process will be forced.

*SUSPEND* SLEEP [WAKEUP yyyy-mm-ddThh:mi:ssZ]|HIBERNATE

It causes, that operating system switches into sleep mode (SLEEP) or hibernation (HIBERNATE). If OS switches into sleep mode, user may define a time of its automatic awakening by the parameter WAKEUP yyyy-mm-ddThh:mi:ssZ, where yyyy-mm-ddThh:mi:ssZ defines UTC time of awakening. The string must be in ISO 8601 format (http://sk.wikipedia.org/wiki/ISO_8601).

Example: *SUSPEND SLEEP WAKEUP 2015-02-11T12:00Z* - causes putting the computer to sleep and automatic awakening at noon, February 11th, 2015 (UTC).

Kotva

	tcp_no_delay
	tcp_no_delay

TCP_NO_DELAY process_name|process_mask [FALSE|TRUE|QUERY]

Enables, disables or queries the delay of data transfer between the process D2000 Server and the client connected via TCP/IP protocol. Setting the parameter TCP_NO_DELAY to TRUE disables TCP delay before sending TCP packets (function setsockopt with parameter TCP_NODELAY - see Nagle's algorithm). The delay improves efficiency of TCP/IP networks by reducing the number of packets that need to be sent over the network. On the other hand if the communicating partners wait for each other's response (e.g. remote procedure calls between two EVENT processes or between HI and EVENT), this delay can significantly slow down execution of scripts and other interactions.
By default TCP delay is on (TCP_NO_DELAY = FALSE).
This tell command is intended only for tuning and debugging purposes.

Note 1: When registering a TCP/IP client, the process D2000 Server queries the value of parameter TCP_NO_DELAY and, depending on this value, it does or does not change the parameter TCP_NO_DELAY for client connection. This value is then sent to client, which also changes TCP_NODELAY parameter of its TCP connection to server.
Warning: In current implementation the tell command TCP_NO_DELAY does not cause any change in the setting on client's side!
Note 2: Besides the parameter TCP_NO_DELAY, there is also another parameter which influences sending TCP delayed acknowledgments (it can be set on OpenVMS and *nix system by calling sysconfig -r inet tcpnodelack). This parameter induces a 200 ms delay before sending TCP acknowledgments and it can interact with TCP_NODELAY parameter.

Kotva

	xml_export0
	xml_export0

XML_EXPORT

Warning: Since the version V8.00.001, the command is not supported.

XML file(s) export from the directory, which is defined by the parameter path, together with the following parameters:

Path – defines the directory where the objects will be exported; required parameter.
It must contain the complete path, e.g. c:\XML. The path must exist. If it does not exist, the export is not allowed.
Instead of fixed path, the user can select the default directory - by entering the value "*" into parameter.
The default directory is placed in "[APP_DIR]\XML_EXPORT", where APP_DIR defines the application directory, e.g. c:\D2000\D2000.APP\application_name\XML_EXPORT" ".
Mask – defines the mask, which correspond to the list of objects that are to be exported; required parameter.
optional settings of XML_SETTINGS

The path for the file export on VMS must be written in Unix format.

Correct syntax: /DKB0/d2000/d2000-app/RIS_ROVE/XML/ mask
Incorrect syntax: DKB0:[d2000.d2000-app.RIS_ROVE.XML] mask - this syntax is not supported, export ends with error.

Kotva

	xml_export_table
	xml_export_table

XML_EXPORT_TABLE

The configuration parts export to the XML files, which is not the part of the object configuration.
The parameters: [Path, FileName, TableName].

Path - defines the path for saving the configuration.
FileName - defines the name of output file. E.g. for the file "systemtxt", there is created the file with the name "systemtxt.xml".
TableName - defines the table of database, which the configuration is to be exported from.
TableName can acquire following values: SYS_COLORS, SYSTEM_TEXT, TRANS_MASKA, DICTIONARY, LANGUAGES, LOGDEF, NAME_RULES.

Warning: Extension ".xml" is added automatically, do not write it.

Kotva

	xml_import0
	xml_import0

XML_IMPORT

Warning: This command is not supported for OpenVMS.

XML file(s) import from the directory, which is defined by the parameter Path.
The parameter:[path_to_dir / path_to_file]

The initialization of tell command is conditioned by using a configuration key.

The path for the file import on VMS should be entered in Unix format.
Correct syntax: /DKB0/d2000/d2000-app/RIS_ROVE/XML/
Incorrect syntax: DKB0:[d2000.d2000-app.RIS_ROVE.XML] - this syntax is not supported, import of directory containing XML files ends with error

The import of one file supports the both records:
Correct syntax: /DKB0/d2000/d2000-app/RIS_ROVE/XML/file.xml
Correct syntax: DKB0:[d2000.d2000-app.RIS_ROVE.XML]file.xml

Note: The command belongs to the "security" TELL commands. I.e., it can be activated only from interactive processes with configuration key or from process D2000 Event Handler.

Kotva

	xml_import_table
	xml_import_table

XML_IMPORT_TABLE

Import of the configuration parts that is not the part of the object configuration from XML files.
The parameter [Path, FileName, TableName[, CleanTable]]

Path - defines the path from which the configuration will be read.
FileName - defines the name of input file without xml extension. For example, "systemtxt" for the file with the name "systemtxt.xml".
TableName - defines the table of database to which the configuration is to be imported.
TableName can acquire following values: SYS_COLORS, SYSTEM_TEXT, TRANS_MASKA, DICTIONARY, LANGUAGES, LOGDEF, NAME_RULES.
CleanTable - defines whether the table in database will be cleaned before import.
This parameter is optional, default value is FALSE.
Parameter can acquire two values: TRUE - clean table, FALSE - table is updated.

The initialization of tell command is conditioned by using the configuration key.

Note: The command belongs to the "security" TELL commands. I.e., it can be activated only from interactive processes with configuration key or from process D2000 Event Handler.

Kotva

	xml_settings
	xml_settings

XML_SETTINGS

Warning: Since the version V8.00.001, the command is not supported.

Sets the parameters for TELL commands XML_IMPORT a XML_EXPORT.

The command without parameter displays the default parameters of D2000 Server.

Kotva

	xml_update
	xml_update

XML_Update

Partial update of the objects by XML from the directory, which is defined by parameter Path.
The parameter:
[path_to_dir / path_to_file]

Note: The command belongs to the "security" TELL commands. I.e., it can be activated only from interactive processes with configuration key or from process D2000 Event Handler.

...

BACKUP [path]

Creates an archive database backup. If the parameter path is not specified, the backup will be performed into the directory, which is set in the archive configuration.

Kotva

	calc_old_requests
	calc_old_requests

CALC_OLD_REQUESTS [path+filename]

Executes recalcs of old values, which were redirected to the auxiliary calc task (see the archive parameter RecalcImmediateDepth) and then instead of being performed were stored to the file (see the archive parameter DropOldRequests). If path+filename is not specified, the file name_ARCHIV_DROPPED_CALCS.DAT will be processed by name.ARC and then renamed to name_ARCHIV_DROPPED_CALCS.DONE (if such a file exists, it will be deleted).

Note: This command fails if the archive parameter DropOldRequests has value 1, because in this case the recalcs would be again stored to the file after being read.

Kotva

	cleanup_slices
	cleanup_slices

CLEANUP_SLICES

A command that must be run after the change of parameter DataTableSlices from value 1 to value 2 (i.e. after changing the time slices mode to time slices for structured archives only).
Archive will transfer the archived values from time slices of simple archives to the original data tables and these time slices will be deleted.
Note: for simple archives, from start of the the archiv till the transfer of archived values to the original data tables, the archiv will provide only data which are located in original data tables. Therefore this conversion is recommended only for systems with redundant archives and the archive performing conversion should be set as passive instance.

CRC path\filename mask from to [step] [PO]

Parameter checks the data identity in instance archives. Creating the file with CRC (checking sum) for archive objects that correspond to mask for entered time period.
Optional parameter step (in hours) allows to divide the calculation for time period into intervals.
The parameter PO ensures the calculation will be executed only for primary archive data.

Kotva
crc_poznamka
crc_poznamka
Note: Values entering the CRC calculation can be "truncated" - in a 64-bit floating point value complying with the IEEE 754 standard, the two lowest bytes will be zeroed, if a debug category DBG.ARCHIV.CRC.Z2LB is enabled. The truncation can be used to ignore minor differences (16. and higher decimal point), which can occur in floating point calculations in archives running on different processors.

CRC_TREE path\filename name row col from to [step]

Parameter checks the data identity in instance archives. Creating the file with CRC (checking sum) for archive objects that correspond to mask for entered time period.
The calculation will be realized for object that has been defined by parameter "name row col" and for all objects that influence its value.
Optional parameter step (in hours) allows to divide the calculation for time period into intervals.
See the note to CRC command.

DEL mask [before]

Deletes data from the archive database as follows:

the parameter before is not defined - for individual archive objects, there will be deleted all data that are older than the history depth (the parameter History depth) defined in the configuration of the objects,
the parameter before is defined - there will be deleted all data with the timestamps older than defined by the parameter before.

Kotva

	delete_data
	delete_data

DELETE_DATA mask from [to]

Deletes data from the archive database without activation of dependent statistics evaluation (similar to the action DELETEARCHDATA).
Time format is dd-mm-rrrr hh:mi:ss.mss.

DI ON/OFF

Debug Info - shows / hides internal debug information of the process D2000 Archiv (only if the process window is displayed on the desktop).

DI ON/OFF [HOBJ/mask [ROW [COL]]]

Debug Info for values - enables / disables displaying information about the evaluation of historical values with specified HOBJ or with the name matching given mask. For structured historical values, you can specify required structure item - column (if ROW=0) or row (if COL=0).

Example:
DP ON H.Test1 3 4 - enables debug information for the item of structured historical value H.Test1 on row 3 and column 4
DP ON H.Test2 - enables debug information for historical value H.Test2 (for all items if the object is a structure)
DP OFF 1234 0 4 - disables debug information for the whole column 4 in the structured historical value with HOBJ=1234

By default, debug information shows just the time and the value of historical value. Enabling the debug category DBG.ARCHIV.DATA (in the process D2000 System Console or using the start parameter /E+DBG.ARCHIV.DATA when starting the process D2000 Archiv), allows to show the complete stored data designed for the D2000 System developers:
Time (archive value time)
Value (value)
Status (a True/False array containing Valid, ProcAlarm, NoAckPAlarm, PrAlSilent, Weak, NoAckValue, Transient, Default, Manual, AlCrit, Unknown values)
Limits (one of the value of InLimit, VL_Limit, L_Limit, H_Limit, VH_Limit, LimitsProblem)
ArchFlags (a True/False array containing Start, Stop, Block, UnBlock, Deleted, UserModify, OldVal, ProcesModify, LoadData, MONO_TIME, K, L, M, N, O, Ver1 values)

DI ONREC/OFFREC HOBJ/mask [ROW [COL]]

Debug Info for values - recursive. The command extends the functionality of the previous commands with the possibility of showing / hiding the debug information for historical values that depend on specified historical values (e.g. minute averages).

Kotva

	dismount_trezor0
	dismount_trezor0

DISMOUNT_TREZOR path+trezor_name

Sybase platform: The parameter path+trezor_name specifies the path and the name of the depository database to dismount. The * and ? characters for mask definition can be used in the depository database name. If more files match to entered mask, all these ones will be dismounted.

For more information see the topic On-line access to data from depository databases.

Kotva

	dismount_trezor_ora0
	dismount_trezor_ora0

DISMOUNT_TREZOR Id [SEGMENT seg]
DISMOUNT_TREZOR trezor_name [SEGMENT seg]
DISMOUNT_TREZOR IdFrom IdTo [SEGMENT seg]

Oracle platform: The parameter Id or trezor_name defines the number (name) of depository database to dismount.
Name of depository database is the name of depository tablespace (e.g. MYAPP_TS_TREZOR15 or MYAPP_TS_TREZOR15_02) or name of tablespace's datafile (e.g. MYAPP_TS_TREZOR0015_S02_20040801.ORA).
You can also dismount all depository databases (except the ones that are currently being filled) by using the parameter all. The parameters IdFrom and IdTo allow to dismount a sequence of depository databases.
The parameter SEGMENT seg (where seg is the number of depository database segment) allows to dismount just the segment. Seg is the number between 0 and TrezorCountSegments. If the command DISMOUNT is used without the parameter SEGMENT Seg for depository database segments enabled, the process D2000 Archiv attempts to dismount all segments of specified depository database/s.

For more information see the topic On-line access to data from depository databases.

Kotva

	dismount_trezor_pg
	dismount_trezor_pg

DISMOUNT_TREZOR Id [SEGMENT seg]
DISMOUNT_TREZOR IdFrom IdTo [SEGMENT seg]

PostgreSQL platform: The parameter Id defines the number of depository database to dismount.
You can also dismount all depository databases (except the ones that are currently being filled) by using the parameter all. The parameters IdFrom and IdTo allow to dismount a sequence of depository databases.
The parameter SEGMENT seg (where seg is the number of depository database segment) allows to dismount just the segment. Seg is the number between 0 and TrezorCountSegments. If the command DISMOUNT is used without the parameter SEGMENT Seg for depository database segments enabled, the process D2000 Archiv attempts to dismount all segments of specified depository database/s.

For more information see the topic On-line access to data from depository databases.

DP ON/OFF

Debug Pipe - shows / hides the course of communication with D2000 Server (only if the process window is displayed on the desktop).

DROP_LIST path+filename

Creates the file (defined by the parameter path+filename) containing SQL commands to delete tables, which are not used by the archive configuration. If the time slices are enabled, the file will contain also the commands to delete respective rows of the table ARC_SLICE, which contain information about the time slices corresponding to tables that are to be deleted.

Kotva

	fill_cache
	fill_cache

FILL_CACHE

Manual loading of archive cache (only available for isochronous cache mode) by reading values from archive database.
Archive cache loading can be also automatic after startup - for more information see description of parameter IsoCacheAutoFill.

Kotva

	force_clear
	force_clear

FORCE_CLEAR HOBJ/mask

For selected object(s), their ClearTime is set to a value of several hours in the past, which means that a periodic delete of object's data should occur shortly (unless it is disabled for some reason, e.g. if the time slices are enabled, it can depend on parameters DeleteInSlice0 and DeleteInSlices).

Kotva

	freeze
	freeze

FREEZE freeze_seconds [report_seconds]

UNFREEZE

FREEZE command causes the writing and calculating tasks of archive stop processing the requests for a period freeze_seconds. Within this time, the next task (deleting) will list the number of requests (primary and calculated) in the queues. After elapsing the time freeze_seconds, the processing of values will be restored. If the parameter report_seconds is entered, the deleting task continues to list the number of request in the queues for this period.
FREEZE command is primarily used for performance tests (testing the maximum speed for processing the requests under load). Before its using, you should realize that it does not influence reading from archive, but during its execution, the writing to the archive (so the newest values are not available when reading) and the calculations are not executed for the period freeze_seconds. In the redundant systems with 2 and more archives, we recommend to execute FREEZE command on a passive instance, so that the functionality of subsystem will not be affected.
UNFREEZE command (without parameters) is used for aborting an inactivity that was caused by FREEZE command.

Kotva

	import_data
	import_data

IMPORT_DATA

Activates the process D2000 Archiv to import external data, e.g. Importing archive databases from D2000 V3.65 (OS/2).

Kotva
list_trezor
list_trezor
LIST_TREZOR [all]
LIST_TREZOR id

The parameter allows to shows the list of depository databases used by the process D2000 Archiv. The contents of the list depends on the used platform - Sybase, PostgreSQL or Oracle.
Parameter id:

for Sybase - name of depository database
for Oracle - number of depository tablespace
for PostgreSQL - number of depository database

LOAD_TREZOR path+filename [mask] [from] [to]

On-line depository database import.

Kotva

	mount_trezor0
	mount_trezor0

MOUNT_TREZOR path+trezor_name

Sybase platform: The parameter path+depository_name defines the path and name of the depository database to be mounted. The name may contain * and ? characters to define a mask. If more files match specified mask, all these will be mounted.

For more information see the topic On-line access to data from depository databases.

Kotva

	mount_trezor_ora
	mount_trezor_ora

MOUNT_TREZOR Id [SEGMENT seg] [WRITE]
MOUNT_TREZOR trezor_name [SEGMENT seg] [WRITE]
MOUNT_TREZOR IdFrom IdTo [SEGMENT seg] [WRITE]

Oracle platform: The parameter Id (trezor_name) defines the number (name) of a depository database to be mounted.
Name of depository database is the name of depository tablespace (e.g. MYAPP_TS_TREZOR15 or MYAPP_TS_TREZOR15_02) or name of tablespace's datafile (e.g. MYAPP_TS_TREZOR0015_S02_20040801.ORA).
The parameters IdFrom and IdTo allow to mount the sequence of depository databases.
The parameter SEGMENT Seg (where Seg is the number of the depository database segment) allows to mount on just one depository database segment. If the command MOUNT is used without the parameter SEGMENT Seg for depository database with segments enabled, the process D2000 Archiv attempts to mount on all segments of specified depository database/s.
The parameter Write can be used to mount depository database (s) for writing (for depository databases synchronization through the Arcsynchro tool).

For more information see the topic On-line access to data from depository databases.

Kotva

	mount_trezor_pg
	mount_trezor_pg

MOUNT_TREZOR Id [SEGMENT seg] [WRITE]
MOUNT_TREZOR IdFrom IdTo [SEGMENT seg] [WRITE]

PostgreSQL platform: The parameter Id specifies the number of a depository database to be mounted. The parameter SEGMENT Seg (where Seg is the number of the depository database segment) allows to mount on just one depository database segment. If the command MOUNT is used without the parameter SEGMENT Seg for depository database with segments enabled, the process D2000 Archiv attempts to mount on all segments of specified depository database/s.
The parameter Write can be used to mount depository database (s) for writing (for depository databases synchronization through the Arcsynchro tool).

For more information see the topic On-line access to data from depository databases.

PENDING_REQUESTS path+filename

Creates a file containing the descriptions of pending requests.

Kotva

	recalc
	recalc

RECALC Mask [Row [Col]] From [To] [BACKGROUND]

Recalculates the values in the statistical archive.
Mask - defines the list of objects, which are to be recalculated. If the specific row and/or column of the structured archive is recalculated, it is possible to specify parameters Row and Col (if unspecified, their default value is 0, meaning "whole row/column").
The parameters <From, To> define a time interval to be recalculated. If end time is not entered, current time will be used. Time format is dd-mm-yyyy [hh[:mi[:ss[.mss]]]].
Optional parameter BACKGROUND (implemented in version 7.02.006) puts the recalculation to the auxiliary calc task (see the archive parameter RecalcImmediateDepth). The parameter is recommended for long-lasting recalculation of historical values which are supposed to be performed on the background while archive still continues archiving real-time data.

Note: If the parameter RecalcTimeIntervalLimit has non-zero value and the time interval <From, To> is longer than RecalcTimeIntervalLimit hours, the parameter BACKGROUND is mandatory, to ensure that the recalculation will be performed by auxiliary calc. This behaviour is stated as a protection against overloading the main task by recalculations.

Kotva

	release_trezor
	release_trezor

RELEASE_TREZOR

Early disconnection of current depository database.

Kotva

	rem_empty_slices
	rem_empty_slices

REM_EMPTY_SLICES HOBJ|mask

If the time slices are activated, the command causes that archive will review all time slices of simple archive objects according to the defined HOBJ or mask and deletes the time slices without data.
The command is used to purify the archive database from empty time slices that were created due to error of archive. This error was repaired in the supported versions in June 8, 2015.

Kotva
reorganize
reorganize
REORGANIZE

On-line reorganization of archive database. The command compacts all archive tables (same as the Oracle command ALTER TABLE MOVE or the Sybase command REORGANIZE TABLE INDEX).

Note: For Oracle, PostgreSQL and Sybase 8.0 platforms or later only.

Kotva

	reorganize_slice
	reorganize_slice

REORGANIZE HOBJ|mask [SLICE slice] [tablespace]

On-line reorganization of archive table of object with specified HOBJ or with name matching specified mask. If the parameter tablespace is also defined, given archive table will be moved to specified tablespace. If time slices are on, all slices of one archive object will be reorganized/moved unless a slice number slice is specified.

Note 1: The parameter tablespace can be used on Oracle platform only.
Note 2: The slice number, except for ordinary values, supports special values:

value -1 means "all slices"
value -2 means "slice for current time"
value -3 means "previous time slice"
value -4 means "all slices older than current time slice"

REORGANIZE ON

Enables the reorganization of archive database (same as running the process D2000 Archiv with the /DBCY parameter).

REORGANIZE OFF

Enables the reorganization of archive database (same as running the process D2000 Archiv without the /DBCY parameter).

REORGANIZE ACTIVE

Enables the reorganization of archive database in the active mode only (same as running the process D2000 Archiv with the /DBCA parameter).

REORGANIZE PASSIVE

Enables the reorganization of archive database in the passive mode only (same as running the process D2000 Archiv with the /DBCP parameter).

REORGANIZE SHRINK

Enables the alternate mode of reorganization of archive database - only for Oracle 10g and above (dame as running the process D2000 Archiv with the /DBCS parameter).
Note: To enable the original mode, use tell command REORGANIZE MOVE.

REORGANIZE TableRowLimit rowLimit

On-line change of the parameter ReorganizeTableRowLimit used for the automatic reorganization of archive database.

REORGANIZE TableTimeLimit timeLimit

On-line change of the parameter ReorganizeTableTimeLimit used for the automatic reorganization of archive database.

Kotva

	set_cache
	set_cache

SET_CACHE size [MB]

The command allows the user to change the dynamic cache size to speed-up the calculation of statistical historical values while the process D2000 Archiv is still running.

Note 1: The initial cache size can be specified by the parameter MaxCacheSize in the process D2000 Application Manager.
Note 2: The command SET_CACHE also changes value of the parameter MaxCacheSize in registry.

Kotva

	set_option
	set_option

SET_OPTION
name_parameter
value_parameter

Tell command SET_OPTION controls the following configuration and start-up parameters of the process D2000 Archiv:

name_parameter

value_parameter

description

AlmostZero
ALMOST_ZERO

positive real number (e.g. 1e-10)

See description of the parameter AlmostZero.

CommitCountActive
COMMIT_COUNT_ACTIVE

positive number

See description of the parameter CommitCountActive.

CommitCountPassive
COMMIT_COUNT_PASSIVE

positive number

See description of the parameter CommitCountPassive.

CommitTimeActive
COMMIT_TIME_ACTIVE

positive number

See description of the parameter CommitTimeActive.

CommitTimePassive
COMMIT_TIME_PASSIVE

positive number

See description of the parameter CommitTimePassive.

DBPO

ON/OFF

Only primary data processing.

RX

ON/OFF

No delete.

RO

ON/OFF

Read only.

RS

ON/OFF>

Backup by copying.

DBRT

ON/OFF

Calculation of the computed historical values in real time.

Kotva

	read_archive_depth
	read_archive_depth

READ_ARCHIVE_DEPTH

"dd-mm-yyyy hh-mi-ss"

OFF

Limitation of the reading depth from the archive.

If the saving to the depository is ON the older data than the specified date will be read from the depository databases. This parameter can be used for checking if the depositories truly contain all data (e.g. after the patching by arcsynchro).
The value OFF deactivates the limitation.
When the limitation is active, every reading from the archive (in which the limitation is applied) produces the following note in the archive log file:
Start time for reading values from archive is before READ_ARCHIVE_DEPTH, limiting

DiskUsageWarning
DISK_USAGE_WARNING

ON/OFF

See description of the parameter DiskUsageWarning.

DropOldRequests
DROP_OLD_REQUESTS

ON/OFF

See description of the parameter DropOldRequests.

IsochronousCache
ISOCHRONOUS_CACHE

ON/OFF

See description of the parameter IsochronousCache.

IsoCacheFullDepth
ISOCACHE_FULL_DEPTH

ON/OFF

See description of the parameter IsoCacheFullDepth.

IsoCacheDepth
ISOCACHE_DEPTH

positive number (seconds)

See description of the parameter IsoCacheDepth.

OldValOnAuxTask
OLD_VAL_ON_AUX_TASK

ON/OFF

See description of the parameter OldValOnAuxTask.

OneThreadForGraph
ONE_THREAD_FOR_GRAPH

ON/OFF

See description of the parameter OneThreadForGraph.

PG_ReorganizeSlice
PG_REORGANIZE_SLICE

0-2

See description of the parameter PG_ReorganizeSlice.

PG_ReorgSliceTime
PG_REORGSLICE_TIME

seconds

See description of the parameter PG_ReorgSliceTime.

RecalcImmediateDepth
RECALC_IMMEDIATE_DEPTH

seconds/OFF

See description of the parameter RecalcImmediateDepth.

RecalcParallelInterval
RECALC_PARALLEL_INTERVAL

seconds/OFF

See description of the parameter RecalcParallelInterval.

RecalcTimeIntervalLimit
RECALC_TIME_INTERVAL_LIMIT

hours/OFF

See description of the parameter RecalcTimeIntervalLimit.

RecalcUseTrezor
RECALC_USE_TREZOR

ON/OFF

See description of the parameter RecalcUseTrezor.

ReadTimeBeforeStart
READ_TIME_BEFORE_START

seconds/OFF

See description of the parameter ReadTimeBeforeStart.

ReorganizeOffset
REORGANIZE_OFFSET

hh:mi

See description of the parameter ReorganizeOffset.

ReorganizePeriode
REORGANIZE_PERIODE

hours

See description of the parameter ReorganizePeriode.

ReorganizeTableRowLimit
REORGANIZE_TABLE_ROW_LIMIT

rows

See description of the parameter ReorganizeTableRowLimit.

ReorganizeTableTimeLimit
REORGANIZE_TABLE_TIME_LIMIT

hours

See description of the parameter ReorganizeTableTimeLimit.

Tablespace_Name
TABLESPACE_NAME

name_of_tablespace

See description of the parameter Tablespace_Name (only on Oracle platform).

TrezorReadSegment0
TREZOR_READ_SEGMENT0

ON/OFF

See description of the parameter TrezorReadSegment0.

WorkingHoursStart
WORKING_HOURS_START

non-negative integer number

See description of the parameter WorkingHoursStart.

WorkingHoursEnd
WORKING_HOURS_END

non-negative integer number

See description of the parameter WorkingHoursEnd.

Note: For parameters which are stored in the Registry database the tell command SET_OPTION will change the value of configuration parameters not only in archive but also in the Registry database.

Kotva

	show_dyn_info_archiv
	show_dyn_info_archiv

SHOW_DYN_INFO HOBJ/name [ROW [COL]]

Shows dynamic information on the specified object (current value, last sent value, time of next calculation for periodic archived objects, time of periodic deleting, parameters and content of cache) on the text console of the process D2000 Archiv.

Note: The command is mainly intended for D2000 System diagnostic purposes.

Kotva

	show_cache
	show_cache

SHOW_CACHE count

If archive cache is enabled, the result is a list of top count historical values having the most values in archive cache.
For every value the following properties are displayed: HOBJ, name, number of items and time interval of values in archive cache.

Kotva

	show_config
	show_config

SHOW_CONFIG

Shows configuration information of the process D2000 Archiv and archive database.
This information covers:

start parameters of process specified in the configuration of archive process (if the archive process is run by process D2000 Server ), or archive service (if the archive process is run by its own watchdog), or command-line parameters (if the archive process is run manually),
parameters for archive specified in Windows registry,
parameters stored directly in archive database in LOG_DATA table (see the parameter /CLD of arcsynchro utility),
specific parameters of database (currently only for Oracle platform).

Note: By comparing information, obtained by this tell command, there is possible to find out whether the redundant archives are configured identically or if any parameter was omitted during migration of archive, database etc.

Kotva

	show_info
	show_info

SHOW_INFO

Shows various information about the process D2000 Archiv and the archive database.

STATISTICS path+filename hours

Creates the file path+filename with statistical information, i.e. number of values for individual historical values from the last n-hours.

Kotva

	arc_stdout
	arc_stdout

STDOUT output

The command redirects the standard output to a new output.

Example:
D2000 on OpenVMS platform: STDOUT "_TNA2:" (output is redirected to the terminal _TNA2:)
D2000 on Windows platform: STDOUT C:\output.txt (output is redirected to the file output.txt)
Note: If a D2000 process is runing on Windows platform as a service, console output is disabled. Therefore if this functionality is required, it is necessary for a D2000 process to be started by D2000 Server without /X parameter.

Kotva

	stop_import_data
	stop_import_data

STOP_IMPORT_DATA

Deactivates a feature of the process D2000 - import of external data.

STOP [NOQUEUE]

Stops the process D2000 Archiv. All unsaved values from the request queue are to be automatically stored on the disk and during the next starting the process, the values will be read from the disk. The current values of historical values are to be stored in the table SAVED_LAST_ROWS to quicken the next start of the process.
If the parameter NOQUEUE is used, the unsaved values from the request queue will not be stored in the file (it quickens stopping the process with a large amount of unprocessed values).

TIMESTAT START
TIMESTAT RESTART
TIMESTAT SHOW
TIMESTAT SHOWLONG
TIMESTAT SHOWSTART
TIMESTAT STOP

Starts (START), stops (STOP), restarts (RESTART), shows (SHOW), shows and restarts (SHOWSTART) or shows the time statistics of reading task(s) in long time format, including the days (SHOWLONG). After starting the statistics, the database reading task(s) will start the measuring time, spent in various parts of reading procedure. These values can be used for tuning by system specialists. Time statistics are displayed per reading task and if ReadThreadsCount > 1, also totals for all tasks are shown.
Note: When time statistics are on, reading from archive may be several percent slower due to time measuring.

...

Strom stránky

Porovnávané verzie

Stará verzia 3

Nová verzia 4

Kľúč