IBM Support

IC66081: SMARTBLOB STORAGE INFORMATION IS IGNORED IF A TABLE IS ALTERED ADDING CRCOLS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In an instance with two sbspaces defined:
    
       "defsbs"  which is the default sbspace as defined in the
    onconfig parameter SBSPACENAME
       "secondsbs"
    
    Run the following:
    
    1)
       create table blob_er (
    
           idx SERIAL not null,
    
           signature blob,
    
       )
    
       put signature in (secondsbs);
    
       insert into blob_er values (0,filetoblob("myfile","server"));
    
    
    You can verify that the blob object for the newly inserted data
    goes inside "secondsbs" as expected. Also, the table schema
    retrieved with dbschema -ss shows the correct blob storage
    information.
    
    2) Add crcols to the table:
    
            alter table blob_er add crcols;
    
     From this point on, any new INSERT will be sent to the blob in
    the default  sbspace "defsbs" or will fail with an error like:
    
          9810: Smart-large-object error.
        12053: Smart Large Objects: No sbspace number specified.
    
    If there is no default sbspace defined (the parameter
    SBSPACENAME  is empty in the onconfig file) .Also, the output of
    dbschema -ss for the table won't show the blob storage
    information anymore.
    
    3) If you now drop crcols :
    
             alter table blob_er drop crcols;
    
    The behavior will return to normal as described in step 1.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users who enable crcols on a table which has smartblob       *
    * column(s) through "alter table" statement                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Storage information on the smartblob column(s) will be       *
    * missing.                                                     *
    * The problem is that when crcols are enabled through "alter   *
    * table" statement on a table with sblob column(s), column     *
    * colno in system catalog syscolattribs is not updated         *
    * accordingly to reflect the new shallow columns. Also, there  *
    * is a mis-matching column position inside sblob code as well. *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.50.xC7 and above.                              *
    ****************************************************************
    

Problem conclusion

  • Fix goes in 11.50.xC7 and version onwards.
    
    Storage information should be intact when a table with smartblob
    column(s) is altering to enable crcols. System catalog
    syscolattribs is upated to reflect the new column position.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC66081

  • Reported component name

    IBM IDS ENTRP E

  • Reported component ID

    5724L2304

  • Reported release

    B15

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-04

  • Closed date

    2010-10-01

  • Last modified date

    2010-10-01

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

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

    IT01428

Fix information

  • Fixed component name

    IBM IDS ENTRP E

  • Fixed component ID

    5724L2304

Applicable component levels

  • RB15 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 October 2010