Thank you!

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
David Ehresman
Sent: Friday, June 02, 2017 10:17 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Tables in TSM database


** THIS IS AN EXTERNAL EMAIL ** Use caution before opening links / attachments. 
Never supply UserID/PASSWORD information.


tsm: ULTSM>q script q_tables f=raw
/*  -----------------------------------------*/
/*  Script Name:  Q_TABLES                   */
/*  Description: Display the TSM DB2 database*/
/*               tables available for selects*/
/*  Parameter:   None                        */
/*  Example:  run q_tables                   */
/*  -----------------------------------------*/
select tabname from syscat.tables -
   where tabschema='TSMDB1'

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Jeannie Bruno
Sent: Friday, June 02, 2017 10:05 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Tables in TSM database

Hello.   Ya know how in TSM one can write queries against a  Table on the TSM 
database (ie: select sum from SUMMARY or select * from NODESVIEW).

Does anyone know the command or query that tells me all the Table names on the 
database?  I can't find....


____________________
Jeannie Bruno
Senior Systems Analyst
jbruno AT cenhud DOT com<mailto:jbruno AT cenhud DOT com>
Central Hudson Gas & Electric
(845) 486-5780