Novell SENTINEL 6.1 SP2, Руководство пользователя, Страница: 285 / 528

Sentinel Data Manager 285
no
vd
ocx
(e
n)
7 Ja
nua
ry 201
0
NOTE: Sentinel partitioned tables are organized into 2 groups. One is the EVENTS table
group, which includes EVENTS and CORRELATED_EVENTS; the other is the summary
table group, which includes all summary, or aggregate, tables. If any one of the tables in the
group is selected then the changes will apply to all the tables in the group.
3 Select the tab in the bottom of the window that relates to the operation that you want to perform
– Add, Delete, Archive, Import or Release.
To add partitions:
1
Select the Add partitions tab.
2 Specify the number of days over which to add the partitions.
NOTE: You can specify the number of partitions in Partition Configuration in SDM GUI.
3 Click Add.
NOTE: In case of MS SQL (MS SQL 2000/2005/2008) databases, maximum number of online
partitions allowed is 255. Therefore, you must schedule the offline delete / archive operations
in such a way that the online partitions should not exceed 255.
To delete partitions:
1
Select the Delete partitions tab.
2 Specify the number of days for which older partitions will be deleted.
3
Click Delete.
To import partitions:
1
Select the Import partitions tab.
2 Select the partition in the Segment table into which the data will be imported.
NOTE: You can specify the input directory in the “Archive Destination” field in Partition
configuration tab in SDM GUI.
3
Click Import.
To release imported partitions:
1
Select the Release partitions tab.
2 Select the partition in the Segment table that will be released.
3
Click Release.
Archiving
Events, correlated events, and aggregation (or summary) tables can all be archived using SDM.
There are several requirements for archiving:

The directory to which the partitions are archived must already exist on the database server (not
the machine running SDM); SDM does not create the directory.

On UNIX systems, archiving cannot be to the /root directory.