Re: 4gl run-time error number -25588 ..

From: Elvis <elvis.perezNOelSPAM@lua.sms.sachsen.de.invalid> > >. The appl process cannot connect to Dynamic server test > >I have Informix IDS 7.30.UC8 and 4gl 7.20.UD6 on an SIEMENS >RM/400 running SINIX 5.43-C4001. > >The sql hosts file on the RM/400 is: > >test onipcshm 172.23.110.2 online> >We need help ! We need your onconfig, sqlhosts, /etc/hosts and /etc/services files. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Hello ! Our files: File: Onconfig.test -------------------- #*********************************************************** *************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.std # Description: Informix Dynamic Server Configuration Parameters # #*********************************************************** *************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace nameROOTPATH /home/informix/database/rootdbs # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 250000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for devicecontaining mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS physdbs # Location (dbspace) of physical log PHYSFILE 4000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 12 # Number of logical logfiles LOGSIZE 2000 # Logical log size (Kbytes) # Diagnostics MSGPATH /home/informix/online.log # System message log file path CONSOLE /dev/console # System console messagepath ALARMPROGRAM /home/informix/etc/log_full.sh # Alarm program path SYSALARMPROGRAM /home/informix/etc/evidence.sh # System Alarm program path TBLSPACE_STATS 1 # System Archive Tape Device TAPEDEV /dev/ios0/rstape016h # Tape device path #TAPEDEV /dev/null # Tape device path TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE 525000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /inf3/logfile # Log tape device path LTAPEBLK 16 # Log tape block size (Kbytes) LTAPESIZE 24000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server/Optical staging area # System Configuration SERVERNUM 0 # Unique id correspondingto a Dynamic Server instance DBSERVERNAME test # Name of default databaseserver DBSERVERALIASES # List of alternatedbservernames NETTYPE ipcstr,1,50,NET NETTYPE tlitcp,1,50,NET NETTYPE ipcshm,1,100,CPU # Configure poll thread(s)for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lockin distributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1for multi-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit numberof cpu vps to one NOAGE 0 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number ofprocessors # Shared Memory Parameters LOCKS 2000 # Maximum number of locks BUFFERS 5000 # Maximum number of sharedbuffers NUMAIOVPS # Number of IO vps PHYSBUFF 64 # Physical log buffer size (Kbytes) LOGBUFF 64 # Logical log buffer size (Kbytes)LOGSMAX 24 # Maximum number of logical log files CLEANERS 2 # Number of buffer cleanerprocesses SHMBASE 0x20000000 # Shared memory baseaddress SHMVIRTSIZE 8000 # initial virtual sharedmemory 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 begincleaning limit LRU_MIN_DIRTY 50 # LRU percent dirty endcleaning limit LTXHWM 50 # Long transaction highwater mark percentage LTXEHWM 60 # Long transaction highwater mark (exclusive) TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # Stack size (Kbytes) # System Page Size # BUFFSIZE - Dynamic Server no longer supports this configuration parameter. # To determine the page size used by Dynamic Server 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 ofoffline worker threads ON_RECVRY_THREADS 1 # Default number ofonline 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 DRbuffer flushes (in sec) DRTIMEOUT 30 # DR network timeout (in sec) DRLOSTFOUND /usr/informix/etc/dr.lostfound # DRlost+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 memoryfor 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 # Informix Storage Manager variables ISM_DATA_POOL ISMData # If the data pool name is changed, be sure to # update $INFORMIXDIR/bin/onbar. Change to # ism_catalog - create_bootstrap -pool <new name> ISM_LOG_POOL ISMLogs # Read Ahead Variables RA_PAGES # Number of pages toattempt to read ahead RA_THRESHOLD # Number of pages leftbefore next group # DBSPACETEMP: # Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces # that the Dynamic Server SQL Engine will use to create temp tables etc. # If specified it must be a colon separated list of dbspaces that exist # when the Dynamic Server system is brought online. If not specified, or if # all dbspaces specified are invalid, various ad hoc queries will create # temporary files in /tmp instead. DBSPACETEMP tempdbs # Default temp dbspaces # DUMP*: # The following parameters control the type

Are your clients remote or on the same host machine? You have only configured a shared memory connection which is NOT available on the network. You need to add a DBSERVERALIAS to represent the hostname of the network connection and add a line in the sqlhosts file with that name in the first column, ontlitcp in the second column and a different servicename (NOT THE ONE YOU USED FOR THE SHARED MEMORY CONNECTION LINE) in the fourth column. Make sure the service is in /etc/services. Now you will have to make a similar entry in the clients' sqlhosts file (or in setnet32 for Windows clients) and voila! All will be OK. Art S. Kagel Elvis wrote: > > Hello ! > Our files: > File: Onconfig.test > -------------------- > #*********************************************************** > *************** > # > # INFORMIX SOFTWARE, INC. > # > # Title: onconfig.std > # Description: Informix Dynamic Server Configuration > Parameters > # > #*********************************************************** > *************** > > # Root Dbspace Configuration > > ROOTNAME rootdbs # Root dbspace name> ROOTPATH /home/informix/database/rootdbs > # Path for device > containing root dbspace > ROOTOFFSET 0 # Offset of root dbspace > into device (Kbytes) > ROOTSIZE 250000 # 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 physdbs # Location (dbspace) of > physical log > > PHYSFILE 4000 # Physical log file size > (Kbytes)> > # Logical Log Configuration > > LOGFILES 12 # Number of logical log> files > LOGSIZE 2000 # Logical log size (Kbytes)> > # Diagnostics > > MSGPATH /home/informix/online.log # System message > log file path > CONSOLE /dev/console # System console message> path > ALARMPROGRAM /home/informix/etc/log_full.sh # Alarm > program path > SYSALARMPROGRAM /home/informix/etc/evidence.sh # System > Alarm program path > TBLSPACE_STATS 1> > # System Archive Tape Device > > TAPEDEV /dev/ios0/rstape016h # Tape device path > #TAPEDEV /dev/null # Tape device path > TAPEBLK 16 # Tape block size (Kbytes) > TAPESIZE 525000 # Maximum amount of data to > put on tape (Kbytes)> > # Log Archive Tape Device > > LTAPEDEV /inf3/logfile # Log tape device path > LTAPEBLK 16 # Log tape block size > (Kbytes) > LTAPESIZE 24000 # Max amount of data to put > on log tape (Kbytes)> > # Optical > > STAGEBLOB # Informix Dynamic > Server/Optical staging area > > # System Configuration > > SERVERNUM 0 # Unique id corresponding> to a Dynamic Server instance > DBSERVERNAME test # Name of default database> server > DBSERVERALIASES # List of alternate> dbservernames > NETTYPE ipcstr,1,50,NET > NETTYPE tlitcp,1,50,NET > NETTYPE ipcshm,1,100,CPU # 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 1 # 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 5000 # Maximum number of shared> buffers > NUMAIOVPS # Number of IO vps > PHYSBUFF 64 # Physical log buffer size > (Kbytes) > LOGBUFF 64 # Logical log buffer size > (Kbytes)> LOGSMAX 24 # Maximum number of logical > log files > CLEANERS 2 # Number of buffer cleaner> processes > SHMBASE 0x20000000 # 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 0x12c # Transaction timeout (in > sec) > STACKSIZE 32 # Stack size (Kbytes)> > # System Page Size > # BUFFSIZE - Dynamic Server no longer supports this > configuration parameter. > # To determine the page size used by Dynamic > Server 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 /usr/informix/etc/dr.lostfound # 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_