Thank you.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Bommasani, Venu
Sent: Friday, June 02, 2017 10:24 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Tables in TSM database
** THIS IS AN EXTERNAL EMAIL ** Use caution before opening
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
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
017 7:35 PM
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
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
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 wrote:
> Hello. Ya know how in TSM one
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
