Archives of the TeradataForum

Message Posted: Tue, 19 Dec 2006 @ 13:00:05 GMT

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

Here is the answer based on an NCR Knowledge Article (SD1000C236A):

Question: The customer is using ARC to migrate user tables from a previous release to V2R6. Following the restore operation, ARC issues the warning:

     *** Warning ARC1257:A cross-release data restore requires
      that a Teradata SQL conversion script be run.  The
      following steps must be performed:

1) Log in as user DBC, and execute the following SQL statement:

     CREATE MACRO DBC.DIPMarkNS50 AS (;);

2) Execute one of the following conversion scripts:

     post_data_restore.

The script post_data_restore takes less than two minutes to run but it requires that logon be disabled and the system quiesced. Is it necessary to run the script?

Answer: This script will update fields within the DBC tables to accurately reflect information regarding UDFs and Triggers. It does not convert any data tables. Assuming you are not making use of these features, you do not have to run the script

You can check for the existence of triggers with the query:

     sel dbase.databasename (FORMAT 'X(15)'),
     tvm.tvmname (FORMAT 'X(25)')
     from dbc.tvm,dbc.dbase where
     dbase.databaseid=tvm.databaseid
     and tvm.tablekind='G'
     order by 1,2;

You can check for the existence of UDFs with the query:

     sel dbase.databasename (FORMAT 'X(15)'),
     tvm.tvmname (FORMAT 'X(25)')
     from dbc.tvm,dbc.dbase where
     dbase.databaseid=tvm.databaseid
     and tvm.tablekind='U'
     order by 1,2;

If neither exist on your system, you do not have to run this script.

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