Get Data Moving 1
Results 1 to 2 of 2

Thread: Error Log Tables Location

  1. #1
    yuril is offline Junior Member
    Join Date
    Oct 2018
    Rep Power

    Error Log Tables Location

    Attention gurus:

    We have been using Replicate functions with Teradata as target DB. Once in a while, there are dozens of error tables (something like my_table_59007E330000_E1) being created in the same database as our production tables. These tables are marginally useful for troubleshooting, but is there a setting in Replicate to change the default database for error logs, say to a separate log DB? Alternatively, how about collecting error logs in just ONE table per object?

    Thank you!

  2. #2
    Hein is offline Senior Member
    Join Date
    Dec 2007
    Nashua, NH - USA.
    Rep Power
    Those bonus tables are created by the Teradata provided TDloader which replicate use.

    You can see this happening in the Replicate task log when requesting logging for TARGET_APPLY set to TRACE.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts