When setting the parameter SP_QUE_POST_SHMSIZE to a value of 2048M or higher, it fails with the error “Parameter type checking failed - look in param-defaults file”:
sp_ctrl (alvsupl14:9900)> set param SP_QUE_POST_SHMSIZE queue
Parameter type checking failed - look in param-defaults file
This is despite the fact that the param-default file located in /proddir/data directory (where proddir refers to SharePlex Product directory) states that the parameter takes an integer value and there is no upper limit for it. Here is the param-default entry:
SP_QUE_POST_SHMSIZE B restart_cop int(>1048575) 33554432 bytes # Post queue shared-memory Size
As of SharePlex 8.6.2, the paramdb cannot handle values that are larger than a 4 byte integer.
Try setting the value to something less than 2048M. For example the following which is just shy of 2048M will work:
sp_ctrl (alvsupl14:9900)> set param SP_QUE_POST_SHMSIZE queue alvsupl14 2146435072
Starting with SharePlex 8.6, the unit of the following parameters have changed from bytes to megabytes (MB). Hence one may want to change all references to the parameters from bytes to megabytes. Here are the latest description of the parameters:
SP_QUE_POST_SHMSIZE
This parameter determines the specific shared-memory size for the post queue.
IMPORTANT: Increasing this parameter might require an increase in the maximum shared memory segment size
in your system settings.
Default: 32 megabytes
Range of valid values: integer greater than 0
Takes effect: When sp_cop is restarted
SP_QUE_Q_SHMSIZE
This parameter determines the specific shared-memory size for the capture and export queues.
Default: 8 megabytes
Range of valid values: integer greater than 0, no maximum
Takes effect: When sp_cop is restarted
