Hello Folks,
i've got two structural identical tables (including tablespace and indexes)
with identical data, on which the access path of an SQL is differs. But I
don't see a reason for the different behaviour.
Both tables are allocated in the same database and storage space and use the
same buffer pool. The DB2 subsystem is Version7.1 on z/OS. On both tables
I've run REORG with standard statistics.
I've checked for stale statistics with the following selects on the system
tables and found difference and no stale entries.
The only difference between the tables I know are:
- prefix of the table and index names
- creation date.
Does anybody have an idea what I could have missed?
Thanks in advance,
Ulrike
----
SELECT * FROM SYSIBM.SYSTABLES
WHERE NAME = 'S55RARCB'
AND CREATOR = 'D$TS55T7'
;
SELECT * FROM SYSIBM.SYSTABLESPACE
WHERE NAME = 'S55AARCB'
AND CREATOR = 'D$TS55T7'
;
SELECT * FROM SYSIBM.SYSCOLUMNS
WHERE TBNAME = 'S55RARCB'
AND TBCREATOR = 'D$TS55T7'
ORDER BY TBNAME, COLNO
;
SELECT * FROM SYSIBM.SYSCOLDIST
WHERE TBNAME = 'S55RARCB'
AND TBOWNER ='D$TS55T7'
-- AND TYPE = 'C'
;
-- NUR PARTITIONIERTE:
SELECT * FROM SYSIBM.SYSCOLSTATS
WHERE TBNAME = 'S55RARCB'
;
-- NUR PARTITIONIERTE:
SELECT * FROM SYSIBM.SYSCOLDISTSTATS
WHERE TBNAME = 'S55RARCB'
;
-- NUR PARTITIONIERTE:
SELECT * FROM SYSIBM.SYSINDEXSTATS
WHERE NAME LIKE 'S55IARCB%'
;
SELECT * FROM SYSIBM.SYSINDEXES
WHERE TBNAME = 'S55RARCB'
AND TBCREATOR = 'D$TS55T7'
;
SELECT * FROM SYSIBM.SYSINDEXPART
WHERE IXNAME LIKE 'S55IARCB%'
AND IXCREATOR = 'D$TS55T7'
;