AS400 Clutter

5 pts.
Tags:
AS/400
DataCenter
ERP
Security
Wireless standards
anyone know what causes *SQLPKG objects to be created in various libraries by many different users, some by IBM internal most not. Trying to cleanup system.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check to see who is creating ODBC data sources from Windows to the iSeries for one thing. There is a tab named ‘Packages’ on the setup of an ODBC data source that asks what library you want to place package files in. Of course, unless you are using dynamic package support, you can uncheck this tab setting and bypass creating them.

======================================================

Under circumstances of “various libraries” and “by many different users”, ODBC and similar access is probably the source. But are you sure that any particular package ought to be deleted? Have you determined if the packages are used?

Most SQL packages are relatively small objects. Unless it’s a very small system with a very large number of packages, it wouldn’t seem likely that you’d recover much by deleting them. And if it is a small system that is creating many packages, it would seem that the potential performance advantages of packages is needed.

See <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/ddp/rbal1sqlpack.htm”>this comment</a> and consider effects on the remaining objects that might still be “dependent on the SQL package”. Also, see some info on where packages come from <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaik/rzaikexecuteprepstmt.htm”>here</a> and <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaik/useedsql.htm”>here</a> for some fundamentals.

Do you prefer having the ODBC requests optimized for reuse or recreated and optimized when each request is repeated? It can be a balancing act.

Is the time spent tracking them down and deleting them worth it? Object creation and object deletion can be expensive operations by themselves.

Tom

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • smford
    I was under the impression that there was an auto-cleanup procedure for those packages.
    20 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following