How to change start time for the Data warehouse Snapshot

The "Data Warehouse Snapshot Time" property allows you to choose a value between 1 and 24 (hours). All the scheduled daily snapshots will run at the chosen hour.

The "Data Warehouse Snapshot Time" property only affects snapshots whose "Task Delay" value is 86400 (24 hours).

We have a server whose users are primarily in India. The data warehouse snapshot process starts around midnight US time, which unfortunately is 9:30 am India time.

There seems to be some performance impact when the snapshot process is running. We would like to reschedule the process so that it runs at a different time of the day, so that it runs during the off-hours for India.

How can we change the time when the data warehouse snapshot process runs everyday?

Well, there's nothing like reading the tutorials. I found that there is a "Data Warehouse Snapshot Time" parameter under the advanced Server settings.

Go to Admin -> Server -> Configuration-> Advanced Properties and in the Data Warehouse section, underneath
com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService is the setting for "Data Warehouse Snapshot Time".

nice discussion and thanx for posting the information :lol:
Data Entry India

DataDataData warehousingwarehousingwarehousing is combining datadatadata from multiple and usually varied sources into one comprehensive and easily manipulated database. Common accessing systems of datadatadata warehousingwarehousingwarehousing include queries, analysis and reporting. Because datadatadata warehousingwarehousingwarehousing creates one database in the end, the number of sources can be anything you want it to be, provided that the system can handle the volume, of course. The final result, however, is homogeneous datadatadata, which can be more easily manipulated

Data Entry India

"Data Warehouse Snapshot Time" just can set the interval time of snapshot making, rather than the start time.

We have a server whose users are primarily in India. The data warehouse snapshot process starts around midnight US time, which unfortunately is 9:30 am India time.

There seems to be some performance impact when the snapshot process is running. We would like to reschedule the process so that it runs at a different time of the day, so that it runs during the off-hours for India.

How can we change the time when the data warehouse snapshot process runs everyday?

Well, there's nothing like reading the tutorials. I found that there is a "Data Warehouse Snapshot Time" parameter under the advanced Server settings.

Go to Admin -> Server -> Configuration-> Advanced Properties and in the Data Warehouse section, underneath
com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService is the setting for "Data Warehouse Snapshot Time".

You're correct, you cannot do this currently.

james
RTC Reports Team Lead

On 2/26/2010 2:22 AM, wangpp wrote:

"Data Warehouse Snapshot Time" just can set the interval
time of snapshot making, rather than the start time.

gastonwwrote:

We have a server whose users are
primarily in India. The data warehouse snapshot process starts
around midnight US time, which unfortunately is 9:30 am India time.

There seems to be some performance impact when the snapshot process
is running. We would like to reschedule the process so that it runs
at a different time of the day, so that it runs during the off-hours
for India.

How can we change the time when the data warehouse snapshot process
runs everyday?

Well, there's nothing like reading the tutorials. I found that there
is a "Data Warehouse Snapshot Time" parameter under the
advanced Server settings.

Go to Admin -> Server -> Configuration-> Advanced Properties
and in the Data Warehouse section, underneath
com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService
is the setting for "Data Warehouse Snapshot
Time".

Ignore me, listen to Rafik. :-)

james

On 2/28/2010 9:57 PM, James Moody wrote:

You're correct, you cannot do this currently.

james
RTC Reports Team Lead

On 2/26/2010 2:22 AM, wangpp wrote:
"Data Warehouse Snapshot Time" just can set the interval
time of snapshot making, rather than the start time.

gastonwwrote:

We have a server whose users are
primarily in India. The data warehouse snapshot process starts
around midnight US time, which unfortunately is 9:30 am India time.

There seems to be some performance impact when the snapshot process
is running. We would like to reschedule the process so that it runs
at a different time of the day, so that it runs during the off-hours
for India.

How can we change the time when the data warehouse snapshot process
runs everyday?

Well, there's nothing like reading the tutorials. I found that there
is a "Data Warehouse Snapshot Time" parameter under the
advanced Server settings.

Go to Admin -> Server -> Configuration-> Advanced Properties
and in the Data Warehouse section, underneath
com.ibm.team.datawarehouse.service.internal.InternalDataWarehouseService
is the setting for "Data Warehouse Snapshot
Time".