Solved

Command in AS400 to display the total size of the library

Posted on 2008-06-19
8
5,040 Views
Last Modified: 2012-05-05
Command to find the total size of the library in AS400. I am using the command DSPLIB OUTPUT(*PRINT),but this is going to print almost 600 pages to display the total size of the library.
0
Comment
Question by:kirankumarvoona
  • 4
  • 2
  • 2
8 Comments
 
LVL 16

Expert Comment

by:theo kouwenhoven
ID: 21821678
Hi kirankumarvoona,

The total size is mentioned at the end of the printout when you use:

                    DSPLIB LIB(MyLibrary) OUTPUT(*PRINT)

Regards,
Murph
0
 

Author Comment

by:kirankumarvoona
ID: 21821707
Is it possible to display the total size of the Library without using Print Command.
0
 
LVL 3

Accepted Solution

by:
WaldenL earned 500 total points
ID: 21821791
dspobjd <lib>/*all objtype(*all) output(*outfile) outfile(qtemp/x)
strsql
select sum(odobsz) from qtemp/x

this is from memory, so parms may not be exact, but hit f4 and you'll get there.

Remember though, if you don't have rights to an object you won't see it in the display, so do this as someone w/correct authority.

-Walden
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

Author Closing Comment

by:kirankumarvoona
ID: 31468709
That was very helpful, thanks a million, Is there any good website you can suggest for getting familiarity with AS400 commands.
0
 
LVL 3

Expert Comment

by:WaldenL
ID: 21821889
Infocenter on the ibm site is the definitive reference. But I'd check out midrange.com too. Great mailing lists to ask questions like these.
0
 

Author Comment

by:kirankumarvoona
ID: 21823003
Can you please confirm with me whether the size in AS400 is calculated in Kb?
0
 
LVL 16

Expert Comment

by:theo kouwenhoven
ID: 21825250
in bytes, if you looked to the spoolfile, it will tell you :p
0
 

Author Comment

by:kirankumarvoona
ID: 21829124
Thank you very much for your help.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
Google always has something new and amazing up its sleeve, and the most current thing that they have been working on is another step in the evolution of Google Search, from machine learning to its brilliant successor, deep learning.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

832 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