All Forums Database
mfgfd 3 posts Joined 11/08
20 Sep 2012
restoring tables from older TD releases deliver strange messages

Hello,
because of business reasons I had to restore some old data. The restore ran fine, but delivered some strange messages, as
"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.DIPMarkNS120 AS (;);               

2) Execute one of the following conversion scripts:
post_data_restore.                                 

"
Does anyone know the meaning of this ? I could select from the restored table without doing anything else and I could insert the rows from the restored table into the target table without problems.
Why should I create an empty macro?
Where can I find this "post_data_restore" script?
Thank you

ulrich 816 posts Joined 09/09
20 Sep 2012

This thread might explain the what and why.
http://www.teradataforum.com/teradata/20101012_151552.htm
I found the script in 
 

/opt/teradata/tdat/tdbms/13.10.01.04/bin/post_data_restore

 

so it might be already on the server.

But might be best to discuss it with your support team.

 

 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.