Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Jan 2016 @ 09:21:54 GMT


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


Subj:   No Build in restore script keeps the secondary index intact on receiving database
 
From:   Chennapragada, Somasankaram

Hi,

I am using the no build option in my restore script but the secondary index on the table is still intact. However, the join index is skipped as expected. can anyone explain me this behaviour. why did the no build option in my restore script did not skip NUSI creation on emp?

Here is my script.

     logon 127.0.0.1/dbc,dbc;
     restore data tables(personnel),
     no build,
     release lock,
     abort,
     file=ARC_PER;
     logoff;


     01/05/2016 23:28:35  restore data tables(personnel),
     01/05/2016 23:28:35  no build,
     01/05/2016 23:28:35  release lock,
     01/05/2016 23:28:35  abort,
     01/05/2016 23:28:35  file=ARC_PER;
     01/05/2016 23:28:35  UTILITY EVENT NUMBER  - 65
     01/05/2016 23:28:35  LOGGED ON    4 SESSIONS
     01/05/2016 23:28:37  STARTING TO RESTORE DATABASE "PERSONNEL"
     01/05/2016 23:28:39  DICTIONARY RESTORE COMPLETED
     01/05/2016 23:28:39  "dept" - 882 BYTES, 6 ROWS RESTORED
     01/05/2016 23:28:39  "emp" -   2,198 BYTES, 21 ROWS RESTORED
     01/05/2016 23:28:39  "PERSONNEL" - LOCK RELEASED
     01/05/2016 23:28:39
     01/05/2016 23:28:39  "personnel"."empdeptjoin" - RECREATING JOIN/HASH INDEX
     01/05/2016 23:28:40  *** Warning ARC0721:CREATE JOIN INDEX failed with error
                          2654: Operation not allowed: personnel.emp is being
                          Restored..
     01/05/2016 23:28:40  "personnel"."empdeptjoin" - JOIN/HASH INDEX SKIPPED
     01/05/2016 23:28:40  STATEMENT COMPLETED
     01/05/2016 23:28:40
     01/05/2016 23:28:40  logoff;
     01/05/2016 23:28:42  LOGGED OFF   7 SESSIONS
     01/05/2016 23:28:42  STATEMENT COMPLETED
     01/05/2016 23:28:42
     01/05/2016 23:28:42

After Restore, the show command defines the emp table....

     show table personnel.emp;

      *** Text of DDL statement returned.
      *** Total elapsed time was 1 second.

     ---------------------------------------------------------------------------
     CREATE SET TABLE personnel.emp ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT,
          DEFAULT MERGEBLOCKRATIO
          (
           EmpNo SMALLINT,
           Name VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,
           DeptNo SMALLINT,
           JobTitle VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,
           Salary DECIMAL(8,2),
           YrsExp BYTEINT,
           DOB DATE FORMAT 'YY/MM/DD',
           Sex CHAR(1) CHARACTER SET LATIN UPPERCASE NOT CASESPECIFIC,
           Race CHAR(1) CHARACTER SET LATIN UPPERCASE NOT CASESPECIFIC,
           MStat CHAR(1) CHARACTER SET LATIN UPPERCASE NOT CASESPECIFIC,
           EdLev BYTEINT,
           HCap BYTEINT)
     PRIMARY INDEX ( EmpNo )
     INDEX si ( Name );  <<<<<<<<<<<<<<<<<<


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016