Arcmain15 unable to read archive from TD14

Tools
Teradata Employee

Arcmain15 unable to read archive from TD14

I have two Teradata Express VMs side by side...

   The 1st  is Release: TD14.00.00.02 Ver TD14.00.00.14

   The 2nd is Release: TD15.00.01.01 Ver TD15.00.01.01

... and I want to move the a set of databases from v14 to v15. 

Just as in the past I planned to use arcmain to move the databases.  Here's an extract from the scripts:


export:

    LOGON TERADATA14/DBC,DBC;

     archive data tables (CIM_APPLICATION)ALL,

     release lock,

     file = CIM_APP;

     LOGOFF;

import:

     LOGON TERADATA15/dbc,dbc;

     copy DATA tables (CIM_APPLICATION),

     RELEASE LOCK,

     file=CIM_APP;


     LOGOFF;

The export works fine and so, too, does the import if I restore the data back to TD14.

However, I get the following error if I try and restore the data to TD15...

02/11/2015 16:09:09  ARC HAS REQUESTED 4 SESSIONS, TASM HAS GRANTED IT 4 SESSIONS

02/11/2015 16:09:09

02/11/2015 16:09:09  UTILITY EVENT NUMBER  - 67

02/11/2015 16:09:10  LOGGED ON    4 SESSIONS

02/11/2015 16:09:10  *** Failure ARC0805:Access Module returned error code 29: Empty file on read open.

02/11/2015 16:09:10  LOGGED OFF   7 SESSIONS

02/11/2015 16:09:10  ARCMAIN TERMINATED WITH SEVERITY 12


What am I missing that preventing the data from loading into TD15?

Any help would be appreciated

1 REPLY
Teradata Employee

Re: Arcmain15 unable to read archive from TD14

'llo, probably need to see the versions of the whole ARC stack to know for sure

At a guess this backup/restore file CIM_APP is ending up larger than a couple of gigabytes

Try cutting the backup into smaller chunks ie. < 2 GB and working with that

From the backup script you seem to be backing up (CIM_APPLICATION) and all of its children but only copy-restoring the this single database?

As this is a copy I'm assuming you have already created/defined the database on the target.

ta'