Get a lot of punch from DSPOBJD *ALL/*ALL *ALL

I have a job schedule entry that automatically runs a "DSPOBJD *ALL/*ALL *ALL OUTPUT(*OUTFILE) OUTFILE(yourlib/DSPOBJD)".

I have it run every Friday and the file DSPOBJD takes up about 35 meg on my system. Which isn't bad considering how many uses I get from it.

Sometimes I have a need to check an objects history about five seconds after I have changed it. It might be to see who recompiled a program last, or when a program was last run or accessed, or when a file was changed before today. On occasion I have had a program blow because it can't find an object. I can check the DSPOBJD file to see if the object existed last Friday at the time I regenerated the file.

You can also use it to query or sequel all objects on the system to search the object's text. Something like "select * from dspobjd where odobtx like "%Census%".

I also have a DSPOBJD query that sorts the objects by size in descending order and calculates the total percentage of system a particular objects uses. It looks something like this:

        Object   PCNT   Library     Object      Object    Object Text description                        
        Size                                      Type    Attr                                          
 1,032,687,616   3.52   QSPL        Q04079N005  *FILE     PF     Spool Data Base File                    
   745,529,344   2.54   QSPL        Q04079N001  *FILE     PF     Spool Data Base File                    
   702,778,880   2.39   QDOC        QGZS531676  *DOC                                                      
   664,100,864   2.26   QSPL        Q04079N002  *FILE     PF     Spool Data Base File                    
   597,782,528   2.04   QSPL        Q04079N003  *FILE     PF     Spool Data Base File                    
   541,114,368   1.84   ATEDTA      H50MD       *FILE     PF     Contributions History               
   533,913,600   1.82   QSPL        Q04079N004  *FILE     PF     Spool Data Base File                   
   508,997,632   1.73   JOURNAL     DAILY4204   *JRNRCV          Daily Journal Receiver                  
   485,527,552   1.65   LYNCHLIB    H50MD       *FILE     PF     Contributions History 
   411,267,072   1.40   CONSTLIB    ELIG003     *JRNRCV          Hour Bank Elig Journal        
   293,752,832   1.00   QSYS        Q13F9C0003  *JRNRCV          Security auditing jrn             
   290,516,992    .99   CLAIMSDTA   H20CLMMH    *FILE     PF38   Medical History File
   245,857,728    .84   QSPL        Q00512N001  *FILE     PF     Spool Data Base File 
   221,331,456    .75   CLAIMSDTA   H22CLMMH    *FILE     PF     Medical ist
   210,464,768    .72   CLAIMSDTA   CLMSJR0005  *JRNRCV          Claims journal                    
   209,874,944    .71   ASIGPL      ADDRES1041  *JRNRCV                                                       
   171,003,904    .58   CLAIMSDTA   H44CLMMH    *FILE     PF     Medical History File                    

end of tip. 

I do have a formatted word document. If you want it, you can e-mail me.

Click here to view Cory's query definition.


The Best Web Links: Tips, tutorials and more.

Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

Read this Search400.com Featured Topic: Managing your iSeries.

Ask the Experts yourself: Our systems management gurus are waiting to answer your technical questions.

This was first published in June 2003

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.