FYI -- New DB2 LUW 9.7 index option

Philip Gunning

FYI -- New DB2 LUW 9.7 index option
FYI. Thought I'd share this with you, there is a new option in DB2 LUW 9.7
that now shows status of index reorgs as follows:



Db2pd -d <dbname> -reorgs index



Retrieval Time: 11/22/2010 10:19:32

TbspaceID: 71 TableID: 4

Schema: DB2ADMIN TableName: GUEST_ACC

Access: Allow write

Status: Completed

Start Time: 11/19/2010 12:49:19 End Time: 11/19/2010 12:49:56

Total Duration: 00:00:36

Prev Index Duration: -

Cur Index Start: -

Cur Index: 0 Max Index: 3 Index ID: 0

Cur Phase: 0 ( - ) Max Phase: 0

Cur Count: 0 Max Count: 0

Total Row Count: 4045345





Phil Gunning

IBM Information Champion

www.gts1consulting.com

Database Industry Analyst

DB2 Consulting, Books on DB2, Outsourcing, Education, Remote Support

Direct +1.610.451.5801

Fax 636.216.8192

IBM Advanced Business Partner

IBM Authorized Reseller

This message (including attachments, header and footer
details) contains confidential information intended for a specific
individual or individuals and purpose(s), and is protected by law. If you
are not the intended recipient, you should delete this message and any
attachments.Any disclosure, copying, or distribution of this message, or the
taking of any action based on it, is strictly prohibited.








_____________________________________________________________________
* 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

Mark Horrocks

Re: FYI -- New DB2 LUW 9.7 index option
(in response to Philip Gunning)

Phil,

Thanks for that.

Hope you are well.

Many Thanks,

Mark Horrocks.

Date: Mon, 22 Nov 2010 10:22:56 -0500
From: [login to unmask email]
Subject: [DB2-L] FYI -- New DB2 LUW 9.7 index option
To: [login to unmask email]
















FYI. Thought I’d share this with you, there is a new
option in DB2 LUW 9.7 that now shows status of index reorgs as follows:



Db2pd –d <dbname> -reorgs index



Retrieval Time: 11/22/2010 10:19:32

TbspaceID: 71 TableID: 4

Schema: DB2ADMIN TableName: GUEST_ACC

Access: Allow write

Status: Completed

Start Time: 11/19/2010 12:49:19 End Time:
11/19/2010 12:49:56

Total Duration: 00:00:36

Prev Index Duration: -

Cur Index Start: -

Cur Index:
0 Max Index:
3 Index ID: 0

Cur Phase:
0 (
- ) Max Phase: 0

Cur Count:
0
Max Count: 0

Total Row Count: 4045345





Phil Gunning

IBM Information Champion

www.gts1consulting.com

Database Industry Analyst

DB2 Consulting, Books on DB2, Outsourcing, Education, Remote
Support

Direct +1.610.451.5801

Fax 636.216.8192

IBM Advanced Business Partner

IBM Authorized Reseller

This message
(including attachments, header and footer

details)
contains confidential information intended for a specific individual or
individuals and purpose(s), and is protected by law. If you are not the
intended recipient, you should delete this message and any attachments.Any
disclosure, copying, or distribution of this message, or the taking of any
action based on it, is strictly prohibited.
















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