Figure 30: System environment in the restructuring phase
Realms
User realms
You can query which user realms BALTER needs during the restructuring phase in an analysis run for which REPORT IS YES EXECUTION IS NO has been specified.
These user realms are not yet accessed. BALTER does not access the needed user realms until the restructuring phase itself.Added realms
Unless temporary, these realms must be created with the CREATE-FILE command before the restructuring phase is started, under the file name:
dbname.realm-name
Work files
During the restructuring phase, BALTER requires two work files on disk. It automatically creates these on public disks under the appropriate user identification and deletes them once the run has normally terminated.
The default names for these files are the link names SCRTCH1 and SORTWK:
SCRTCH1 | is required by BALTER for buffering information concerning the re-storage and modification of records and the creation of tables |
SORTWK | requires the SORT used by BALTER for sorting internal evaluation records (see the manual "SORT (BS2000)"). |
If the two work files are to be created explicitly, they must have the following attributes:
work-file-1
The primary allocation for work file 1 should be based on the data population that is to be buffered. There should always be an appropriate secondary allocation in case it should be necessary to extend the storage space.
SCRTCH1 file link name
PAM access method
The data population for buffering can be calculated approximately using the following formula:
max(key-length x no.-of-records) x 3 Bytes
key-length
total length of all keys required. The value 8 should be chosen as the minimum.
max
maximum value obtained when processing various record types.
work-file-2
SORT needs work file 2 if there is not enough virtual memory for pre-sorting. The primary allocation should be based on the data population that is to be sorted while taking account of the safety factor recommended by SORT (see the discussion of work files in the manual "SORT (BS2000)"). There should always be an appropriate secondary allocation in case it is necessary to extend the storage space.
SORTWK file link name
PAM access method
The sort data population can be calculated approximately using the following formula:
max(rec-length x no.-of-records) Bytes
rec-length | length of a record incl. SCD |
max | maximum value obtained when processing various record types |
If you do not set up the two work files yourself, BALTER creates them with the following names and sizes:
UTI.tsn.SCRTCH1 (360,360)
UTI.tsn.SORTWK (120,120)
tsn is the task sequence number under which BALTER is started.