Replication Guide and Reference

Improving Apply performance for Sybase or Microsoft SQL Server on AIX

If you are running the Apply program on AIX with a DBLIB connection for either Sybase or Microsoft SQL Server, you can significantly improve your overall performance. To take advantage of this improvement:

1. Retrieve the names of the packages for the Apply program. To find your package names, issue the following SQL statement:

   SELECT PKGNAME 
   FROM SYSCAT.PACKAGES
   WHERE PKGNAME LIKE 'ASN%'
   

   The package names change with each release and with each service update, but this query retrieves names that are specific to your service level.

2. If you have an apply_name.ini file (in the sqllib directory), replace the package names with the ones that you retrieved in step 1. If you do not have an apply_name.ini file, create one and list the package names. The following lines show an example of an apply_name.ini file:

   ASN6A001+
   ASN6B001+
   ASN6C001+
   ASN6F001+
   ASN6I001+
   ASN6M001+
   ASN6P001  
   

3. Create server options for the Apply packet and buffer sizes. Sample sever options for Sybase are:

   create server option apply_packet_size for server type sybase setting 16384;
   create server option apply_buffer_size for server type sybase setting 16384;
   

   Sample sever options for Microsoft SQL Server are:

   create server option apply_packet_size for server type mssqlserver setting 16384;
   create server option apply_buffer_size for server type mssqlserver setting 16384;
   

   You can set the packet and buffer size to any appropriate value; set them to 16384 initially, and adjust as necessary.

4. Set the following environment variable:

   DJX_ASYNC_APPLY=TRUE
   

5. If you created or changed the apply_name.ini file, or if you changed the DJX_ASYNC_APPLY variable, you must stop and restart DataJoiner before these changes take effect. To stop and restart DataJoiner, issue the db2stop and db2start commands.

[ DB2 List of Books | Search the DB2 Books ]