Using Centrally Controlled Databases

How to:

When using centrally controlled data sources, you communicate through the FOCUS Database Server that controls them. So, before issuing requests to SU, you must allocate a communication data set for each FOCUS Database Server you will access. For each allocation, supply the following parameters:

Assume, for example, that you will use two FOCUS Database Servers. One server has communication data set SYS1.SU01.DATA allocated to ddname FOCSU and the other has communication data set SYS1.SU02.DATA allocated to ddname FOCSU. To allocate these data sets on your TSO user ID, you could issue the following ALLOC commands:

ALLOC F(SYNCA) DA('SYS1.SUO1.DATA') SHR
ALLOC F(SYNCB) DA('SYS2.SU02.DATA') SHR

You must allocate them in SHR mode so that others can also allocate them. You will reference individual servers by the ddnames to which you allocated their communication data sets. In this example, the first server is SYNCA and the second is SYNCB.

Unless you are using the Multi-Threaded SU Reporting Facility, you do not allocate centrally controlled databases. Instead, you allocate the data sets containing the Master Files for these data sources, which must be identical to the Master Files allocated in the FOCUS Database Server startup JCL.

Allocate all other files as you if you were using FOCUS locally.
Top of page
x
Syntax: How to Access Centrally Controlled Databases

To gain access to centrally controlled databases, specify the databases in an extended form of the FOCUS USE command: 

USE 
fileid1 ON server
fileid2 ON server 
. 
.
END

where:

fileid1, fileid2

Are ddnames for FOCUS databases you will access on the sink machine.

server

Is the ddname of the communication data set you allocated on the client ID. This data set must be allocated to ddname FOCSU in the FOCUS Database Server job.

In the USE command, you must specify all of the databases you will use under SU, but you can also specify locally controlled databases.

Example: Accessing Centrally Controlled Databases

In this example, the EMPLOYEE and EDUCFILE databases are controlled by the server whose communication data set is allocated to ddname SYNCA, and JOBFILE is controlled by the server whose communication data set is allocated to ddname SYNCB: 

USE
EMPLOYEE ON SYNCA
EDUCFILE ON SYNCA
JOBFILE ON SYNCB
END
Example: Accessing Both Centrally Controlled and Local Databases

The following USE command accesses the EMPLOYEE database controlled by the server whose communication data set is allocated to ddname SYNCA, the EDUCFILE database controlled by the server whose communication data set is allocated to ddname SYNCB, and the PRODUCT database allocated in the client address space: 

USE
EMPLOYEE ON SYNCA
EDUCFILE ON SYNCB
PRODUCT 
END

Notice that several FOCUS Database Servers can be active at the same time.
Top of page
x
Syntax: How to Specify Additional USE Options for Centrally Controlled Databases

ON may be used with AS in the USE command if the keyword READ is included. The syntax is: 

USE action
fileid [READ|NEW] [AS mastername]

or

fileid AS mastername ON server READ

or

fileid LOCAL

or

fileid ON server 
.
.
.

or

fileid AS mastername ON server READ

or

fileid LOCAL

or 

fileid ON server 
.
.
.
END

where:

action

Is one of the following:

ADD

Appends one or more new file IDs to the present directory. If you issue the USE command without the ADD parameter, the list of data sources you specify replaces the existing USE directory.

CLEAR

Erases the USE directory. The keyword END is not required with this option. Any other options specified will be ignored.

REPLACE

Replaces an existing file ID in the USE directory. This option enables you to change the file specification for the file ID and the options following the file ID.

fileid

Is the ddname of a FOCUS or XFOCUS database.

READ

Restricts data sources to read-only access.

NEW

Indicates that the data source has yet to be created.

AS mastername

Specifies the name of the Master File to be associated with the file ID.

Note: When using the AS phrase for files on the FOCUS Database Server with ON, the READ parameter is required. Write access to these files is prevented, as they are being accessed with Master Files other than those with which they were created. Only READ access is allowed in this case.

ON server

Specifies the ddname of the sink machine communication data set.

Note: When using the AS phrase for files on the FOCUS Database Server with ON, the READ parameter is required. Write access to these files is prevented, as they are being accessed with Master Files other than those with which they were created. Only READ access is allowed in this case.

LOCAL

This option requires a previous directory entry for the file ID with the ON server option. Use the LOCAL keyword to use the Multi-Threaded SU Reporting Facility.

The following options after the file ID are valid together:

READ and AS
NEW and AS
AS and ON and READ

Any other combination of options after the file ID is not valid.

Information Builders