LASTAUTHFLAG control statement

Specifies the state of the READ ONLY flag and the PROHIBIT AUTHORIZATION flag in RECON after post-reorganization processing has ended.

This control statement is optional. The default is LASTAUTHFLAG=OFF.

Read syntax diagramSkip visual syntax diagramLASTAUTHFLAG=OFFORIGINAL
OFF
Issues the CHANGE.DB AUTH READOFF command to turn off all authorization flags.
ORIGINAL
Issues the CHANGE.DB command to restore the authorization flags to the original state.
Notes:
  • When NAMESWAP=NO is specified, the Smart Reorg utility does not do post-reorganization processing automatically. However, the CHANGE.DB command that is influenced by the LASTAUTHFLAG control statement is printed in the DBRC Notification Command Stream report.
  • In the following cases where additional manual post-reorganization is required, the Smart Reorg utility does not issue the CHANGE.DB command. Therefore, the LASTAUTHFLAG control statement is ignored.
    • NEWDBD control statement is specified (message HPSG0371I is issued)
    • ILDSBLD=NO is specified though ILDS needs to be rebuilt (message HPSG0374W is issued)
    • Manual prefix resolution and update are needed because the database has either external logical relationships or HISAM internal logical relationships (message HPSG0379W is issued)
    • PREFIXRES=NO is specified though prefix resolution and update are needed (message HPSG0377I is issued)
  • When the database has secondary indexes and INDEXBLD=NO or PSINDEXBLD=NO is specified, the Smart Reorg utility does not issue the CHANGE.DB command for the secondary indexes after reorganization. Therefore, the LASTAUTHFLAG control statement has no effect on secondary indexes.