Prev: "FOR READ ONLY" not usable in SQLs in SP
Next: Jet uses Yellowfin for Location Intelligence
From: Willem Fischer on 4 Feb 2010 12:02
I'm looking for documentation on db2pd that is complete to some
extend. At the moment I'm doing a lot of guesswork, but there must be
many more hidden gems than I discovered so far.

As an example, I can guess what "Scans", "Reads", "Inserts" and
"Updates" are in the TCB Table Stats. But I have no clue about "UDI"
or "NoChgUpdts"...
From: Frederik Engelen on 4 Feb 2010 12:13
On Feb 4, 6:02 pm, Willem Fischer <w.l.fisc...(a)googlemail.com> wrote:
> I'm looking for documentation on db2pd that is complete to some
> extend. At the moment I'm doing a lot of guesswork, but there must be
> many more hidden gems than I discovered so far.
>
> As an example, I can guess what "Scans", "Reads", "Inserts" and
> "Updates" are in the TCB Table Stats. But I have no clue about "UDI"
> or "NoChgUpdts"...

The v9.5 info center page related to db2pd explains them all. Just
look it up.

--
Frederik Engelen
From: The Boss on 4 Feb 2010 18:20
Willem Fischer wrote:
> I'm looking for documentation on db2pd that is complete to some
> extend. At the moment I'm doing a lot of guesswork, but there must be
> many more hidden gems than I discovered so far.
>
> As an example, I can guess what "Scans", "Reads", "Inserts" and
> "Updates" are in the TCB Table Stats. But I have no clue about "UDI"
> or "NoChgUpdts"...

For 9.7:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0011729.html

--
Jeroen


From: Willem Fischer on 5 Feb 2010 01:47
> > I'm looking for documentation on db2pd that is complete to some
> > extend.

> The v9.5 info center page related to db2pd explains them all. Just
> look it up.

It's in there. And also in the PDF documentation. Somehow I didn't
expect it to be there...

Thanks!
 | 
Pages: 1
Prev: "FOR READ ONLY" not usable in SQLs in SP
Next: Jet uses Yellowfin for Location Intelligence