Resolution:
Description:
============
Message "S6BID086I Mixed Subschema detected: RU using xxxxxxxx, Table tttttttttttttttt ; defined with ssssssss" is not documented nor is the associated parameter MIXEDSSCDETECTION. Message S6BID086I is issued by default when a situation is detected that may pose a potential problem. This additional checking was introduced at TIBCO Service Gateway™ for IDMS/DB release 5.2. This solution describes how the extra checking can be customized to meet the needs of a particular installation.


Environment:
============
* z/OS
* running TIBCO Service Gateway™ for IDMS/DB

Symptoms:
=========
Message "S6BID086I Mixed Subschema detected: RU using xxxxxxxx, Table tttttttttttttttt ; defined with ssssssss" is issued by the gateway task to the z/OS Jes job log. If all IDMS tables accessed by an Object Service Broker transaction are not mapped by the same subschema, data may be processed incorrectly.

Cause:
======
Additional checking was added to TIBCO Service Gateway™ for IDMS/DB at 5.2 to address a perceived problem where an IDMS transaction can only use one subschema but can access more than one IDMS table which could depend on multiple subschemas. The IDMS/DB Gateway ignores this and uses the first subschema referenced to service subsequent IDMS tables. This could result in field mapping errors if not intentional. To avoid this "problem", a new parameter was added to the IDMS gateway called MIXEDSSCDETECTION.

You can code this parameter as follows:

MIXEDSSCDETECTION={ I | W | E }
I -ignore this condition (as per pre-5.2 behaviour).
W -display a message in the gateway log indicating the discrepancy but allow the transaction to continue. This is the default.
E -display the message in the gateway log and end the transaction with an error.


Resolution:
===========
Customize your environment by coding the MIXEDSSCDETECTION parameter to suit your processing requirements.


References:
===========
TIBCO Service Gateway™ for IDMS/DB: Installing and Operating
TIBCO® Object Service Broker: Parameters
SGID-17 Multiple IDMS tables referencing multiple subschemas could present data incorrectly.

"S6BID086I Mixed Subschema detected: RU using xxxxxxxx, Table tttttttttttttttt ; defined with ssssssss" is not documented nor is the associated parameter MIXEDSSCDETECTION.