View Darren Duke's profile on LinkedIn
Admin

Darren Duke Blog Zone

If you have Transaction Logging enabled on your servers and you run a FIXUP.....

Darren Duke  August 27 2012 10:46:45 AM
.....be sure to use the -J option.

Transaction logging is good for servers. It's like your parents telling you to eat more fiber, you don't ask why just know that it is. However if you run fixup on database that is transaction logged then it will not actually do anything to that database.

Unless you run it like this that is:

load fixup -F -J dbname



Comments

Gravatar Image  1David Schaffer  8/27/2012 3:08:14 PM  fixup switches

I've got servers with a weekly program document for "fixup -f -v -l". Probably been that way since R7. Never changed when we added transaction logging and DAOS.

OK to just add -J?

Gravatar Image  2ML  8/28/2012 2:39:56 AM  load fixup

load fixup [database] -J

Runs fixup against databases that have transaction logging enabled. If this parameter isn't used, fixup doesn't check these databases.

Gravatar Image  3Darren Duke  8/29/2012 8:33:03 AM  fixup switches

It may affect you if you use Archived Transaction Logging, so make sure to do a full NSF backup after fixup if you are using archived mode. Otherwise there is no issue other than you are running fixup for the first time in years ;)

Gravatar Image  4Ben Rose  9/10/2012 5:01:17 AM  No Need

David,

If using transactional logging, you should disable all scheduled fixup tasks. They aren't required.

Gravatar Image  5Rodney Loureiro  4/10/2013 5:04:39 PM  Same subject

About the subject, I have two questions. The transaction loggin file is necessarily a nsf file, or can be a simple data directory? And in case of the directory, how I set the fixup command?

    NOTE: - Email, name and subject are required, otherwise I'll have to approve the comment.....