Description of BALTER messages

The messages which BALTER issues to SYSOUT enable its activities to be monitored:

Message	Meaning
*** ANALYSE-PHASE ***	Start message for analysis phase
*** REPORT-PHASE ***	Start message for REPORT phase with the analysis report
*** EXECUTION-PHASE ***	Start message for restructuring phase
NO ERRORS DETECTED IN SCHEMA CHANGES	Self-explanatory
ERRORS DETECTED IN SCHEMA CHANGES	Self-explanatory
DATABASE ALTERED	Stored data adapted to schema changes
DATABASE NOT ALTERED	Stored data not adapted to schema changes
NUMBER OF DATABASE ACCESSES integer	Self-explanatory
NUMBER OF FILE ACCESSES integer	Self-explanatory
NUMBER OF SORT ACCESSES integer	Self-explanatory

Table 43: General BALTER messages

Action indicators

Message	Meaning
PRINTOUT OF THE USED TAB2-INDICES TAB2-INDEX number FOR RECORD rec-name PRINTOUT OF TAB3- & TAB4-INDICES FOR         MATCHING AND SINGULAR SETS TAB3-INDEX number FOR SET set-name TAB4-INDEX number FOR SET set-name KEY-REF keyref	The TAB-INDICES are used for diagnostic purposes only. They give information about BALTER activities and changes to record types, sets and keys.

Table 44: TAB-INDICES

Restructuring messages

During the restructuring phase BALTER logs to SYSOUT all changes it makes to record types, sets or keys:

Message	Meaning
REALM ADDED TO DATABASE: realm-name	Self-explanatory
RECORD DELETED FROM DATABASE: record-name	Self-explanatory
RECORD ADDED TO DATABASE: record-name	Self-explanatory
RECORD MODIFICATION STARTED FOR: REC NAME: record-name REC REF : record-reference	Self-explanatory
SET REF : set-no SET NAME: set-name	Modification/creation of set set-name begun
CALCKEY TABLE	Modification/creation of CALC-key table begun
SORTKEY TABLE, DBTT COLUMN NR: integer	Modification/creation of SORT key table begun; DBTT column no.: integer
SEARCHKEY TABLE, DBTT COLUMN NR: integer	Modification/creation of SEARCH key table begun; DBTT column no.: integer
TABLE FILLING IS integer PERCENT	Occupancy level for specified table is integer per cent; only shown if FILLING (Format 1) has been specified
MINIMUM TABLE SIZE FROM POPULATION: integer ENTRIES	The table size was determined on the basis of the POPULATION clause and the table contains integer entries; appears only if FILLING (Format 2) was specified
CALC SEARCHKEY TABLE	Creation of indirect hash area for CALC SEARCH key begun
ALLOCATION OF LIST RECORDS STARTED	Self-explanatory
STORING DATABASE RECORDS	Self-explanatory
DELETION OF REALM: realm-name	Self-explanatory

Table 45: Restructuring messages