Z/OS DB2 commands

Joseph Reichman

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

Binyamin Dissen

Re: Z/OS DB2 commands
(in response to Joseph Reichman)
On Sun, 28 Nov 2010 04:34:48 -0500 michealbutz <[login to unmask email]>
wrote:

:>I am a newbee to DB2

:> Would anyone know on a Z/OS DB2 subsystems if I can list the tables

SELECT CREATOR, NAME FROM SYSIBM.SYSTABLES WHERE TYPE = 'T'

--
Binyamin Dissen <[login to unmask email]>
http://www.dissensoftware.com

Director, Dissen Software, Bar & Grill - Israel


Should you use the mailblocks package and expect a response from me,
you should preauthorize the dissensoftware.com domain.

I very rarely bother responding to challenge/response systems,
especially those from irresponsible companies.

_____________________________________________________________________
* 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

Lizette Koehler

Re: Z/OS DB2 commands
(in response to Binyamin Dissen)
> Hi,
>
>
> I am a newbee to DB2
>
> Would anyone know on a Z/OS DB2 subsystems if I can
> list the tables
>


Your best option is to go review the different DB2 system tables and
catalogs and then create select commands for the information you need.


All versions of DB2 should have the following books

DB2 Command Reference Look at DISPLAY or SELECT commands
DB2 V9.1 for z/OS SQL Reference SC18-9854-08

The DB2 manuals can be found here
http://www-01.ibm.com/support/docview.wss?uid=swg27011656#manuals

Also the following redbooks are helpful

IBM DB2 9 for z/OS: New Tools for Query Optimization

You can find a lot of good references and examples by googling the DB2 and
SELECT phrases

Since you are new, you need to review the ADMIN and Reference Guides for
your version of DB2.
See what tutorials are available online that you can use.
Go to the info center link:
http://publib.boulder.ibm.com/infocenter/zos/basics/index.jsp

A lot of good basic z/OS skills are described on this url which includes
DB2.
http://publib.boulder.ibm.com/infocenter/zos/basics/index.jsp


Remember - DB2 is itself installed in DB2 Tables. IBM uses SYSIBM.?? For
its system tables and catalogs. If you have QMF you can use it to query
your environment. If you only have SPUFI, that works just as well but you
do need to know more about SQL syntax.

If you can code REXX, you can use DSNREXX interface and get the information
that way. There are many examples on the internet, just query what you are
looking for. If your company is a member of SHARE, go there and start
downloading the presentations on DB2.


Lizette

_____________________________________________________________________
* 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

Philip Gunning

Re: Z/OS DB2 commands
(in response to Lizette Koehler)
A good rerference is the DB2 Developers Guide by Craig Muillins. PG
Sent via BlackBerry by AT&T

-----Original Message-----
From: michealbutz <[login to unmask email]>
Sender: IDUG DB2-L <[login to unmask email]>
Date: Sun, 28 Nov 2010 04:34:48
To: <[login to unmask email]>
Reply-To: IDUG DB2-L <[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 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

Roger Hecq

Re: Z/OS DB2 commands
(in response to Philip Gunning)
Given that it appears that you are in the NYC Metro area, I would strongly suggest that you, and your colleagues, attend the meetings of the local DB2 User Group, TriDEx (Tri-State DB2 Exchange). The group meets quarterly at the National Grid building at MetroTech and the meetings are free. The next meeting will be on 14 December.

Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of michealbutz
Sent: Sunday, November 28, 2010 4: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
Visit our website at http://www.ubs.com

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.


UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Avram Friedman

Re: Z/OS DB2 commands
(in response to Roger Hecq)
Joe
As a DB2 newbe you should do some investigation on what is a DB2 command.

Yes DB2 has a commad lanuage and that command lanuage can be used to do opperational things like
Start / Stop DB2 and other resources
Displaly Operational resources.
A database and its status may be displayed
A table space as a subset of database may be displayed along with its status may be displayed
No COMMAD FOR DISPLAYING TABLES AND THERE STRUCTURE
tables are not operational resouces.

In addition to the command lanuage there is something called SQL which can be used to create, alter, delete, minipulate, secure resources including both operational and application resources.
There are several sub lanuage types with in SQL
Defineing
Securing
and Minpulation.

Just curious
Why does the name in your email address look like a name micheal butz but not match your name?
Some people consider it a mistake to list personal information in your sign block
Not an error, just a common suggestion.
Guess I am on a 'newbe; question kick.

Best Wishes
Avram Friedman


On Sun, 28 Nov 2010 04:34:48 -0500, michealbutz <[login to unmask email]> wrote:

>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. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Troy L Coleman

Re: Z/OS DB2 commands
(in response to Avram Friedman)
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

Steen Rasmussen

Re: Z/OS DB2 commands
(in response to Troy L Coleman)
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