Is there a way to find out what indexes a given TSM table, e.g. the backups
table, has? Just trying to optimize a select statement.
David
SELECT * FROM SYSCAT.COLUMNS
at least in TSM 5.
Richard Sims
in the house?
W
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David
Ehresman
Sent: Thursday, September 25, 2014 1:23 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TSM Table Index
Is there a way to find out what indexes a given TSM table, e.g
Hi,
This does not answer to your question a new SHOW ADMINSQL command that
may be usefull is provided begining with TSM 7.1.1. See :
www-01.ibm.com/support/docview.wss?uid=swg21677879
Erwann
Le 25/09/2014 19:23, David Ehresman a écrit :
Is there a way to find out what indexes a given TSM
where indschema='TSMDB1' and
tabname='BACKUP_OBJECTS'
Rejean Larivee
IBM Tivoli Storage Manager Software Support
From: David Ehresman david.ehres...@louisville.edu
To: ADSM-L@VM.MARIST.EDU
Date: 09/25/2014 02:23 PM
Subject:TSM Table Index
Sent by:ADSM: Dist Stor Manager