Problem Note 39857: ERROR: The "IDENTITYIGNORE" option is incompatible with the "SPECIFIED FORMAT" option
 |  |  |  |  |
You might encounter the following error when running SAS® Merchandise Intelligence ETL jobs or the DI_JOB job in conjunction with a DB2 database:
ERROR: [IBM][CLI Driver][DB2/NT] SQL3525N The "IDENTITYIGNORE" option is incompatible with the "SPECIFIED FORMAT" option.
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.
Click the Hot Fix tab in this note to access the hot fix for this issue. NOTE: The Hot Fix only fixes this issue for the SAS® Size Optimization Suite. A fix for this issue for the SAS® Revenue Optimization Suite is planned for a future software release.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | ||