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