I have a question about the number of sessions that a fastexport uses. When i read through the fastexport manual, came to know that in fastexport sessions parameter is optional. If no sessions parameter is specified, the default is 4 sessions. The max can be the total number of AMPS on the system.
So, my question is -
1. how to find out from the log tables, how many sessions a job has actually taken ?
2. Is there any setting DBS/TASM that affects this ?
3. Is there any guideline to specify this fugure
Any reference to any material would really help
If I want to export data from Teradata table that contains more than 2 GB to a file what is the utility need to use to load into file using shell scripting. Please do needful.
Install TPT - Teradata Parallel Transporter, included within TTU - Teradata Tools and Utilities - on the server running your shell script, then do a TPT Export.