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