AdagerHome 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


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

Your Adager Guide is also available online