IBM Support

IC67709: AF IN RDATAVALVCHAR OBSERVED WITH TRIGGER ON TABLE AND DATA INSERTED INTO VARCHAR COLUMN

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • An AF can occur with a trigger on a table which has a varchar
column that is being inserted to.

The stack shows:

afstack
afhandler
affail_interface
mt_ex_throw_sig
afsig_handler
<signal frame>
rdatavalVchar
ev_column
new_eval
scan_filter
rsseqscan_read
fmseqscan_read
gettupl
scan_next
dodelupd
excommand
ip_evalsql
runproc
udrlm_spl_execute
udrlm_exec_routine
udr_execute
exroutine
execproc
aud_execproc
excommand
dotrstmts
dotrigs
ferafttrig
addone
insone_next
doinsert
excommand
sq_execute
sqmain
spawn_thread
startup

Local fix

  • A possible workaround could be to change the varchar type of the
table inserted into to a char type.

Problem summary

  • ****************************************************************
* USERS AFFECTED:                                              *
* 11.50                                                        *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Server can unexpectedly crash when user is using the         *
* triggering procedure having the table references.            *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to latest 11.50.xCX server.                          *
****************************************************************

Problem conclusion

  • The Latest 11.50 server will correct this issue of unexpected
crash of the server while running the trigger which has
triggerring procedure with table references.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IC67709
    • 

  • Reported component name
    IBM IDS ENTRP E
    • 

  • Reported component ID
    5724L2304
    • 

  • Reported release
    B15
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2010-04-07
    • 

  • Closed date
    2011-01-20
    • 

  • Last modified date
    2011-01-20
    • 





    

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

    • 

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

    • 



Fix information


    

  • Fixed component name
    IBM IDS ENTRP E
    • 

  • Fixed component ID
    5724L2304
    • 



Applicable component levels


    

  • RB15  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            20 January 2011
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback