SAP Knowledge Base Article - Preview

3249720 - DB2LUW: DISTRIBUTE BY HASH clause is not reversed for column-organized table SAP PD


  • Reverse Engineering a DB2 database, the DISTRIBUTE BY HASH statement is not determined and not adopted.
  • The DISTRIBUTE BY HASH clause is not reversed for DB2 column-organized tables. Works fine for row-organized table.



  • SAP PowerDesigner (PD) 16.7
  • DBMS : IBM DB2 Version 11.x for Linux, UNIX, and Windows.
  • JDBC Connection


SAP PowerDesigner 16.7


DB2, "distribute by hash", CR827173 , CR#827173 , 827173 , KBA , BC-SYB-PD , PowerDesigner , Problem

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.