While running ADAGER, it reported that AUTODEFER was enabled for the DB. How do I reset AUTODEFER?
Below is a run of DBUTIL. Given the fact that I had no clue regarding which command to use, I asked for "generic help". Then, I asked for specific help on the "disable" command. I was lucky and I got what I wanted. So, here is the scoop.
Assuming that your database's name is "foo", what you want to do with DBUTIL is:
If your database has a maintenance word (let's assume it is "secret"), then:
disable foo for autodefer
This is a DBUTIL run asking for help:
disable foo/secret for autodefer
HP30391C.09.00 TurboIMAGE/XL: DBUTIL (C) COPYRIGHT HEWLETT-PACKARD COMPANY 1987
ACTIVATE ADDINDEX CREATE DEACTIVATE DETACH
DISABLE DROPINDEX ENABLE ERASE EXIT
HELP MOVE PURGE REBUILDINDEX RELEASE
SECURE SET SHOW VERIFY
Commands may be abbreviated.
For help on a particular command type: 'HELP command name'.
DI[SABLE] database name[/maint word] FOR parm[[,parm]...]
Valid parameters are:
ACCESS DUMPING ILR LOGGING RECOVERY ROLLBACK AUTODEFER
MUSTRECOVER PREFETCH INDEXING HWMPUT SHADOWING DSEM