All Forums Database
teradatauser2 236 posts Joined 04/12
15 Oct 2013
Join index and table header change- how are they related ?

Hi,
We had a prod issue today wherein one table was being updated by etl job and at the same time one JI was being created on that table. We got an error in the etl update that structural changes are being made to the table and the update job failed.
1. why would a JI do a structural change to the table. In fact when you see that table defn in dbc.tables, the lastupdatetime is changed to today.
2. I saw the explain, in the last step the JI takes a exclusive lock on the table and updates the table header. That's why the etl job failed. But, the question is why does a JI creation does a table header change ?
 
Thanks !

teradatauser2 236 posts Joined 04/12
17 Oct 2013

Hi All,
Any response to this ?
Thanks !

dhirajpalse 36 posts Joined 01/08
18 Oct 2013

Table header of the base table is locked to update table's version number. If you see the 'Version' column in TVM , it should be incremented by 1.
Per manuals, Table's structural version is one of the various components of table header. It is incremented each time the table description is modified and a structural change is made that makes a database dump obsolete.

Dhiraj

You must sign in to leave a comment.