Troubleshooting › CA CSM Address Space Functions Incorrectly

CA CSM Address Space Functions Incorrectly

Symptom:

The SCS address space does not function correctly, and I see messages similar to the following sample in the log:

MSMC0501E SQL PREPARE VERSIONSTMT for task MSMCJTSK failed, SQLCODE=-124, SQLSTATE=51002, RETCODE=,
                             IRETCODE=X'0000'
MSMC0503E SQL error message: PLAN CASWMGT.MSMCFSQL_050_001 DOES NOT EXIST
MSMC0501E SQL ROLLBACK for task MSMCJTSK failed, SQLCODE=-124, SQLSTATE=51002, RETCODE=, IRETCODE=X'0000'
MSMC0503E SQL error message: PLAN CASWMGT.MSMCFSQL_050_001 DOES NOT EXIST
 

MSMC0501E SQL PREPARE_DEPUNIT for task MSMCIENG failed, SQLCODE=-124, SQLSTATE=51002, RETCODE=, IRETCODE=X'0000'
MSMC0501E SQL ROLLBACK for task MSMCIENG failed, SQLCODE=-124, SQLSTATE=51002, RETCODE=, IRETCODE=X'0000'

Additionally, you can see the messages similar to these messages:

MSMC0401E EVTINIT for task MSMCIES0 failed, RETCODE=X'00000020'
MSMC0401E EVTINIT for task MSMCIENG failed, RETCODE=X'00000020'
MSMC0401E EVTINIT for task MSMCCEVH failed, RETCODE=X'00000020'

Reason:

The SQL plans in the CA Datacom/MSM database are not up-to-date.

Solution:

Update and synchronize the SQL plans in the CA Datacom/MSM database.

Note: For more information about updating SQL plans, see the Administration Guide.