Problem Note 18374: Bulkload statistics now stored in macro variables
 |  |  |  |  |
Currently statistics generated as a result of doing a bulkload for DB2 on a Windows or Unix platform are written to the SAS log. Five new global macro variables have been added to store statistics about how the process went. These macros are as follows:
SYSBL_ROWSLOADED - number of rows loaded SYSBL_ROWSSKIPPED - number of rows skipped SYSBL_ROWSREJECTED - number of rows rejected SYSBL_ROWSDELETED - number of rows deleted SYSBL_ROWSCOMMITTED - number of rows committed
Select the Hot Fix tab in this note to access the hot fix for this issue.
ATTENTION: This Hot Fix is intended for Unix and Windows customers running the DB2 Client 8.1 Fix Pack 9 or later. Customers running earlier version of the DB2 Client should only install hot fixes prior to E9D205.Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Linux on Itanium | 9.1 TS1M3 | |||
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Linux | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS1M0 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#018374A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#018374| Type: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> DB2 |
| Date Modified: | 2006-09-15 08:53:48 |
| Date Created: | 2006-08-29 13:51:34 |