Teradata system such as FastLoad, MultiLoad, FastExport and TPT. Automatic Distribution: Teradata automatically distributes the data evenly to the disks without any manual intervention. . 18:33:38 Teradata Database Release: 14.10.02.08. Please refer to the FastLoad reference manual for the correct syntax. You can use a typecast in FastLoad. For more information, see Teradata FastLoad Reference documentation. TStatCatcher Statistics. Select this check box to collect log data at the component level. This component offers the flexibility of the DB query and covers all possible SQL queries. Fastload is a Teradata Bulk Load Utility used to load vast amounts of data as quickly and efficiently as possible. As a bulk load utility, it bypasses the transient journal and loads data in blocks. The Fastload utility first assembles the client-side data blocks and then sends them to Teradata, minimizing network load.
Message Posted: Wed, 28 Nov 2007 @ 18:56:20 GMT
<Prev | Next> | <<First | Next> | Last>> |
![Online reference manual Online reference manual](https://i.ebayimg.com/images/g/otcAAOSwETBecT-M/s-l400.jpg)
Subj: | LSN error using FASTLOAD |
From: | Duell, Bob |
Hi,
I hope someone can help with a mysterious problem. We use SAS software to interact with Teradata. One feature enables SAS to invoke Teradata's FASTLOAD utility using a native SAS data source to provide rows to be inserted into a table. This has always worked well.
However, we have recently begun getting this error message from SAS:
ERROR: Fastload could not allocate data sessions: Associated LSN was not found.
The closest thing I can find in the Teradata Messages manual is this (from page 6-60):
*3029 Associated LSN was not found.*
Teradata Fastload Tutorial
*Explanation: *An LSN associate connect request has been received for a host/LSN which cannot be found in the system.
*Generated By: *Session Control.
*For Whom: *Support Representative.
*Notes: *This error is returned by an internal consistency check. This error causes an error message to be returned to the host.
*Remedy: *Check the LSN sent to the DBC to see that it already exists.
The problem cannot be reproduced; running the job a second time loads the table just fine so I assume it has something to do with system congestion or maybe a timing problem.
Can someone please help me diagnose this problem? If I can get a clear explanation on what this error means I may be able to get additional assistance from SAS.
Teradata Fastload Reference Manual User
Note: We upgraded the Teradata Utilities on our UNIX server in September, just prior to a system upgrade from V2R5. Our current release is V2R.06.01.01.74. The FASTLOAD version is 07.08.00.05. I don't remember ever seeing this message before upgrading.
Thanks very much,
Bob
Teradata Fastload Reference Manual Download
Teradata Fastload Reference Manual Pdf
<Prev | Next> | <<First | Next> | Last>> |