Informix - Problem description
Problem IT26272 | Status: Closed |
ARCHECKER TABLE LEVEL RESTORE (TLR) OF TABLE WITH SMART BLOBS DOESN'T ALWAYS RESTORE ALL SLOBS FROM BACKUP | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
This problem was reported running archecker TLR against a 12.10.FC7W1 backup on linux x86_64 and I suspect this should reproduce against current latest 12.10.FC12 version. When running archecker to restore a table that contains smart blobs, it is possible that the TLR will not restore all sblobs from the backup. For instance, the following archecker command restores a table with a blob column: create table "informix".tab1 ( c1 serial not null , c2 "informix".blob not null , c3 char(8) not null , c4 datetime year to second not null , primary key (c1) ) in rootdbs PUT c2 in ( sb1 ) extent size 256 next size 64 lock mode row; At the end of the restore, the TLR reports 201 rows were produced. LOADED: db1:tab1 produced 201 rows. However, if you observe the number of slobs actually created, it is possible that this number won't match. For instance, the external file in this case was created in /tmp and there should have been 201 files returned from the following ls command, but we only see 30: $ ls -l /tmp/sb2* | wc -l 30 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Archecker table level restore (TLR) of table with smart * * blobs doesn't always restore all slobs from backup. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.09.2018 03.10.2019 03.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |