If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > archecker Restoration problem

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-24-12, 03:20
jagathabhaya jagathabhaya is offline
Registered User
 
Join Date: Mar 2012
Posts: 2
archecker Restoration problem

Hi All,

I am facing a table level restoration issue of restoring a missing table from L0 backup. Our databases sysmaster, Sysadmin ,sysuser and Sysutils have dbs_collate en_US.819. The rest of the Production databases (with the target restoration database) have dbs_collate en_US.57372.

When I try to restore this particular table archecker complains as 'the connection failed Error 23197 database locale info mismatch'.

I set both DB_LOCALE and CLIENT_LOCALE enviornment variables to en_US.819 but archecker complained about the same error. (We are using IDS 11.70.FC4W1GE) .

Any idea to sort this issue?

Thanks,

Jag.
Reply With Quote
  #2 (permalink)  
Old 06-06-12, 17:56
K2skier100 K2skier100 is offline
Registered User
 
Join Date: Jun 2012
Posts: 1
I had the same issue. It turned out to be the block size of the L0 Backup. In the AC_Config file I had identified the block size as 32k. In my case the database was 16k block sizes. Once I made the correction in the AC_Config file this error went away.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On