Perfect. Thank you! -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Nick Marouf Sent: Friday, June 02, 2017 10:16 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. 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 <[email protected]> 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 > [email protected]<mailto:[email protected]> > 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=
