View previous topic :: View next topic |
Author |
Message |
satyenderd Beginner
Joined: 26 Aug 2005 Posts: 144 Topics: 73
|
Posted: Fri Jun 05, 2009 5:44 pm Post subject: Creating database using JCL |
|
|
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 |
|
 |
dbzTHEdinosauer Supermod
Joined: 20 Oct 2006 Posts: 1411 Topics: 26 Location: germany
|
Posted: Fri Jun 05, 2009 7:02 pm Post subject: |
|
|
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 |
|
 |
satyenderd Beginner
Joined: 26 Aug 2005 Posts: 144 Topics: 73
|
Posted: Tue Jun 09, 2009 1:15 pm Post subject: |
|
|
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 |
|
 |
|
|