Teradata Partition Backup (in Mainframe)

Tools & Utilities

Teradata Partition Backup (in Mainframe)

Hello!

I need your knowlodge because I read this manual "Teradata Archive/Recovery Utility" V12.00 and used the example (page 157)
So, my job has:

LOGON 4/xx,xxxx;
ARCHIVE DATA TABLES
(TEMPORAL.INTERCONEXION)
(PARTITIONS WHERE
(!FC_LLAMADA BETWEEN DATE'2010-10-20' AND DATE'2010-11-20'!) ),
RELEASE LOCK,
FILE=ARCOUT;
LOGOFF;
/*

the structure of table: the partition of temporal.interconexion

PRIMARY INDEX INTERCONEXION_NUPI ( cd_numero_a ,fc_llamada ,hr_hora )
PARTITION BY RANGE_N(fc_llamada BETWEEN DATE '2010-10-01' AND DATE '2011-04-30' EACH INTERVAL '1' DAY );

I executed the job and then the sysprint (or log) displayed:

03/15/2011 14:38:51 ARCHIVE DATA TABLES
03/15/2011 14:38:51 (TEMPORAL.INTERCONEXION)
03/15/2011 14:38:51 (PARTITIONS WHERE
03/15/2011 14:38:51 (!FC_LLAMADA BETWEEN DATE'2010-10-20' AND
DATE'2010-11-20'!) ),
03/15/2011 14:38:51 *** Failure ARC0202:( was not expected.
03/15/2011 14:38:51 LOGGED OFF 2 SESSIONS
03/15/2011 14:38:51 ARCMAIN TERMINATED WITH SEVERITY 12

¿What is wrong? I tried a lot of combinations, one of then... take out the 3th "(" and its ")" but it cancelled because arcmain didn't recognize the "!"

Additional Info:
PROGRAM: ARCMAIN
RELEASE: 12.00.00.00
BUILD: 070147I (May 10 2007)

thank you for your help!

Paola

1 REPLY

Re: Teradata Partition Backup (in Mainframe)

Hi Paola, I have the same problem as you. at last could you find the fix?

Thanks a lot.