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
