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:[EMAIL PROTECTED]] >Sent: Monday, September 23, 2002 3:21 PM >To: [EMAIL PROTECTED] >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 ===============================================================================
