We're in the process of splitting up our single test-server into a number of development servers (as you may have noticed from some other threads I started). A new hurdle has entered our horizon...

In our current situation we have several focus executables that are run nightly and generate aggregated data-sets of our various data sources into hold files for use in other focus procedures. Some of these hold files are quite large, several are quite intensive on said databases. There are some that take the larger part of the night to run.

For these reasons it seems inadvisable to generate those files anew on each development server. Is there some way to access those files directly from our (possibly remote) test-server?

I realise that changes to the procedures that generate those files would invalidate those focus databases for that specific development environment, but changes to these files are pretty rare.

This message has been edited. Last edited by: Kerry,

Can the development servers map drives to each other? If so, generate the files on one server, then, on each server, APP MAP to the folder on the mapped drive.

Alternatively, a WebFOCUS server can access another WebFOCUS server, if appropriate ports are open.

A synonym can be created that points to the data soruce on the other server.