Archives of the TeradataForum

Message Posted: Thu, 20 Nov 2003 @ 12:51:30 GMT

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

Ian.a.Russell wrote:

Ian,

You could run a dictionary archive from server A, and restore this archive onto server B.

E.g. From server A::

ARCHIVE DICTIONARY TABLES (DBC) ALL,
RELEASE LOCK,
USE READ LOCK,
OUTPUT ROW COUNTS,
DDNAME=filename;

& to server B::

COPY DICTIONARY TABLES ALL FROM ARCHIVE,
RELEASE LOCK,
FILE=filename ;

(above on MVS - amend DDNAME on Unix)

Cheers,

Mark

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