TAA Tools
SCNPFA          SCAN PHYSICAL FILE ATTRIBUTES          TAADBMH

The Scan Physical  File Attributes command  scans one or  more physical
files for  attribute values.  This acts as  a simple query to determine
the value of attributes of physical files.

A typical command would be:

              SCNPFA    ATTR(MAINT) FILE(xxx/*ALL)
                         SCNVAL(*DLY) SCNOPR(*EQ)

A  spooled  file  would  be  displayed of  all  physical  files  in the
specified library that have a maintenance value of *DLY.

SCNPFA escape messages you can monitor for
------------------------------------------

      TAA9891    No physical files exist

Escape messages from based on functions will be re-sent.

SCNPFA Command parameters                             *CMD
-------------------------

   ATTR          The Physical File  attribute to be  scanned for.   The
                 value must be one of the following:

                 ACCPTH.  The  access path used for the  file.  It must
                 be a scan value of *ARRIVAL or *KEYED.

                 ALLOCATE.   Whether the  storage is  allocated for the
                 file.  It must be a scan value of *YES or *NO.

                 ALTCOLSEQ.   Whether an  alternate collating  sequence
                 is used.  It must be a scan value of *YES or *NO.

                 ALWDLT.   Whether  records  can  be deleted  from  the
                 file.  It must be a scan value of *YES or *NO.

                 ALWRD.   Whether  records can be  read from  the file.
                 It must be a scan value of *YES or *NO.

                 ALWUPD.  Whether records can  be updated in the  file.
                 It must be a scan value of *YES or *NO.

                 ALWWRT.   Whether  new  records can  be  added to  the
                 file.  It must be a scan value of *YES or *NO.

                 CONTIG.   Whether  the storage  for  the file  must be
                 contiguous.   It must be a  scan value of *YES or *NO.

                 CCSID.   The character set  ID used for  the file.   A
                 decimal value must be entered.

                 DLTPCT.   Whether  to  send a  message  to the  system
                 operator  if the number  of deleted  records reaches a
                 percentage.   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.

                 EXTDSC.   Whether  the  file is  externally described.
                 It must be a scan value of *YES or *NO.

                 FILEATR.  The  attribute of the  file.  It  must be  a
                 scan value of PF or PF38.

                 FILETYPE.  The type  of data in the file.   It must be
                 a scan value of *SRC or *DATA.

                 FRCACCPTH.     Whether  the  access   path  should  be
                 forced.  It must be scan value of *YES or *NO.

                 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.

                 IGCDTA.   Whether the  file can contain IGC  data.  It
                 must be a scan value of *YES or *NO.

                 LANGID.   The  language  ID  used for  the  data.    A
                 character value or *JOB may be entered.

                 LVLCHK.   Whether to  check the level  ID of  the file
                 that  was used  when  a program  opens the  file.   It
                 must be a scan value of *YES or *NO.

                 MAINT.  The  type of  maintenance to  be performed  on
                 the access path.   It must be a scan  value of *IMMED,
                 *DLY, or *REBLD.

                 MAXKEYLEN.   The  maximum  key length  used  for keyed
                 files.  A numeric scan value must be used.

                 MAXMBRS.    The  maximum number  of  members  that may
                 exist in  the  file.   A numeric  scan  value must  be
                 used.

                 NBRMBRS.   The  number of  members that  exist  in the
                 file.  A numeric scan value must be used.

                 RCDCAP.   The record capacity of  the file.  A numeric
                 scan value must be used.

                 RCDLEN.  The  record length  of the file.   A  numeric
                 scan value must be used.

                 RECOVER.    How  to  recover  the  access  path  if  a
                 failure   occurs  while  the  access   path  is  being
                 updated.   The  type of  access  path recovery  to  be
                 used.  The  scan value must  be *IPL, *AFTIPL  or *NO.

                 REUSEDLT.   Whether  to  reuse the  space  for deleted
                 records.  It must be a scan value of *YES or *NO.

                 SRTSEQ.    The sort  sequence to  be  used.   The scan
                 value  must  be  a  character  value  or  one  of  the
                 special  values  *HEX,   *JOB,  *SRC,  *LANGIDUNQ,  or
                 *LANGIDSHR

                 SRTSEQL.  The library of the sort sequence.

                 TEXT.  The scan operator must be *CT.

                 WAITFILE.   Then number of seconds  to wait for a lock
                 to be satisfied  when opening the file.   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.    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  physical  file  to  be
                 scanned.   A single physical  file, a generic name, or
                 *ALL may be entered.

                 The library  qualifier defaults  to *LIBL.   *USRLIBL,
                 *CURLIB,  *ALL, *ALLUSR,  *ALLUSR2, *ALLNONQ,  or *IBM
                 may  be  entered.   For  a full  description  of these
                 values, see the CVTLIBOBJD command.

   SCNVAL        The value to be  scanned for.  Up  to 10 bytes may  be
                 entered.

                 To  scan   for  non-blank  entries   enter  '   '  and
                 SCNOPR(*NE).

                 If  SCNOPR(*CT)  is  entered,  the  SCNVAL  should  be
                 entered   without   quotes   as   the   object    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.

   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  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:

     CVTLIBOBJD      Convert library object description
     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
   ------        ----    ---------      ----------    ----------

   SCNPFA        *CMD                   TAADBMH       QATTCMD
   TAADBMHC      *PGM       CLP         TAADBMHC      QATTCL
   TAADBMHR      *PGM       RPG         TAADBMHR      QATTRPG
					

Added to TAA Productivity tools July 15, 2009


Home Page Up to Top