Usage Note 20976: An error might occur when you perform concurrent uploads to DB2 partitioned databases
 |  |  |  |  |
When you perform concurrent uploads to DB2 databases using the option
BULKLOAD=YES with the option BL_METHOD=CLILOAD, you might get the
following error message:
SQL6555N The load utility encountered an unexpected communications
error.
You might need additional ports to perform the concurrent uploads. The
provided hot fix enables you to specify the port range that the software
will use in the CLI LOAD interface. You define the range with the new
options BL_PORT_MIN= and BL_PORT_MAX=, which are in the hot fix. This
port range corresponds with the piPortmin and piPortMax member of the
piPortRange structure that SAS/ACCESS Interface to DB2 passes to DB2.
For more information on the piPortRange structure, see the DB2 Data
Movement Utilities Guide and Reference that is available from IBM.
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 versions 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 | |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |||
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |||
| 64-bit Enabled Solaris | 9.1 TS1M3 | |||
| Linux | 9.1 TS1M3 | |||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | |||
| 64-bit Enabled AIX | 9.1 TS1M3 | |||
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#020976A 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#020976| Type: | Usage Note |
| Priority: | |
| Topic: | SAS Reference ==> LIBNAME Engines Data Management ==> Data Sources ==> External Databases ==> DB2 |
| Date Modified: | 2009-07-10 16:31:28 |
| Date Created: | 2007-09-18 13:37:49 |