Re:
Do you possibly have PSORT_DBTEMP set, or did you have it set when you
kicked off the server?
From: "Lewis, Keith A." <Lewis@timken.com>
>
> I have a problem with queries using all of the temp dbspace. We
>just moved to IDS 7.31 FC4 from
>IDS 7.30 UC3. The same queries run fine under the previous version of
>Dynamic Server but now a single query uses all the temp dbspace and then
>abends with -229. Ihave 2GB assign to temp dbspace which should be plenty.
>Is there some parameters in the onconfig file I should be adjusting??
>
>Thanks for any help
>
>Here is my onconfig file:
>
>Informix Dynamic Server Version 7.31.FC4 -- On-Line -- Up 23:36:47 --
>977216s
>
>Configuration File: /usr/informix/etc/onconfig.bbudwprod
>#**************************************************************************
>#
># INFORMIX SOFTWARE, INC.
>#
># Title: onconfig.std
># Description: Informix Dynamic Server Configuration Parameters
>#
>#**************************************************************************
>
># Root Dbspace Configuration
>
>ROOTNAME rootdbs # Root dbspace name>ROOTPATH /dev/vgfc4/rlvf401 # Path for device containing root
>dbspace
>ROOTOFFSET 0 # Offset of root dbspace into device
>(Kbytes)
>ROOTSIZE 80000 # 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 10000 # Physical log file size (Kbytes)>
># Logical Log Configuration
>
>LOGFILES 8 # Number of logical log files
>LOGSIZE 5000 # Logical log size (Kbytes)>
># Diagnostics
>
>MSGPATH /usr/informix/online.logbbudwprod # System message log file
>path
>CONSOLE /dev/console # System console message>path
>ALARMPROGRAM /usr/informix/etc/no_log.sh # Alarm program path
>SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path
>TBLSPACE_STATS 0>
># System Archive Tape Device
>
>TAPEDEV /dev/rmt/0m # Tape device path
>TAPEBLK 20 # Tape block size (Kbytes)
>TAPESIZE 23400000 # Maximum amount of data to put on tape
>(Kbytes)>
># Log Archive Tape Device
>
>LTAPEDEV /dev/rmt/1m # Log tape device path
>LTAPEBLK 20 # Log tape block size (Kbytes)
>LTAPESIZE 7800000 # Max amount of data to put on log tape
>(Kbytes)>
># Optical
>
>STAGEBLOB # Informix Dynamic Server/Optical staging
>area
>
># System Configuration
>
>SERVERNUM 3 # Unique id corresponding to a Dynamic>Server ie
>DBSERVERNAME bbudwprod # Name of default database server
>DBSERVERALIASES bbudwprod_tcp # 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 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
>
>NOAGE 0 # Process aging
>AFF_SPROC 0 # Affinity start processor
>AFF_NPROCS 0 # Affinity number of processors>
># Shared Memory Parameters
>
>LOCKS 20000 # Maximum number of locks
>BUFFERS 80000 # Maximum number of shared buffers
>NUMAIOVPS 16 # Number of IO vps
>PHYSBUFF 64 # Physical log buffer size (Kbytes)
>LOGBUFF 32 # Logical log buffer size (Kbytes)>LOGSMAX 10 # Maximum number of logical log files
>CLEANERS 8 # Number of buffer cleaner processes
>SHMBASE 0x0 # Shared memory base address
>SHMVIRTSIZE 800000 # initial virtual shared memory segment>size
>SHMADD 8192 # Size of new shared memory segments
>(Kbytes)
>SHMTOTAL 0 # Total shared memory (Kbytes).
>0=>unlimited
>CKPTINTVL 1800 # 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 64 # 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)>CDR_LOGDELTA 30 # % of log space allowed in queue memory
>CDR_NUMCONNECT 16 # Expected connections per server
>CDR_NIFRETRY 300 # Connection retry (seconds)
>CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)>
># Backup/Restore variables
>BAR_ACT_LOG /usr/informix/bar_act.log
>BAR_BSALIB_PATH /usr/informix/lib/libbsa.sl
>BAR_MAX_BACKUP 1
>BAR_RETRY 1
>BAR_NB_XPORT_COUNT 10
>BAR_XFER_BUF_SIZE 31
>#BAR_DEBUG 9
>#BAR_DEBUG_LOG /usr/informix/bardebug.log>
># Informix Storage Manager variables
>ISM_DATA_POOL ISMData # If the dat