Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC95197 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem 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.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9.                       * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in Version 9.7 Fix Pack 9.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC98017 IC98018 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
26.08.2013
23.12.2013
23.12.2013
Problem solved at the following versions (IBM BugInfos)
9.7.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.9 FixList
9.7.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.