Hussein Abdirahman wrote:

Hi All;

An easy one perhaps but I would like to know How can I find out all the TSM
table names?

TIA

regards;
Hussein A.

-----Original Message-----
From: Sam Haziprodromu [mailto:sam.hazi AT IRWINTOY DOT COM]
Sent: Monday, September 23, 2002 3:21 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Missing volume


Hi *smers, I have a strange problem for me. We deleted  the data from a
volume to make it a scratch and we can not see the volume when we do a q
libvol or q volume. We can't see the volume. In the activity log the process
ran to successful conclusion. Help

                       TIA
Sam Haziprodromu  I.T.

Sam,

You can do the following:

select * from syscat.tables

or if you just want the table names and nothing else:

select tabname from syscat.tables

That will do it.



--
Regards,
Mark D. Rodriguez
President MDR Consulting, Inc.

===============================================================================
MDR Consulting
The very best in Technical Training and Consulting.
IBM Advanced Business Partner
SAIR Linux and GNU Authorized Center for Education
IBM Certified Advanced Technical Expert, CATE
AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux
Red Hat Certified Engineer, RHCE
===============================================================================