A fix is available
APAR status
Closed as program error.
Error description
While issuing a JOIN command from within a browse session of an Archive or extract file an S0C4 ABEND or SYSTEM ERROR may be encountered: System Completion Code=0C4 From entry point edprep at statement 2788 Join Compile failed DB2Rel=1215(NFM), Rel=11.7.0 Code=-1, AuxInfo=rc=9003 01 FOPABROW 20230123 PH50193 (002756) ARDMActivateTable 02 FOPDETCH 20230123 PH50193 (000715) AT_FetchSet 03 FOPEJOIN 20230123 PH50193 (002721) JoinTables 04 FOPEJOIN 20230123 PH50193 (000837) Join 05 FOPELINE 20230123 PH50193 (004883) JoinHandleReturn 06 FOPEDRIV 20230123 PH50193 (001180) EditAD 07 FOPABROW 20230123 PH50193 (004025) BrowsePerform 08 FOPABROW 20230123 PH50193 (001133) ArcBrowse 09 FOPAMAIN 20230123 PH50193 (000446) ArcHighLevel 10 FOPJINI 20230123 PH50193 (000540) StartJobSubmission 11 FOPMCALL 20220720 PH45127 (001749) CallJSub 12 FOPMMENU 20230123 PH50193 (001795) PromptDM 13 FOPMMENU 20230123 PH50193 (000948) PromptMain 14 FOPMMAIN 20230123 PH50193 (001003) Main
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Optim users joining tables in an Access * * session. * **************************************************************** * PROBLEM DESCRIPTION: If tables are JOINed in an Access * * browse or edit session and a SORT * * primary command is entered followed by * * a JOIN to another table, a System Error * * may occur. * **************************************************************** * RECOMMENDATION: Apply the fix provided. * **************************************************************** Due to an error in Optim processing a reference to an invalid control block may be made during the JOIN process.
Problem conclusion
The error has been corrected.
Temporary fix
Comments
APAR Information
APAR number
PH52843
Reported component name
OPTIM MOVE FOR
Reported component ID
5655V0700
Reported release
B70
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-02-24
Closed date
2023-03-20
Last modified date
2023-04-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FOP4PEMN FOP9APIM FOPCFPMN FOPDYER6 FOPHSTM FOPMAIN FOPMAMAI FOPMCBMN FOPMDMAI FOPMDPRC FOPMDXTR FOPMECMN FOPMEMAI FOPMMCMR FOPMMJBS FOPMMUTL FOPOMN FOPRS10 FOPRS3 FOPSYER1 FOPSYER2 FOPSYER3 FOPZFBMN FOPZFMMN
Fix information
Fixed component name
OPTIM MOVE FOR
Fixed component ID
5655V0700
Applicable component levels
RB70 PSY UI91033
UP23/03/21 P F303
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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"B70"}]
Document Information
Modified date:
03 April 2023