HP 3000 Manuals HP 3000 Manuals
Selecting Tables to Synchronize
Selecting Tables to Synchronize
Check that table definitions in the data dictionary match the current
characteristics of the table sources, using the Synchronization Main
(SYM) screen.
Table 9-1 describes the fields in the Synchronization Main screen.
For each of the three types of tables, here is what is checked:
* IMAGE tables:
The database name, the group name, the account name, the database
password, the open mode, and the dataset name are checked.
For each item in the table, the item name, the item kind (view,
search, key, or normal), the type designator (integer, real, and
so forth), the length, the number of sub-items (if applicable),
and IMSAM key values (if applicable) are also checked.
* File tables:
The file name and type, the group name, the account name, the
lockword, and the record size are checked. Item length and offset
are checked to ensure that neither the file record length nor the
maximum record length supported by Access Server are exceeded.
Item definition overlap is also checked.
For each item in a table derived from an SD or BRW/IRF file, the
name, type (integer, real, numeric, and so forth), offset, and
length are checked. All mismatches are reported. For each key
item in a table derived from a KSAM file, the type, offset, and
length are checked. Actual data in a file table is checked by
verifying sample values (up to 12 records) for free- format
numeric, packed, and zoned data. (Integer, real, logical, and
character data cannot be verified.)
* View tables:
View table definitions are checked, for the most part, against the
definitions of the tables named in the Using Clause.
Item names are checked against the source; that is, the dataset,
catalog, or file is checked for an item name match. Item
attributes, however, are only checked against the data dictionary
definitions of the source tables.
You can perform the synchronization check:
* Interactively, if you only complete the Synchronization Option on
the screen, or
* By creating a batch input file for later processing, if you also
complete the File field and related fields.
The Synchronization Main screen looks like this.
______________________________________________________________________________________________
| |
| |
| SYNC Synchronization Main Screen: SYM |
| Type in the information and press ENTER. |
| |
| |
| 1. All configured tables |
| 2. Selected configured tables |
| |
| 3. All tables by HP 3000 system |
| 4. All tables by IMAGE database |
| 5. All tables by file |
| |
| |
| |
| Synchronization Option |
| |
| |
| File.Group.Account . . ______ Lockword |
| (Specify to create a batch input file for later processing.) |
| |
| |
| |
| Help ADMIN |
| Main |
| |
______________________________________________________________________________________________
Table 9-1. Synchronization Main Screen Fields
--------------------------------------------------------------------------------------------
| | |
| Field | Description |
| | |
--------------------------------------------------------------------------------------------
| | |
| Synchronization | The kind of synchronization check you want to perform. |
| Option | |
| | 1 All configured tables. Checks all view, IMAGE, and file tables. |
| | |
| | 2 Selected configured tables. Checks configured tables you specify |
| | on the Synchronize Configured Tables screen. |
| | |
| | 3 All tables by HP 3000 system. Checks IMAGE, file, and view tables |
| | derived (in whole or in part) from data sources on the system you |
| | specify on the Synchronize Tables by HP 3000 System screen. |
| | |
| | 4 All tables by IMAGE database. Checks IMAGE and view tables derived |
| | (in whole or in part) from the database you specify on the |
| | Synchronize Tables by IMAGE Database screen. |
| | |
| | 5 All tables by file. Checks file tables and view tables derived (in |
| | whole or in part) from the file you specify on the Synchronize Tables |
| | by File screen. |
| | |
--------------------------------------------------------------------------------------------
| | |
| File | (Optional.) Name of a new MPE file to be used for batch input at |
| | some later time. Filling in this field (along with any of the |
| | attribute fields that follow) means the synchronization check will |
| | not be done interactively. Instead, the tables or groups of tables |
| | you want to check will be identified in the new file, for later |
| | processing. (See "To Create and Process...", below.) |
| | |
--------------------------------------------------------------------------------------------
| | |
| Group | (Optional.) MPE group where file resides. If not specified, logon |
| | group is assumed. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Account | (Display-only.) Your MPE logon account. MPE security disallows |
| | keeping files across account boundaries. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Lockword | (Optional.) Lockword for the new file. When you process the file |
| | later, you will be prompted for its lockword. |
| | |
--------------------------------------------------------------------------------------------
DBA Capabilities.
If you are the primary DBA, you can check synchronization of any table
definition in the data dictionary. If you are a secondary DBA, you can
only check the synchronization of table definitions that you control.
To Check All Configured Tables Interactively:.
1. Go to the Synchronization Main screen by typing SYM in the Go to
screen field of any menu, or by choosing Sync f4 at the
Administrator Utility Main Menu.
2. Type a 1 in the Synchronization Option field. Leave the remaining
fields blank.
NOTE Once the synchronization check has begun, it cannot be interrupted
except by breaking out of the Administrator Utility and aborting
it.
3. Press Enter.
Each configured table is checked in turn. A status message at the
top of the Synchronization Summary screen indicates which table is
being checked and the current table count out of the total number
of tables.
When all tables have been checked, the Synchronization Summary
screen is filled in with a summary of the results. You can either
print out a full report (which goes to ADMSYLST) or investigate
the details interactively using the Synchronization Detail screen.
(See "To Check for Errors," below.)
4. To leave the Synchronization Summary screen, first choose Done
f8 to reach the Synchronization Main screen, then choose ADMIN
Main f8 to reach the Administrator Utility Main Menu. From there,
you can go to another screen or exit the utility.
To Check Individual Tables Interactively:.
1. Go to the Synchronization Main screen by typing SYM in the Go to
screen field of any menu, or by choosing Sync f4 at the
Administrator Utility Main Menu.
2. Type a 2 in the Synchronization Option field. Leave the remaining
fields blank.
3. Press Enter.
The Synchronize Configured Tables screen appears.
4. Type the name of a configured table in the Table field, then press
Enter.
The specified table is checked. The Synchronization Detail screen
appears with the results of the check.
If you want to print out the results to ADMLIST, choose Print f1.
5. Choose Done f8 to return to the Synchronize Configured Tables
screen.
To check another table, go to Step 4.
6. To leave the Synchronize Configured Tables screen, choose Done
f8 to reach the Synchronization Main screen, then choose ADMIN
Main f8 to reach the Administrator Utility Main Menu. From there,
you can go to another screen or exit the utility.
To Check Groups of Tables Interactively:.
1. Go to the Synchronization Main screen by typing SYM in the Go to
screen field of any menu, or by choosing Sync f4 at the
Administrator Utility Main Menu.
2. Type a 3, 4, 5, or 6 in the Synchronization Option field. Leave
the remaining fields blank.
_________________________________________________________________
NOTE Once the synchronization check has begun, it cannot be
interrupted except by breaking out of the Administrator
Utility and aborting it.
_________________________________________________________________
3. Press Enter.
If you chose Option 3, the Synchronize Tables by HP 3000 System
screen appears. Fill in the Remote System field or leave it blank
for the host system.
If you chose Option 4, the Synchronize Tables by IMAGE Database
screen appears. Fill in the Database field and any additional
fields required to uniquely identify the database.
If you chose Option 5, the Synchronize Tables by File screen
appears. Fill in the File field and any additional fields
required to uniquely identify the file.
_________________________________________________________________
NOTE If a file table definition references a file equation
instead of an actual file, the file equation must be issued
prior to synchronizing your tables. Otherwise, the file
cannot be opened.
_________________________________________________________________
4. Press Enter.
Each configured table is checked in turn. A status message at the
top of the Synchronization Summary screen indicates which table is
being checked and the current table count out of the total number
of tables.
When all tables have been checked, the Synchronization Summary
screen is filled in with a summary of the results. You can either
print out a full report (which goes to ADMSYLST) or investigate
the details interactively using the Synchronization Detail screen.
(See "To Check for Errors," below.)
5. To leave the Synchronization Summary screen, choose Done f8 to
reach the screen you came from (which varies according to the
option chosen), choose Done f8 to reach the Synchronization Main
screen, then choose ADMIN Main f8 to reach the Administrator
Utility Main Menu. From there, you can go to another screen or
exit the utility.
To Create and Process a Batch Input File:.
1. Go to the Synchronization Main screen by typing SYM in the Go to
screen field of any menu, or by choosing Sync f4 at the
Administrator Utility Main Menu.
2. Fill in the Synchronization Option field, the File field, and any
of the optional fields if necessary.
3. Press Enter.
If you chose Option 1, the batch input file is created and a
message to that effect appears on the screen. Now skip to Step 6.
If you chose Option 2, the Synchronize Configured Tables screen
appears. Fill in the Table field.
If you chose Option 3, the Synchronize Tables by HP 3000 System
screen appears. Fill in the Remote System field or leave it blank
for the host system.
If you chose Option 4, the Synchronize Tables by IMAGE Database
screen appears. Fill in the Database field and any additional
fields required to uniquely identify the database.
If you chose Option 5, the Synchronize Tables by File screen
appears. Fill in the File field and any additional fields
required to uniquely identify the file.
_________________________________________________________________
NOTE For Option 4, if you fill in the Database Password field
(which may be required to uniquely identify the database),
it will be written to the batch input file. To preserve
your IMAGE security, since the batch input file is not a
privileged file, we strongly recommend that you use the
Lockword field to secure the file or else secure the group
and account where the file resides.
_________________________________________________________________
4. Press Enter.
An entry for the table or group of tables specified is added to
the batch input file and the screen clears to allow you to specify
more tables or groups of tables.
5. If you want to check more tables, or more of the same grouping of
tables, continue to specify them and press Enter.
When you are finished, choose Done f8 to return to the
Synchronization Main screen.
6. To add another option to the same batch input file, type in the
new option in the Synchronization Option field and go to Step 3.
To close the current batch input file and create a new one, type
in the new file information, type in your first synchronization
option, and go to Step 3.
To close the current batch input file and do some interactive
checking, blank out the File fields and go to Step 2 in one of the
three interactive procedures ("To Check..."), above.
7. When you want to leave the Synchronization Main screen, choose
ADMIN Main f8. This closes the current batch input file and
returns you to the Administrator Utility Main Menu. From there,
you can
go to another screen or exit the utility.
_________________________________________________________________
NOTE You can do the following steps interactively or as a batch
job.
_________________________________________________________________
8. To process the batch input file, equate the file ADMSYNC to your
batch input file and run ADMIN.PPC.SYS with PARM=10 and an INFO
string identifying the DBA and password. If no INFO string is
provided, you will be prompted for your user name and password (if
running interactively).
If an error occurs, the JCW ADMSYNCJCW is set to a non-zero value.
This JCW can be checked in a batch job to determine if $STDLIST
contains an error or if it can be deleted. For example:
:JOB SYNCTEST,USER.ACCT,GROUP
:FILE ADMSYNC=INPTFILE/lockword
:RUN ADMIN.PPC.SYS;PARM=10;
INFO="ADMIN/password"
:IF ADMSYNCJCW <> 0 THEN
: TELL USER.ACCT; Batch file error.
:ELSE
: SET STDLIST=DELETE
: TELL USER.ACCT; Batch file OK.
:ENDIF
:EOJ
If no INFO string is provided in the job, you will not be prompted
for your user name and password.
The synchronization check is performed and a detailed report,
containing the information that appears interactively on the
Synchronization Detail screen, is sent to the file ADMSYLST, which
prints immediately to the default or other specified printer. (To
specify another printer, set up a file equation for ADMSYLST
before running the Administrator Utility.)
Batch Input File Format
Batch input files are normal ASCII files that can be edited directly if
you choose.
Each line of the file represents one request to check synchronization.
You can have a maximum of 1023 requests in any one file. (The example
below shows a batch input file with seven requests.)
* The first position in each line contains the number of the
Synchronization Option.
* The second position contains a blank.
* The remainder of the line contains, all in uppercase, any further
information required in the corresponding screen. In the two
instances where there are multiple fields, the fields follow one
after the other, without break, in the order they appear on the
screen.
Any non-blank characters following the field information will
cause the batch input file to fail with the error:
Unrecognized record in batch file (AC4725)
NOTE Some editors (such as TDP/3000) store line numbers at the end of
each line. These line numbers will cause the error condition
mentioned above. To avoid this problem, keep the file unnumbered.
Here's an example of a batch input file, followed by an explanation of
each line:
2 BIGTABLE
1
3 REMOTE2
3
4 MYDATAOURGROUPACCOUNTXREMOTE10PASSWORD
4 MYDATA PASSWORD
5 MYFILE OURGROUPACCOUNTZREMOTE12
Line 1 is a request to check the individual table called BIGTABLE. Since
the Table field is 16 characters long, the table name can be a maximum of
16 characters.
Line 2 is a request to check all tables. Nothing follows the 1 because
no further information is required.
Line 3 is a request to check all tables derived (in whole or in part)
from databases and files on the remote HP 3000 called REMOTE2. Since the
Remote System field is eight characters long, the remote system name can
be a maximum of eight characters.
Line 4 is a request to check all tables derived (in whole or in part)
from databases and files on the host HP 3000.
Line 5 is a request to check all tables derived (in whole or in part)
from the database MYDATA located in OURGROUP.ACCOUNTX on the remote HP
3000 called REMOTE10. The database is to be opened with the password
PASSWORD. The first field is six characters long; the others are eight
characters long.
Line 6 is identical to the request on line 5, assuming that the database
name and the password uniquely identify the database definition we're
interested in.
NOTE When you create the batch input file, if you fill in the Database
Password field (which may be required to uniquely identify the
database) on the Synchronize Tables by IMAGE Database screen, it
will be written to the batch input file. To preserve your IMAGE
security, since the batch input file is not a privileged file, we
strongly recommend that you use the Lockword field to secure the
file or else secure the group and account where the file resides.
Line 7 is a request to check all tables derived (in whole or in part)
from the file MYFILE located in OURGROUP.ACCOUNTZ on the remote HP 3000
called REMOTE12.