Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 19 Jul 2001 @ 14:35:31 GMT


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


Subj:   Archive dictionary table
 
From:   Christopher Platt

is there a trick to this i missed :

(arc parm used)
 ARCHIVE DICTIONARY TABLE (MLOAD_SPOOL),
 RELEASE LOCK,
 DDNAME=COKEDBC;
LOGOFF;

(i tried restore and copy)
  COPY    DICTIONARY TABLE (MLOAD_SPOOL.TCSM_TEST1),
  RELEASE LOCK,
  FILE=COKEDBC;
 LOGOFF;
(output showing copy worked and lock
released)
 LOGGED ON   18 SESSIONS
 UTILITY EVENT NUMBER  - 8302
 "MLOAD_SPOOL"."tcsm_test1" CREATED
 STARTING TO COPY TABLE "MLOAD_SPOOL"."tcsm_test1"
 DICTIONARY COPY COMPLETED
 "TCSM_TEST1" -   1,036 BYTES COPIED
 "MLOAD_SPOOL"."TCSM_TEST1" - LOCK RELEASED

 STATEMENT COMPLETED

 LOGOFF;
 LOGGED OFF  20 SESSIONS
 STATEMENT COMPLETED

 ARCMAIN TERMINATED WITH SEVERITY 0

(yet we are still locked.....tried release lock thru arc again no luck)

select * from mload_spool.tcsm_test1;

 select * from mload_spool.tcsm_test1;
  *** Failure 2654 Operation not allowed: mload_spool.tcsm_test1 is being
  Restored.
                 Statement# 1, Info =0
  *** Total elapsed time was 0.23 seconds.


     
  <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