IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to read the db2 table space status using rexx command


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
cmsmoon

New User


Joined: 17 Jun 2010
Posts: 75
Location: Chennai

PostPosted: Fri Apr 17, 2015 2:29 am
Reply with quote

Hi All,
I have a requirement to check all the tablespaces status of database.the objective is , if we given database name as a input and it should reply the status of table space under the database.
then I validate and write results TRUE ,if all the tablesspace status is RW.
Else i should write FALSE,If any one of tablespaces status is COPY,STOP.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Fri Apr 17, 2015 5:59 pm
Reply with quote

Well, you cannot with a 'Rexx command' - whatever that is. But you could possibly run the required commands via Rexx using the Rexx/DB2 interface as documtned in the SQL user guide.
Back to top
View user's profile Send private message
farhad_evan

New User


Joined: 30 Aug 2014
Posts: 24
Location: UK

PostPosted: Wed Apr 22, 2015 10:41 am
Reply with quote

hi
if you want run DB2 command in rexx you can use this :
Code:
/*rexx*/                                                             
 ADDRESS(TSO)                                                       
 Y = OUTTRAP(DB2CMD.,"*","NOCONCAT")                                 
 QUEUE "-DIS DB(******) SPACENAM(*******) LIMIT(*)"/*DB2 COMMAND */ 
 QUEUE "END"                                                         
 "DSN SYSTEM(****)"  /*DB2 SYSTEM NAME*/                             
 Y = OUTTRAP("OFF")                                                 
 ADDRESS(ISPEXEC)                                                   
 DO I = 1 TO DB2CMD.0                                               
 SAY DB2CMD.I                                                       
 END                                                                 
Back to top
View user's profile Send private message
cmsmoon

New User


Joined: 17 Jun 2010
Posts: 75
Location: Chennai

PostPosted: Fri Apr 24, 2015 2:32 am
Reply with quote

Hi farhad

Thank you so much !!!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts How to replace a string dynamically i... CLIST & REXX 16
No new posts Determine Library REXX exec was execu... CLIST & REXX 7
No new posts Command line placement in DB2I panels TSO/ISPF 2
No new posts Any examples of calling FTP from REXX? CLIST & REXX 1
No new posts SummeRx: a new framework for REXX z/OS CLIST & REXX 6
Search our Forums:

Back to Top