Table Level restore

Posted in 2005

Topics: Data Types & Schema Design, Platform-Specific Issues

Link, David A. (Omaha) — Fri, 4 Nov 2005 20:15:32 -0600 — source: Usenet: comp.databases.informix

We are attempting to restore several tables from a replicated server. We can restore one simple table which has 1 column char(10) just fine. So we know we have functionality. However when we attempt to restore a table with multiple column types it seems to scan the archive just fine and return the correct number of rows but the data in the table is corrupt. We keep getting 1210: Date could not be converted to month/day/year format Error in line 1Near character position 1 The table has date, integer, small integer, and char fields. The data in other columns is also incorrect. The table is replicated and I don't know if the shadow columns are causing problems. Any suggestions? Version: 10.00.FC3R1 OS: AIX 5.3 TIA, David sending to informix-list

↪ replying to Link, David A. (Omaha)

mpruet@comcast.net — 6 Nov 2005 01:18:05 -0800 — source: Usenet: comp.databases.informix

You're assessment is probably correct. I haven't tried it yet, but my guess is that the table level restore is not checking to see if the table contains any shadow columns. That would include both the CRCOLS as well as the ROWID for fragmented tables. Please contact tech support on this and let's get a patch in place for this. There are too many customers using ER and or ROWID for table level restore to be broken.