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

APAR status

• Closed as program error.

Error 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
  

Local fix

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:                                              *
  ****************************************************************
  

Problem conclusion

• Fixed in IDS 12.10.xC13.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels