suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    get the ultimate tool for Informix

    pfeil  
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)
Informix EditionsInformix Editions
Informix Editions
DocumentationDocumentation
Documentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download