DB2 for z/OS V8 - index information

Jim McAlpine

DB2 for z/OS V8 - index information
In which catalog table are the primary and secondary quantities for indexes
held.

Jim McAlpine

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

David Simpson

Re: DB2 for z/OS V8 - index information
(in response to Jim McAlpine)
SYSINDEXPART. Measured in pages.

Sent from my iPhone - Pardon the typos.

On Dec 22, 2010, at 9:13 AM, "Jim McAlpine" <[login to unmask email]> wrote:

> In which catalog table are the primary and secondary quantities for indexes held.
>
> Jim McAlpine
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Philip Sevetson

Re: DB2 for z/OS V8 - index information
(in response to David Simpson)
SYSIBM.SYSINDEXPART, PQTY and SQTY columns. Note that PQTY and SQTY are _number of 4K pages_, which is 1/4 of the actual values specified for the allocations.

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jim McAlpine
Sent: Wednesday, December 22, 2010 10:13 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS V8 - index information

In which catalog table are the primary and secondary quantities for indexes held.

Jim McAlpine

________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv