|
|
| Author |
Message |
premkrishnan
Active User
Joined: 07 Sep 2006
Posts: 63
Location: Mars
|
|
|
|
Hi ,
How to get vcat and extents details of all TABLE SPACES OF all DATABASEs using rexx.
Thanks,
Prem |
|
| Back to top |
|
 |
References
|
 Posted: Thu May 08, 2008 2:43 pm Post subject: Re: Vcat and extents details of all TABLE SPACES thru REXX |
|
|
|
|
enrico-sorichetti
Global Moderator
Joined: 14 Mar 2007
Posts: 2649
Location: italy
|
|
|
|
system tables are from an SQL point of view ordinary tables
if You have the proper authorization You can run any query on them
ask Your support to find out if ...
the db2 rexx interface has been enabled
the tso logon procedures and
the mvs library search order has been properly setup
search the forums for "DSNREXX"
google for "REXX DB2 SAMPLES" "DSNREXX SAMPLES"
but, unless You want to run queries with complicated relations between the columns
and/or build commands streams ( for RYO reorg analisys, usually ) ...
spufi or dsntep2 are usually more than adequate |
|
| Back to top |
|
|
|
|
