IBM Support

IV27894: LOW PERFORMANCE FOR MORE NO. OF RECORDS WHEN DB2 FILES ARE CONVERTED TO FLAT FILE (DTOF) IN CICSDDT.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Records unload slow form file when using DB2 as the file
manager.

Local fix

  • 



Problem summary


    

  • When db2 files with large number of records are converted to a
flat file using dtof option of cicsddt command ,it takes a long
time to complete.

    



Problem conclusion


    

  • It is observed that for each record of db2 files processed, the
status is printed out to know the progress of the cicsddt
command.  This printing of the status impacts the performance of
the cicsddt command when  the db2 file records are large.
cicsddt is modified to print the status only if -v option is
specified to the command.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IV27894
    • 

  • Reported component name
    TXSERIES V6 AIX
    • 

  • Reported component ID
    5724AX600
    • 

  • Reported release
    620
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2012-09-12
    • 

  • Closed date
    2012-10-03
    • 

  • Last modified date
    2012-10-03
    • 





    

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

    • 

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

    
IV29433
    

    • 



Fix information


    

  • Fixed component name
    TXSERIES V6 AIX
    • 

  • Fixed component ID
    5724AX600
    • 



Applicable component levels


    

  • R620  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGMGV","label":"CICS Transaction Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.2","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            10 March 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback