# Striim 4.0.4 documentation

##### System log messages about SQL/MP automatic recompilation

When Striim is used to work with change data from SQL/MP tables, embedded SQL code in SQMPCDCP is used to read the description of each of those tables from the SQL/MP catalog in which it is registered. Since similarity checking is not available for SQL/MP catalog tables, each of those embedded queries is automatically recompiled when it is run. There are two automatic recompilations done each time a different catalog is referenced. These automatic recompilations do not affect the performance of capturing the change data from the TMF audit trail and sending it to the Striim server. They occur only at the time the Striim application is started on the Striim server, when it sends the request to start capture of change data from particular tables on the NonStop system.

The SQL/MP compiler reports each automatic recompilation in a message to the system log, and there is no way to turn off or redirect those messages, so at least two automatic recompilation messages will appear each time a Striim application is started. There could be more than two automatic recompilation messages if the Striim application requests change data from tables in more than one catalog. These messages can be ignored safely. They are expected during normal operation and do not indicate anything wrong in the SQL/MP change data capture process. However, if these messages interfere with your regular monitoring of the system log, you can reduce or eliminate them by SQL compiling the SQMPCDCP program to reference the tables in the SQL/MP catalog on your system used most frequently for tables that the Striim applications reference.

If you decide to SQL compile the SQMPCDCP program, run the following commands while logged on as SUPER.SUPER:

VOLUME <Striim vol-subvol>
SQLCOMP / IN SQMPCDCP / CATALOG <your catalog vol-subvol>, &
COMPILE PROGRAM STORE SIMILARITY INFO
FUP LICENSE SQMPCDCP

Where:

<Striim vol-subvol> is the volume and subvolume in which you installed the Striim files

<your catalog vol-subvol> is the volume and subvolume of the SQL/MP catalog most frequently used by the SQL/MP tables referenced by Striim applications. This is not necessarily the volume and subvolume in which the tables themselves reside. Use FUP INFO with the DETAIL option on a SQL/MP table to determine in which catalog it is registered.

The system log messages that report the automatic recompilations do not give the name of the table referenced by the query that caused the recompilation. You will have to determine by other means which SQL/MP tables are being used by Striim applications, then check them to see which SQL/MP catalog is used most frequently. If you register all of your SQL/MP tables in the same catalog, you would not have to do any checking to see which catalog to use in the above commands.

The above method will not eliminate all system log messages about automatic SQL compilations of the SQMPCDCP program unless all the SQL/MP tables used from your Striim applications are registered in the one SQL/MP catalog. However, if it is the case that every HpNonStopSQLMPReader Adapter in every Striim application references tables only from a single SQL/MP catalog, with some additional effort, you could eliminate all the system log messages.