ADMIN_MOVE_TABLE may fail with error SQL2103N / Reason code 6

Technote (FAQ)


Question


Row level Label-based access control (LBAC) protect tables cannot be moved using ADMIN_MOVE_TABLE procedure. The main reason that we block the move is that some data (rows) may not be seen by the user who performed online table move (OTM), so that the data might be lost. But the column level LBAC is supported because it is merely an access control, and does not hide or mask data.

Simiar restriction applies to newly added feature in DB2 version 10.1 i.e row and column access control (RCAC) which is sometimes referred to as fine-grained access control or FGAC.

$ db2 "CALL SYSPROC.ADMIN_MOVE_TABLE ('SAMPLE', 'TABLE1','TABLE1', 'TABLE1', 'TABLE1','', '', '', '', '', 'MOVE')"
SQL2103N  The ADMIN_MOVE_TABLE procedure could not be completed because some
aspect of either the source table or target table is not supported by the
ADMIN_MOVE_TABLE procedure.  Reason code: "6".  SQLSTATE=5UA0M

You can verify table protection granularity by looking at PROTECTIONGRANULARITY column of the table by running below query :

db2 "select protectiongranularity from syscat.tables where tabname='table_name'"

Value includes :
B = Both column- and row-level granularity
C = Column-level granularity
R = Row-level granularity
Blank = Non-protected table


Answer

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7, 9.8, 10.1, 10.5

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1647001

Modified date:

2013-08-15

Translate my page

Machine Translation

Content navigation