home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC87081 Status: Geschlossen

SQL0471N IS RETURNED UPON CALLING LANGUAGE SQL ROUTINES AFTER MIGRATION OF
32-BIT DATABASES TO 64-BIT VERSION

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Migration of 32-bit Version 9.7 databases to 64-bit versions of 
DB2 Version 9.7, 9.8, or 10.1 does not revalidate LANGUAGE SQL 
user and system routines, including system modules like 
'SYSIBMADM.UTL_MAIL'. 
 
Here is a sample error message that might appear when you call 
routine 'SYSIBMADM.UTL_MAIL' : 
 
CALL UTL_MAIL.SEND_ATTACH_VARCHAR2(v_sender, v_recipients, 
NULL.NULL, v_subj, v_msg, NULL, NULL, v_attachment, False, null, 
v_att_name); 
 
DB21034E The command was processed as an SQL statement because 
it was not a valid Command Line Processor command. During SQL 
processinq it returned: SQL0471N Invocation of routine 
"SYSIBMADM.UTL_MAIL.SEND_ATTACH_VARCHAR2" failed due to reason 
"1". SQLSTATE=5502 
 
The purpose of this APAR is to create a tool called pvmMigration 
that will migrate both user and system 32-bit routines to 64-bit 
versions.  Please contact IBM DB2 Support to obtain the tool for 
your db2level. 
 
Note: It is recommended to upgrade first to at least DB2 Version 
9.7 Fix Pack 8 to use the tool.  It may work on earlier Fix 
Packs; however, this has not been tested.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW v97 v101                                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please contact DB2 support to obtain a tool, specific to     * 
* your release and build level, that will repair the system    * 
* module definitions in your database.                         * 
****************************************************************
Local-Fix:
It is possible to correct a user routine by dropping and 
recreating it. 
 
In the absence of the 'pvmMigration' tool, it is possible to 
correct the system routines with the following workaround: 
 
First, create a new 64-bit database on a 64-bit instance; this 
will create fresh 64-bit versions of the system routines.  Once 
the database is created, recreate all DDL, export the data from 
the existing database, and import it into the new one. 
Basically, rebuild the database from scratch and import the data 
from the old database into the new one.
verfügbare FixPacks:
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

Lösung
Please contact DB2 support to obtain a tool, specific to your 
release and build level, that will repair the system module 
definitions in your database.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC92134 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.10.2012
13.05.2013
04.06.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.8 FixList