ARCMAIN failed!!!!!

General
Enthusiast

ARCMAIN failed!!!!!

I did a dictionary archieve of a table and then did a copy and got two problem:

1)

    COPY DATA TABLES

    (PMART_ST.SHIPMENT_SETL1_HISTORY) (FROM (PMART_ST.SHIPMENT_SETL1_HISTORY))

    RELEASE LOCK

    FILE=ARCTEST1;

THE LOG AS FOLLOWS:

COPY DATA TABLES

09/10/2013 09:10:19      (PMART_ST.SHIPMENT_SETL1_HISTORY) (FROM

                     (PMART_ST.SHIPMENT_SETL1_HISTORY)),

09/10/2013 09:10:19  

09/10/2013 09:10:19  RELEASE LOCK,

09/10/2013 09:10:19  FILE=ARCTEST4;

09/10/2013 09:10:19  UTILITY EVENT NUMBER  - 5636536

09/10/2013 09:10:23  LOGGED ON   12 SESSIONS

09/10/2013 09:10:23  *** Warning 3803:Table 'SHIPMENT_SETL1_HISTORY' already

                     exists.

09/10/2013 09:10:23  STARTING TO COPY TABLE "PMART_ST"."SHIPMENT_SETL1_HISTORY"

09/10/2013 09:10:24  DICTIONARY COPY COMPLETED

09/10/2013 10:28:04  "SHIPMENT_SETL1_HISTORY" - 191,255,977,254 BYTES,

                     788,424,630 ROWS COPIED

09/10/2013 10:31:19  "PMART_ST"."SHIPMENT_SETL1_HISTORY" - LOCK RELEASED

09/10/2013 10:31:19   

09/10/2013 10:31:19  "PMART_ST"."SHIPMENT_SETL1_HISTORY" - RECREATING STAT

                     COLLECTION

09/10/2013 10:31:20  "PMART_ST"."SHIPMENT_SETL1_HISTORY" - STAT COLLECTION

                     RECREATED

09/10/2013 10:31:20  STATEMENT COMPLETED

09/10/2013 10:31:20  

09/10/2013 10:31:20  LOGOFF;

09/10/2013 10:31:21  LOGGED OFF  14 SESSIONS

09/10/2013 10:31:21  STATEMENT COMPLETED

09/10/2013 10:31:21  

09/10/2013 10:31:21  

09/10/2013 10:31:21  ARCMAIN TERMINATED WITH SEVERITY 4

[10:31:21] ARCMAIN return code is '4'

THE DATA ALREADY EXISTING IN TARGET TABLE, HOWEVER THERE IS ERROR CODE RETRUE. ANYONE ONE CAN EXPLIAN? IS THERE ANY POTENTIAL PROBLEM?

2)  I AM TRYING TO COPY ALL DATABASE WITH ARCMAIN:

     COPY DATA TABLES

    (PMART_ST) ALL

    RELEASE LOCK

    FILE=ARCTEST2;

THE ERROR IS :

failure 5628:Column TD_SYSFNLIB not found in DBC.SessionTbl.

Thanks in advance.

1 REPLY
Enthusiast

Re: ARCMAIN failed!!!!!

1. Return Code 4 is for warnings, but the normal flow of the execution will continue. If you see the processing logs, there was a warning issued by the utility as the table SHIPMENT_SETL1_HISTORY already exists.

2. Probably the source and target table definitions are different. TD_SYSFNLIB seems to be available in the archive file but doesn't exist in the table where you are copying the data.