IBM Support

PH54752: Receive SQLCODE -805 when attempting to view Db2 tables with FM v15.1 and bind job FMN2BN2K was run using Db2 v12 FL100

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Receive the following SQLCODE -805 when attempting to
view/edit Db2 tables with FM/Db2 v15.1 when bind job FMN2BN2K
was run for FM/Db2 v15.1 using Db2 v12 FL100


SQLCODE :  -805

 DSNT408I SQLCODE = -805, ERROR:  DBRM OR PACKAGE NAME
 CAROYI01ZDB2..FMN2D2IB.1B7AD9F609AFB920 NOT FOUND IN PLAN
 FMN2PLAN. REASON 03

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: FM/Db2 V15 users running Db2 V12 FL100       *
****************************************************************
* PROBLEM DESCRIPTION: FM/Db2 V15 does not currently support   *
*                      accessing a Db2 V12 FL100 subsystem.    *
****************************************************************
* RECOMMENDATION: Apply the provided PTF.                      *
****************************************************************
Db2 V12 FL100 is running compatibility mode with Db2 V11 and the
GA version of FM/Db2 V15 only supported accessing and issuing of
the GEN command against Db2 V12 FL150 and higher subsystems.

    



Problem conclusion


    

  • FM/Db2 V15 is modified to allow access and issuing of the GEN
command in Db2 V12 FL100 subsystems by binding using the
FMN2BN1K sample member

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH54752
    • 

  • Reported component name
    FILE MANAGER Z/
    • 

  • Reported component ID
    5755A0300
    • 

  • Reported release
    F10
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2023-05-25
    • 

  • Closed date
    2023-10-11
    • 

  • Last modified date
    2023-11-01
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  • FMN2ACOO FMN2ACSO FMN2AGDO FMN2APMO FMN2APRO FMN2AREO FMN2ARMO
FMN2ARPO FMN2ARRO FMN2ARSO FMN2ARTO FMN2ARYO FMN2ASLO FMN2ASQO
FMN2ASWO FMN2AZPO FMN2BN1K FMN2BN2K FMN2BN3K FMN2BN3P FMN2CHK
FMN2DATA FMN2FCQT FMN2FDBI FMN2FDBX FMN2FDFM FMN2FSC4 FMN2FSC5
FMN2FTU2 FMN2FX2C FMN2FX2D FMN2GEN  FMN2INEX FMN2LVL  FMN2MENU
FMN2MJPN FMN2P0KB FMN2P0KR FMN2PEXO FMN2PIOP FMN2POKB FMN2POKR
FMN2PXO2 FMN2PXOB FMN2RBO4 FMN2RDPZ FMN2REO5 FMN2RET1 FMN2RET2
FMN2REXO FMN2RGEN FMN2RIM5 FMN2RIMA FMN2RIMB FMN2RIML FMN2RRT6
FMN2RRT8 FMN2RTSS FMN2RX62 FMN2RXO9 FMN2RXOE FMN2RXTO FMN2ST00
FMNDA00  FMNDC17  FMNMOD2  FMNMOD2G FMNMOD2I

    



Fix information


    

  • Fixed component name
    FILE MANAGER Z/
    • 

  • Fixed component ID
    5755A0300
    • 



Applicable component levels


    

  • RF12  PSY  UI93971
       UP23/10/19  P  F310
    • 



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":"F10"}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 November 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback