home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT03675 Status: Geschlossen

DB2EXMIG DOES NOT PRESERVE PERMISSIONS ON RECREATED TABLES

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
It is expected that the migrated explain tables are usable by 
the same users before/after the db2exmig, but that doesn't 
happen on 10.5 . After upgrading a database  to v10.5 FP3 there 
are new/recreated function and tables from the db2exmig output 
however the permission granted to tables that existed before the 
migration are lost. Looking at the permissions before/after the 
db2exmig (using the db2look tool) no permissions are granted to 
the tables before the migration. 
 
Example: 
 
$ db2look -d test -x -a 
-- Generate statistics for all creators 
-- This CLP file was created using DB2LOOK Version "10.5" 
-- Timestamp: Mon Jul 28 15:14:50 EDT 2014 
-- Database Name: TEST 
-- Database Manager Version: DB2/AIX64 Version 10.5.3 
-- Database Codepage: 1208 
-- Database Collating Sequence is: SYSTEM_819 
-- Alternate collating sequence(alt_collate): null 
-- varchar2 compatibility(varchar2_compat): OFF 
 
-- Binding package automatically ... 
-- Bind is successful 
-- Binding package automatically ... 
-- Bind is successful 
 
CONNECT TO TEST; 
 
-------------------------------------------- 
-- Authorization Statements on Tables/Views 
-------------------------------------------- 
 
 
GRANT SELECT ON TABLE "DB2INST  "."EXPLAIN_PREDICATE" TO USER 
"TEST    " ; 
 
COMMIT WORK; 
 
CONNECT RESET; 
 
TERMINATE; 
 
 
 
$ db2exmig -d test -e DB2INST 
DB2 Universal Database Version 10.5, 5622-044 (c) Copyright IBM 
Corp. 1999, 2012 
Licensed Material - Program Property of IBM 
IBM DATABASE 2 Explain Table Migration Tool 
 
Connecting to the Database. 
Connect to Database Successful. 
Binding package - Bind was Successful 
Migrating Explain Tables from v9.7FP1 or later to current 
release. 
 
Examining the columns for table DB2INST.EXPLAIN_INSTANCE 
Found table DB2INST.EXPLAIN_STATEMENT. No changes required for 
this migration. 
Found table DB2INST.EXPLAIN_ARGUMENT. No changes required for 
this migration. 
Examining the columns for table DB2INST.EXPLAIN_OBJECT 
Found table DB2INST.EXPLAIN_OPERATOR. No changes required for 
this migration. 
 
Examining the columns for table DB2INST.EXPLAIN_PREDICATE 
Found table DB2INST.EXPLAIN_STREAM. No changes required for this 
migration. 
Found table DB2INST.EXPLAIN_DIAGNOSTIC. No changes required for 
this migration. 
Found table DB2INST.EXPLAIN_DIAGNOSTIC_DATA. No changes required 
for this migration. 
Found table DB2INST.EXPLAIN_ACTUALS. No changes required for 
this migration. 
Found table DB2INST.ADVISE_INSTANCE. No changes required for 
this migration. 
 
Examining the columns for table DB2INST.ADVISE_INDEX 
Found table DB2INST.ADVISE_WORKLOAD. No changes required for 
this migration. 
Found table DB2INST.ADVISE_MQT. No changes required for this 
migration. 
Found table DB2INST.ADVISE_PARTITION. No changes required for 
this migration. 
Found table DB2INST.ADVISE_TABLE. No changes required for this 
migration. 
Found all tables OK. Start migration. 
 
Old tables renamed...begin creating new explain tables. 
 
Altering Explain table DB2INST.EXPLAIN_INSTANCE 
Altering Explain table DB2INST.EXPLAIN_OBJECT 
Creating Explain table DB2INST.EXPLAIN_PREDICATE 
Creating Explain table DB2INST.EXPLAIN_PREDICATE with NOT LOGGED 
INITIALLY 
Creating Explain table DB2INST.OBJECT_METRICS (New) 
Altering Explain table DB2INST.ADVISE_INDEX begin insert into 
tables. 
Copying to Explain table EXPLAIN_PREDICATE from 
EMPRD_001406574918 
Check all tables where copied properly. 
 
All tables confirmed to have been copied properly. 
 
Dropping old Explain table EMPRD_001406574918(EXPLAIN_PREDICATE) 
Dropped old Explain function DB2INST.EXPLAIN_GET_MSGS. 
Created new Explain function DB2INST.EXPLAIN_GET_MSGS. 
Migration of the explain tables to Version 10.05.3 format has 
succeeded. 
 
 
******** WARNING ********** 
Because the 'NOT LOGGED INITIALLY' option was used in migrating 
the explain 
tables it is recommended that a backup of the explain tables be 
taken as soon 
as possible, if your backup procedures include the backing up of 
the explain tables. 
******** WARNING ********** 
 
 
$ db2look -d test -x -a 
-- Generate statistics for all creators 
-- This CLP file was created using DB2LOOK Version "10.5" 
-- Timestamp: Mon Jul 28 15:15:31 EDT 2014 
-- Database Name: TEST 
-- Database Manager Version: DB2/AIX64 Version 10.5.3 
-- Database Codepage: 1208 
-- Database Collating Sequence is: SYSTEM_819 
-- Alternate collating sequence(alt_collate): null 
-- varchar2 compatibility(varchar2_compat): OFF 
 
 
CONNECT TO TEST; 
 
COMMIT WORK; 
 
CONNECT RESET; 
 
TERMINATE;
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users running on DB2 10.5 before Fix Pack 5                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 Fix Pack 5 or later.                     * 
****************************************************************
Local-Fix:
Backup permissions using db2look before running the db2exmig 
tool and grant it back after running it.
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.08.2014
31.03.2015
31.03.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.5 FixList