Named Pipe : Teradata

Step by Step : Arc /restore by Named pipe

Fig: Arcmain Data Transfer using the Named-Pipe Access Module

Step 1 : Create Named Pipe by using below linux command.

Mknod ARCPIPE p

Step2 : Create archive file and specify file = Pipe name

.logon TDDEV/arc_user2,user2arc1;

ARCHIVE DATA TABLES

(sichake.tbl1),

release lock, file=ARCPIPE;

LOGOFF;

Step 3: Create restore/copy file and specify file = Pipe name

.logon TDTEST/arc_user2,user2arc1;

COPY DATA TABLES

(sichake.tbl1),

release lock,

file=ARCPIPE;

LOGOFF;

Step 4 : Execute below arcmain commands to archive and copy/restore the database/table

nohup arcmain vb3 sessions=10 checkpoint=0 outlog=swdout errlog=swerr < resttest1.arc &

nohup arcmain vb3 sessions=10 checkpoint=0 outlog=goldout errlog=golderr < arctest1.arc &

Two possible archive job strategies

• All-amp - Database objects are identified at a database or table level. Data from all database amps are sent together.

• Serial Cluster - Database objects are identified to the finer granu-larity of a cluster or a group of clusters. Following a dictionary ar-chive, the clusters are archived and restored/copied one after an-other. This is because in almost all cases the target system will be a different configuration from the source system, and each opera-tion will apply an all-amp exclusive lock on its target objects. In the restore/copy script the "CLUSTER=" option will have to be omit-ted, and the "NO BUILD" option will have to be used. Only after all of the archives have been restored, should a separate "BUILD DATA TABLES" command be executed.

Command Line Options

Options to be added to the arcmain command line. There are others, and documentation can be found in the ARC Reference Manual for them. Additional information on setting the values for these options can be found in later sections of this document.

• sessions=n - The number of data sessions. Each session is a sepa-rate connection to the database, the default is 4 ses-sions, but a starting point for analysis should be 1 ses-sion per amp. Session count is discussed further in the Performance Analysis section.

• checkpoint=0 - suppress checkpointing by arcmain

• outlog=jobout - echo arc output to this file (max 8 characters)

• errlog=joberr - echo arc errors to this file (max 8 characters)

• verbose3 - show detailed progress in arcmain output (optional)

• syntax - parse only, do not execute (optional)

• default=filename - allows always-used options to be kept in a file

When using the Named Pipes Access Module there are some additional parameters that must be included to support the access module:

• iomodule=np_AXSMOD.dll - W2K Named Pipes Access Module

• iomodule=np_axsmod.so - MP-RAS Named Pipes Access Module

• ioparms= - parameters passed to the iomodule at launch

• ioparms=fallback_directory=c:\work log_level=4 - Named Pipe parameters

• filedef=(ARCPIPE,\\.\pipe\ARCPIPE) - W2K, local pipe

• filedef=(ARCPIPE,\\.\targetsys\ARCPIPE) - W2K, remote pipe