The SWAMI
of VSE/VSAM

 

Backup and Recovery Questions and Answers
What do you mean, don't reorganize my files?

BACKUP OFTEN
BUT
Reorganize only when NEEDED!

I said a lot earlier in the general Q and A pages about the reliability of disk storage subsystems. This especially applies to the subsystems using RAID technologies to provide single point of failure avoidance.

You Still HAVE to BACKUP your data. Even if the disk devices don't fail, you or one of your collegues could have inadvertantly caused data to be overwritten or deleted or otherwise corrupted.

You don't need to reorganize often

Just because you backup the file, you need not restore it! Of course, you should ensure that the backup and restore procedures really work, but generally reorganization does not speed direct processing (the type that is usually done by on-line transactions). Think about how much batch window time is spent doing reorganizations, when simpler and quicker backups would be enough.

Particularly, when insert activity for a file hits one or more "hot spots", there is a high probability that CI and/or CA splits will occur during that insert activity. VSAM uses split activity to create free space within a file at the specific point where an insert must be made. If, because of clustered insert patterns, additional inserts occur in the same areas of the file, they will be able to exploit that free space efficiently.

On the other hand, consider that if you reorganize the file and leave insufficient free space at the "hot spots", VSAM will have to recreate the free space again through the split process.

A judicious balance among CI and CA freespace can accommodate random insert patterns with little or no clustering efficiently. Similarly, the VSAM CI and CA split processes make it possible to provide little to no distributed free space throughout the file, and to create free space at the point(s) of insertion.

BACKUP and RESTORE or reorganization processing can be a very significant part of critical batch window time. Trading a bit more disk space (by allocating VSAM CI and CA FREESPACE and by allowing CI and CA splits to remain in a file without reorganizing the file) can save critical batch window time and permit higher availability of on-line activity.

   
 
Up to the
Q and A
Page
Up to the
B and R
Q and A Page
E-Mail
The Swami
Go to
The Swami's
Home
 

This entire site -- including all its pages and content --
are the intellectual property of and copyright © 2002-2003 by
Dan Janda, theswami@epix.net