Re: Possible SQL Activation Group Issues

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 10/14/2016
01:25:16 PM:

The duplicate key exception logged by the database feature [i.e. to
be clear, separate from the effective equivalent SQL /message/ sqlcode
in response to the DB messaging] states what file; just review that
prior message for the message data that would conclusively reveal that
the wrong file was referenced with an implication almost surely an
existing but incorrect query Open Data Path (ODP) was accessed.

Insufficient. Because, the message only indicates the file/table
name. It does not indicate the library. The file/table name shown is as
expected but this same name exists in every data library.

The Reclaim Activation Group (RCLACTGRP) between companies is
probably the simplest sure-fire way to circumvent an issue if the origin

is, as alluded is suspected.

I was hoping to avoid that -- especially since IBM said it would
not be necessary. They said that the "advanced" SQL optimizer would
detect changes in the library list and rebuild the data path accordingly
under the requirements previously described.

Sincerely,

Dave Clark