What's the meaning of IID=0 in output of db2pd command

[James]

In output of comand "db2pd -d <dbname-tcbstats index", what's the
meaning of IID=0? Please advise. Thanks so much.

James

[Udo]

Re: What's the meaning of IID=0 in output of db2pd command

In output of comand "db2pd -d <dbname-tcbstats index", what's the
meaning of IID=0? Please advise. Thanks so much.

It's the index ID (Column IID from sysibm.sysindex es).

Regards,
Udo

--
Speedgain for DB2 - The DB2 Monitor

http://www.itgain.de/en/produkte/speedgain.html

[James]

Re: What's the meaning of IID=0 in output of db2pd command

On Jul 10, 10:11 pm, Udo <udo.we...@gmai l.comwrote:

In output of comand "db2pd -d <dbname-tcbstats index", what's the
meaning of IID=0? Please advise. Thanks so much.

>
It's the index ID (Column IID from sysibm.sysindex es).
>
Regards,
Udo
>
--
Speedgain for DB2 - The DB2 Monitorhttp://www.itgain.de/en/produkte/speedgain.html

Any additional meaning of the value 0? It seems the value 0 is not a
common value in sysibm.sysindex es or syscat.indexes system tables.