Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 Dec 2002 @ 14:59:02 GMT


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


Subj:   archive/copy
 
From:   Karen Gebhard

I know I'm being a pest but I have another problem. We archived just stored procs from a database using the following:

archive data tables (first_core)
(exclude tables (T_81A
    ,T_81ADtl
    ,T_81Ajoins
    ,T_ABIDESDAILYJOINS
    ,T_ABIDESEOM
    ,T_ABIDESEOMDtl
    ,T_ABIDESJOINS
    ,T_ABIDESMONTHLYJOINS
    ,T_ABIDESTH
    ,T_ABIDESTHDtl
    ,T_CPAIS
    ,T_CPAISA
    ,T_CPAISADRCTL
    ,T_CPAISB
    ,T_CPAISJOINS
    ,T_D5W
    ,T_D5WA
    ,T_D5WB
    ,T_D5WE
    ,T_d5wJOINS
    ,T_D5WRPTCtl
    ,T_dolarjoins
    ,T_DOLARS
    ,T_DOLARSDtl
    ,T_GenID
    ,T_SFCTitle
    ,T_SFCTXN
    ,T_SOURCESYSTEM
    ,T_SrcSysDes
    ,t_srcsysdes_temp
    ,t_srcsysdes_temp_new
    ,T_SYSTEMMANAGER))
  , release lock
 ,file = coresp
;

This worked.

However when we tried to do the copy back (copy code follows) we got warnings that the tables weren't archived. What's up with that? It also looks like it recreated the dictionary entries for the tables when we didn't ask it to.

Copy statements:

copy data tables
 (first_core_1.spCPASD5WMigrator) (FROM (first_core.spCPASD5WMigrator))
,(first_core_1.spDOLARSMigrator) (FROM (first_core.spDOLARSMigrator))
,(first_core_1.spGAFS81AMigrator) (FROM (first_core.spGAFS81AMigrator))
,(first_core_1.spGAFSD5WMigrator) (FROM (first_core.spGAFSD5WMigrator))
,release lock
,file=coresp
;

Sample error message from copy:

"FIRST_CORE_1"."T_D5W_0" CREATED
12/11/2002 21:26:26  "FIRST_CORE_1"."T_dolarjoins" CREATED
12/11/2002 21:26:27  "FIRST_CORE_1"."T_DOLARS" CREATED
12/11/2002 21:26:28  "FIRST_CORE_1"."T_DOLARSDtl" CREATED
12/11/2002 21:26:29  "FIRST_CORE_1"."T_DOLARS_0" CREATED
12/11/2002 21:26:30  "FIRST_CORE_1"."T_GenID" CREATED
12/11/2002 21:26:30  *** Warning 3803:Table 'T_SFCTitle' already exists.
12/11/2002 21:26:30  *** Warning 3803:Table 'T_SFCTXN' already exists.
12/11/2002 21:26:31  "FIRST_CORE_1"."T_SOURCESYSTEM" CREATED
12/11/2002 21:26:32  "FIRST_CORE_1"."T_SOURCESYSTEM_4" CREATED
12/11/2002 21:26:33  "FIRST_CORE_1"."T_SrcSysDes" CREATED
12/11/2002 21:26:34  "FIRST_CORE_1"."T_SRCSYSDES_0" CREATED
12/11/2002 21:26:35  "FIRST_CORE_1"."t_srcsysdes_temp" CREATED
12/11/2002 21:26:36  "FIRST_CORE_1"."t_srcsysdes_temp_new" CREATED
12/11/2002 21:26:37  "FIRST_CORE_1"."T_SYSTEMMANAGER" CREATED
12/11/2002 21:26:47  STARTING TO COPY DATABASE "FIRST_CORE_1"
12/11/2002 21:28:15  DICTIONARY COPY COMPLETED
12/11/2002 21:28:17  "spABIDESEOMMigrator" - 122,322 BYTES, 8 ROWS COPIED
12/11/2002 21:28:19  "spABIDESTHMigrator" - 138,030 BYTES, 8 ROWS COPIED
12/11/2002 21:28:20  "spCPAISMigrator" - 157,592 BYTES, 8 ROWS COPIED
12/11/2002 21:28:22  "spCPAS81AMigrator" -  89,408 BYTES, 7 ROWS COPIED
12/11/2002 21:28:24  "spCPASD5WMigrator" - 167,654 BYTES, 9 ROWS COPIED
12/11/2002 21:28:25  "spDOLARSMigrator" -  96,592 BYTES, 7 ROWS COPIED
12/11/2002 21:28:27  "spGAFS81AMigrator" -  94,190 BYTES, 7 ROWS COPIED
12/11/2002 21:28:28  "spGAFSD5WMigrator" - 193,956 BYTES, 10 ROWS COPIED
12/11/2002 21:28:30  "spGenIDProc" -  38,292 BYTES, 6 ROWS COPIED
12/11/2002 21:28:31  "spnewintevent" -  34,898 BYTES, 6 ROWS COPIED
12/11/2002 21:28:31  "T_81A" -   3,302 BYTES, 0 ROWS COPIED
12/11/2002 21:28:31  *** Warning ARC1242:Empty Table restored/copied:
"T_81A" -

                   TABLE EXCLUDED BY USER WHEN ARCHIVING.


     
  <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