IBM Support

JR31076: DB2 DOES NOT SUPPORT CREATE A INDEX ON FUNCTION, HOWEVER, INFORMIX DOES. CREATE NICKNAME SQL0083C ERROR RETURNED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 does not support create a index on function, However
    informix does. If user create a nickname for a remote table
    that has indexes created on function, will caused db2 failed to
    allocate memory to create the index, you can find the call stack
    like following.
    
    2008-10-29-11.24.27.248480+060 I449518A2048       LEVEL: Warning
    PID     : 7909                 TID  : 1           PROC :
    db2agent (DSPS)
    0
    INSTANCE: db2dwp1              NODE : 000         DB   : DSPS
    APPHDL  : 0-583                APPID: *N0.db2dwp1.081029102423
    AUTHID  : DB2DWP1
    FUNCTION: DB2 UDB, SQO Memory Management, sqlogmblkEx,
    probe:1000
    MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt
    invalid
    size"
              DIA8563C An invalid memory size was requested.
    DATA #1 : String, 43 bytes
    Memory management block allocation failure.
    DATA #2 : Codepath, 8 bytes
    2
    DATA #3 : Memory pool handle pointer,
    PD_TYPE_MEM_POOL_HANDLE_PTR, 8
    bytes
    0x6000000000044870
    DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
    0
    DATA #5 : Adjusted block size, PD_TYPE_MEM_ADJUSTED_SIZE, 8
    bytes
    0
    DATA #6 : Options for requested block, PD_TYPE_GET_MEM_OPTIONS,
    4 bytes
    0x00000008
    DATA #7 : Pointer to address that will be set by new allocation,
    PD_TYPE_PTR_TO_ADDRESS_OUT, 8 bytes
    0x87ffffffffff4890
    DATA #8 : File name, PD_TYPE_OSS_MEM_FILE_NAME, 18 bytes
    sqlrl_datajoiner.C
    DATA #9 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes
    6111
    DATA #10: Resource binding pointer,
    PD_TYPE_RESOURCE_BINDING_PTR, 8
    bytes
    0x0000000000000000
    CALLSTCK:
      [0] 0xC00000000D445C20 sqlogmblkEx + 0x4C0
      [1] 0xC00000000D118470 sqlmoAllocBlock + 0xD0
      [2] 0xC00000000D445D00 sqlogmblkEx + 0x5A0
      [3] 0xC000000010048370
    _Z27sqlrl_create_nickname_indexP8sqlrr_cbP13Nickname_Infomi +
    0x490
      [4] 0xC00000001004FDF0
    _Z24sqlrl_create_nickname_pdP8sqlrr_cbP13Nickname_InfoPhiS3_iPPv
    ttRm +
    0x470
      [5] 0xC0000000100591F0
    _Z28sqlrl_create_nickname_workerP8sqlrr_cbP13Nickname_InfoPhi +
    0x290
      [6] 0xC00000000F1DF3A0
    _Z25sqlnq_create_nickname_twoP8nn_namesP16nickname_optionsP11opt
    ion_pair
    P20sqlnq_multipart_nameS6_P9sqlnq_qunP3loc + 0x580
      [7] 0xC00000000F1DD380
    _Z26sqlnq_create_nickname_stmtPP8stknode_i10actiontypePhP3loc +
    0x9A0
      [8] 0xC00000000D477940 _Z12sqlnp_smactnP8sqlnp_cbi + 0x1020
      [9] 0xC00000000D479530 _Z12sqlnp_parserP8sqlnp_cb + 0x17A0
    
    2008-10-29-11.24.27.469064+060 I451567A489        LEVEL: Error
    PID     : 7909                 TID  : 1           PROC :
    db2agent (DSPS)
    0
    INSTANCE: db2dwp1              NODE : 000         DB   : DSPS
    APPHDL  : 0-583                APPID: *N0.db2dwp1.081029102423
    AUTHID  : DB2DWP1
    FUNCTION: DB2 UDB, catalog services,
    sqlrl_create_nickname_index,
    probe:150
    MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt
    invalid
    size"
              DIA8563C An invalid memory size was requested
    

Local fix

  • Before creating the nickname, drop those indexes where all the
    index columns are on functions.  You can restore the indexes
    after creating the nickname.
    

Problem summary

  • Users affected:
      Users of the Informix wrapper in InfoSphere Federation Server
    Problem description and summary:
      See error description
    

Problem conclusion

  • Problem was first fixed in Version 9.1, FixPak 7 (s090308). This
    fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR31076

  • Reported component name

    INFORMIX WRAPPE

  • Reported component ID

    5724N9710

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-11-12

  • Closed date

    2009-05-11

  • Last modified date

    2009-05-11

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

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

    JR31316

Fix information

  • Fixed component name

    INFORMIX WRAPPE

  • Fixed component ID

    5724N9710

Applicable component levels

  • R910 PSN

       UP

  • R911 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPK","label":"Data Sources and Wrappers - Informix"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 May 2009