|
Problem IC74380
|
Status: Closed |
SQL0901 WITH "SCAN INTERFACE ERROR" CAN BE SEEN DURING ADMIN_MOVE_TABLE PROCESSING |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The following error message can be seen during ADMIN_MOVE_TABLE
processing:
SQL0901N The SQL statement failed because of a non-severe
system error.
Subsequent SQL statements can be processed. (Reason "Scan
interface
error".)
This is seen due to the authid mistakenly being nulled while
running ADMIN_MOVE_TABLE. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Persons using ADMIN_MOVE_TABLE *
****************************************************************
* PROBLEM DESCRIPTION: *
* The following error message can be seen during *
* ADMIN_MOVE_TABLE processing: *
* *
* SQL0901N The SQL statement failed because of a non-severe *
* system error. Subsequent SQL statements can be processed. *
* (Reason "Scan interface error".) *
* *
* This is seen due to the authid mistakenly being nulled while *
* running ADMIN_MOVE_TABLE. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 FP5 or newer. *
**************************************************************** |
| Local Fix: |
A workaround for this is to grant the binder of NULLID.AOTMH00
the DBADM privilege, which will skip this code path. The binder
of the package can be found with the following statement:
select char( BOUNDBY, 15)boundby, char(PKGSCHEMA, 15)pkgschema,
char(PKGNAME, 15)pkgname, valid from syscat.packages where
pkgname='AOTMH00' and pkgschema='NULLID' |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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 |
This fix will resolve the issue with authid being nulled so that
the ADMIN_MOVE_TABLE works reliably. |
| Workaround |
A workaround for this is to grant the binder of NULLID.AOTMH00
the DBADM privilege, which will skip this code path. The binder
of the package can be found with the following statement:
select char( BOUNDBY, 15)boundby, char(PKGSCHEMA, 15)pkgschema,
char(PKGNAME, 15)pkgname, valid from syscat.packages where
pkgname='AOTMH00' and pkgschema='NULLID' |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.02.2011
20.12.2011
20.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
