Automic Workload Automation

Initial data file format 

03-12-2019 01:32 PM

When the Automation Engine is installed, one of the steps is loading initial data into the AE database. This file is usually called something like uc_ini.txt. The initial data file includes about one thousand AE objects that are required by the system to operate. The file format is very similar to the transport case file format. It is not officially documented by CA, but it has been reverse-engineered and partly documented by MichaelLowry. This document is intended to be a collaborative effort to more fully document the file format, filling in missing pieces and elaborating on important details. If you are interested in contributing, please contact one of the authorized editors.

 

Overall structure

The initial data file format consists of many records. Each record occupies a single line in the transport case file. The record type is indicated by  the first character of the line. There are five different record types. Lines beginning with a semicolon (;) are comments, and are ignored.

 

Record types

Record typeDescription
VFile & version information
TTable name
CTable column definition
FTable field data
REnd of group of data fields
;Comment

Unlike the transport case file format, the initial data file format does not separate table descriptions from table content at the bottom. Instead, both appear together. In the initial data format, the records containing the data of a table appear immediately after the records describing the structure of that table.

 

The V record

All transport case files begin with a single V record. This record encodes basic information about the file and the system whence it originates.

V08 12.3      INITIAL                                            006

Fields of record type V

DescriptionPositionLengthExample
Record   type11V
File version248
System version51012.3
File type1521INITIAL
Unknown66?006

T records

T records indicate the table to which a subsequent set of C and F records pertains.

TABLOB

Fields of record type T

DescriptionPositionLengthExample
Record type11T
Table name2?ABLOB

C records

C records describe the columns in a particular table.

C001ABLOB_AH_Idnr     300004

 

Fields of record type C

DescriptionPositionLengthExample
Record type11C
Column number231
Column name515ABLOB_AH_Idnr
Column data type2313
Column data length2454

The column numbers correspond to the order of columns in the DB schema documentation. There are several column data types.

 

Column data types

Data typeDescription
ACLOB
B?
CLong Integer
DXML
0Binary
1Byte
2Integer
3Long Integer
4Long Integer, counter
5Date/Time
6Unknown (not yet encountered)
7Text
8?
9Byte

For the Memo data types, there is usually more information about the data type in the Description field of the DB schema documentation for the corresponding table.

 

F records

F records contain the data for each field in a particular table.

F004CUC0.DEV.TEST#1_1.JOBP

Fields of record type F

DescriptionPositionLengthExample
Record type11F
Field number234
Field data type51C
Field data61UC0.DEV.TEST#1_1.JOBP

The field numbers correspond to the column numbers of the corresponding tables, and the order of columns in the DB schema documentation.

There are several field data types.

 

Field data types

Data typeDescription
-Integer
+Integer
0Byte
2Date/Time
CString
MString with byte count. Can contain multiple parts.

There may be additional types too. The date/time values in F***2 fields begin with the numeral 2 in byte 5.

Some fields of type C can contain multiple labeled parts. E.g., JBA_Rest is used to store additional attributes for z/OS jobs.

 

F records (data type M)

F records with data type M have an additional data length field that indicates the length of the data to follow.

F005M000000010key1value1

Fields of record type F, data type M

DescriptionPositionLengthExample
Record type11F
Field number235
Field data type51M
Field data length6910
Field data15variable (10 in this case)key1value1

M fields often contain multiple parts separated by ^K (control-K) characters. These fields sometimes include embedded XML.

R records

A single R record terminates a group of F records corresponding to a single row in a table (which table is indicated in the most recent preceding T record). If an R record is followed immediately by another F record, this indicates the beginning of a new row of data for the same table. If an R record is followed immediately by a T record, this indicates the beginning of records for a different table.

Differences from transport case format

Unlike the transport case file format, the initial data file format does not have O records. Instead, initial data files contain the complete set of OH and OFS records that define the folder locations of initial data objects.

 

Unlike the transport case file format, the initial data file format has no terminating S record.

Statistics
0 Favorited
8 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.