View previous topic :: View next topic
|
Author |
Message |
antonrino.b
New User
Joined: 10 Jan 2006 Posts: 76 Location: Germany
|
|
|
|
Hi,
Could someone help me how to stop and start tablespace through JCL? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
antonrino.b
New User
Joined: 10 Jan 2006 Posts: 76 Location: Germany
|
|
|
|
I would like to know if it is possible to run database commands through JCL. |
|
Back to top |
|
|
saiprasadh
Active User
Joined: 20 Sep 2006 Posts: 154 Location: US
|
|
|
|
Hi,
Yes you can run the database command through JCL.
Thanks
Sai |
|
Back to top |
|
|
antonrino.b
New User
Joined: 10 Jan 2006 Posts: 76 Location: Germany
|
|
|
|
Could you please help me to do that? Thanks |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
As asked, your post need more clarification to provide you better answer. Still I got this post, might help you. |
|
Back to top |
|
|
antonrino.b
New User
Joined: 10 Jan 2006 Posts: 76 Location: Germany
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
antonrino.b
New User
Joined: 10 Jan 2006 Posts: 76 Location: Germany
|
|
|
|
I have permission to stop database/tablespace online. Just wanted to know if i could do that batch. |
|
Back to top |
|
|
saiprasadh
Active User
Joined: 20 Sep 2006 Posts: 154 Location: US
|
|
|
|
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 |
|
|
|