IBM Support

JR43891: SQL STATEMENT FAILED WITH -901 ERROR REASON "BAD OPCODE ...(SYSIBM.DJ_RPAD)"

Fixes are available

DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Running a SQL ststement failed with following error:

SQL0901N  The SQL statement failed because of a non-severe
system error.
Subsequent SQL statements can be processed.  (Reason "Bad Opcode
-9, ref_arity 3, sqlnq_pid ID 941 (SYSIBM.DJ_RPAD)".)
SQLSTATE=58004

The root cause is that DJ_RPAD function has no related function
mapping for AS400 datasource.  The fix will add function mapping
for DJ_RPAD for AS400 datasource.

Local fix

  • 



Problem summary


    

  • User affected:
  Users who use DRDA wrapper of InfoSphere Federation Server
Problem description and summay:
  See error description

    



Problem conclusion


    

  • Problem was fistly fixed in Version 9.7, FixPak 8. This
fix should be applied on the federation Server.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR43891
    • 

  • Reported component name
    FEDERATION SERV
    • 

  • Reported component ID
    5724N9700
    • 

  • Reported release
    970
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2012-08-24
    • 

  • Closed date
    2013-04-09
    • 

  • Last modified date
    2013-04-09
    • 





    

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

    • 

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

    
IC88648
    

    • 



Fix information


    

  • Fixed component name
    FEDERATION SERV
    • 

  • Fixed component ID
    5724N9700
    • 



Applicable component levels


    

  • R970  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            12 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback