PM07633 - Major Performance Improvement for V7 -> V8 migrations

Previous topic - Next topic

Ed_Arnold

This APAR makes a huge difference.

ERROR DESCRIPTION:                                               
arsdb command import option (-i) performance degradation occurs 
due to frequency of commits. Even though the arsdb import code   
itself does not issue explicit commits, code elsewhere in arsdb 
turns on the ODBC auto-commit setting, a fact that the code to   
do the import was not cognizant of. (The auto-commits don't     
show up in an ODBC application trace.) 
                         
#zOS #ODF

Ed_Arnold

Oops - the title is a bit misleading, don't know how to edit it.

This APAR affects H272741, H272841, H27284A .... in other words, if you're migrating from V2 -> V7 it'll improve table load throughput at that release as well.

PROBLEM DESCRIPTION(S):                                           
  PM07633 -                                                       
    ***************************************************************
    * USERS AFFECTED: All Content Manager OnDemand for z/OS users 
    *                 using arsdb -i                               
    ***************************************************************
    * PROBLEM DESCRIPTION: arsdb -i can experience long import     
    *                      times                                   
    ***************************************************************
    * RECOMMENDATION: None.                                       
    ***************************************************************
    arsdb -i was running with the ODBC autocommit enabled.  This   
    caused a commit to be performed after every insert of a row   
    into the table being imported.                                 
#zOS #ODF

Ed_Arnold

This code change provides so much improvement it's been marked HIPER:
                                                                     
http://www-01.ibm.com/support/docview.wss?uid=isg1_ODMP710_H272711 

R711 PSY UK55884                                                     
R84A PSY UK55885                                                     
R841 PSY UK55886
                                                     
                                                                     

#zOS #ODF