ADMIN? LISTSERV hiccup

Avram Friedman

ADMIN? LISTSERV hiccup
Looks like the listserve hickuped and reposted 2 replies to a question entered 28 Nov and responded to 28, 29 concering DB2 commands for displaying tables and table structures.

Don't know how many other postings were repicated on 5 Dec, I happened to notice these because I also replied to the original.


My response was not reposted (and happens to be correct)
There is no command for displaying table lists and table structure in DB2 for Z/OS
Several peole suggested SQL that will work.
SQL however is not the DB2 for z/os command lanuage.
My actual reply and the two reposted replies are also on the listserv for 28 29 Nov

Best wishes
Avram Friedman




On Sun, 5 Dec 2010 11:05:34 -0500, Rasmussen, Steen <[login to unmask email]> wrote:

>And if you want to see yourself, do a SELECT * FROM SYSIBM.SYSTABLES. For the catalog tables add the predicate WHERE DBNAME='DSNDB06'.
>
>Steen Rasmussen
>CA Technologies
>Sr Engineering Services Architect
>IBM Certified Database Associate - DB2 9 Fundamentals
>IBM Certified database Administrator - DB2 9 DBA for z/OS
>
>
>-----Original Message-----
>From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Coleman, Troy L
>Sent: Sunday, December 05, 2010 1:31 AM
>To: [login to unmask email]
>Subject: Re: [DB2-L] Z/OS DB2 commands
>
>You should take a few minutes and look at the SQL Reference guide.
>You will find the DB2 Catalog tables defined in an appendix at the end.
>Take a look at SYSTABLES.
>
>
>Troy Coleman
>CA Technologies
>Principal Product Manager
>Tel: �����+1-630-505-6025
>Fax:���� +1-630-505-6608
>Mobile: +1-224-343-0073
>[login to unmask email]
>
>
>-----Original Message-----
>From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of michealbutz
>Sent: Sunday, November 28, 2010 3:35 AM
>To: [login to unmask email]
>Subject: [DB2-L] Z/OS DB2 commands
>
>Hi,
>
>
>I am a newbee to DB2
>
> Would anyone know on a Z/OS DB2 subsystems if I can list the tables
>
>Joseph Reichman
>
>Joe Reichman
>
>5420 15TH AVE APT 2B
>Brooklyn NY 11219
>
>
>Hone (718) 851 - 8712
>Work ( (914) 921 - 7360
>Cell�������� (917) 748 - 9693
>
>
>�
>
>_____________________________________________________________________
>* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
>* If you are going to attend only one conference this year, this is it! *
>** The best DB2 technical sessions in the world
>** Independent, not-for-profit, User Run - the IDUG difference!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
>* Your only source for independent, unbiased, and trusted DB2 information. *
>_____________________________________________________________________
>http://www.IDUG.org/mentor
>How can you expand your staff or do succession planning in this economy?
>Mentoring is a proven, economical, way to train the next generation of DB2 Users!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
>* Your only source for independent, unbiased, and trusted DB2 information. *
>_____________________________________________________________________
>http://www.IDUG.org/mentor
>How can you expand your staff or do succession planning in this economy?
>Mentoring is a proven, economical, way to train the next generation of DB2 Users!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv