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
Back to discussions
Expand all | Collapse all

ASF connection name error during startup

  • 1.  ASF connection name error during startup

    Posted 06/30/26 07:38 AM
    Edited by Doug Lawry 06/30/26 08:37 AM

    We are migrating an HDR pair to new hosts and have cloned Linux and Informix with HDR running independently between them for testing before going live. All is fine except there are two identical ignorable entries in the primary message log during startup just before or after "On-Line Mode" as below (with the actual DB server alias replaced with "alias" for confidentiality):

    10:45:32  ASF connection name "@alias" errno is 0 asfcode_fileid asfns.c asfcode_line 600
    10:45:32  ASF connection name "@alias" errno is 0 asfcode_fileid asfns.c asfcode_line 600

    I have subsequently found that this also occurs on the old primary server. The actual alias name is a defunct HDR secondary HA_ALIAS from before the previous migration. Neither $ONCONFIG or "sqlhosts" contains that alias, not any other files in $INFORMIXDIR/etc or /INFORMIXTMP, nor "onstat -g cluster" output. There is nothing obvious in the "sysha" database. Restarting with DBSERVERALIASES hashed out as an experiment has no effect, nor does restarting with "oninit -D". Does anyone have any other ideas? If not, I will raise a case with IBM.



    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------



  • 2.  RE: ASF connection name error during startup

    Posted 06/30/26 08:49 AM
    Not sure I would expect an onstat -D to start the engine .... ��


    Paul Watson
    www.oninit.com
    Tel: +1 913 387 7529





  • 3.  RE: ASF connection name error during startup

    Posted 06/30/26 09:17 AM

    Not onstat -D, Paul, oninit -D - starting the engine without replication.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------

    Original Message


  • 4.  RE: ASF connection name error during startup

    Posted 06/30/26 09:54 AM

    DBPATH env var set?
    Just a quick shot in the dark...



    ------------------------------
    Andreas Legner
    Informix Dev
    HCL Software
    ------------------------------



  • 5.  RE: ASF connection name error during startup

    Posted 06/30/26 10:03 AM

    Hi Andreas.

    DBPATH is not in the "informix" environment used to start "oninit" or in "onstat -g env" output.



    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------

    Original Message


  • 6.  RE: ASF connection name error during startup

    Posted 06/30/26 02:55 PM

    Another shot in the dark: What does this show:

    dbaccess sysmaster -
    select * from sysconfig where cf_name = 'HA_ALIAS';

    and what is in the ONCONFIG file for HA_ALIAS?

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------

    Original Message


  • 7.  RE: ASF connection name error during startup

    Posted 07/01/26 04:41 AM

    Hi Art.

    Those both show the expected new value, not the old one in the error message.



    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------

    Original Message


  • 8.  RE: ASF connection name error during startup

    Posted 07/01/26 04:16 AM

    Hi,

    onstat -g cfg full HA_ALIAS 

    onstat -g cluster

    Has ER every been enabled?

    cdr list server

    Regards,
    David.



    ------------------------------
    David Williams
    Senior Database Platform Engineer
    Flutter
    London
    ------------------------------



  • 9.  RE: ASF connection name error during startup

    Posted 07/01/26 04:46 AM

    Hi David.

    Those "onstat" commands show the expected new HDR instance name, not the old one in the error message. ER has never been used on this system, so "cdr list server" fails:

    Enterprise Replication not active  (62)
    command failed -- unable to connect to server specified  (5)



    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------

    Original Message


  • 10.  RE: ASF connection name error during startup

    Posted 07/01/26 10:23 AM

    Hi,

    oncheck -cr

    oncheck -pP  0 <pagenum>  to dump the config reserved pages from the first 12 pages.

    Regards,
    David.



    ------------------------------
    David Williams
    Senior Database Platform Engineer
    Flutter
    London
    ------------------------------



  • 11.  RE: ASF connection name error during startup

    Posted 07/01/26 10:42 AM

    Hi David.

    I think you meant:

    oncheck -pR
    for i in {0..11} ; do oncheck -pP 1 $i ; done

    Neither output contains the old alias name.



    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------

    Original Message


  • 12.  RE: ASF connection name error during startup

    Posted 07/01/26 02:18 PM

    Hi,

    ls -lart $INFORMIXDIR/etc

     .infos file(s) which can be regenerated by onmode -R

     I think there are .oncfg(?) file(s) in there are well

    /INFORMIXTMP   ( onstat -g dis to show?)

       strings <filename>

    these as well or just clear out for the instance and restart.

    Regards,
    David.



    ------------------------------
    David Williams
    Senior Database Platform Engineer
    Flutter
    London
    ------------------------------

    Original Message


  • 13.  RE: ASF connection name error during startup

    Posted 07/02/26 04:27 AM

    Hi David.

    Not in any of those.

    Thanks for input everyone. Will raise with IBM for them to look at "asfns.c" line 600 in 14.10.FC11W1.



    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------

    Original Message


  • 14.  RE: ASF connection name error during startup

    Posted 07/03/26 07:21 AM

    Hi,

    Let us know what is found.


    Regards,

    David.



    ------------------------------
    David Williams
    Senior Database Platform Engineer
    Flutter
    London
    ------------------------------

    Original Message


Related Content