IC67012: ARCHECKER FAILS IF IFX_ONTAPE_FILE_PREFIX IS SET TO A VALUE THAT INCLUDES AN UNDERSCORE CHARACTER

APAR status

• Closed as program error.

Error description

• When IFX_ONTAPE_FILE_PREFIX is set to any value with an
  underscore character in it,
  the archecker restore fails as it does not correctly interpret
  the naming convention
  and instead searches for the hostname_servernum_Ln prefix
  format.
  
  export IFX_ONTAPE_FILE_PREFIX=test_L0
  
  schema.file
  
  database stores8;
  create table customer
    (
   customer_num serial not null ,
   fname char(15),
   lname char(15),
   company char(20),
   address1 char(20),
   address2 char(20),
   city char(15),
   state char(2),
   zipcode char(5),
   phone char(18),
  primary key (customer_num)
  ) in dbs1;
  create table customer_1
    (
  customer_num serial not null ,
  fname char(15),
  lname char(15),
  company char(20),
  address1 char(20),
  address2 char(20),
  city char(15),
  state char(2),
  zipcode char(5),
  phone char(18),
  primary key (customer_num)
  ) in dbs1;
  
  insert into customer_1 select * from customer;
  set workspace to dbs1;
  restore to current with no log;
  
  archecker -tdvs -f schema.file
  
  ontape -s -L 0
  10 percent done.
  20 percent done.
  100 percent done.
  File created: /sqldists/server/1150fc6/backup/tapes/test_L0
  
  Please label this tape as number 1 in the arc tape sequence.
  This tape contains the following logical logs:
  
   22
  
  Program over.
  
  AC_STORAGE               /tmp
  AC_MSGPATH               /tmp/ac_msg.log
  AC_VERBOSE               on
  AC_TAPEDEV               /sqldists/server/1150fc6/backup/tapes/
  AC_TAPEBLOCK             32 KB
  AC_LTAPEDEV              /dev/null
  AC_LTAPEBLOCK            32 KB
  AC_RESTORE_FILTER        /usr/bin/gzip -d
  Dropping old log control tables
  Restore only physical image of archive
  Target table [customer_1] already created
  Extracting table stores8:customer into stores8:customer_1
  Archive file /sqldists/server/1150fc6/backup/tapes/test__120_L0
  Error(2) opening tape
  device(/sqldists/server/1150fc6/backup/tapes/test__120_L0)
  
  Scan FAILED
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * User taking backups using ontape and directory devices  that *
  * want to check the archives using archecker                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When IFX_ONTAPE_FILE_PREFIX is set to any value, the         *
  * archecker restore fails as it does not correctly interpret   *
  * the naming convention                                        *
  * and appends the _<SERVERNUM> suffix to the value of          *
  * IFX_ONTAPE_FILE_PREFIX.                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC7 and above.                              *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in 11.50.xC7.
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP