Export slow - Export queue is backlogged as Export is running very slow. (4224468)

Export slow - Export queue is backlogged as Export is running very slow.
 

Some resource or network issues can result in slow Export.

The issue can also be caused by slow disk I/O on the Target.
If Import encounters slow disk I/O it may cause the TCP receive buffer to back up.

If the network is functioning normally and there are no disk I/O issues, it may be that the import write commit values on the Target are set too high.

On Target, make sure that SP_IMP_WCMT_MSGCNT & SP_IMP_WCMT_TIMEOUT are set to their default values.

SP_IMP_WCMT_MSGCNT
   This parameter works in conjunction with the SP_IMP_WCMT_TIMEOUT parameter.
   It defines the number of messages that are processed before the Import process checkpoints.
   Checkpointing saves the state of the process in case it is needed for failure recovery.

   When Import checkpoints, it triggers the Export process to perform its own checkpoint.
   If the value for this parameter is reached before the value set for SP_IMP_WCMT_TIMEOUT, it triggers the checkpoint.

   In a WAN environment, you can increase this parameter to as many as 10,000 messages, with the understanding that increasing the message interval between
   checkpoints can negatively affect SharePlex's fault tolerance.
   If you are using SharePlex in an environment where the network continually fails, you can decrease this parameter.

Default: 10,000 messages
Range of valid values: any positive integer
Takes effect: immediately

================

SP_IMP_WCMT_TIMEOUT
   This parameter works in conjunction with the SP_IMP_WCMT_MSGCNT parameter.
   It defines the number of seconds that pass before the Import process checkpoints.
   Checkpointing saves the state of the process in case it is needed for failure recovery.

   When Import checkpoints, it triggers the Export process to perform its own checkpoint.
   If the value for this parameter is reached before the value set for SP_IMP_WCMT_MSGCNT, it triggers the checkpoint.

Default: 30 seconds
Range of valid values: any positive integer
Takes effect: immediately



Setting Import writecommit values on the Target high, may increase performance on the Target.
However, messages in the Export queue are readreleased when Import writecommits, not when the messages are posted.

 

You can run a number of diagnostics like truss, snoop, pfiles, etc on both Export (sp_xport) and Import (sp_mport) processes to get more clues to determine if the disk I/O and fdsync() calls were slow. One thing that can certainly be checked is whether the parameter SP_QUE_SYNC is set to a value other than the default of 0, and if so, you can unset it. This workaround will mitigate the issue since it will cause less I/O which are typical when the parameter is set to a value other than the default.
To unset the parameter:
 

   sp_ctrl> reset param SP_QUE_SYNC
   sp_ctrl> shutdown
Then restart SharePlex.