This issue occurs because the IDENTITYIGNORE option for DB2 bulkload is no longer supported. In particular, this issue has been seen in the the SAS® Size Optimization Suite (SAS® Pack Optimization or SAS® Size Profiling) Load_STG2DM_Size_translation job when the SIZE_TRANSLATION table is used and in the rpo_alert tasks of SAS® Regular Price Optimization. There is no work-around for this issue.
SAS System | SAS Pack Optimization | 64-bit Enabled AIX | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2008 for x64 | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2008 | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 for x64 | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Standard Edition | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Enterprise Edition | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Datacenter Edition | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
SAS System | SAS Size Profiling | Microsoft Windows Server 2003 Datacenter Edition | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Enterprise Edition | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Standard Edition | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 for x64 | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2008 | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2008 for x64 | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
64-bit Enabled AIX | 2.2 | 2.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2008 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2008 for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
64-bit Enabled AIX | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
SAS System | SAS Markdown Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2008 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2008 for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
64-bit Enabled AIX | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
SAS System | SAS Promotion Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2003 for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2008 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
Microsoft Windows Server 2008 for x64 | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |
64-bit Enabled AIX | 4.2 | 4.2_M1 | 9.2 TS2M2 | 9.2 TS2M3 |