Solved

Viewing the overall size of a library on a tape

Posted on 2012-03-29
5
300 Views
Last Modified: 2013-08-01
I have a tape with an ERP environment on it. The env. consists of say 6 libraries. I want to know the size of each library on the tape before I restore, to make sure the env. does not max my as400 disk out.

I currently use a 3rd party command called Display Save Tape (DSPSAVTAP). It shows sizes, but only for each object within the library. I don't have enough time to go through all objects in all 6 libraries and add them up. I need a commnad that shows me the six library sizes OR the overall tape size.

Thanks.
0
Comment
Question by:MichaelKilroy
5 Comments
 
LVL 16

Accepted Solution

by:
theo kouwenhoven earned 168 total points
Comment Utility
Hi  MichaelKilroy,

Afaik there is no command that show you the librsize of a saved library,

But you mentioned : "It shows sizes, but only for each object within the library"
So store this info in a table and use SQL to give you the total (or paste it to Excel)
0
 
LVL 27

Assisted Solution

by:tliotta
tliotta earned 166 total points
Comment Utility
In many cases, there will be many elements stored on tape for a library that will not be restored. For example, when objects are saved, ownership and authority info are also saved. If there were many 'private' authorities, that can take a lot of time and space to put on tape.

OTOH, logical files might be saved as objects, but the access paths might not be saved. I've seen access paths that took more space than the physical files they were built over. There is no rational way to determine what size would result.

Other elements can increase or decrease computed values in significant ways.

Simply put, the restored size of a library can't be determined by examining a tape. It's just a fact of backup/restore.

Tom
0
 
LVL 34

Assisted Solution

by:Gary Patterson
Gary Patterson earned 166 total points
Comment Utility
Tom, of course, is right.  

Safest thing to do is to either perform the restore to another system that has plenty of space, or have a friendly IBM business partner do it for you and check the lib size after index rebuilds.  Ask you IBM rep or BP for help, and if they can't or won't post back here asking for a BP referral that can help you.

Another alternative is to just restore a few objects at a time, but if you don't have time to dump the object list to a spreadsheet and add up the object sizes, you probably don't have time to do your restore in tiny bits.

- Gary Patterson
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now