× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. January 2012

Re: SQLCLI problems: handles evidently being invalidated

A new piece of the puzzle:

The SQL CLI evidently runs in an activation group called "QSQCLI": if there's an active CLI session, there's always a QSQCLI activation group in the job. (Moreover, the CLI is implemented in the QSQCLI service program, and a DSPSRVPGM QSQCLI does indeed show that it uses that named activation group).

But in the jobs that are locked up from a corrupted CLI, there's *no* QSQCLI activation group listed for the job!

I think I've found what's causing the corruption, and it apparently *is* the wanton purging of activation groups that's doing it.

So I just now went into "bench-test mode" on the program that's blowing up, running a simple query twice, without incident. Then I did a RCLACTGRP QSQCLI, and tried the same query again. BOOM!

--
JHHL

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.