|
Problem IC62928
|
Status: Geschlossen |
UTL_MAIL AND UTL_SMTP MODULES FAIL WITH "BAD ARGUMENT" AND SQL0443 WHEN DB2_COMPATIBILITY_VECTOR=ORA |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
The two modules UTL_MAIL and UTL_SMTP provide routines that will
interface with an SMTP server and can send emails.
If the db2set parameter DB2_COMPATIBILITY_VECTOR=ORA, then some
of the routines in these modules may fail with the following
message:
SQL0443N Routine "UTL_TCP.IMP_WRITE_TEXT" (specific name
"UTL_TCP_IMP_WRITE_TEXT") has returned an error SQLSTATE with
diagnostic text
"UTL_TCP.BAD_ARGUMENT". SQLSTATE=5UA0I
This APAR will fix the condition that leads to this SQL error,
however it is important to note that it will only fix databases
that are created or upgraded to DB2 version 9.7 fixpack 1 or
later.
If there is an existing database that is created or upgraded to
the v9.7 GA release level, then this APAR will not be able to
patch the existing database. If this is needed, please contact
IBM support. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users wtih DB2_COMPATIBILITY_VECTOR set to ORA *
****************************************************************
* PROBLEM DESCRIPTION: *
* UTL_MAIL AND UTL_SMTP MODULES FAIL WITH "BAD ARGUMENT" AND *
* SQL0443 WHEN DB2_COMPATIBILITY_VECTOR=ORA *
****************************************************************
* RECOMMENDATION: *
* upgrade to v97 FP1 *
**************************************************************** |
| Local-Fix: |
none. However if you drop the database and create again new
without any DB2_COMPATIBILITY_VECTOR setting, then the problem
will no longer happen. |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a 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 10 for Linux, UNIX, and Windows
|
| Lösung |
UTL_MAIL AND UTL_SMTP MODULES FAIL WITH "BAD ARGUMENT" AND
SQL0443 WHEN DB2_COMPATIBILITY_VECTOR=ORA |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 01.09.2009
04.01.2010
04.01.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP1
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
