Perfect. Thank you! -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Nick Marouf Sent: Friday, June 02, 2017 10:16 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. Hi, I've found these to be helpful select * from syscat.tables select * from syscat.columns select * from syscat.enumtypes Select colname from syscat.columns where tabname='OCCUPANCY' and tabschema='TSMDB1' On Fri, Jun 2, 2017 at 8:05 AM, Jeannie Bruno <jbr...@cenhud.com> wrote: > 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 > -- PGP PUBLIC KEY https://urldefense.proofpoint.com/v2/url?u=https-3A__keybase.io_marouf_key.asc&d=DwIBaQ&c=BY0WRPt8vrhqs_gNwjcMsqT0O3k78MJMGj95ah0eDEA&r=7l_gtgCLb17w6YLNyl5xk2NLH8XcWIQUFrWhANDp1mE&m=lLjhwVnAD0VuZ7N_yKK1k6TJ-lKBC66oi7qVEVnWbzY&s=TF993DAZK7zUSK3JyLM6otgeH13paxydM84sR-PR8Cg&e=