ggarri2910
ADSM.ORG Member
Hey Gang-
Does anyone know if there is a way to run a select statement to search for a file in a NDMP TOC?
Does anyone know if there is a way to run a select statement to search for a file in a NDMP TOC?
-
-
Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
Select statement to search TOC?
- Thread starter ggarri2910
- Start date
madferret2277
ADSM.ORG Member
- Joined
- Oct 1, 2008
- Messages
- 28
- Reaction score
- 3
- Points
- 0
Sorry, not possible.
TonyB
ADSM.ORG Senior Member
Indeed...the TOC file is stored as a single object - when queried during a restore the TOC file is unpacked into a temporary table and scanned at query time.
ggarri2910
ADSM.ORG Member
Well that sucks 
NDMP has a long way to go with TSM.
NDMP has a long way to go with TSM.
TonyB
ADSM.ORG Senior Member
Well that sucks
NDMP has a long way to go with TSM.
Its a trade-off, really - if you stored the TOC in a persistent table there'd be significant TSM database bloat involved, with all of the expiration overhead. Assume you've got a big NAS infrastructure with 100s of millions of objects on it...one of the big advantages of storing the data as an NDMP image in TSM is that you have the tape overhead without the management overhead. All of that advantage goes away if you have a persistent store of references within each image.
I can see why the devs/designers chose to implement a runtime based method.
