Qlik Replicate: Disable SQL Package REPCTLAFBA generation on DB2i Server

[john_wang]

A new object was created on the IBM DB2 for Series server when working with a DB2i source.

The object's name is REPCTLAFBA, or a similar name such as REPCTL* (where * may be a combination of four different characters).

If the object is deleted manually, Qlik Replicate will create it again during the first Full Load run.

The object's detailed information presents as such:

The SQL package contains the control structures and access plans necessary to process SQL statements on the application server when running a distributed program. It's the wonderful performance-enhancing technology from IBM. The Packages relate to AS/400 query execution plans and are a great way to optimize the performance of your client applications. More detailed information can be found at IBM SQL Package Questions and Answers .

 

Resolution

The SQL Package is harmless to DB2i Server, however if still want to disable the package auto-generation, it's easy to do it by:

1. Open DB2i source endpoint
2. Go to the Advanced tab
3. Open Internal Parameters
4. Add a new parameter named additionalConnectionProperties
   
5. Press <Enter> and set the parameter's value to:
   
   ExtendedDynamic=0
   
   If you do not want to disable the package but just want to change the default package library then set the value to:
   
   DefaultPkgLibrary=DEMODB
   
   Where DEMODB is the library name where the package will be generated to.

A sample:

Environment

Qlik Replicate  all versions
DB2i iSeries Server  all versions

 

Internal Investigation ID(s):

Support cases, #00060121

Qlik Replicate