The Scan Member Attributes command scans one or more data base
members in a library for attribute values. For example, you can scan
for the number of members with more than 1000 records or all members
that have a keyed access path. This acts as a simple query to
determine the value of attributes of members.
A typical command would be:
SCNMBRA ATTR(NBRRCD) FILE(xxx/*ALL)
SCNVAL(100) SCNOPR(*GT)
A spooled file would be displayed of all members in the named library
that have more than 100 records.
SCNMBRA escape messages you can monitor for
-------------------------------------------
TAA9891 No members were found
Escape messages from based on functions will be re-sent.
SCNMBRA Command parameters *CMD
--------------------------
ATTR The Member attribute to be scanned for. The value
must be one of the following:
ACCPTH. The access path used for the member. It
must be a scan value of *ARRIVAL or *KEYED.
ACCPTHVLD. Whether the access path for the member
is valid to be used. The scan value must be *YES,
*NO, or *HELD.
ALLOCATE. Whether storage is allocated for the
member. The scan value must be *YES or *NO.
ALTCOLSEQ. Whether an alternate collating sequence
is used. The scan value must be *YES or *NO.
ALWDLT. Whether records can be deleted from the
member. The scan value must be *YES or *NO.
ALWRD. Whether records can be read from the member.
The scan value must be *YES or *NO.
ALWUPD. Whether records can be updated in the
member. The scan value must be *YES or *NO.
ALWWRT. Whether new records can be added to the
member. The scan value must be *YES or *NO.
CHGDAT. The last change date of the member. A date
in Job format must be used for the scan value.
CONTIG. Whether the storage for the member must be
contiguous. The scan value must be *YES or *NO.
CRTDAT. The create date of the member. A date in
Job format must be used for the scan value.
CURINC. The current number of storage increments
used. A numeric value must be entered as a scan
value.
EXPDAT. The expiration date of the member. A date
in Job format must be used for the scan value.
EXTDSC. Whether the member is externally described.
The scan value must be *YES or *NO.
FRCACCPTH. Whether the access path should be
forced. The scan value must be *YES or *NO. A
blank value may be entered for arrival sequence
access paths.
FRCRATIO. Whether to force record changes to
auxiliary storage. If the scan value is *NONE, a
scan operator of *EQ or *NE may be used. A numeric
value may also be entered as a scan value.
INXENT. The number of index entries for the member.
A numeric scan value must be used.
INXSIZ. The size of the index in bytes. A numeric
scan value must be used.
JOIN. Whether the member is of a joined file. The
scan value must be *YES or *NO.
LVLCHK. Whether to check the level ID of the member
that was used when a program opens the file. The
scan value must be *YES or *NO.
MAINT. The type of maintenance to be performed on
the access path. The scan value of *IMMED, *DLY,
*REBLD, or blank may be used. Blanks should be used
for arrival sequence members.
MAXINC. The maximum number of storage increments
that may be used to increase the size of the member.
A numeric scan value must be used.
MAXKEYLEN. The maximum key length used for keyed
members. A numeric scan value must be used.
MAXMBR. The maximum number of members that may
exist in the file. A numeric scan value must be
used unless the value *NOMAX is entered.
MAXRCDLEN. The maximum record length of the member.
A numeric scan value must be used.
NBRDLTRCD. The number of deleted records that exist
in the member. A numeric scan value must be used.
NBRFMT. The number of formats in the member. A
numeric scan value must be used.
NBRMBR. The number of members that exist in the
file. A numeric scan value must be used.
NBRRCD. The number of records that exist in the
member. A numeric scan value must be used.
RCDCAP. The maximum number of records that may
exist in the member. If *NOMAX is entered the scan
operator must be *EQ or *NE. A numeric value may
also be entered as a scan value.
RSTDAT. The restore date of the member. A date in
Job format must be used for the scan value.
SAVDAT. The save date of the member. A date in Job
format must be used for the scan value.
SELOMT. Whether select/omit of key values is used
for the member. The scan value must be *YES or *NO.
SRCCHGDAT. The last source change date of the
member. A date in Job format must be used for the
scan value. The value is only meaningful for source
members.
SRCTYPE. The source type such as CLP, PF, RPG, etc.
The source types described as valid for WRKMBRPDM
MBRTYPE parameter may be used. The value is only
meaningful for source members.
TEXT. The member text. The scan operator must be
*CT. The scan value should be entered in upper
case. The member text is folded to upper case
before scanning. Trailing blanks are trimmed off
the scan value.
USEDAT. The last used date of the member. A date
in Job format must be used for the scan value.
WAITFILE. Then number of seconds to wait for a lock
to be satisfied when opening the member. If the
scan value is *IMMED or *CLS, the scan operator must
be *EQ or *NE. A numeric value may be entered.
WAITRCD. The number of seconds to wait for
accessing a record that is locked in the member. If
the scan value is *IMMED or *NOMAX, the scan
operator must be *EQ or *NE. A numeric value may be
entered.
FILE The qualified name of the file to be scanned. A
single file, a generic name, or *ALL may be entered.
The library qualifier must be entered as a specific
library name.
SCNVAL The value to be scanned for. Up to 10 bytes may be
entered.
To scan for blank entries, leave the value blank.
If SCNOPR(*CT) is entered when ATTR(TEXT) is
specified, the SCNVAL should be entered without
quotes as the member text description will be folded
to upper case before scanning.
SCNOPR The scan operator to be used. *EQ is the default.
*NE, *GT, *GE, *LT, *LE, or *CT (contains) may be
entered. Non-meaningful functions such as scanning
the ALLOCATE attribute (supports only *YES or *NO)
for a scan operator other than *EQ/*NE are rejected.
MBR The member name to be scanned.
*ALL is the default for all members of the named
file.
A specific or generic member may also be entered.
DATATYPE The type of members to be scanned.
*ALL is the default for all types.
*DATA may be entered to scan just data type members.
*SRC may be entered to scan just source members.
FILETYPE The type of file be scanned.
*ALL is the default for all types.
*PF may be entered to scan just physical files.
*LF may be entered to scan just logical files.
OUTPUT How to output the results. * is the default to
display the spooled file if the command is entered
interactively. The spooled file is deleted after it
is displayed if it is ended with F3/F12 or the Enter
key. To retain the spooled file, you may use the
the System Request 'Cancel' function and the spooled
file will exist in a HLD status.
If the command is entered in batch or *PRINT is
specified, the spooled file is output and retained.
Restrictions
------------
None.
Prerequisites
-------------
The following TAA Tools must be on your system:
CHKGENERC Check generic
CHKOBJ3 Check object 3
CHKSRCTYP3 Check source type 3
CVTDAT Convert date
CVTMBRD Convert member description
RSNLSTMSG Resend last message
RTVVALA Retrieve value attributes
RTVSYSVAL3 Retrieve system value 3
SNDCOMPMSG Send completion message
SNDESCINF Send escape information
SNDESCMSG Send escape message
Implementation
--------------
None, the tool is ready to use.
Objects used by the tool
------------------------
Object Type Attribute Src member Src file
------ ---- --------- ---------- ----------
SCNMBRA *CMD TAADBOF QATTCMD
TAADBOFC *PGM CLP TAADBOFC QATTCL
TAADBOFR *PGM RPG TAADBOFR QATTRPG
|
