IBM Support

IC98017: IF A TABLE HAS DB2SECURITYLABEL COLUMN, ADMIN_MOVE_TABLE FAILED WITH SQL0683N.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • You may fail to move table that has a DB2SECURITYLABEL column
    (row level security label) using ADMIN_MOVE_TABLE because
    if the user will return the following message. The message might
    be different on  different DB2 version or fixpack level.
    
    ADMIN_MOVE_TABLE failed with SQL0683N:
    SQL0683N  The specification for column, attribute, user-defined
    type or
    function "USER_SECURITY" contains incompatible clauses.
    SQLSTATE=42842
    
    If there's row level LBAC defined on the table, DB2 used to
    block the move table in ADMIN_MOVE_TABLE because if the user
    cannot access all rows in the LBAC table, the move may cause
    data loss.
    
    However, if the user id has all privileges to access all rows,
    and DBA is aware of that if the user cannot access all rows, the
    move may cause data loss, the APAR is to provide a new option
    ALLOW_RLBAC to allow the move data.
    The KEEP and ALLOW_RLBAC may be required to be specified
    together.
    
    For example,
    call
    admin_move_table('TEST','TAB1','newtbs','newtbs','newtbs','','',
    '','','ALLOW_RLBAC, COPY_USE_LOAD, KEEP','MOVE,TRACE')
    
    The original table will be renamed and kept in the table space
    so that the original table can be used for data recovery purpose
    in case data loss during move due to access permission.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All platform                                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 10.1 Fix Pack 4                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 10.1 Fix Pack 4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC98017

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-11-28

  • Closed date

    2014-06-02

  • Last modified date

    2014-06-02

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

    IC95197

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 10.1

Reference #: IC98017

Modified date: 02 June 2014