Re: Problem Connecting Database (Sahred Memory ser

Sometimes happens if the application is using the address space to which shared memory would attach for a shared memory connection. If you can consistently run using strpip or TCP connection types this is likely the problem. There's an environment var you can set to change the shared memory connect address, but I haven't time to look it up right now. Art S. Kagel ----- Original Message ----- From: Omer Khan <ids@iiug.org> At: 4/06 3:14:17 Hello All, I have facing a very interesting problem, in which, when i try to connect to the database using dbaccess, it sometimes connects and sometimes give the following error: --------------------------------------------------------------------- - 25588: The appl process cannot connect to Dynamic Server ids_tsi5.Invalid argument ------------------------------------------------------------------- --- Although, It is a very common error that we mostly get when the database is not running(offline) but in my case i have verifed that database is working fine as well and to my surprise, while statying in the same dbaccess interface, when i tried to connect it to using the 'ids_net_tsi5' services, it connected successfully. ----Entries from sqlhost File------------------------ ids_tsi5 onipcshm etp1 sqlturbo_tsi5 ids_net_tsi5 olsoctcp etp1 sql_net_tsi5 ------------------------------------------------------ B ut this problem also occures rerely using 'ids_net_tsi5' service as well. Now i need to know the root cause of this error, so that i could rectify it as soon as possible. Our 4GL routine uses the shared memory service to connect to the database and due to this problem we are facing alot of issues. Please check all the info provided and do suggest me any concrete solutiuon to rectify this issue. Do let me know in case of any additional information is required. Thanks in advance for anticipation. --------------- Regards, Omer Saeed Khan ---------------- Here are the additional Informations: Informix Version: IDS 9.40.UC3 OS: Red Hat Enterprise Linux AS release 4 (Nahant)(Linux version 2.6.9-5.ELsmp (gcc version 3.4.3 20041212 (Red Hat 3.4.3-9.EL4))) Hardware: Linux etp1 2.6.9-5.ELsmp #1 SMP Wed Jan 5 19:30:39 EST 2005 i686 i686 i386 GNU/Linux Processor: Intel(R) Xeon(TM) CPU 2.80GHz (This is a 4 processor machine) RAM: 3 GB This is the onconfig File Setting: onstat -c IBM Informix Dynamic Server Version 9.40.UC3 -- On-Line -- Up 2 days 10:35:59 -- 222636 Kbytes Configuration File: /u/informix/etc/onconfig_tsi5 #********************************************* ***************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.std# Description: Informix Dynamic Server Configuration Parameters # #*********************************************************** *************** # Root Dbspace Configuration ROOTNAME rootdbs5 # Root dbspace name ROOTPATH /u/ids_space/rootdbs5# Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 512000 # 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 rootdbs5 # Location (dbspace) of physical log PHYSFILE 4000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 60 # Number of logical log files LOGSIZE 1000 # Logical log size (Kbytes) # Diagnostics MSGPATH /u/informix/online.log5 # System message log file path CONSOLE /dev/console # System console message path ALARMPROGRAM /u/informix/etc/log_full.sh6 # Alarm program pathSYSALARMPROGRAM /u/informix/etc/evidence.sh # System Alarm program path TBLSPACE_STATS 1 # System Archive Tape Device TAPEDEV /u/informix/onconfig_tsi5.level.0.fifo # Tape device path TAPEBLK 128 # Tape block size (Kbytes) TAPESIZE 20480000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /y/ABS_backups/informix/logical/ids_tsi5.log # Tape device path LTAPEBLK 128 # Log tape block size (Kbytes) LTAPESIZE 2048000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server/Optical staging area # System Configuration SERVERNUM 1 # Unique id corresponding to a Dynamic Server instance DBSERVERNAME ids_tsi5 # Name of default database serverDBSERVERALIASES ids_net_tsi5 # List of alternate dbservernames NETTYPE ipcshm,4,50,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,4,50,NET # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT -1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 4 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one NUMAIOVPS 8 # Number of IO vps NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 4 # Affinity number of processors # Shared Memory Parameters LOCKS 2000000 # Maximum number of locks BUFFERS 5000 # Maximum number of shared buffers PHYSBUFF 64 # Physical log buffer size (Kbytes) LOGBUFF 64 # Logical log buffer size (Kbytes) CLEANERS 8 # Number of buffer cleaner processes SHMBASE 0x10000000 # Shared memory base address SHMVIRTSIZE 32000 # initial virtual shared memory segment size SHMADD 8192 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited #SHMTOTAL 256000 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec) LRUS 8 # Number of LRU queues LRU_MAX_DIRTY 60.000000 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 50.000000 # 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 DRINTERVAL 30 # DR max time between DR buffer flushes (in sec) DRTIMEOUT 30 # DR network timeout (in sec) DRLOSTFOUND /u/informix/etc/dr.lostfound.tsi5 # DR lost+found file path # CDR Variables 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

Hello Art, I will be so kindful, if you could please allocate some time for this and explain me what you have thought that mighe be a problem? What can i do to overcome this issue. Looking forwrd for your kind cooperation. Regards, Omer Saeed Khan