IBM Support

IC65376: REPACK OPERATION FAILED WITH ISERRNO 0 AFTER A SUCCESSFUL COMPRESSION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Issues with compression,  repack operation fails after a
successful compression operation.
The following is shown in the online.log:


12:02:32 SCHAPI Estimate Compression for

database:table.cus_ses started
12:02:32 SCHAPI table estimate_compression

cintdqa:dbaccsc.hcusxtpd_prt_dtl succeeded

12:03:33  SCHAPI Repack for database:table.cus_ses started
12:03:33 Repack operation failed for database:table.cus_ses,
iserrno 0

12:03:33 SCHAPI ERROR: table repack_offline

database:table.cus_ses failed
12:04:52  Checkpoint Completed:  duration was 0 seconds.

12:04:52 Mon Dec 14 - loguniq 1101, logpos 0xdd7018, timestamp:

0x26c5e59b Interval: 14997



12:04:52  Maximum server connections 439

12:04:52 Checkpoint Statistics - Avg. Txn Block Time 0.000, #
Txns
blocked 0, Plog used 49, Llog used 55

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Users compressing tables                                     *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Compressing tables with pending in place alters can corrupt  *
* indices.                                                     *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.50.xC7 and above.                              *
****************************************************************

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments



APAR Information




    

  • APAR number
    IC65376
    • 

  • Reported component name
    IBM IDS ENTRP E
    • 

  • Reported component ID
    5724L2304
    • 

  • Reported release
    B15
    • 

  • Status
    CLOSED  FIN
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2010-01-04
    • 

  • Closed date
    2010-10-01
    • 

  • Last modified date
    2010-10-01
    • 





    

  • 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


    

  • RB15  PSN
       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:
            

            01 October 2010
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback