Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to stop and start tablespace through JCL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
antonrino.b

New User


Joined: 10 Jan 2006
Posts: 76
Location: Germany

PostPosted: Sun Sep 09, 2007 8:23 pm    Post subject: How to stop and start tablespace through JCL
Reply with quote

Hi,

Could someone help me how to stop and start tablespace through JCL?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 10, 2007 5:28 am    Post subject:
Reply with quote

Hello,

It is not clear what you mean by start and stop tablespace.

I suggest you talk with your DBA about your question.
Back to top
View user's profile Send private message
antonrino.b

New User


Joined: 10 Jan 2006
Posts: 76
Location: Germany

PostPosted: Mon Sep 10, 2007 5:22 pm    Post subject: Reply to: How to stop and start tablespace through JCL
Reply with quote

I would like to know if it is possible to run database commands through JCL.
Back to top
View user's profile Send private message
saiprasadh

Active User


Joined: 20 Sep 2006
Posts: 154
Location: US

PostPosted: Mon Sep 10, 2007 5:49 pm    Post subject:
Reply with quote

Hi,

Yes you can run the database command through JCL.


Thanks
Sai
Back to top
View user's profile Send private message
antonrino.b

New User


Joined: 10 Jan 2006
Posts: 76
Location: Germany

PostPosted: Mon Sep 10, 2007 6:36 pm    Post subject: Reply to: How to stop and start tablespace through JCL
Reply with quote

Could you please help me to do that? Thanks
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 10, 2007 7:05 pm    Post subject:
Reply with quote

Hello,

If you post what you want, someone may be able to offer suggestions.

This
Quote:
I would like to know if it is possible to run database commands through JCL
needs clarification.

What particular "thing(s)" are you looking for? The forum will not be able to teach you all of batch DB2. . . If you spend some time in the manuals for the version of DB2 you are using, you will find information there.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Sep 10, 2007 8:19 pm    Post subject:
Reply with quote

Hi,

As asked, your post need more clarification to provide you better answer. Still I got this post, might help you.
Back to top
View user's profile Send private message
antonrino.b

New User


Joined: 10 Jan 2006
Posts: 76
Location: Germany

PostPosted: Mon Sep 10, 2007 10:14 pm    Post subject:
Reply with quote

Sorry for not being clear with the requirement.
I need to stop a tablespace/database through JCL. If I could get how to issue DB2 commands through JCL, would be helpful.
Is it possible to do?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 10, 2007 11:58 pm    Post subject:
Reply with quote

Hello,

Not everyone has permission to start and stop the database.

As mentioned earlier,
Quote:
I suggest you talk with your DBA about your question.


Is there some reason the database support people should not be involved?
Back to top
View user's profile Send private message
antonrino.b

New User


Joined: 10 Jan 2006
Posts: 76
Location: Germany

PostPosted: Tue Sep 11, 2007 12:36 am    Post subject:
Reply with quote

I have permission to stop database/tablespace online. Just wanted to know if i could do that batch.
Back to top
View user's profile Send private message
saiprasadh

Active User


Joined: 20 Sep 2006
Posts: 154
Location: US

PostPosted: Tue Sep 11, 2007 9:21 am    Post subject:
Reply with quote

Hi ,
Use the Below JCL

Code:
//Job Card
//STEP010   EXEC  PGM=IKJEFT1B,REGION=4096K         
//STEPLIB DD  DISP=SHR,DSN=My.dataset             
//SYSPRINT  DD SYSOUT=*                             
//SYSTSPRT  DD SYSOUT=*                             
//SYSUDUMP  DD SYSOUT=*                             
//SYSIN     DD DUMMY                               
//SYSTSIN   DD *                                   
DSN S(DB2 subsystem name)                           
-STOP DB(Database name)   
/*                 



Please let me know if you face any problem while executing the above JCL

Thanks
Sai
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Creating ISPF Screens with Scrname vi... Albireo20 TSO/ISPF 10 Tue Sep 05, 2017 4:24 pm
No new posts How to Clear all TSQs during CICS sta... Hooman24 CICS 10 Mon Jun 26, 2017 9:46 pm
No new posts CICS START AND CANCEL blayek CICS 1 Wed Dec 07, 2016 3:27 am
No new posts Event-driven programming (BTS) VS (ST... Rohit Umarjikar CICS 2 Sat Jun 11, 2016 2:05 am
No new posts START Command in CICS amitc23 CICS 17 Fri Jun 03, 2016 3:49 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us