Re: Tables in TSM database

2017-06-02 Thread Jeannie Bruno 
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 links / attachments. 
Never supply UserID/PASSWORD information.


Hi Jeannie,

Please try below.

To display list of Table names
select * from syscat.tables

To display columns from all the tables
select * from syscat.columns

To display list of columns from a particular table.
SELECT COLNAME FROM syscat.columns WHERE tabname=' TABNAME'
Ex:
SELECT COLNAME FROM syscat.columns WHERE tabname='LIBVOLUMES'
SELECT COLNAME FROM syscat.columns WHERE tabname='ASSOCIATIONS'
SELECT COLNAME FROM syscat.columns WHERE tabname='ACTLOG'

Hope this helps.

Best Regards,
_
Venu P Bommasani
Capgemini Technology Services India Limited / Bangalore
CONA TSM Backup & Restore
Mobile: +91 7795 213 309 / Oncall: +1 602 586 3532

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Jeannie Bruno
Sent: Friday, June 02, 2017 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 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
This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient, you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

Re: Tables in TSM database

2017-06-02 Thread Jeannie Bruno 
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

Re: Tables in TSM database

2017-06-02 Thread Jeannie Bruno 
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  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=

Re: Tables in TSM database

2017-06-02 Thread Bommasani, Venu 
Hi Jeannie,

Please try below.

To display list of Table names
select * from syscat.tables

To display columns from all the tables
select * from syscat.columns

To display list of columns from a particular table.
SELECT COLNAME FROM syscat.columns WHERE tabname=' TABNAME'
Ex:
SELECT COLNAME FROM syscat.columns WHERE tabname='LIBVOLUMES'
SELECT COLNAME FROM syscat.columns WHERE tabname='ASSOCIATIONS'
SELECT COLNAME FROM syscat.columns WHERE tabname='ACTLOG'

Hope this helps.

Best Regards,
_
Venu P Bommasani
Capgemini Technology Services India Limited / Bangalore
CONA TSM Backup & Restore
Mobile: +91 7795 213 309 / Oncall: +1 602 586 3532

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Jeannie Bruno
Sent: Friday, June 02, 2017 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 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
This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient, you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

Re: Tables in TSM database

2017-06-02 Thread David Ehresman 
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

Re: Tables in TSM database

2017-06-02 Thread Nick Marouf 
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 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
> Central Hudson Gas & Electric
> (845) 486-5780
>



--

PGP PUBLIC KEY

https://keybase.io/marouf/key.asc

Tables in TSM database

2017-06-02 Thread Jeannie Bruno 
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
Central Hudson Gas & Electric
(845) 486-5780