IT19106: UNDULY SENDING NEW INDEX ON RAW TABLE VIA IPL OR DRIDXAUTO

APAR status

• Closed as program error.

Error description

• The content of an index on a raw table wouldn't matter much to a
  secondary server, nor would it be more correct than an empty
  index. Neither would a raw table be accessible on a secondary
  (s. error -19846), nor could it be changed to mode standard on
  the primary (error -19845). And in case of a failover this would
  even introduce inconsistency (index entry pointing to
  non-existent rows).
  
  Nonetheless full index page logging (IPL, if configured or an
  SDS connnected) would occur upon creation of such index, and
  similarly DRIDXAUTO would transfer it to an HDR secondary with
  IPL off, which could delay index creation, would imply extra IPL
  checkpointing and might cause extensive server blocking.  In
  general this sort of defeats the purpose of a raw table: being
  light weight and quick.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * users creating index on huge raw table with index page       *
  * logging enabled                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC9                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC9
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RC10 PSY

     UP