Using Centrally Controlled Databases

How to: Access Centrally Controlled Databases Specify Additional USE Options for Centrally Controlled Databases Example: Accessing Centrally Controlled Databases Accessing Both Centrally Controlled and Local Databases

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:

• A ddname of your choice.
• The data set name of the file allocated to ddname FOCSU by the sink machine.
• A disposition of SHR.

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 would 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.

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 sinkid
fileid2 ON sinkid
. 
.
END

where:

fileid1, fileid2

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

sinkid

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 sink machines can be active at the same time.

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 
.
.
.
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.

ON server

Specifies the ddname of the sink machine communication data set.

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.