How could I copy/restore data from a table with CLOB field(s) when using arcmain?

Database
Fan

How could I copy/restore data from a table with CLOB field(s) when using arcmain?

Hi,
When I executed
"
LOGON ip/usr,pswd
COPY DATA TABLES(myDataBase.myClobTable),
RELEASE LOCK,
FILE=arc1;
LOGOFF;
"
in arcmain.
A failure occurred:

*** Warning ARC1254:Can not restore LOB subtables to a
rehashed system.

How to copy LOB data?
Tags (1)
4 REPLIES
Junior Supporter

Re: How could I copy/restore data from a table with CLOB field(s) when using arcmain?

The HASH function must be the same in both systems.

HTH.

Cheers.

Carlos.
Enthusiast

Re: How could I copy/restore data from a table with CLOB field(s) when using arcmain?

Hi, all

1.How to compare hash function used by two different systems? Whether they are same or different.

2.Even if the hash function is the same on two systems, is resotre tables with LOB'S and CLOB'S with possible using arcmain or ABU.

 

Junior Supporter

Re: How could I copy/restore data from a table with CLOB field(s) when using arcmain?

You can check the hash function from DBS control utility.Its in General Fields.

Once you are connected enter the following command

di gen

Check the value of 5 th field HashFuncDBC

 

 


Abhishek Jadhav
Teradata Employee

Re: How could I copy/restore data from a table with CLOB field(s) when using arcmain?

ARC 14.0 or later can copy/restore tables with LOB data even if the hash functions differ.