Ending ODBC Connections

80 pts.
Tags:
iSeries database
ODBC on i5
QUSRWRK
I have several active ODBC connections throughout the day and I'm finding they sometimes lock objects during my Dayend so I want to cancel them just before the Dayend starts. Can someone tell me the cleanest method to end ODBC connections? I was going to try just ending the Qusrwrk sub-system but I'm not sure if the jobs will just restart in Qserver. I'm also looking at an Endhostsvr (*database) endactcnn(*database) to see if that will do it. Any advice would be much appreciated. Thanks

Answer Wiki

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

Close the application which opened the connections to the database?

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

<i>Can someone tell me the cleanest method to end ODBC connections?</i>

The “cleanest” will always be the suggestion above. There’s no way around that. Everything else will have some ‘dirty’ component or potential.

<i>I was going to try just ending the Qusrwrk sub-system but I’m not sure if the jobs will just restart in Qserver.</i>

That will depend on how your system is configured.

<i>I’m also looking at an Endhostsvr (*database) endactcnn(*database) to see if that will do it.</i>

If you need to have control from the server side, this will be your best chance at being the closest to “cleanest”. Obviously, cutting a connection will have results directly related to whatever a remote connection is being used for at the time the cut happens. I don’t know of any way to determine that without understanding the relevant remote apps.

Tom

Discuss This Question: 2  Replies

 
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
  • pdraebel
    There are several things you could do, but at our shop we issue an ENDPJ. ENDPJ SBS(QUSRWRK) PGM(QZDASOINIT) This ends connections in a controlled manner, leaving 30 seconds to complete whatever it is doing. We used to set the job uses to 1, but this lead to some 8000 extra jobs every day, so we abandoned that.
    2,985 pointsBadges:
    report
  • Batman47
    You should do both of these suggestions, starting with the ending of the database host server to prevent any new connections and then ending all the prestart jobs that are using QZDASOINIT for the clean method you are looking for.
    1,050 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