Adager Questions and Answers		(Section 13 of 13)
	First | Prev	Table of Contents

Your Adager Guide is also available online

---

How do I reset AUTODEFER on a database?

---

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:

disable foo for autodefer

If your database has a maintenance word (let's assume it is "secret"), then:

disable foo/secret for autodefer

This is a DBUTIL run asking for help:

:run dbutil.pub.sys
HP30391C.09.00 TurboIMAGE/XL:  DBUTIL (C) COPYRIGHT HEWLETT-PACKARD COMPANY 1987
>>help
Commands are:
   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'.

>>help disable

       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
             DEADLOCKDETECT OLDINFOLIMITS

>>exit
End Run

	Adager Questions and Answers		(Section 13 of 13)
	First | Prev	Table of Contents

Your Adager Guide is also available online