I found the clean up document that tells me to clean up *CRTNONRES objects manually.  We have not done it for a long time, maybe never.  Has anyone found a submitted way to do this?  For example, delete from I all *CRTNONRES objects with a create date older than 90 days. 
I can dig through the screens and find the files to create the SQL to feed to program to delete the objects, but why reinvent the wheel.

------------------------------
David Taylor
Senior Developer
Range Resources Corporation
Fort Worth TX US
------------------------------

Hi David,
The presentation Educational Materials - Related Objects LMi provides the steps for doing that in the clean up section on slide 45. For your convenience I have attached a copy of the presentation.

Hope this helps.

------------------------------
Newton Beckford
Senior Technical Support Engineer
Rocket Internal - All Brands
Mississauga ON CA
------------------------------

---

Hi David,
The presentation Educational Materials - Related Objects LMi provides the steps for doing that in the clean up section on slide 45. For your convenience I have attached a copy of the presentation.

Hope this helps.

------------------------------
Newton Beckford
Senior Technical Support Engineer
Rocket Internal - All Brands
Mississauga ON CA
------------------------------

Newton. 

Thank you for the link.  While this presents the information from the other link differently, the process is still very manual. We are a small shop, so time can be an issue.  Merci beaucoup.

------------------------------
David Taylor
Senior Developer
Range Resources Corporation
Fort Worth TX US
------------------------------

---

Newton. 

Thank you for the link.  While this presents the information from the other link differently, the process is still very manual. We are a small shop, so time can be an issue.  Merci beaucoup.

------------------------------
David Taylor
Senior Developer
Range Resources Corporation
Fort Worth TX US
------------------------------

David,
Yes, this is a manual process but keep in mind that this should not be a cleanup that you'll have to perform frequently. If that is the case then a review of your promotion process as it relates to dependent objects would be a good idea. The attached presentation provides tips about that as well. There shouldn't be a lot *CRTNONRES objects left behind.

In addition, as suggested in the presentation you could automate the cleanup process using LMi provided commands.

------------------------------
Newton Beckford
Senior Technical Support Engineer
Rocket Internal - All Brands
Mississauga ON CA
------------------------------

---

David,
Yes, this is a manual process but keep in mind that this should not be a cleanup that you'll have to perform frequently. If that is the case then a review of your promotion process as it relates to dependent objects would be a good idea. The attached presentation provides tips about that as well. There shouldn't be a lot *CRTNONRES objects left behind.

In addition, as suggested in the presentation you could automate the cleanup process using LMi provided commands.

------------------------------
Newton Beckford
Senior Technical Support Engineer
Rocket Internal - All Brands
Mississauga ON CA
------------------------------

Looking more once I put out this mornings fires.  Thank you again.

------------------------------
David Taylor
Senior Developer
Range Resources Corporation
Fort Worth TX US
------------------------------

---