IBM Support

PI98470: BIG SQL MAY TRAP WHEN USING THE SPECIAL REGISTER CURRENT DECFLOAT ROUNDING MODE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Queries which use the SPECIAL REGISTER CURRENT DECFLOAT
ROUNDING MODE like the one given below may trap in
sqlriInitSpecialRegisters.
     SELECT CURRENT DECFLOAT ROUNDING MODE FROM SYSIBM.SYSDUMMY1
Following stack may be noticed:
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007F36D44C17F6
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0356
               (/home/bigsql/sqllib/lib64/libdb2osse.so.1)
0x00007F36D44C143B ossDumpStackTraceV98 + 0x002b
               (/home/bigsql/sqllib/lib64/libdb2osse.so.1)
0x00007F36D44BD5E7 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00d7
               (/home/bigsql/sqllib/lib64/libdb2osse.so.1)
0x00007F36DB6FA787 sqlo_trce + 0x03c7
               (/home/bigsql/sqllib/lib64/libdb2e.so.1)
0x00007F36DB860B41 sqloEDUCodeTrapHandler + 0x03b1
               (/home/bigsql/sqllib/lib64/libdb2e.so.1)
0x00007F36E312A5E0 address: 0x00007F36E312A5E0 ; dladdress:
0x00007F36E311B000 ; offset in lib: 0x000000000000F5E0 ;
               (/lib64/libpthread.so.0)
0x00007F36DC64D03A
_Z25sqlriInitSpecialRegistersP8sqlrr_cbP9sqlri_shd + 0x050a
               (/home/bigsql/sqllib/lib64/libdb2e.so.1)
0x00007F36DC651E04
_Z26sqlriSectInitializeComplexP8sqlrr_cbP9sqlri_shdb + 0x06d4
               (/home/bigsql/sqllib/lib64/libdb2e.so.1)
0x00007F36DBE8B8A9 _Z24sqlraInitSectionAndFlagsP8sqlrr_cbb +
0x0039
               (/home/bigsql/sqllib/lib64/libdb2e.so.1)
0x00007F36DBE7F4BC address: 0x00007F36DBE7F4BC ; dladdress:
0x00007F36D4A11000 ; offset in lib: 0x000000000746E4BC ;
               (/home/bigsql/sqllib/lib64/libdb2e.so.1)
0x00007F36DBE7D19A
_Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x06ca
               (/home/bigsql/sqllib/lib64/libdb2e.so.1)

This is related to the Db2 APAR: IT18506
The Db2 APAR leads to a wrong result while in Big SQL, we
result in a trap.

Local fix

  • 



Problem summary


    

  • Please see problem description.

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI98470
    • 

  • Reported component name
    IBM BIG SQL
    • 

  • Reported component ID
    5737E7400
    • 

  • Reported release
    500
    • 

  • Status
    CLOSED  FIN
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2018-05-28
    • 

  • Closed date
    2020-09-09
    • 

  • Last modified date
    2020-09-09
    • 





    

  • 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


    








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"500"}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            10 September 2020
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback