Archives of the TeradataForum

Message Posted: Mon, 13 Sep 1999 @ 23:54:48 GMT

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

At our site, we are restoring (using the COPY statement) multiple tables from an archive tape to a database with a name different than the database that was archived in an MVS environment. The table names are the same.

I noticed that, for each table that is restored, the system starts a scan of the tapes from the beginning, even though it processes the tables in alphabetical order. I thought that the archive process stores the tables within a database in alphabetical order on the tape. Therefore, when restoring, the utility should be able to do one sequential pass of the tape.

Is this correct? If so, is this a JCL problem where the JCL needs to specify something like a NOREWIND parameter?

Also, when performing an ANALYZE of an archive in a job step separate from the archive itself, does the Archive utility logon to the system? If so, what user ID is used, since the output from the ANALYZE step does not indicate that a logon occurred? We were running an Analyze step and it failed because the TDP was not available (CLI0280). Is the TDP required, even for an analyze step?

Respectfully,

Tom Stanek
TFS CONSULTING

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