APAR status
Closed as program error.
Error description
When executing a Table Level Restore (TLR) with archecker and specifying the owner of the table in the command file, it will fail to find the table in the archive. This appears to not reproduce when using the informix userid. The archecker message log will display: STATUS: IBM Informix Dynamic Server Version 11.50.FC5 Program Name: archecker Version: 8.0 Released: 2009-07-14 19:41:36 CSDK: IBM Informix CSDK Version 3.50 ESQL: IBM Informix-ESQL Version 3.50.FC4 Compiled: 07/14/09 19:42 on SunOS 5.9 Generic_122300-36 STATUS: Arguments [-t -f arch.cmd] STATUS: AC_STORAGE /usr/informix/1150F/tmp STATUS: AC_MSGPATH /usr/informix/1150F/tmp/ac_msg.log STATUS: AC_VERBOSE on STATUS: AC_TAPEDEV /usr2/informix/tapedev/1150F/ STATUS: AC_TAPEBLOCK 1024 KB STATUS: AC_LTAPEDEV /dev/null STATUS: AC_LTAPEBLOCK 32 KB STATUS: AC_SCHEMA arch.cmd TIME: [2009-08-25 14:56:31] All old validation files removed. STATUS: Dropping old log control tables STATUS: Restore only physical image of archive STATUS: Extracting table stores_demo:customer into stores_demo:customer_ext WARNING: Source table [customer] has no storage option WARNING: No storage space to scan STATUS: Archive file /usr2/informix/tapedev/1150F/ctu_116_L0 STATUS: Tape type: Archive Backup Tape STATUS: OnLine version: IBM Informix Dynamic Server Version 11.50.FC5 STATUS: Archive date: Tue Aug 25 14:56:04 2009 STATUS: Archive level: 0 STATUS: Tape blocksize: 1048576 STATUS: Tape size: 2147483647 STATUS: Tape number in series: 1 STATUS: starting to scan dbspace 1 created on 2009-08-25 14:56:04. STATUS: Archive timestamp 0X00030E04. ERROR: "PREPARE" failed ERROR: -206: The specified table (briano.ext_tlr_1) is not in the database. ERROR: -111: ISAM error: no record found. ERROR: Unable to open table stores_demo:customer_ext ERROR: Table stores_demo.customer is being skipped TIME: [2009-08-25 14:56:31] Tape 1 completed STATUS: Scan PASSED STATUS: Control page checks PASSED STATUS: Table checks PASSED STATUS: Table extraction commands 1 STATUS: Tables found on archive 0 STATUS: Tables not located on archive 1 STATUS: LOADED: stores_demo:customer_ext produced 0 rows TIME: [2009-08-25 14:56:31] Physical Extraction Completed TIME: [2009-08-25 14:56:31] Unload Completed STATUS: archecker completed Physical Restore pid = 106 exit code: 3
Local fix
Remove the owner from the table name and it should work just fine.
Problem summary
**************************************************************** * USERS AFFECTED: * * Archecker users * **************************************************************** * PROBLEM DESCRIPTION: * * archecker TLR fails to find a table when non-informix owner * * is specified in the command file (-f) * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC6 and above. * ****************************************************************
Problem conclusion
Problem first fixed in IDS 11.50.xC6
Temporary fix
Comments
APAR Information
APAR number
IC62839
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
2009-08-27
Closed date
2009-10-27
Last modified date
2009-10-27
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":"","label":""}}]
Document Information
Modified date:
27 October 2009