TSM Table Index

2014-09-25 Thread David Ehresman
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

Re: TSM Table Index

2014-09-25 Thread Sims, Richard B
SELECT * FROM SYSCAT.COLUMNS at least in TSM 5. Richard Sims

Re: TSM Table Index

2014-09-25 Thread Prather, Wanda
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

Re: TSM Table Index

2014-09-25 Thread Erwann SIMON
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

Re: TSM Table Index

2014-09-25 Thread Rejean Larivee
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