ASF connection name error during startup

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 600I 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 ------------------------------

Not sure I would expect an onstat -D to start the engine .... Paul Watson www.oninit.com Tel: +1 913 387 7529

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 ------------------------------

DBPATH env var set? Just a quick shot in the dark... ------------------------------ Andreas Legner Informix Dev HCL Software ------------------------------

Hi Andreas. DBPATH is not in the "informix" environment used to start "oninit" or in "onstat -g env" output. ------------------------------ Doug Lawry Oninit Consulting ------------------------------

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 ------------------------------

Hi, onstat -g cfg full HA_ALIAS onstat -g clusterHas ER every been enabled? cdr list server Regards, David. ------------------------------ David Williams Senior Database Platform Engineer Flutter London ------------------------------

Hi Art. Those both show the expected new value, not the old one in the error message. ------------------------------ Doug Lawry Oninit Consulting ------------------------------

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 ------------------------------

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 ------------------------------

Hi David. I think you meant: oncheck -pR for i in {0..11} ; do oncheck -pP 1 $i ; doneNeither output contains the old alias name. ------------------------------ Doug Lawry Oninit Consulting ------------------------------

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 ------------------------------

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 ------------------------------

Hi, Let us know what is found. Regards, David. ------------------------------ David Williams Senior Database Platform Engineer Flutter London ------------------------------