MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

To check the status of Tablespace

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
Arun
Beginner


Joined: 24 Mar 2003
Posts: 13
Topics: 7
Location: Philadelphia, US.
PostPosted: Tue May 20, 2003 1:11 pm    Post subject: To check the status of Tablespace Reply with quote
Hi all,
Is there any way i can check the status (Check Pending, Copy Pending etc) of the DB2 table space directly using BMC.

My jobs are abending 'coz some of my tables are in Check/Copy pending status. As of now, i'm just trying to load the table using DSNUTILB, and the sysout of the job says the status of the table space.
Instead i want to see directly using BMC, the state of the table space.
Back to top
View user's profile Send private message Send e-mail
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
PostPosted: Tue May 20, 2003 5:24 pm    Post subject: Reply with quote
Arun,

Try this JCl

Code:

//STEP0100  EXEC PGM=IKJEFT01                 
//SYSTSPRT DD  SYSOUT=*                       
//SYSTSIN  DD  *                               
DSN SYSTEM(XXXX)                             
-DISPLAY DATABASE(DBNAME) SPACENAM(TBSPACE NAME)     
END                                           
//*                                           


XXXX - Is your DB2 Region Name

The same thing can be achieved via DB2 COMMANDS option 7 under DB2 primary menu(spufi...)

enter the following command and press ENTER

Code:

-DISPLAY DATABASE(DBNAME) SPACENAM(TBSPACE NAME)     



Hope this helps....

cheers

kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Arun
Beginner


Joined: 24 Mar 2003
Posts: 13
Topics: 7
Location: Philadelphia, US.
PostPosted: Wed May 21, 2003 12:32 pm    Post subject: Reply with quote
It worked. Smile
Thank You very much Exclamation
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group