|
|
Archives of the TeradataForum
Message Posted: Wed, 01 Oct 2003 @ 17:38:20 GMT
Subj: | | Re: Teradata Archive/Recovery Util |
|
From: | | Al Sharrieff |
Thanks Ysbrand & James...I really appreciated your input.
Can ARC handle 'pipe' files?
BTW, here's the MVS ARC script I ran earlier:
5 //STEP001 EXEC PGM=ARCMAIN,PARM='SESSIONS=32'
//*******************************************************************
6 //DBCLOG DD DSN=TSHRCI.ARCMAIN.LOGF01,
// DISP=(,CATLG),
// SPACE=(CYL,(12,15)),DCB=(RECFM=FS,LRECL=8192)
7 //ARCHIVE DD DSN=TSHRCI.P548AS.TSTARC01,
// DISP=(,CATLG,DELETE),
// DCB=(BLKSIZE=0,BUFNO=32),
// UNIT=SYSDA,SPACE=(CYL,(10,5),RLSE)
10/01/2003 08:53:56 Copyright 1989-2002, NCR Corporation.
10/01/2003 08:53:56 All Rights Reserved.
10/01/2003 08:53:56
10/01/2003 08:53:56 **** **** **** DATABASE COMPUTER
10/01/2003 08:53:56 * * * * *
10/01/2003 08:53:56 * * **** * PROGRAM: ARCMAIN
10/01/2003 08:53:56 * * * * * RELEASE: 07.00.00
10/01/2003 08:53:56 **** **** **** BUILD: 020237eI (Aug 13 2003)
10/01/2003 08:53:56
10/01/2003 08:53:56 PARAMETERS IN USE:
10/01/2003 08:53:56
10/01/2003 08:53:56 SESSIONS 32
10/01/2003 08:53:56
10/01/2003 08:53:56
10/01/2003 08:53:56 CHARACTER SET IN USE: EBCDIC
10/01/2003 08:53:56 LOGON TDP/XXXXX,;
10/01/2003 08:53:56 LOGGED ON 2 SESSIONS
10/01/2003 08:53:56
10/01/2003 08:53:56 DBS RELEASE V2R.05.00.01.05
10/01/2003 08:53:56 DBS VERSION 05.00.01.10
10/01/2003 08:53:56
10/01/2003 08:53:56 STATEMENT COMPLETED
10/01/2003 08:53:56
10/01/2003 08:53:56 ARCHIVE DATA TABLES
10/01/2003 08:53:56 (IW_WORKDB.PATIENTS_ACCTS),
10/01/2003 08:53:56 RELEASE LOCK,
10/01/2003 08:53:56 INDEXES,
10/01/2003 08:53:56 ABORT,
10/01/2003 08:53:56 FILE=ARCHIVE;
10/01/2003 08:53:56
10/01/2003 08:53:57 UTILITY EVENT NUMBER - 7978
10/01/2003 08:53:58 LOGGED ON 32 SESSIONS
10/01/2003 08:53:58 *** Failure ARC0800:An open error occurred on file ARCHIVE
- Archive file open failure, code:
10/01/2003 08:53:58 LOGGED OFF 34 SESSIONS
10/01/2003 08:53:58 ARCMAIN TERMINATED WITH SEVERITY 12
| |