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?