Re: Need advice for Object cleanup

Tim, outside of looking at the last used date, days used, changed date,
etc, you may wish to create a junk library to move these objects to.

That way, if it is determined that you do need these, you have them.

If you back up your system at year end, & these haven't been asked for
since you moved them, then you can probably blow them away from this
junk library (& still have them on a yearly backup).

I do this for queries that aren't frequently used.

Thanks.
James Salter
Systems Programmer
American Cast Iron Pipe Co
Email: jsalter@xxxxxxxxxx
Phone: (205) 325-3033
Fax: (205) 307-3833

"Tim Gornall" <tgornall@xxxxxxxxxx>
Subject
Need advice for Object cleanup

I would like to clean up old unused Jobd, Jobq, etc. I ran a DSPOBJD to
outfile get lists with the last used date, etc. What gotcha's should I
lookout for basing my criteria on the last date used? For instance, if
the
last used date is zero, does that mean it's never been used, or if it's
a
year old, does that mean nothing has used it to since then?

Is there an easy way to determine if a Jobd is attached to users,
autostart
jobs, etc?

I "inherited" a few messy systems, so I really need to clean up all
types
of
objects, maybe theres a better way to go about this whole project? Any
other tricks you can recommend?

Thanks, Tim
_________Confidentiality Notice_______________________
This e-mail and any files transmitted with it is
confidential and is intended solely for the use of
the individual(s) or entity(ies) to whom this e-mail
is addressed. If you are not the intended recipient
or the person responsible for delivering the e-mail
to the intended recipient, be advised that you have
received this e-mail in error, and that any use,
disclosure, dissemination, forwarding, printing,
retention or copying of this e-mail is strictly
prohibited. If you have received this e-mail in
error, please immediately return this e-mail to
the sender and delete the e-mail from your system.
Thank you.