16.10 - Restrictions and Limitations - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)
  • The Teradata PT Error Table Extractor supports VARBYTE or BLOB for the DATAPARCEL column in the FastLoad acquisition phase error table.

    The Teradata PT Error Table Extractor supports VARBYTE or BLOB for the HOSTDATA column in the MultiLoad acquisition phase error table.

    The DATAPARCEL or HOSTDATA column is VARBYTE when the TPT Load or Update operator job is running against a Teradata Database that does not have the Teradata Database 1MB Permanent Row feature enabled.

    The DATAPARCEL or HOSTDATA column is BLOB when the TPT Load or Update operator job is running against a Teradata Database that has the Teradata Database 1MB Permanent Row feature enabled.

    If the DATAPARCEL or HOSTDATA column is not VARBYTE or BLOB, the Teradata PT Error Table Extractor will terminate the job with an error message.

  • The Teradata PT Error Table Extractor supports the acquisition phase error table for only these Teradata PT operators:
    • Load operator:
    • Update operator:

      The Teradata PT Error Table Extractor cannot extract the error information from a Stream operator error table, because the Teradata PT Error Table Extractor does not know the layout of the Stream operator error table.

    • The schema for the Teradata PT Load and Update operator jobs must have all VARCHAR columns when the record format is DELIMITED. For other record formats, the Load and Update jobs can have different column data types.
    • The Teradata PT Error Table Extractor does not support the extraction of the application phase error tables.
    • The Teradata PT Error Table Extractor supports only a single-byte delimiter character.
    • On z/OS, the Teradata PT Error Table Extractor does not support the extraction of the acquisition phase error tables which were created on non-z/OS platforms, because the character encoding on z/OS is different from non-z/OS platforms.

      On z/OS, the Teradata PT Error Table Extractor can only support the extraction of the acquisition phase error tables that were created from jobs run from the z/OS platforms.

    • On non-z/OS platforms, the Teradata PT Error Table Extractor does not support the extraction of the acquisition phase error tables which were created on z/OS, because the character encoding on non-z/OS is different from z/OS platforms.

      On non-z/OS platforms, the Teradata PT Error Table Extractor can only support the extraction of the acquisition phase error tables that were created from jobs run from the non-z/OS platform.

    • On z/OS, the Teradata PT Error Table Extractor does not prompt the user for the password if the -u Password option is not specified. You must specify the -u Password option on z/OS.
    • The Teradata PT Error Table Extractor is not certified to extract the error information from the acquisition phase error table for these Teradata utilities.

      – FastLoad

      – MultiLoad

      – TPump

      However, the Teradata PT Error Table Extractor can extract the error information from the acquisition phase error table for the Teradata FastLoad and MultiLoad utilities if the data for the FastLoad or MultiLoad job was sent in the indicator mode. If the data was sent in the non-indicator mode, then the Teradata PT Error Table Extractor cannot extract the error information.

      The Teradata PT Error Table Extractor cannot extract the error information from a TPump error table, because the Teradata PT Error Table Extractor does not know the layout of the TPump error table.