Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 01 Oct 2003 @ 17:38:20 GMT


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


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


     
  <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: 15 Jun 2023