PH67947: RECEIVE SQLCODE -9055 OR -9005 FROM IMS ZDDL UTILITY WHEN BROWSING AN IMS DATABASE USING FM/IMS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When browsing an IMS database using File Manager/IMS via a
  secondary index and a dynamic PSB in an IMS Managed ACB
  environment, FM/IMS can use the IMS Data Definition utility
  (DFS3ID00), also called zDDL, to generate the dynamic PSB.  This
  may result in a zDDL utility failure with a return code 12 and
  either a -9055 or -9005 sqlcode:
  
  
  -9055 SENSEG sensegview-name from schema-name not found in
  database-name | SENSEG sensegview-name from schema-name
  -9005 object-type object-name invalid for resource-name. |
  object-type keyword keyword-name required for resource-name
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All FM/IMS users on IMS Managed ACBLIB       *
  *                 systems.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The user is encountering SQLCODE -9055  *
  *                      or -9005 from the zDDL utility when     *
  *                      attempting to create a dynamic PSB      *
  *                      through File Manager to browse an IMS   *
  *                      database that has a secondary index.    *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  

Problem conclusion

• Added the WITH REFERENCES clause in zDDL statements for segments
  in databases accessed through a secondary index.
  

Temporary fix

Comments

APAR Information

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

  PH67913

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

Modules/Macros

• FMN0LVL  FMN0LVLJ FMN0MENU FMN0MJPN FMN0POE1 FMN0POPI FMN0POPT
  FMN1FRES FMN1J1A  FMN1J2A  FMN1J3A  FMN1LVL  FMN1LVLJ FMN1MENU
  FMN1MJPN FMN1POPT FMN1RBC1 FMN1RECC FMN1RECF FMN1ST00 FMN1XITA
  FMN2ACO  FMN2ACS  FMN2AGD  FMN2APM  FMN2APR  FMN2ARM  FMN2ARP
  FMN2ARR  FMN2ARS  FMN2ART  FMN2ARY  FMN2ASL  FMN2ASQ  FMN2AZP
  FMN2BN1K FMN2BN2K FMN2BN2P FMN2BN3K FMN2BN3P FMN2CHK  FMN2CIX
  FMN2CPYB FMN2D2I8 FMN2D2IA FMN2D2IB FMN2D2IC FMN2D2ID FMN2D2JA
  FMN2D2JB FMN2D2JC FMN2D2JD FMN2DATA FMN2DENP FMN2DENU FMN2DJPN
  FMN2F447 FMN2FE3F FMN2GSC2 FMN2GSC3 FMN2GV22 FMN2GV23 FMN2GVW2
  FMN2GVW3 FMN2LVL  FMN2LVLJ FMN2MENU FMN2MJPN FMN2MSG  FMN2PEO4
  FMN2POLT FMN2POPT FMN2POQI FMN2RBRG FMN2RD04 FMN2RD46 FMN2REDG
  FMN2RFC1 FMN2RGC1 FMN2RGEX FMN2RLC1 FMN2RLIB FMN2ROAB FMN2ROAC
  FMN2ROAD FMN2ROAE FMN2ROAF FMN2ROAG FMN2ROAH FMN2ROAK FMN2ROAL
  FMN2ROAO FMN2ROAP FMN2ROAQ FMN2ROAS FMN2ROAT FMN2ROAY FMN2ROCX
  FMN2ROLC FMN2ROLD FMN2ROLE FMN2ROLF FMN2ROLG FMN2ROLJ FMN2ROLK
  FMN2ROLL FMN2ROLM FMN2ROLN FMN2ROLO FMN2ROLP FMN2ROLQ FMN2ROLR
  FMN2ROLS FMN2ROLT FMN2ROLX FMN2ROLY FMN2ROXK FMN2RSED FMN2RSEN
  FMN2RVWG FMN2ST00 FMN3CICS FMN3LVL  FMN3LVLJ FMN3MENU FMN3MJPN
  FMN3POPT FMNAPPLY FMNASMX  FMNBA00  FMNBA02  FMNBA16  FMNBF94
  FMNCBLX  FMNCL    FMNCOPYR FMNCREGX FMNDA00  FMNDB30  FMNDB36
  FMNDB89  FMNDD39  FMNELIBD FMNFCLN  FMNFCMBR FMNFCST1 FMNFDTGM
  FMNFSSTR FMNFSTRT FMNFTBTB FMNFTBTU FMNFTDSC FMNFTDSM FMNFTDSP
  FMNFTEXC FMNFTFCH FMNFTFCM FMNFTPBK FMNFTTPI FMNFTTPX FMNFTVLM
  FMNFVWAX FMNIA00  FMNIA27  FMNIDXLS FMNIOXEP FMNKEYS  FMNMAIN
  FMNMAINZ FMNMOD1  FMNMOD16 FMNMOD2  FMNMOD2B FMNMOD2H FMNMOD2S
  FMNMOD6Z FMNMODD  FMNMODPB FMNMODT  FMNPAMSI FMNPAMSL FMNPANL
  FMNPCHGM FMNPCHM2 FMNPCRIX FMNPCRX2 FMNPCRZC FMNPCRZR FMNPCRZX
  FMNPIDXG FMNPIDXH FMNPINDQ FMNPINDX FMNPINX2 FMNPIXGP FMNPIXNM
  FMNPLGXS FMNPMSG  FMNPNEWS FMNPPM34 FMNPREFG FMNPREFH FMNPSRCH
  FMNPXNEW FMNRAMS1 FMNRCHGM FMNRCIX3 FMNRCRX1 FMNRCRX3 FMNRCRZC
  FMNRCRZR FMNREDCC FMNREDCE FMNREDCF FMNRFCP1 FMNRFCP2 FMNRFCP6
  FMNRIDXG FMNRIDXH FMNRIXGP FMNRREFG FMNRREFH FMNRSRCH FMNRXEX
  FMNRXFUN FMNSAMCS FMNSJ1BB FMNSJ1DI FMNSJ1EB FMNSJ1IL FMNSJ1IP
  FMNSJ1IX FMNSRCH  FMNSRCHK FMNSTASK FMNSTRT  FMNVMAC  FMNWD1ST
  

Fix information

• Fixed component name

  FILE MANAGER Z/

• Fixed component ID

  5755AB300

Applicable component levels

• RG10 PSY UO05337

     UP25/10/22 P F510

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.