IBM Support

IC62839: ARCHECKER TLR FAILS TO FIND A TABLE WHEN NON-INFORMIX OWNER IS SPECIFIED IN THE COMMAND FILE (-F)

Subscribe

You can track all active APARs for this component.

 

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