Am plaining to use TPT in place for MLOAD and FLOAD for loading huge data from other source to Teradata tables using Tedata mainframe TPT utility.
Could any one please help to figure out below answers.
1. We will be using PGM=BTQMAIN, PGM=MLOAD, PGM=FASTLOAD and PGM=XPORT in JCL to load/unload the data. What we need use for TPT i.e, PGM=?
2. Is there any sample TPT script to import data to TD tables? Please share
Thanks in Advance, please help me guys
Solved! Go to Solution.
Teradata Parallel Transporter User Guide
there is a section
IBM z/OS Sample Files
These sample files can be found on the Teradata Tools and Utilities software release distribution tape and are loaded during the installation process into a SAMPLIB dataset. For the dataset name the Teradata Tools and Utilities for IBM z/OS Installation Guide and contact your software installer.
I got all JCL libraries for TPT and not able to spot SAMPJCL member for TPT utility.
Please share the sample TPT JCL and let me know what i need to use PGM= _____ for TPT utility
While runing the TPT am getting following error.
TPT_INFRA: TPT01155: Error: Infrastructure setup for the Parallel Task Manager failed
TPT_INFRA: TPT02057: Error: LPAR- PTM status 10: IPC initialization problem; Check Teradata Parallel Transporter file config.ini
Am using Teradata Parallel Transporter Version 15.00.00.04 32-Bit
Please help me
You can get the Teradata Parallel Transporter manuals from info.teradata.com. (Go to Teradata Utilities and select your release.) Appendix A of the User Guide describes examples and states that "A sample JCL is included with the SAMPLIB dataset to execute the job script examples." It also say, "For the [full] dataset name [see] the Teradata Tools and Utilities for IBM z/OS Installation Guide and contact your software installer." Someone there must know where SAMPLIB is.
You can also use BTEQ (Batch Teradata Query) for queries and other SQL - the manual is also in the utilities section. There should be a BTEQ JCL procedure, TDSBTEQ, in TERADATA.PROCLIB, or you can use something like (from the manual):
//YNBTQ Job 1,'Your Name',CLASS=B,Notify=YN,MSGCLASS=A,MSGLEVEL=(1,1)
//BTEQ EXEC PGM=BTQMAIN
//STEPLIB DD DSN=TERADATA.APPLOAD,DISP=SHR
// DD DSN=TERADATA.TRLOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*,DCB=(LRECL=137)
//SYSABEND DD SYSOUT=*
//SYSTERM DD SYSOUT=*
//SYSIN DD DATA,DLM=##