Resolution:
The error message S6BIM176E is issued by the "TIBCO Service Gateway™ for IMS/DB" when an INSERT or REPLACE operation is attempted against an IMS database segment that is improperly defined to "TIBCO Object Service Broker" (OSB). The update operation is abnormally terminated in order to prevent incomplete or inconsistent data from being written to the IMS database.

Environment:
============
TIBCO Object Service Broker (for Open Systems or z/OS)
TIBCO Service Gateway™ for IMS/DB

Symptoms:
=========
The client's rule will fail with an error sequence such as:

   Error detected in rule "your_rule_name" at action n                            
   Access error on table "your_IMS_tablename"                                          
   REPLACE  your_IMS_tablename                                        
   S6BIM176E serverid userid detecting_module: Incomplete IMS segments in table definition
   . . .

Cause:
======
Although the error message S6BIM176E suggests that the IMS segments are not completely defined to OSB, the error may occur even if all segments being accessed are completely defined. (There will be an update to the Messages manual in a forthcoming documentation update.) The error is issued for the following conditions:
1) the fields defined in the OSB IMS table definition do not completely map the IMS segment being updated
2) the IMS table definition has fields mapping the entire IMS segment but some of the fields overlap each other.

In the second situation, IMS allows DBD field definitions to overlap since they refer to offsets in an IOAREA. OSB IMS table field definitions however are kept independently within a row buffer. Thus if fields overlap, then if one field is updated but the overlapping field is not, it may not be possible to reconcile the intended data value for the eventual IMS update operation. This is why the IMS Table Definer will issue the warning:
    WARNING: Fields "field_A" and "field_B" overlap    
for this situation. As the "TIBCO Service Gateway™ for IMS/DB Installing and Operating" manual states in Chapter 3 "Managing IMS Data Definitions", "... fields cannot overlap in a segment; if they do, no updates are permitted." If an update is attempted, then message S6BIM176E is issued and the upate is disallowed.

Resolution:
===========
In order to prevent the error S6BIM176E being raised, you should ensure that:
1) the IMS segments being processed are completely mapped by the table fields for the full size of the segment as defined in the IMS DBD assembly.
2) fields do not overlap if update operations are to be performed on that segment


References:
===========
IBM IMS Database Administration
TIBCO Service Gateway™ for IMS/DB Installing and Operating manual
TIBCO® Object Service Broker Messages With Identifiers manual

What causes the error message "S6BIM176E serverid userid modulename: Incomplete IMS segments in table definition" ?