IBM Support

II13084: STORED PROCEDURE BUILDER WEBSITE TO ASSIST IN INSTALLATION AND SETUP FOR STORED PROCEDURE BUILDER ON THE MAINFRAME ZOS/OS390

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as canceled.

Error description

  • Users attempting to install stored procedure builder from the
db2 connect (personal or Enterprise) experience the following
error messages when performing the connect to the mainframe
ie.. os/390 or zOS.
Please review the following website:
http://www-4.ibm.com/software/data/db2/os390/sqlproc/sqlp6.html
...
If you experience the following error message:
ERROR: Call to DSNTPSMP failed
-----> Processing halted
  DSNT408I SQLCODE = -471, ERROR:  INVOCATION OF FUNCTION OR PRO
           DSNTPSMP FAILED DUE TO REASON 00E79106
  DSNT418I SQLSTATE   = 55023 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNX9CAC SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 0  0  0  -1  0  0 SQL DIAGNOSTIC INFORMA
  DSNT416I SQLERRD    = X'00000000'  X'00000000'  X'00000000'  X
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
..
Either from running the stored procedure builder from your
workstation or from the IVP job dsntej65.  Chances are that
you are missing either the db2 rexx feature or you are missing
apar PQ45202 (UQ51033)
..
Another issue if you see message:
CEE3608I The following messages pertain to the invocation
command run-time options
CEE3606I The string ' ' was too long and was ignored.
this is resolved by apar pq47236, ptf uq53180
SPB

Local fix

  • 



Problem summary


    

  • 



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • Informational Apar for Stored procedure builder tool

    



APAR Information




    

  • APAR number
    II13084
    • 

  • Reported component name
    PB LIB INFO ITE
    • 

  • Reported component ID
    INFOPBLIB
    • 

  • Reported release
    001
    • 

  • Status
    CLOSED  CAN
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2001-11-14
    • 

  • Closed date
    2001-11-14
    • 

  • Last modified date
    2001-11-14
    • 





    

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

    • 

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

    • 



Fix information


    



Applicable component levels


    








      
              
                            

              

              [{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            14 November 2001
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback