Changes the time on the Analytic Server you selected with the SELECT command, to match the time on another Analytic Server.
RESETOTLCHANGETIME fromPartition toPartition
fromPartition includes the following parameters:
serverName | Name of the Analytic Server from which the time change is applied. |
appName | Name of the application from which the time change is applied. |
dbName | Name of the database from which the time change is applied. |
partitionType |
The name of the type of partition
from which the time change is
applied. Values: 1 - Replicated 2 - Linked 3 - Transparent |
direction |
Values: Source - The selected database is used as a data source for the replicated, transparent, or linked partition. Target - The selected database is used as a data target for the replicated, transparent, or linked partition. |
toPartition includes the following parameters:
serverName | Name of the Analytic Server to get the time change. |
appName | Name of the application to get the time change. |
dbName | Name of the database to get the time change. |
partitionType |
The name of the type of partition
the time change is applied to. Values: 1 - Replicated 2 - Transparent 3 - Linked |
direction |
Values:
|
The RESETOTLCHANGETIME command synchronizes the internal time stamps between two Analytic Services databases that share a partition. This time stamp is used when performing GETPARTITIONOTLCHANGES and APPLYOTLCHANGEFILE operations to synchronize the outlines. That is, to propagate changes (made during a dimension build, for example) from the outline in one database sharing a partition to the other.
Partitioned databases contain a time stamp indicating when the outline was last modified. Analytic Services uses the time stamp when it performs GETPARTITIONOTLCHANGES and APPLYOTLCHANGEFILE operations to synchronize the outlines. When you use GETPARTITIONOTLCHANGES, the time is stamped in one of the databases. When you use APPLYOTLCHANGEFILE, Analytic Services reads that time stamp and writes it TO the partition definition file (AppName.ddb
) of the other database. The direction in which changes are propagated (data source to data target, or data target to data source) is set in the partition definition
It is not necessary to use the RESETOTLCHANGETIME command when performing GETPARTITIONOTLCHANGES and APPLYOTLCHANGEFILE operations, or as part of regular maintenance. Instead, use it as needed, to reset the time stamp on a partitioned database. For example, if two databases that share a partition reside on different server computers, and a power outage affects the time stamp on one of the databases, you can use RESETOTLCHANGETIME to re-synchronize the time stamps.
For more information, see the Database Administrator's Guide.
RESETOTLCHANGETIME "BAMBOO" "SAMPLE" "BASIC" "1" "SOURCE" "ASPEN" "SAMPLE" "BASIC" "1" "TARGET";
GETPARTITIONOTLCHANGES
APPLYOTLCHANGEFILE
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |