TAA Tools
CHGMAXMBR       CHANGE MAXIMUM MEMBERS                 TAADBOJ

The  Change Maximum  Members  command  changes  the number  of  maximum
members  for one  or  more data  base  files in  a library  based  on a
specified  percentage.   Only data physical  files are  processed.  The
command  defaults   to  'check'   meaning  no   changes  occur   unless
ACTION(*CHANGE) is specified.

You must have *ALLOBJ special authority to use CHGMAXMBR.

Changing a  file requires exclusive  use of the  file.  You  cannot use
ACTION(*CHANGE) to cause a change on a file that is in use.

A typical command would be:

             CHGMAXMBR  FILE(xxx/*ALL) CURPCTLMT(75) NEWPCTLMT(65)

All  data  base files  in  the named  library  would be  checked.   One
record for each file would be listed with:

        - The number of existing members
        - The current maximum allowed
        - The current percentage used of the maximum

If the percentage used is greater than the NEWPCTLMT specified:

        - The new maximum to be set
        - The new percentage of usage

Source  files  are  always  bypassed  and  flagged.    Files  that  are
specified as MAXMBRS(*NOMAX)  are bypassed as well as  those files that
allow only one member or have no members.

Because  the default  is ACTION(*CHECK), no  changes would  occur which
allows you to review  the changes that  would occur if  ACTION(*CHANGE)
was specified.

Using ACTION(*CHANGE) produces  the same listing along with  any errors
such as  the file is  allocated and cannot  be changed.   CHGPF is used
internally to change the file.

Example
-------

Assume  you created a file  and specified that the  file have a maximum
of 10 members and that 8  exist.  This is an 80% usage of  the maximum.

If  the default of  75% is  used for  CURPCTLMT, the  CHGDBFINC command
would  identify that the file  capacity must be increased.   Assume you
used a value of 70% for the NEWPCTLMT.

Changing the maximum to 11  members would increase the percentage  used
to  73%.   Changing  the  maximum  to  12  members would  increase  the
percentage  used  to  67%.    Therefore,  changing  the maximum  to  12
members would be proposed by  ACTION(*CHECK) and the new maximum  would
be set by ACTION(*CHANGE).

Recovering from a CHGMAXMBR error
---------------------------------

The  most   typical   error  is   that  the   file  is   in  use   when
ACTION(*CHANGE) is specified.

You can recover  by waiting for a time when the file  is not in use and
run  CHGMAXMBR again  or just  use CHGPF  with the  recommended MAXMBRS
value.

CHGMAXMBR escape messages you can monitor for
---------------------------------------------

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

CHGMAXMBR Command parameters                          *CMD
----------------------------

   FILE          The qualified  name of the  file to  be processed.   A
                 single or  generic name may be entered  or the special
                 value *ALL.  A specific library must be named.

                 Only  data  physical  files  are  processed.    Source
                 files are flagged and bypassed.

   CURPCTLMT     The current  percent  of existing  members  that  will
                 cause a change.  The default is 75%.

                 See  the previous  example  to  understand a  specific
                 situation.

   NEWPCTLMT     The  new  percent  limit  of  existing  members.   The
                 default is  *CURPCTLMT  meaning  the  value  specified
                 for CURPCTLMT.

                 If the  CURPCTLMT is  greater than  the percentage  of
                 existing members  used, the maximum  number of members
                 will  be changed  to decrease  the percentage  used to
                 meet the NEWPCTLMT value specified.

                 If a value is  entered, it cannot be greater  than the
                 CURPCTLMT value.

   ACTION        The type of action to be performed.

                 *CHECK  is  the default  that  produces  a listing  of
                 what would be changed.

                 *CHANGE  may   be  specified  to  change  the  maximum
                 number  of  members   allowed  for   a  file  if   the
                 CURPCTLMT percentage is not met.

   OUTPUT        How  to output  the  results.   *  is  the default  to
                 display  the spooled  file if  the command  is entered
                 interactively.  If  the display is  ended with  F3/F12
                 or the  Enter key, the  spooled file is  deleted after
                 it  is displayed.   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:

     CHKALLOBJ       Check *ALLOBJ special authority
     CHKOBJ3         Check object 3
     EDTVAR          Edit variable
     RSNLSTMSG       Resend last message
     RTVDIAGMSG      Retrieve diagnostic message
     RTVSYSVAL3      Retrieve system value 3
     SNDCOMPMSG      Send completion message
     SNDESCINF       Send escape information
     SNDESCMSG       Send escape message
     SNDSTSCNT       Send status count
     SNDSTSMSG       Send status message

Implementation
--------------

None, the tool is ready to use.

Objects used by the tool
------------------------

   Object        Type    Attribute      Src member    Src file
   ------        ----    ---------      ----------    ----------

   CHGMAXMBR     *CMD                   TAADBOJ       QATTCMD
   TAADBOJC      *PGM       CLP         TAADBOJC      QATTCL
   TAADBOJR      *PGM       RPG         TAADBOJR      QATTRPG
					

Added to TAA Productivity tools January 15, 2014


Home Page Up to Top