IBM Support

IC70178: GEIE-EDITION: ONCHECK -CI PLACES UPDATE LOCKS ON EACH DATA ROW

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

  • In Growth Edition an index check (oncheck -cI) places update
locks on each data row.

> oncheck -cI ge:mytab#i_mytab_id

Validating index i_mytab_id for ge:informix.mytab...
      Index i_mytab_id
        Index  fragment partition dbs1 in DBspace dbs1

> onstat -k

IBM Informix Dynamic Server Version 11.50.FC7W1GE -- On-Line --
Up 00:11:49 -- 1197980 Kbytes

Locks
address   wtlist owner     lklist    type     tblsnum  rowid
key#/bsiz

...
44fb7c70  0      841e9bf0  44fb7bf0  HDR+U    20036c   bf3e
  0
44fb7cf0  0      841e9bf0  44fb7c70  HDR+U    20036c   bf3f
  0
44fb7d70  0      841e9bf0  44fb7cf0  HDR+U    20036c   bf40
  0
44fb7df0  0      841e9bf0  44fb7d70  HDR+U    20036c   bf41
  0
44fb7e70  0      841e9bf0  44fb7df0  HDR+U    20036c   bf42
  0
44fb7ef0  0      841e9bf0  44fb7e70  HDR+U    20036c   bf43
  0
44fb7f70  0      841e9bf0  44fb7ef0  HDR+U    20036c   c001
  0
 12803 active, 320000 total, 16384 hash buckets, 4 lock table
overflows

Local fix

  • Customers who own a license for parallel operations might use
GE_ALLOW_PARALLEL 1 in ONCONFIG.

Problem summary

  • ****************************************************************
* USERS AFFECTED:                                              *
* Growth edition users                                         *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Oncheck -cI will be slow.                                    *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to the latest version 11.50.xc8.                     *
****************************************************************

Problem conclusion

  • Problem fixed in version 11.50.xc8.  Oncheck -cI will be faster
and will not consume the update locks.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IC70178
    • 

  • 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-07-25
    • 

  • 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  PSN
       UP
    • 

  • 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