Problem solve Get help with specific problems with your technologies, process and projects.

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

Check out this tip to get thee most out of DSPOBJD *ALL/*ALL *ALL.

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


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 Featured Topic: Managing your iSeries.

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

This was last published in June 2003

Dig Deeper on Implementation

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.