WebSphere Commerce EnterpriseWebSphere Commerce ProfessionalFeature Pack 5 or later

Troubleshooting: Quick publish performance issues

Aside from publishing workspace data to the Production environment database, quick publish also performs bookkeeping on the Authoring environment database. Bookkeeping can take a long time to complete. You can set optional post-publish phase attributes to increase performance.

Bookkeeping marks any records that are associated with the task in the STAGLOG table as processed, so that the same changes are not propagated again during staging propagation. You can use two configuration parameters to tune bookkeeping:
lowerCaseStaglog
When set to true, this attribute removes LOWER() from the AQL statement, thus improving performance.
updateStaglogStmtNum
When set to 1, bookkeeping uses an IN clause in the SQL that updates the STAGLOG table.
Notes:
  • You can set lowerCaseStaglog to true only when the following conditions are met:
    • There are no custom stageable tables in the schema.
    • All UPDATE, DELETE, and INSERT triggers on all custom stageable tables insert lowercase values only into the STGTABLE column of the STAGLOG table.
  • updateStaglogStmtNum might not improve performance if you have already fine-tuned the performance of your database.
To edit the quick publish post publish parameters:
  1. Update the wc-resource-containers.xml file.
    1. Open the WC_profiledir\installedApps\cell_name\WCServer_enterprise_archive\xml\content-management\wc-resource-containers.xml file for editing.
    2. In the wc-resource-containers.xml file, locate the <wc:QuickPublishConfiguration> element, and add the postPublish and postPublishSize parameters as shown:
      <wc:QuickPublishConfiguration>
      		<wc:Publisher className="com.ibm.commerce.context.content.resources.publish.DefaultJDBCContentPublisherImpl"
      		initParameters=[other-parameters]lowerCaseStaglog="true" updateStaglogStmtNum ="1" [other-parameters]/ >
      </wc:QuickPublishConfiguration>
  2. Save your changes and close the file.
  3. Update the wc-resource-containers.xsd file.
    1. Open the WC_profiledir\installedApps\cell_name\WCServer_enterprise_archive\xml\content-management\xsd\wc-resource-containers.xsd file for editing.
    2. In the wc-resource-containers.xsd file, locate the Publisher element, and add the attributes as shown:
      <element name="Publisher">
      		<complexType>
           <attribute name="className" type="string" use="required"/>
           <attribute name="initParameters" type="string" use="optional"/>
        		[other attributes]
           <attribute name="lowerCaseStaglog" type="string" use="optional">
      	        <annotation>
      		        <documentation>ADD ONCE ABOVE QUESTIONS ARE ANSWERED.
      		        </documentation>
      	        </annotation>
           </attribute>
           <attribute name="updateStaglogStmtNum" type="int" use="optional">
      	        <annotation>
      		        <documentation>ADD ONCE ABOVE QUESTIONS ARE ANSWERED.
      		        </documentation>
      	        </annotation>
           </attribute>
      			...
      			[other attributes]
           ...
      		</complexType>
      </element>
      
  4. Save your changes and close the file.