A fix is available
APAR status
Closed as program error.
Error description
Customer is performing EDIT of a table which contains LOB and XML columns. After making a change and pressing ENTER, he enters the CANCEL command after which he exits the Choose a DB2 Table/View to Edit panel going back to the Optim main selection panel. Then he reenter DB2 table EDIT using the same table. The following SQL error is being reported: +------------------------------DB2 SQL Error------------------+ | Release=11.7.0, DB2Rel=1115(NFM) | Encountered the SQL Error Described Below | | DSNT408I SQLCODE = -423, ERROR: INVALID VALUE FOR LOCATOR IN POSITION 1 Alternatively the following ABEND S0C4, ABEND0C4, may be reported: Current Condition: CEE0198S The termination of a thread was signaled due to an unhandled condition. Original Condition: CEE3204S The system detected a protection exception (System Completion Code=0C4). Location: Program Unit: //'SYS18353.T161305.RA000.FOPQ.SRCCMS.H01(FOPQ)' Entry: DSQL_Fetch Statement: 1796 Offset: +0000468A Traceback: DSA Entry E Offset Statement Load Mod Program Unit Service 1 CEEHDSP +00004A4C CEEHDSP HLE77B0 2 DSQL_Fetch +0000468A 1796 FOPMCMAI FOPQ PH04647 3 atfetch +0000B820 825 FOPMDMAI FOPDETCH COPYSEN 4 Initialize +00018B08 2800 FOPMEMAI FOPEDRIV COPYSEN 5 ededitad +00001DEA 418 FOPMEMAI FOPEDRIV COPYSEN 6 mngorun +00000A70 1123 FOPMMUNU FOPMCALL COPYSEN 7 PromptEditTable +000016A0 1078 FOPMMUNU FOPMMENU PH04647 8 mnprmpt +000048F0 814 FOPMMUNU FOPMMENU PH04647 9 main +00003BC2 841 FOPMAIN FOPMMAIN PH04647 10 EDCZMINV +000000C2 11 CEEBBEXT +000001C6 CEEBBEXT HLE77B0
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Optim for z/OS users performing EDIT of DB2 * * tables with LOB and XML columns.. * **************************************************************** * PROBLEM DESCRIPTION: Customer is performing EDIT of a table * * which contains LOB and XML columns. * * After making a change and pressing * * ENTER, he enters the CANCEL * * command after which he exits the Choose * * a DB2 Table/View to Edit panel going * * back to the Optim main selection panel. * * Then he reenters DB2 table EDIT using * * the same table. * * The following SQL error is being * * reported: * * * * +------------------------------DB2 SQL * * Error------------------+ * * | Release=11.7.0, DB2Rel=1115(NFM) * * | Encountered the SQL * * Error Described Below * * | * * | DSNT408I SQLCODE = -423, ERROR: * * INVALID VALUE FOR LOCATOR IN * * POSITION 1 * * * * Alternatively the following ABEND S0C4, * * ABEND0C4, may be reported: * * * * Current Condition: * * CEE0198S The termination of a thread * * was signaled due to an * * unhandled condition. * * Original Condition: * * CEE3204S The system detected a * * protection exception (System * * Completion Code=0C4). * * Location: * * Program Unit: //'SYS18353.T161305. * * RA000.FOPQ.SRCCMS.H01(FOPQ)' * * Entry: DSQL_Fetch * * Statement: 1796 Offset: +0000468A * * * * Traceback: * * DSA Entry E Offset Statement * * Load Mod * * Program Unit * * Service * * 1 CEEHDSP +00004A4C * * CEEHDSP HLE77B0 * * 2 DSQL_Fetch +0000468A 1796 * * FOPMCMAI * * FOPQ * * PH04647 * * 3 atfetch +0000B820 825 * * FOPMDMAI * * FOPDETCH * * COPYSEN * * 4 Initialize +00018B08 2800 * * FOPMEMAI * * FOPEDRIV * * COPYSEN * * 5 ededitad +00001DEA 418 * * FOPMEMAI * * FOPEDRIV * * COPYSEN * * 6 mngorun +00000A70 1123 * * FOPMMUNU * * FOPMCALL * * COPYSEN * * 7 PromptEditTable * * +000016A0 1078 * * FOPMMUNU * * FOPMMENU * * PH04647 * * 8 mnprmpt +000048F0 814 * * FOPMMUNU * * FOPMMENU PH04647 * * 9 main +00003BC2 841 * * FOPMAIN * * FOPMMAIN PH04647 * * 10 EDCZMINV +000000C2 * * 11 CEEBBEXT +000001C6 * * CEEBBEXT HLE77B0 * **************************************************************** Optim is incorrectly tracking the data structures responsible for LOB and XML column data access.
Problem conclusion
The LOB and XML data access will be corrected.
Temporary fix
Comments
APAR Information
APAR number
PH06806
Reported component name
OPTIM MOVE FOR
Reported component ID
5655V0700
Reported release
B30
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-12-26
Closed date
2019-01-09
Last modified date
2019-02-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FOP1OSFN FOP3DTPR FOP9APIM FOPCFPMN FOPCXLIB FOPHSTM FOPMADDE FOPMAIN FOPMARCN FOPMCMAI FOPMCOFN FOPMCOLP FOPMDMAI FOPMDPRC FOPMDXTR FOPMECMN FOPMEMAI FOPMMCMR FOPMMJBS FOPMMUNU FOPMMUTL FOPOMN FOPRS10 FOPRS3 FOPUMCBT FOPZFMMN FOPZMAIN
Fix information
Fixed component name
OPTIM MOVE FOR
Fixed component ID
5655V0700
Applicable component levels
RB30 PSY UI60592
UP19/01/11 P F901
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B30","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 February 2019