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 number
IC67012
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-03-09
Closed date
2010-11-15
Last modified date
2010-11-15
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 November 2010