DB2 - Problem description
Problem IT21824 | Status: Closed |
IN FEDERATION, SYSPROC.NNSTAT SEEMS TO UPDATE STATS_TIME | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Here is an example scenario. Problem Reproducible Steps: 1. $ repro.sh > repro.log $ cat repro.sh ---------- #!/bin/sh ########################################## # At source side. craete testdb1 source database db2 terminate db2stop db2 -v "update dbm cfg using FEDERATED yes" db2 -v "update dbm cfg using FED_NOAUTH yes" db2start db2 -v "create database testdb1" db2 -v "connect to testdb1" db2 -v "create table tab01 (col1 int not null, col2 int, constraint pk_tab1 primary key(col1))" db2 -v "create index tab01_idx1 on tab01(col2)" db2 -v "insert into tab01 values ( 1, 1 )" db2 -v "runstats on table tab01 with distribution and unsampled detailed indexes all allow write access" # timeA db2 -v "select substr(indname,1,30) indname, stats_time from syscat.indexes where tabname='TAB01'" db2 -v "terminate" ########################################## # At federate server side. create testdb2 as federate database db2 -v "create database testdb2" db2 -v "connect to testdb2" db2 -v "CREATE WRAPPER DRDA LIBRARY 'libdb2drda.a' OPTIONS (DB2_FENCED 'N')" db2 -v "CREATE SERVER TEST01 TYPE DB2/AIX VERSION '10.5' WRAPPER DRDA authorization hidehy password hogehoge OPTIONS (DBNAME 'testdb1')" db2 -v "CREATE USER MAPPING FOR hidehy SERVER TEST01 OPTIONS (REMOTE_AUTHID 'HIDEHY', REMOTE_PASSWORD 'hogehoge')" db2 -v 'CREATE NICKNAME "HIDEHY"."TAB01" FOR "TEST01"."HIDEHY"."TAB01"' # timeB db2 -v "select substr(indname,1,30) indname, stats_time from syscat.indexes where tabname='TAB01'" db2 -v "call sysproc.nnstat ('TEST01', 'HIDEHY','TAB01', null,null,0,null, ?, 1)" # timeC db2 -v "select substr(indname,1,30) indname, stats_time from syscat.indexes where tabname='TAB01'" db2 -v "call sysproc.nnstat ('TEST01', 'HIDEHY','TAB01', null,null,0,null, ?, 1)" db2 "terminate" ---------- $ egrep 'select substr|nnstat|PK' repro.log and added those time. select substr(indname,1,30) indname, stats_time from syscat.indexes where tabname='TAB01' PK_TAB1 2015-03-04-00.26.28.142687 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Db2 Version 11.1 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 11.1 Mod 2 Fix Pack 2. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT08123 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.08.2017 10.10.2017 10.10.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |