Cluster level Archive!!!

Database
Enthusiast

Cluster level Archive!!!

Hi,

I would like to know about "Cluster Archive" and how it differs from an All-Amp Archive.

Regards,
Annal T
2 REPLIES
Fan

Re: Cluster level Archive!!!

Hi:

I am intrested in arcmain cluster=0,1 ... feature. 

i read this section on the manual  (the cluster command is only covered in 1 page) but don't fully under stand the strength of archive cluster .

my question is : can I run the job 2 and job 3 clustered command on different node in the clique and archive to different filename  in parallel.     (assuming I only have limited size file system on each nodes so I intend to run multiple steams of arcmain on using cluster command and make each files smaller on different nodes, is this possible?)

if anyone has done this , please kindly provide simple example will be apprecated. and how the recovery should be performed ? 

----- the example from Teradata ARC manual  ----

Job 1 LOGON USER,USER;

ARCHIVE DICTIONARY TABLES (USERDB),

FILE = ARCHDICT;

LOGOFF;

Job 2 (run in parallelwith Job 3)

LOGON USER, USER;

ARCHIVE DATA TABLES (USERDB),

CLUSTER = 0,1,

FILE = CLUSTER1;

LOGOFF;

Job 3 (run in parallel with Job 2)

LOGON USER, USER;

ARCHIVE DATA TABLES (USERDB),

CLUSTER = 2,3,

FILE = CLUSTER2;

LOGOFF;

Job 4 LOGON USER, USER;

RELEASE LOCK (USERDB);

LOGOFF;
Fan

Re: Cluster level Archive!!!

Hi, its me again,

one more additional implementaiton related question, How do I find out what cluster number is associate each machine (node) in the clque.

thanks.