SAP Knowledge Base Article - Preview

1512284 - VARCHAR data fields ALLOCATE attributes and DB2 performance with Data Services / Data Integrator jobs

Symptom

  • Data Integrator creates template tables in an IBM iSeries DB2 database the VARCHAR format columns have a default ALLOCATE attribute value of 0.
  • Hope to set this ALLOCATE attribute to a value that matches the VARCHAR length of the field in an effort to improve database performance.
  • Is there an attribute or setting that can be performed in DIXI R2 to set this ALLOCATE attribute to a different number?


Read more...

Environment

  • Data Integrator XI R2
  • IBM iSeries DB2 database
  • iSeries Client Access for Windows                                                                                                                          
                                                                                                                                        
            

Product

SAP Data Integrator XI R2 ; SAP Data Integrator XI R2 Accelerated ; SAP Data Services XI 3.0 ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2

Keywords

KBA , EIM-DI , Data Integrator, Composer , EIM-DS , Data Services , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.