After starting up SharePlex or starting a previously stopped process you get the following error message and the process exits immediately:
06/27/07 15:07 Process launched: sp_ordr (for o.SID) [pid = 8021]
06/27/07 15:07 Process exited sp_ordr (for o.SID) [pid = 7947] - exit(1)
06/27/07 15:07 Error: que_create(quename+X) error=21 [sp_ordr(rim)/7947]
06/27/07 15:07 Error: Could not create shared memory segment [sp_ordr(que)/7947]
06/27/07 15:07 Notice: Not enough disc space for 268435456 bytes of shared memory [sp_ordr(shs)/7947]
06/27/07 15:07 Notice: Result (12) Not enough space calling shmget to get shared memory segment (9300) [sp_ordr(shs)/7947]
This can happen to any SharePlex queue (Capture/Export/Post) and is caused by SharePlex trying to allocate x amount of Shared memory from the OS and failing to get it.
Lower the value of shared memory which SharePlex tries to allocate by modifying the value of SP_QUE_Q_SHMSIZE (for Capture, Export) or SP_QUE_POST_SHMSIZE (for Post)
SP_QUE_Q_SHMSIZE
Default: 8388608 bytes
Range of valid values: 8388608 to no maximum
Takes effect: When sp_cop is restarted
SP_QUE_POST_SHMSIZE
Default: 33554432 bytes
Range of valid values: greater than 8388607
Takes effect: When sp_cop is restarted
Usually occurs on HP and AIX a lot.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy