IBM Support

IT32566: DBEXPORT & DBSCHEMA WILL HANG ON AN UPDATABLE RSS NODE CONTAINING SEQUENCES WITHOUT RESTART VALUES AND STOP_APPLY IS ENABLED

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

  • If the database has a number of sequences defined but all have
restart values set to null, then the running of dbexport &
dbschema on the rss node will hang with the following stack â ¦

Stack for thread: 157 sqlexec
 base: 0xc000000213e2c000
  len:   266240
   pc: 0x0000000000000000
  tos: 0xc000000213e6c220
state: sleeping
   vp: 1

0x4000000003a786b0 (r-12.10.FC13/bin/oninit)resume
0x40000000009bf360 (r-12.10.FC13/bin/oninit)yield_processor_mvp
0x40000000009cc480 (r-12.10.FC13/bin/oninit)mt_yield
0x4000000000eab3e0 (r-12.10.FC13/bin/oninit)proxyWriteLSNYield
0x4000000000eaf3e0 (r-12.10.FC13/bin/oninit)proxyWritePostCommit
0x4000000000e6da10 (r-12.10.FC13/bin/oninit)sqiscommit
0x40000000015c3330 (r-12.10.FC13/bin/oninit)sqcommit
0x40000000015c2140 (r-12.10.FC13/bin/oninit)aud_sqcommit
0x4000000002a43df0 (r-12.10.FC13/bin/oninit)sql_commit
0x4000000002a439c0 (r-12.10.FC13/bin/oninit)sq_commit
0x400000000195d510 (r-12.10.FC13/bin/oninit)sqmain
0x4000000002e1a870 (r-12.10.FC13/bin/oninit)listen_verify
0x4000000002e13b00 (r-12.10.FC13/bin/oninit)spawn_thread
0x40000000010523a0 (r-12.10.FC13/bin/oninit)th_init_initgls
0x4000000000a080d0 (r-12.10.FC13/bin/oninit)startup
0x4000000003a786a0 (r-12.10.FC13/bin/oninit)coroutine_start

If stop_apply is turned off, then the job completes.

If the sequence restart_val columns are updated to contain
values, then the problem is not seen.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC16 and 14.10.xC7.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC16 or 14.10.xC7.          *
****************************************************************

    



Problem conclusion


    

  • Fixed in Informix Server 12.10.xC16 and 14.10.xC7.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT32566
    • 

  • Reported component name
    INFORMIX SERVER
    • 

  • Reported component ID
    5725A3900
    • 

  • Reported release
    C10
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2020-04-16
    • 

  • Closed date
    2023-05-04
    • 

  • Last modified date
    2023-05-04
    • 





    

  • 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
    INFORMIX SERVER
    • 

  • Fixed component ID
    5725A3900
    • 



Applicable component levels


    








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            05 May 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback