RE: IIUG-IDS-9-4-UC2-linux Problems
Posted in 2005
What does your sqlhosts file look like? Protocol should be onsoctcp.
Bill
> -----Original Message-----
> From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org]
> On Behalf Of Thomas Ronayne
> Sent: Wednesday, April 06, 2005 11:40 AM
> To: informix-list@iiug.org
> Subject: Re: IIUG-IDS-9-4-UC2-linux Problems
>
> This is a multi-part message in MIME format.
> --------------000301010004080202080802
> Content-Type: text/plain; charset=us-ascii; format=flowed
> Content-Transfer-Encoding: 7bit
>
> I've built, installed and wrung-out these glibc packages for i686
> (replacing the same compiled for i486):
>
> glibc-2.3.4-i686-1
> glibc-i18n-2.3.4-noarch-1
> glibc-profile-2.3.4-i686-1
> glibc-solibs-2.3.4-i686-1
> glibc-zoneinfo-2.3.4-noarch-1
>
> I've completely removed and reinstalled IIUG-IDS-9-4-UC2-linux, edited
>
> sqlhosts and onconfig, and, when I execute
>
> oninit -v>
> I get
>
> Checking group membership to determine server run modesucceeded
> Reading configuration file
> '/opt/informix/etc/onconfig'...succeeded
> Creating /INFORMIXTMP/.infxdirs ... succeeded
> Creating infos file "/opt/informix/etc/.infos.fubar_a" ...
> "/opt/informix/etc/.conf.fubar_a" ... succeeded
> Writing to infos file ... succeeded
> Checking config parameters...succeeded
> Allocating and attaching to shared memory...succeeded
> Creating resident pool 3384 kbytes...succeeded
> Creating buffer pool 40002 kbytes...succeeded
> Initializing rhead structure...succeeded
> Initializing ASF ...oninit: Fatal error in initializing ASF with
> 'ASF_INIT_DATA' flags; asfcode = '25507'.
> FAILED
>
> And I have absolutely no idea what to do about that.
>
> I also cannot find where ESQL/C got installed -- did I miss something?
>
> I'm sorry to attach both sqlhosts and onconfig, but maybe I missed
> something and some kind soul can point out where I'm being stupid.
>
> Thank you.
>
>
> --------------000301010004080202080802
> Content-Type: text/plain;
> name="sqlhosts"
> Content-Transfer-Encoding: 7bit
> Content-Disposition: inline;
> filename="sqlhosts"
>
> #*********************************************************************
> *****
> #
> # INFORMIX SOFTWARE, INC.
> #
> # PROPRIETARY DATA
> #
> # THIS DOCUMENT CONTAINS TRADE SECRET DATA WHICH IS THE PROPERTY
> OF
> # INFORMIX SOFTWARE, INC. THIS DOCUMENT IS SUBMITTED TO RECIPIENT
> IN
> # CONFIDENCE. INFORMATION CONTAINED HEREIN MAY NOT BE USED,
> COPIED OR
> # DISCLOSED IN WHOLE OR IN PART EXCEPT AS PERMITTED BY WRITTEN
> AGREEMENT
> # SIGNED BY AN OFFICER OF INFORMIX SOFTWARE, INC.
> #
> # THIS MATERIAL IS ALSO COPYRIGHTED AS AN UNPUBLISHED WORK UNDER
> # SECTIONS 104 AND 408 OF TITLE 17 OF THE UNITED STATES CODE.
> # UNAUTHORIZED USE, COPYING OR OTHER REPRODUCTION IS PROHIBITED BY
> LAW.
> #
> #
> # Title: sqlhosts.demo
> # Sccsid: @(#)sqlhosts.demo 9.2 7/15/93 15:20:45
> # Description:
> # Default sqlhosts file for running demos.
> #
> #*********************************************************************
> *****
>
> #demo_on onipcshm on_hostname on_servername> #demo_se seipcpip se_hostname sqlexec
>
> fubar_a onipcshm fubar fubar_a> fubar_anet seipcpip fubar fubar_anet
>
> --------------000301010004080202080802
> Content-Type: text/plain;
> name="onconfig"
> Content-Transfer-Encoding: 7bit
> Content-Disposition: inline;
> filename="onconfig"
>
> #*********************************************************************
> *****
> #
> # INFORMIX SOFTWARE, INC.
> #
> # Title: onconfig.std
> # Description: Informix Dynamic Server Configuration Parameters
> #
> #*********************************************************************
> *****
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name
> ROOTPATH /dbs/rootdbs # Path for device containing root> dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device
> (Kbytes)
> ROOTSIZE 30000 # Size of root dbspace (Kbytes)>
> # Disk Mirroring Configuration Parameters
>
> MIRROR 0 # Mirroring flag (Yes = 1, No =
> 0)
> MIRRORPATH # Path for device containing mirrored> root
> MIRROROFFSET 0 # Offset into mirrored device (Kbytes)>
> # Physical Log Configuration
>
> PHYSDBS rootdbs # Location (dbspace) of physical
> log
> PHYSFILE 2000 # Physical log file size (Kbytes)>
> # Logical Log Configuration
>
> LOGFILES 6 # Number of logical log files
> LOGSIZE 2000 # Logical log size (Kbytes)>
> # Diagnostics
>
> MSGPATH /opt/informix/online.log # System message log
> file path
> CONSOLE /dev/null # System console message path>
> # To automatically backup logical logs, edit alarmprogram.sh and set
> # BACKUPLOGS=Y
> ALARMPROGRAM /opt/informix/etc/alarmprogram.sh # Alarm program path
> TBLSPACE_STATS 1 # Maintain tblspace statistics>
> # System Archive Tape Device
>
> TAPEDEV /dev/null # Tape device path
> TAPEBLK 32 # Tape block size (Kbytes)
> TAPESIZE 10240 # Maximum amount of data to put on tape
> (Kbytes)>
> # Log Archive Tape Device
>
> LTAPEDEV /dev/null # Log tape device path
> LTAPEBLK 32 # Log tape block size (Kbytes)
> LTAPESIZE 10240 # Max amount of data to put on log tape
> (Kbytes)>
> # Optical
>
> STAGEBLOB # Informix Dynamic Server staging area
>
>
> # System Configuration
>
> SERVERNUM 0 # Unique id corresponding to a OnLine> instance
> DBSERVERNAME fubar_a # Name of default database server
> DBSERVERALIASES fubar_anet # List of alternate> dbservernames
> NETTYPE # Configure poll thread(s) for> nettype
> DEADLOCK_TIMEOUT 60 # Max time to wait of lock in> distributed env.
> RESIDENT 0 # Forced residency flag (Yes = 1, No =
> 0)
>
> MULTIPROCESSOR 0 # 0 for single-processor, 1 for> multi-processor
> NUMCPUVPS 1 # Number of user (cpu) vps
> SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps> to one
>
> NOAGE 0 # Process aging
> AFF_SPROC 0 # Affinity start processor
> AFF_NPROCS 0 # Affinity number of processors>
> # Shared Memory Parameters
>
> LOCKS 2000 # Maximum number of locks
> BUFFERS 20000 # Maximum number of shared> buffers
> NUMAIOVPS # Number of IO vps
> PHYSBUFF 32 # Physical log buffer size (Kbytes)
> LOGBUFF 32 # Logical log buffer size
> (Kbytes)
> CLEANERS 1 # Number of buffer cleaner processes
> SHMBASE 0x10000000L # Shared memory base address
> SHMVIRTSIZE 73536 # initial virtual shared memory segment> size
> SHMADD 32768 # Size of new shared memory segments
> (Kbytes)
> SHMTOTAL 0 # Total shared memory (Kbytes).
> 0=>unlimited
> CKPTINTVL 300 # Check point interval (in sec)@@NL