IBM Support

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as Permanent restriction.

Error description

  • Migration of 32-bit 9.7 databases to 64-bit version of DB2 v9.7,
    v9.8 or v10.1 does not revalidate the LANGUAGE SQL system
    routines the database, including system modules like
    `SYSIBMADM.UTL_MAIL'.
    
    Here is a sample error message 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. Durinq SQL
    processinq it returned:
    SQL0471N Invocation of routine
    "SYSIBMADM.UTL_MAIL.SEND_ATTACH_VARCHAR2" failed due to reason
    "1". SQLSTATE=5502
    

Local fix

  • Workaround for this issue is to create a new 64-bit database on
    a 64-bit instance (which will fix the issue with the system
    routines), then 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 in.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 LUW                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * contact DB2 Support to obtain fix-up tool specific to        *
    * release and build level                                      *
    ****************************************************************
    

Problem conclusion

  • There is no permanent resolution to this problem that can be put
    into fix pack, this has to be addressed per customer basis.
    In case of occurrence , APAR text  contains request to contact
    DB2 Support to obtain fix-up tool specific to release and build
    level.
    This tool has been added to
    /vbs/db2tools/dbappext/utility/src/pvmMigration.
    
    Run the internal-use-only 'db2svcpw' utility to generate a
    service mode password for the customer.  Provide the password,
    along with the 'pvmMigration' tool, to the customer experiencing
    the problem.
    
    Please ask the customer to :
    1. set up the service password.  (Substitute the actual password
    for 'password', below.)
        export DB2SVCPW=password
        db2stop
        db2start
    
    2. Run the pvmMigration tool:
        pmvMigration <dbname>
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC92134

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PRS

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-05-07

  • Closed date

    2013-10-01

  • Last modified date

    2013-10-01

  • APAR is sysrouted FROM one or more of the following:

    IC87081

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 October 2013