Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Viewing the overall size of a library on a tape

Posted on 2012-03-29
5
305 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
ID: 37787406
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
ID: 37788980
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 35

Assisted Solution

by:Gary Patterson
Gary Patterson earned 166 total points
ID: 37874076
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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
AS400  SNDDST Truncating 5 97
iSeries DB2 SQL - Query Missing Value 10 85
iSeries DB2 SQL - Request user input 12 60
SQL Stored Procedure Authority 3 20
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

829 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