Archives of the TeradataForum

Message Posted: Tue, 28 Feb 2006 @ 08:32:38 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

I'm new customer in Teradata. Our site decided to choose teradata for implementing the new project for Enterprise datawarehouse instead of IBM- MVS. But right now, We have encontering the problem about JCL on the mainframe for PPBMAIN (teradata program on mainframe) after we installed it. Because it cannot work in our site. Fortunately, JCL of MLOAD, FASTLOAD, FASTEXPORT can work.

Now,Teradata technician is solving problem by tell me to modifying JCL for PPBMAIN, and submitting it in 2-3 times but it still has error occured.

Has anyone have a sample JCL for PPBMAIN which can work?

Or my JCL below is not correct, please help to verify.

     //DB25173A JOB (BATCH),ALLD,MSGLEVEL=(1,1),CLASS=A,
     //          MSGCLASS=X,NOTIFY=&SYSUID,REGION=4M,TIME=1440
     //*-------------------------------------------------------*/
     //PRECOMP  EXEC  PGM=PPBMAIN,
     //                 PARM='SQLCHECK NOSYNTAX'
     //STEPLIB    DD    DSN=SYSP.DBCAD.APPLOAD,DISP=SHR
     //                 DD    DSN=SYSP.DBCAD.TRLOAD,DISP=SHR
     //SYSPRINT DD    SYSOUT=*,
     //                 DCB=(LRECL=133,RECFM=FBA,BLKSIZE=1330)
     //SYSTERM  DD    DUMMY
     //SYSIN        DD    DISP=SHR,DSN=SYSP.DBCAD.SAMPLIB(PPCOBLB1)
     //SYSPUNCH DD    DSN=DB25173.COMPILER.INPUT,
     //                 UNIT=SYSDA,SPACE=(TRK,(5,5)),
     //                 DCB=(LRECL=80,RECFM=FB,BLKSIZE=3600),

     //                 DISP=(NEW,CATLG)

     //SYSUT1    DD UNIT=SYSDA,SPACE=(CYL,(5,2)),
     //                DCB=(LRECL=80,RECFM=FB,BLKSIZE=3600)
     /*
     **************************** Bottom of Data *********************

Any help or advice would be appreciated.

Regards,

Ausanee

	<Prev	Next>		<<First	<Prev	Next>	Last>>