The Compare File Attribute (CMPFILA) command supports comparisons at the file and member level. Most of the attributes supported are for file-level comparisons. The #FILATR audit and the #FILATRMBR audit each invoke the CMPFILA command for the comparison phase of the audit.
Some attributes are common file attributes such as owner, authority, and creation date. Most of the attributes, however, are file-specific attributes. Examples of file-specific attributes include triggers, constraints, database relationships, and journaling information.
The difference Indicator (DIFIND) returned after comparing file attributes may depend on whether the file is defined by file entries or object entries. For instance, a attribute could be equal (*EC) to the database configuration but not equal (*NC) to the object configuration. See What attribute differences were detected.
Table 145 lists the attributes that can be compared and the value shown in the Compared Attribute (CMPATR) field in the output file. The Returned Values column lists the values you can expect in the System1 Value (SYS1VAL) and System 2 Value (SYS2VAL) columns as a result of running the comparison.
|
Attribute |
Description |
Returned Values (SYS1VAL, SYS2VAL) |
|---|---|---|
|
*ACCPTH1 |
Access path |
AR - Arrival sequence access path EV - Encoded vector with a 1-, 2-, or 4-byte vector. KC - Keyed sequence access path with duplicate keys allowed. Duplicate keys are accessed in first-changed-first-out (FCFO) order. KF - Keyed sequence access path with duplicate keys allowed. Duplicate keys are accessed in first-in-first-out (FIFO) order. KL - Keyed sequence access path with duplicate keys allowed. Duplicate keys are accessed in last-in-first-out (LIFO) order KN - Keyed sequence access path with duplicate keys allowed. No order is guaranteed when accessing duplicate keys. KU - Keyed sequence access path with no duplicate keys allowed (UNIQUE). |
|
*ACCPTHVLD2 3 |
Access path valid |
*YES, *NO |
|
*ACCPTHSIZ1 |
Access path size |
*MAX4GB, *MAX1TB |
|
*ALWDLT |
Allow delete operation |
*YES, *NO |
|
*ALWOPS |
Allow operations |
Group which checks attributes *ALWDLT, *ALWRD, *ALWUPD, *ALWWRT |
|
*ALWRD |
Allow read operation |
*YES, *NO |
|
*ALWUPD |
Allow update operation |
*YES, *NO |
|
*ALWWRT |
Allow write operation |
*YES, *NO |
|
*ASP |
Auxiliary storage pool ID |
1-16 (pre-V5R2) 1-255 (V5R2) 1 = System ASP See Comparison results for auxiliary storage pool ID (*ASP) for details. |
|
*AUDVAL |
Object audit value |
*NONE, *CHANGE, *ALL |
|
*AUT |
File authorities |
Group which checks attributes *AUTL, *PGP, *PRVAUTIND, *PUBAUTIND |
|
*AUTL |
Authority list name |
*NONE, list name |
|
*BASEDONPF2 |
Name of based-on physical file member |
33 character name in the format: library/file(member) |
|
*BASIC |
Pre-determined set of basic attributes |
Group which checks a pre-determined set of attributes. When *FILE is specified for the Comparison level (CMPLVL), these attributes are compared: *CST (group), *NBRMBR, *OBJATR, *RCDFMT, *TEXT, and *TRIGGER (group). When *MBR is specified for the Comparison level (CMPLVL) for a file identified by a data group file entry, these attributes are compared: *EXPDATE, *OBJATR, *SHARE, and *TEXT. When *MBR is specified for the Comparison level (CMPLVL) for a file that is not identified by data group file entry, these attributes are compared: *CURRCDS, *EXPDATE, *NBRDLTRCD, *OBJATR, *SHARE, and *TEXT. |
|
*CCSID1 |
Coded character set |
1-65535 |
|
*CST |
Constraint attributes |
Group which checks attributes *CSTIND, *CSTNBR |
|
*CSTIND 4 |
Constraint equal indicator |
No value, indicator only7 When this attribute is returned in output, its Difference Indicator value indicates if the number of constraints, constraint names, constraint types, and the check pending attribute are equal. For referential and check constraints, the constraint state as well as whether the constraint status is enabled or disabled is also compared. |
|
*CSTNBR 4 |
Number of constraints |
Numeric value |
|
*CURRCDS |
Current number of records |
0-4294967295 |
|
*DBCSCAP |
DBCS capable |
*YES, *NO |
|
*DBR |
Group which checks *DBRIND, *OBJATR |
|
|
*DBRIND 4 |
Database relations |
No value, indicator only7 When this attribute is returned in output, its Difference Indicator value indicates if the number of database relations and the dependent file names are equal. |
|
*EXPDATE1 |
Expiration date for member |
Blank for *NONE or date in CYYMMDD format, where C equals the century. Value 0 is 19nn and 1 is 20nn. |
|
*EXTENDED |
Pre-determined, extended set |
Valid only for Comparison level of *FILE, this group compares the basic set of attributes (*BASIC) plus an extended set of attributes. The following attributes are compared: *ACCPTH, *AUT (group), *CCSID, *CST (group), *CURRCDS, *DBR (group), *MAXKEYL, *MAXMBRS, *MAXRCDL, *NBRMBR, *OBJATR, *OWNER, *PFSIZE (group), *RCDFMT, *REUSEDLT, *SELOMT, *SQLTYP, *TEXT, and *TRIGGER (group). |
|
*FIRSTMBR1 5 |
Name of member *FIRST |
10 character name *NONE if the file has no members. |
|
*FRCKEY1 |
Force keyed access path |
*YES, *NO |
|
*FRCRATIO1 |
Records to force a write |
*NONE, 1-32767 |
|
*INCRCDS1 |
Increment number of records |
0-32767 |
|
*JOIN |
Join Logical file |
*YES, *NO Add, update, and delete authorities are not checked. Differences in these authorities do not result in an *NE condition. |
|
*JOURNAL |
Journal attributes |
Group which checks *JOURNALED, *JRN, *JRNLIB, *JRNIMG, *JRNOMIT. Results are described in Comparison results for journal status and other journal attributes. |
|
*JOURNALED |
File is currently journaled |
*YES, *NO |
|
*JRN |
Current or last journal |
10 character name, blank if never journaled |
|
*JRNIMG |
Record images |
*AFTER, *BOTH |
|
*JRNLIB |
Current or last journal library |
10 character name, blank if never journaled |
|
*JRNOMIT |
Journal entries to be omitted |
*OPNCLO, *NONE |
|
*LANGID1 |
Language ID |
3 character ID |
|
*LASTMBR1 5 |
Name of member *LAST |
10 character name *NONE if the file has no members. |
|
*LONGNAME |
SQL long name |
long SQL name (128 char value) |
|
*LVLCHK1 |
Record format level check |
*YES, *NO |
|
*MAINT1 |
Access path maintenance |
*IMMED, *REBLD, *DLY6 |
|
*MAXINC1 |
Maximum increments |
0-32767 |
|
*MAXKEYL1 |
Maximum key length |
1-2000 |
|
*MAXMBRS1 |
Maximum members |
*NOMAX, 1-32767 |
|
*MAXPCT1 |
Max % deleted records allowed |
*NONE, 1-100 |
|
*MAXRCDL1 |
Maximum record length |
1-32766 |
|
*NBRDLTRCD1 |
Current number of deleted records |
0-4294967295 |
|
*NBRMBR1 |
Number of members |
0-32767 |
|
*NBRRCDS1 |
Initial number of records |
*NOMAX, 1-2147483646 |
|
*OBJCTLLVL1 |
Object control level |
8 character user-defined value |
|
*OWNER |
File owner |
User profile name |
|
*PFSIZE |
File size attributes |
Group which checks *CURRCDS, *INCRCDS, *MAXINC, *NBRDLTRCD, *NBRRCDS |
|
*PGP |
Primary group |
*NONE, user profile name |
|
*PRVAUTIND |
Private authority indicator |
No value, indicator only7 When this attribute is returned in output, its Difference Indicator value indicates if the number of private authorities and private authority values are equal. |
|
*PUBAUTIND |
Public authority indicator |
No value, indicator only7 When this attribute is returned in output, its Difference Indicator value indicates if public authority values are equal. |
|
*RCACIND |
Row and Column Access Control (RCAC) indicator |
No value, indicator only7 When this attribute is returned in output, its Difference Indicator value indicates if RCAC values are equal. This attribute is only available on systems running IBM i 7.3 and higher. |
|
*RCDFMT |
Number of record formats |
1-32 |
|
*RECOVER1 |
Access path recovery |
*IPL, *AFTIPL, *NO |
|
*REUSEDLT1 |
Reuse deleted records |
*YES, *NO |
|
*SELOMT |
Select / omit file |
*YES, *NO |
|
*SHARE1 |
Share open data path |
*YES, *NO |
|
*SQLTYP |
SQL file type |
PF Types - NONE, TABLE, LF Types - INDEX, VIEW, NONE |
|
*SRCMBRTYP |
Source physical file member type |
10 character value |
|
*TEXT1 |
Text description |
50 character value |
|
*TMPTBLIND |
Temporal table indicator |
No value, indicator only7 When this attribute is returned in output, its Difference Indicator value indicates whether temporal settings for the table are equal. This attribute is only available on systems running IBM i 7.3 and higher. |
|
*TRIGGER |
Group which checks *TRGIND, *TRGNBR, *TRGXSTIND |
|
|
*TRGIND 4 |
Trigger equal indicator |
No value, indicator only7 When this attribute is returned in output, its Difference Indicator value indicates whether it is enabled or disabled, and if the number of triggers, trigger names, trigger time, trigger event, and trigger condition with an event type of ‘update’ are equal. |
|
*TRGNBR 4 |
Number of triggers |
Numeric value |
|
*TRGXSTIND 4 |
Trigger existence indicator |
No value, indicator only7 When this attribute is returned in output, its Difference Indicator value indicates if a trigger program exists on the system. |
|
*USRATR |
User-defined attribute |
10 character user-defined value |
|
*WAITFILE1 |
Maximum file wait time |
*IMMED, *CLS, 1-32767 |
|
*WAITRCD1 |
Maximum record wait time |
*IMMED, *NOMAX, 1-32767 |
|
1 Differences detected for this attribute are marked as *EC (equal configuration) when the compare request specified a data group and the object is configured for system journal replication with a configured object auditing value of *NONE. 2This attribute is only compared for logical file members by the #FILATRMBR audit. 3Differences detected for this attribute are marked as *EC (equal configuration) when the source is set to MAINT(*DLY) and the value for ACCPTHVLD is *NO. 4This attribute cannot be specified as input for comparing but it is included in a group attribute. When the group attribute is checked, this value may appear in the output. 5Differences detected for this attribute are marked as *EC (equal configuration) when the compare request specified a data group and the file is configured for system journal replication with a configured Omit content (OMTDTA) value of *FILE. 6Differences detected for this attributes are marked as *EC (equal configuration) when the source is set to *IMMED and the target is set to *DLY by Access Path Maintenance. 7If *PRINT is specified in the comparison, an indicator appears in the system 1 and system 2 columns. If *OUTFILE is specified, however, these values are blank. |