|
Problem IC85101
|
Status: Closed |
UTL_MAIL.SEND() PROCEDURE RETURNS SQL1336N |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
UTL_MAIL.SEND() procedure returns SQL1336N on correctly
configured DB2 installation.
Example:
db2 "CALL UTL_MAIL.SEND('user1@ibm.com', 'user2@ibm.com',
NULL, NULL, 'TEST', 'TEST)"
SQL1336N The remote host "mailserver.ibm.com" was not found.
SQLSTATE=08001. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users running DB2 on Oracle Solaris 10. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 7. *
* Oracle Solaris 10 fix for CR# 6847733 'getaddrinfo returns *
* wrong protocol' is required. *
**************************************************************** |
| Local Fix: |
The Oracle reference for the getaddrinfo is 6847733
This apar is fixed in V9.7 Fix Pack 7 and Fix Pack 8, however
when the Oracle Solaris patch is installed, the current fix in
Fix Pack 7 and 8 does not behave correctly. This has been
reported as apar IC95179 to be addressed in Fix Pack 9.
So until apar IC95179 has been fixed, the advice is not to
install the Solaris patch. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 Version 9.7 Fix Pack 7. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC88309
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.07.2012
20.10.2012
26.08.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
