PH55832: BROWSE JOIN SYSTEMERROR AFTER "NUMBER OF ROWS EXCEEDS MAXIMUM FETCH SET LIMIT. NOT ALL ROWS FETCHED"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is Browsing a DB2 table, or an EXTRACT file, and issues
  a JOIN command. The command returns the rows from the related
  table and the number of such rows exceeds the "Maximum Fetch
  Rows", as specified in the Optim Options.
  The message "NUMBER OF ROWS EXCEEDS MAXIMUM FETCH SET LIMIT. NOT
  ALL ROWS FETCHED" is being displayed which is expected.
  Customer performs a ZOOM request to the original start table
  and manipulates the set of presented rows by means of SEL, SQL
  or SORT commands. Then he wants to return to the view of the
  joined tables by entering another ZOOM command. At such time
  Optim may abort processing with a System Error, similar to the
  following one:
  
  An Internal System Error has Occurred on 2023/07/05 08:06
  DB2Rel=1215(NFM), Rel=11.7.0
  Code=0, AuxInfo=
  01 FOPELINE 20220309 PH42976 (003881) ExecuteLineCmds
  02 FOPEDRIV 20220720 PH45127 (001180) EditAD
  03 FOPMCALL 20220720 PH45127 (001127) CallEdit
  04 FOPMTLST 20220309 PH42976 (000610) LC_SelTbl
  05 FOPEISPL 20220309 PH42976 (000859) ExecLineCmds
  06 FOPEISPL 20220309 PH42976 (000393) DisplayISPFList
  07 FOPMTLST 20220309 PH42976 (000518) TblSelList
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Optim users performing BROWSE of related     *
  *                 DB2 tables.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: See Error Description.                  *
  ****************************************************************
  Incorrect processing logic for viewing of joined tables may lead
  to an error.
  

Problem conclusion

• Optim processing will be corrected.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• FOP1OSFN FOP9APIM FOPALLOC FOPCFPMN FOPCRDB  FOPCXLIB FOPDPLUS
  FOPEXPAD FOPEXPY1 FOPHSTM  FOPINS0  FOPK05   FOPK12   FOPMAIN
  FOPMCOLA FOPMCOLP FOPMDPRC FOPMDXTR FOPMECMN FOPMEMAI FOPMMCMR
  FOPMMJBS FOPMMUTL FOPMUXIM FOPOMN   FOPRS10  FOPRS2   FOPRS9
  FOPT121B FOPTADX1 FOPTEVAL FOPUMCBT
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI93308

     UP23/08/30 P F308

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.