Re: More details
Set INFORMIXSERVER to ol_nisbc
You have no ol_nisbc_dev informix server defined in your
sqlhosts.ifmx
Hope this helps,
Octav
On Wed, Jun 30, 1999 at 02:43:09PM -0600, Eric Shipek wrote:
> I don't know how to fix this stuff so I'm posting the results of reading the
> files listed in previous posts in hopes that the problem will become
> visable:
>
> I really appreciate you taking time to read through this:
>
> Results of printenv:
>
>
> HOME=/home/erics
> PATH=.:/usr/openwin/bin:/usr/ucb:/usr/dt/bin:/usr/informix/bin:/bin:/usr/bin> :/usr/sbin:/usr/ccs/bin:/usr/sbin:/usr/bin
> LOGNAME=erics
> HZ=100
> TERM=vt220
> TZ=US/Mountain
> SHELL=/usr/local/bin/tcsh
> MAIL=/var/mail/erics
> LC_COLLATE=en_US
> LC_CTYPE=en_US
> LC_MESSAGES=C
> LC_MONETARY=en_US
> LC_NUMERIC=en_US
> LC_TIME=en_US
> HOSTTYPE=sun4
> VENDOR=sun
> OSTYPE=solaris
> MACHTYPE=sparc
> SHLVL=1
> PWD=/usr/informix
> USER=erics
> GROUP=www
> HOST=perrin.nisbc.com
> REMOTEHOST=bdsl80.slkc.uswest.net
> INFORMIXDIR=/usr/informix
> INFORMIXSERVER=ol_nisbc_dev
> ONCONFIG=onconfig.ifmx
> INFORMIXSQLHOSTS=/usr/informix/etc/sqlhosts.ifmx
> INFORMIXTERM=terminfo>
>
> Results of cat /usr/informix/sqlhosts:
>
> #**************************************************************************
> #
> # INFORMIX SOFTWARE, INC.
> #
> #**************************************************************************
>
> demo_on onipcshm on_hostname on_servername> demo_se seipcpip se_hostname sqlexec
>
>
> Results of cat /usr/informix/sqlhosts.ifmx
>
>
> #**************************************************************************
> #
> # INFORMIX SOFTWARE, INC.
> #
> #**************************************************************************
>
> ol_nisbc ontlitcp perrin ifmx_srvc>
>
> Results for cat /usr/informix/onconfig.ifmx
>
> #**************************************************************************
> #
> # INFORMIX SOFTWARE, INC.
> #
> # Title: onconfig.std
> # Description: INFORMIX-OnLine Configuration Parameters
> #
> #**************************************************************************
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name> ROOTPATH /usr/informix/dbspace/rootdbs # Path for device containing root
> dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
> ROOTSIZE 40000 # 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 1000 # Physical log file size (Kbytes)>
> # Logical Log Configuration
>
> LOGFILES 6 # Number of logical log files
> LOGSIZE 500 # Logical log size (Kbytes)>
> # Diagnostics
>
> MSGPATH /usr/informix/online.log # System message log file path
> CONSOLE /dev/null # System null message path> ALARMPROGRAM /usr/informix/log_full.sh # Alarm program path
>
> # System Archive Tape Device
>
> TAPEDEV /dev/null # Tape device path
> TAPEBLK 16 # 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 16 # Log tape block size (Kbytes)
> LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)>
> # Optical
>
> STAGEBLOB # INFORMIX-OnLine/Optical staging area
>
> # System Configuration
>
> SERVERNUM 14 # Unique id corresponding to a OnLine instance
> DBSERVERNAME ol_nisbc # Name of default database server
> DBSERVERALIASES # 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 200 # Maximum number of shared buffers
> NUMAIOVPS # Number of IO vps
> PHYSBUFF 32 # Physical log buffer size (Kbytes)
> LOGBUFF 32 # Logical log buffer size (Kbytes)> LOGSMAX 6 # Maximum number of logical log files
> CLEANERS 1 # Number of buffer cleaner processes
> SHMBASE 0x0A000000L # Shared memory base address
> SHMVIRTSIZE 8000 # initial virtual shared memory segment size
> SHMADD 8192 # Size of new shared memory segments
> (Kbytes)
> SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
> CKPTINTVL 300 # Check point interval (in sec)
> LRUS 8 # Number of LRU queues
> LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
> LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
> LTXHWM 50 # Long transaction high water mark percentage
> LTXEHWM 60 # Long transaction high water mark (exclusive)
> TXTIMEOUT 300 # Transaction timeout (in sec)
> STACKSIZE 32 # Stack size (Kbytes)>
> # System Page Size
> # BUFFSIZE - OnLine no longer supports this configuration parameter.
> # To determine the page size used by OnLine on your platform
> # see the last line of output from the command, 'onstat -b'.
>
>
> # Recovery Variables
> # OFF_RECVRY_THREADS:
> # Number of parallel worker threads during fast recovery or an offline
> restore.
> # ON_RECVRY_THREADS:
> # Number of parallel worker threads during an online restore.
>
> OFF_RECVRY_THREADS 10 # Default number of offline worker threads
> ON_RECVRY_THREADS 1 # Default number of online worker threads>
> # Data Replication Variables
> # DRAUTO: 0 manual, 1 retain type, 2 reverse type
> DRAUTO 0 # DR automatic switchover
> DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
> DRTIMEOUT 30 # DR network timeout (in sec)
> DRLOSTFOUND /tmp # DR lost+found file path>
> # CDR Variables
> CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes)
> CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
> CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
> CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue
> (Kbytes)>
> # Backup/Restore variables
> BAR_ACT_LOG /tmp/bar_act.log
> BAR_MAX_BACKUP 0
> BAR_RETRY 1
> BAR_NB_XPORT_COUNT 10
> BAR_XFER_BUF_SIZE 31>
> # Read Ahead Variables
> RA_PAGES # Number of pages to attempt to read ahead
> RA_THRESHOLD # Number of pages left before next group>
> # DBSPACETEMP:
> # On