APAR status
Closed as program error.
Error description
If you define and execute a repair job in an Enterprise Replication (ER) environment and then drop one of the ER servers, once that dropped server has been re-added, if you try to delete the previously added repair job, you will get returned the following error: command failed -- Encountered an SQL error. (196) Error Details: SQLCODE:100 Error in deleting a resynch job If after this error you try to cdr list repair to view the job, you will see the below output: RESYNCHJOB REPLICATE/REPLSET STATE ---------------------------------------------------------------- ------------ jj_repair jj_rep1 Pending Delete this situation exists until the ER environment is re-created.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Any user using repair jobs who drops and adds a node * **************************************************************** * PROBLEM DESCRIPTION: * * If the DBA has created a repair job and then later drops and * * re-adds one of the nodes within the job, then it will not be * * possible to delete the repair job. * **************************************************************** * RECOMMENDATION: * * The repair job is going to be removed from the server in a * * future release. The user should use 'cdr check' instead. * * To continue using the repair job while still on 11.50, * * upgrade to 11.50.xC7. * ****************************************************************
Problem conclusion
Problem first fixed in 11.50.xC7
Temporary fix
Comments
APAR Information
APAR number
IC67457
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-03-25
Closed date
2010-11-17
Last modified date
2010-11-17
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
17 November 2010