×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to delete obsolete Distribution Points?

How to delete obsolete Distribution Points?

How to delete obsolete Distribution Points?

(OP)
Hi All,

I get Error 2302 in the SMS_DISTRIBUTION_MANAGER for non-existing Distribution Points. These Distribution Points were removed from SMS long back. How to remove non-existing/obsolete Distribution Points completely from SMS?

-Keshav

RE: How to delete obsolete Distribution Points?

From a MYITForum.com post:
http://www.myitforum.com/forums/m_158677/tm.htm

If so you can use this SQL syntax to locate the DP's in the DB and then you can remove them.  In the display 1 syntax, replace the sitecode with the sitecode of site B.  This should give you a list of known DP's to that site.  


Display 1
Select * from pkgstatus where Sitecode = 'XXX'
Select * from pkgservers where Sitecode = 'XXX'


In display 2, choose the name of the DP you'd wish to remove.

Display 2
Select * from pkgstatus where Sitecode = 'XXX' and pkgserver like '%dp-name%'
Select * from pkgservers where Sitecode = 'XXX' and nalpath like '%dp-name%'

Once your satisifed that you have the DP you wish to delete listed in the syntax of Display 2, then enter that Dp's name into the Delete 1.

Delete 1
Delete from pkgstatus where Sitecode = 'XXX' and pkgserver like '%dp-name%'
Delete from pkgservers where Sitecode = 'XXX' and nalpath like '%dp-name%'

You can repeat the steps as many times as necessary.  This should remove the DP's from SMS know list of DPs.

As always, double-check and make sure your deleting the correct one, otherwise all your DP's could be deleted.

RE: How to delete obsolete Distribution Points?

(OP)
Thanks very much for your reply. I am yet to try your suggestion. Before that, I would like to clarify one more thing. The sites are still active. Only the distribution points for these sites have changed. Can I still execute the steps?

-Keshav

RE: How to delete obsolete Distribution Points?

Yes these are for deleting specific DP's from the SMS db.  The only reason you would do it this way was if someone just "unplugged" the DP so you couldnt go to the SMS console and remove them properly through that method.  If you read the entire link up there it should explain why they got to this point to have to remove the DP's this way.

Tim B

RE: How to delete obsolete Distribution Points?

(OP)
Thanks Tim. I will try this.

-Keshav

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close