Archives of the TeradataForum

Message Posted: Mon, 24 May 2004 @ 14:23:14 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi all

I have a question regarding fastexport and the error:

     UTY5427 ** No room for new file  d:\Teradata\CLAIMS_DELTA.mload  **

Were getting this error about 7 or 8 tables into a fastexport script which calsl a runfile with our required tables in it (and with mlscript). Now the manual has the explanation:

UTY5427 No room for new file '<file name>'.

Explanation: There was no room in the file name table to include the entry for the specified file.

Generated By: UMBSTMOP

Remedy: Reduce the number of files accessed and resubmit the program.

The question is, where is the limit? Logtable?

To get around it we've limited the number of tables to fastexport per job to 4 tables.

Just curious.

Simon

Simon Bloomer Solutions Consultant: Business Intelligence Bytes Specialized Solutions Akker Park, Neels Bothma Street, N1 City 7463, Cape Town, South Africa

	<Prev	Next>		<<First	<Prev	Next>	Last>>