Load Ingest Data
Results 1 to 2 of 2

Thread: Error Log Tables Location

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

    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
    Location
    Nashua, NH - USA.
    Posts
    145
    Rep Power
    12
    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.

    Hein

Posting Permissions

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