IBM Support

IC89114: SQL0901N "ERROR LOADING TYPE PD (SQLRL_FTC_TYPEPD)" FOR EXPLICIT REBIND OF A PACKAGE IN DPF

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • In DPF environments, an explicit rebind of a package for a
    stored procedure hits -901, if the procedure uses UDT and the
    UDT was previously dropped.
    
    The following is reported in the db2diag.log
    
    2012-11-03-11.30.58.248415-240 I1330148E863        LEVEL: Severe
    PID     : 14392                TID  : 46916985416000PROC :
    db2sysc 1
    INSTANCE: db2inst1             NODE : 001          DB   : SAMPLE
    APPHDL  : 1-38882              APPID: *N1.db2inst1.121103153005
    AUTHID  : DB2INST1
    EDUID   : 939                  EDUNAME: db2agent (CAPO) 1
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
    probe:300
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 40
     sqlerrmc: Error loading type pd (sqlrl_ftc_typepd)
     sqlerrp : SQLNN0C9
     sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)
    0x00000000
               (4) 0x00000000      (5) 0xFFFFFF9C      (6)
    0x00000001
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
    
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    
    
    The relevant stack file indicates that the error occurred in
    sqlnnCheckNestedTypeInDPF.
    

Local fix

  • Recreate the UDT and revalidate the corresponding routine during
    next access or call sysproc.admin_revalidate_db_objects, instead
    of rebinding the package.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to v9.7 Fixpack 10                                    *
    ****************************************************************
    

Problem conclusion

  • First fixed in v9.7 Fixpack 10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89114

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-14

  • Closed date

    2014-08-11

  • Last modified date

    2014-08-11

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

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

    IC97839

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC89114

Modified date: 11 August 2014