suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    das ultimative Tool für Informix

    pfeil  
Neueste VersionenFixList
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT26272 Status: Geschlossen

ARCHECKER TABLE LEVEL RESTORE (TLR) OF TABLE WITH SMART BLOBS DOESN'T
ALWAYS RESTORE ALL SLOBS FROM BACKUP

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
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-Zusammenfassung:
****************************************************************
* 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:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
12.09.2018
03.10.2019
03.10.2019
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC13
Problem behoben lt. FixList in der Version
Informix EditionenInformix Editionen
Informix Editionen
DokumentationDokumentation
Dokumentation
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