Recent content by Austin Skrepak

(Procedure: 'as/connect.p' Line:514) Invalid or inappropriate handle value given to RUN...IN statement. Procedure 'as/connect.p':514. (2128)

Some of my apps are intermittently receiving the following error: "4GL STOP condition: lib/SessionMod/Sink.p Singleton main-block procedure ended with an STOP condition (8026) (7241)" Does this mean that the AppServer it is connecting to needs more servers? Thanks,

Awesome, thanks so much!

Unable to disconnect user (2258) and yeah I'm an admin.

Is there a way to kill or disconnect either a _sqlsrv2 PID or a SQL user? I got an ODBC call stuck. I was able to identify the user, but using proshut mfgsys -C disconnect ### failed with error 2258. OpenEdge 10.2A. Any ideas?

Will the system automatically attach each ODBC request to an empty server until they all have one before attaching more than one to a server?

Is there a way to trace back a _sqlsvr2 PID to the specific SQL log file?

Is there any rule of thumb on what the max clients per server should be on an ODBC group (SQL Only)?

Thank you!

10.2A

Is there any way to track down information on any current active ODBC queries on the system? Windows username, server, etc. Thanks!

So this means I have a problem?

Do either of you have any good resources on defining storage areas and moving tables and indexes to those storage areas via dump & load?

Okay, I've created this .sql file. This looks like this needs to run on the database while it is running. Is that true? It doesn't change the indices, just optimizes them, correct?

How could I tell if this is an issue? Would we be smarter to go with 40 cores instead of hyper-threading to 80?