Thank you! -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of David Ehresman Sent: Friday, June 02, 2017 10:17 AM To: [email protected] 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:[email protected]] On Behalf Of Jeannie Bruno Sent: Friday, June 02, 2017 10:05 AM To: [email protected] 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 [email protected]<mailto:[email protected]> Central Hudson Gas & Electric (845) 486-5780
