I am running TOC 7.1.1 on a virtual Windows 2008 R2, 4 vCPU, 12 GB memory, 50
GB laid out for DB, 40 GB for active log, 100 GB for archive log. Monitoring 5
TSM servers, approx. 300 clients.
Most of the time the CPUs are flatlining at 0 % and memory consumption at 4 GB.
The database is just 3 GB
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
They used to tell us that for the V5 DB.
I think it went away with TSM V6. You would have to ask a DB2 person how to go
into DB2 and look there.
And the problem there, a bunch of the tables are created on the fly, so I don't
have a clue how you would find those.
Anybody got a DB2 DBA in the h
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 tab
Hello David,
the following db2 command gives you the table names used by TSM :
db2 "select tabname from syscat.tables where tabschema='TSMDB1' and
type='V'"
the following db2 command gives you the index names used for the
BACKUP_OBJECTS table for example :
db2 "select indname from syscat.indexes
Upgraded from TDP for Exchange 6.4 to TDP for Exchange 7.1.1
Exchange 2010, Windows TSM server 6.3.5.
The doc for 7.1.1 says:
"The following parameters are available options in the MMC when you select Show
Restore Options from the Recover tab:
- Set the /KEEPRDB parameter option to Yes to retain
