Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Vcat and extents details of all TABLE SPACES thru REXX

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
Author Message
premkrishnan

Active User


Joined: 07 Sep 2006
Posts: 63
Location: Mars

PostPosted: Thu May 08, 2008 2:43 pm    Post subject: Vcat and extents details of all TABLE SPACES thru REXX
Reply with quote

Hi ,

How to get vcat and extents details of all TABLE SPACES OF all DATABASEs using rexx.

Thanks,
Prem
Back to top
View user's profile Send private message
References
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 3168
Location: italy

PostPosted: Sun May 18, 2008 3:56 pm    Post subject: Reply to: VCAT , EXTENTS of TABLESPACE
Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1