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 

Creating database using JCL

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


Joined: 26 Aug 2005
Posts: 144
Topics: 73

PostPosted: Fri Jun 05, 2009 5:44 pm    Post subject: Creating database using JCL Reply with quote

Hi all,

Please excuse me if I am repeating the question.

I want o create a database using JCL.

For this I have used the following jcl to create it.

//CREATE EXEC PGM=IKJEFT01,DYNAMNBR=20,
// COND=(4,LT)
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD DSN=SMUR540.CREATE.DB(N6Q1),DISP=SHR
// DD DSN=SMUR540.CREATE.DB(DSNTISQL),DISP=SHR
//SYSIN DD DSN=SMUR540.CREATE.DB(CREADB),DISP=SHR


But, I am getting an error:

'PGM=DSNTIAUL' DOES NOT EXIST

Could anyone pls throw some light on this.
Thanks to all in advance.
_________________
Satya
Back to top
View user's profile Send private message
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Fri Jun 05, 2009 7:02 pm    Post subject: Reply with quote

need to see your SYSIN statements (contents of SMUR540.CREATE.DB(CREADB))
as well as the concatenated members of SYSTSIN.

though the issue could be you need to steplib your db2 loadlib,
i think your SYSTSIN and SYSIN contents are the problem.
I don't see any READY or DSN output statements.
_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message
satyenderd
Beginner


Joined: 26 Aug 2005
Posts: 144
Topics: 73

PostPosted: Tue Jun 09, 2009 1:15 pm    Post subject: Reply with quote

Thank you dbzTHEdinosauer for your response.
The READY or DSN statement are in the SYSTSIN.

However, the error got resoved, instead of the program DSNTIAUL, I have changed to DSNTEP2 which is being used at my shop. It went fine now.

Thank you once again.
_________________
Satya
Back to top
View user's profile Send private message
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