Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  weird and unexpected errors -908 on archecker

    Posted Wed February 16, 2022 12:44 PM
    Hi Folks

    I am working with archecker with the option of table level restore, which has been working fine on my lab systems.
    I am now testing a script on my customer's staging system, with same ifmx version (14.10 FC4) which looks ok in terms of connections (dbaccess under the soctp INFORMIXSERVER works fine), onstat works fine etc...

    but when I launch the same archecker script that works 'at home' I got the following log file, saying basically that I had errors -908 and the table has not been
    captured nor restored

    STATUS: Arguments [-bdvs -X -f /tmp/aga031.cmd]
    STATUS: AC_STORAGE /tmp
    STATUS: AC_MSGPATH /tmp/ac_msg.log
    STATUS: AC_VERBOSE on
    STATUS: AC_TAPEBLOCK 62 KB
    STATUS: AC_IXBAR /appli/informix/ids/etc/ixbar.1
    STATUS: AC_SCHEMA /tmp/aga031.cmd
    TIME: [2022-02-16 16:53:40] All old validation files removed.
    STATUS: Dropping old log control tables
    STATUS: Temporary workspace has been set
    STATUS: Restore only physical image of archive
    ERROR: "Prepare (name check)" failed
    ERROR: -908: (rgetlmsg() returned -1227)
    ERROR: "Execute (name check)" failed
    ERROR: -410: (rgetlmsg() returned -1227)
    ERROR: "Prepare (table_exists)" failed
    ERROR: -908: (rgetlmsg() returned -1227)
    ERROR: "Prepare (lg_name_ptnum_count)" failed
    ERROR: -908: (rgetlmsg() returned -1227)
    ERROR: "Execute (lg_name_ptnum_count)" failed
    ERROR: -410: (rgetlmsg() returned -1227)
    STATUS: Target table [afc] already created
    STATUS: SQL [SET INDEXES, TRIGGERS, CONSTRAINTS FOR afc DISABLED]
    STATUS: Extracting table aga031:afc into aga031:afc
    STATUS: Using IBM's PSM version 14.10.FC4W1 as the Storage Manager. XBSA API version is 1.0.3.
    STATUS: Determined Storage Manager to be psm.
    STATUS: dbspace name: aga031dbs aid: 79711
    STATUS: Object Name /IDS_INST1shm
    Path /IDS_INST1shm/aga031dbs/0
    Resource ND

    STATUS: starting to scan dbspace 22 created on 2022-02-14 17:03:27.
    STATUS: Archive timestamp 0XEFFD47BF.
    ERROR: "Execute (acu_name_save)" failed
    ERROR: -908: (rgetlmsg() returned -1227)
    ERROR: Unable to open table aga031:afc
    ERROR: Table aga031.afc is being skipped
    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: aga031:afc produced 0 rows
    TIME: [2022-02-16 16:54:47] Physical Extraction Completed
    TIME: [2022-02-16 16:54:47] Unload Completed



    STATUS: archecker completed Physical Restore pid = 273170 exit code: 3

    Any idea ?

    ------------------------------
    [eric] [Vercelletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]

    Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
    ------------------------------

    #Informix


  • 2.  RE: weird and unexpected errors -908 on archecker

    Posted Wed February 16, 2022 01:00 PM
    Eric:

    I think that the -1227 error is the root cause:

    $ finderr 1227
    -1227   Message file not found.

    4GL cannot locate a file of message texts. The file should have a
    suffix of .iem and be in the product directory, $INFORMIXDIR/msg.
    Reinstall such files from the distribution materials. If you have
    started to modify the user-message file, 4glusr.msg, check that its
    compiled form has been replaced in the correct directory.

    Something is not right with the path to INFORMIXDIR so archecker can't find the message files.

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.






    Original Message


  • 3.  RE: weird and unexpected errors -908 on archecker

    Posted Wed February 16, 2022 02:21 PM
    Yes. Looks like messy install


    Thanks




    Original Message


  • 4.  RE: weird and unexpected errors -908 on archecker

    Posted Wed February 16, 2022 01:05 PM

    Sounds like you env is wrong somewhere, we know 908 is Attempt to connect to database server (servername) failed. But you are seeing -1227 instead 'cos it can't find the error message files

     

    Cheers

    Paul

     




    Original Message


Related Content