Archives of the TeradataForum

Message Posted: Thu, 14 Oct 2010 @ 18:19:08 GMT

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

Mark-

I'm not sure what the basis is for the recommendation for a re-run of the script "a month after the migration". If you can recall who made the recommendation, I will try to get clarification.

In any event, the post_data_restore script updates the Teradata Dictionary for the following objects: User Defined Functions, User Defined Types, User Defined Methods, Stored Procedures, Java External Objects, tables with Partitioned Primary Indexes and JAR objects.

As you point out, the script requires that logons be disabled and the system quiesced and I realize that this is considered an outage by many sites. This was raised to Development but the official policy is that this script must be run following any data migration (Reference DR100322).

To provide some relief, the article points out a couple of very specific scenarios in which you can forgo running the script or defer running the script...

o) If you are not migrating these objects, you do not have to run the script.

o) If you are incrementally migrating data and you will not be referencing these objects in the interim, you can defer the execution and run it once, upon completion of the migration.

-dave.clark

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