Hi,

One of my customers has an informix error code -204. His NSDK
application returns this error code when accessing to database. The
workstation configuration is :
- Windows NT 4.0 SP6a
- IDS Workgroup Edition 7.31.TC5
- Informix Client 2.20TC1
- NSDK 1.60

I tested several cases :
- Windows NT4 SP6a + IDS 7.31 + Client 2.20
- Windows NT4 SP6a + IDS 7.31 + Client 2.81
- Windows NT4 SP6a + IDS 9.21 + Client 2.20
- Windows NT4 SP6a + IDS 9.21 + Client 2.81
- Windows XP SP1 + IDS 7.31 + Client 2.20
- Windows XP SP1 + IDS 7.31 + Client 2.81
- Windows XP SP1 + IDS 9.21 + Client 2.20
- Windows XP SP1 + IDS 9.21 + Client 2.81
I never had this error when I used the same application.

Can you explain me why this error could happen?

Thanks

-- Log file --
Wed Oct 29 15:09:57 2003

15:09:57 DR: DRAUTO is 0 (Off)
15:10:03 Informix Dynamic Server Version 7.31.TC5 Software Serial
Number AAC#J860444
15:10:12 Informix Dynamic Server Initialized -- Complete Disk
Initialized.
15:10:12 Warning: Invalid dbspace 'tempdbs' listed in DBSPACETEMP.
15:10:12 Checkpoint Completed: duration was 0 seconds.
15:10:12 Dataskip is now OFF for all dbspaces
15:10:12 On-Line Mode
15:10:23 Building 'sysmaster' database ...
15:10:29 Logical Log 1 Complete.
15:10:31 Logical Log 2 Complete.
15:10:32 Logical Log 3 Complete.
15:10:39 Logical Log 4 Complete.
15:10:46 'sysmaster' database built successfully.
15:10:46 'sysutils' database built successfully.
15:10:46 Init operation complete - Mode Online Initialized
15:11:16 Checkpoint Completed: duration was 0 seconds.
15:11:35 Checkpoint Completed: duration was 0 seconds.
15:11:43 Shutdown Mode
15:11:44 Quiescent Mode
15:12:06 Checkpoint Completed: duration was 0 seconds.
15:12:08 Logical Log 5 Complete.
15:12:09 Logical Log 6 Complete.
15:12:11 Logical Log 8 Complete.
15:12:13 Logical Log 10 Complete.
15:12:15 Checkpoint Completed: duration was 0 seconds.
15:12:16 Checkpoint Completed: duration was 0 seconds.
15:12:17 Checkpoint Completed: duration was 0 seconds.
15:12:18 Checkpoint Completed: duration was 0 seconds.
15:12:19 Checkpoint Completed: duration was 0 seconds.
15:12:20 Checkpoint Completed: duration was 0 seconds.
15:12:21 Checkpoint Completed: duration was 0 seconds.
15:12:26 Informix Dynamic Server Stopped.

Wed Oct 29 15:12:47 2003

15:12:47 DR: DRAUTO is 0 (Off)
15:12:47 Informix Dynamic Server Version 7.31.TC5 Software Serial
Number AAC#J860444
15:12:49 Informix Dynamic Server Initialized -- Shared Memory
Initialized.
15:12:49 Physical Recovery Started.
15:12:49 Physical Recovery Complete: 0 Pages Restored.
15:12:49 Logical Recovery Started.
15:12:52 Logical Recovery Complete.
1 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

15:12:54 Onconfig parameter PHYSDBS modified from rootdbs to logsdbs.
15:12:54 Onconfig parameter PHYSFILE modified from 2000 to 5120.
15:12:54 Onconfig parameter LOGFILES modified from 6 to 8.
15:12:54 Dataskip is now OFF for all dbspaces
15:12:54 Init operation complete - Mode Quiesent
15:12:54 Quiescent Mode
15:12:54 Checkpoint Completed: duration was 0 seconds.
15:13:10 On-Line Mode
15:16:16 Checkpoint Completed: duration was 0 seconds.
15:21:32 Checkpoint Completed: duration was 0 seconds.
15:26:32 Checkpoint Completed: duration was 0 seconds.
15:56:38 Checkpoint Completed: duration was 0 seconds.
16:01:38 Checkpoint Completed: duration was 0 seconds.

Thu Oct 30 11:36:39 2003

11:36:39 DR: DRAUTO is 0 (Off)
11:36:45 Informix Dynamic Server Version 7.31.TC5 Software Serial
Number AAC#J860444
11:36:48 Informix Dynamic Server Initialized -- Shared Memory
Initialized.
11:36:48 Physical Recovery Started.
11:36:48 Physical Recovery Complete: 0 Pages Restored.
11:36:48 Logical Recovery Started.
11:36:51 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

11:36:52 Dataskip is now OFF for all dbspaces
11:36:52 Init operation complete - Mode Online
11:36:52 On-Line Mode
11:37:04 Checkpoint Completed: duration was 0 seconds.
11:42:03 Checkpoint Completed: duration was 0 seconds.



-- Onconfig file --
#************************************************* *************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: Informix Dynamic Server Configuration Parameters
#
#************************************************* *************************

# Root Dbspace Configuration
ROOTNAME rootdbs
ROOTPATH C:\IFMXDATA\MAPP_DEP_TR\CH_APP_DEP_TR_R
ROOTOFFSET 0 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 16384 # 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 logsdbs # Location (dbspace) of physical log
PHYSFILE 5120 # Physical log file size (Kbytes)

# Logical Log Configuration
LOGFILES 8 # Number of logical log files
LOGSIZE 1024 # Logical log size (Kbytes)
LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL,
CONT)

# Diagnostics
MSGPATH C:\APP_DEP\MAPP_DEP_TR.LOG
CONSOLE C:\APP_DEP\MAPP_DEP_TR.MSG
ALARMPROGRAM C:\PROGRA~1\INFORMIX\etc\log_full.bat # Alarm program
path

# System Diagnostic Script.
# SYSALARMPROGRAM - Full path of the system diagnostic script (e.g.
# c:\informix\etc\evidence.bat.) Set this parameter
# if you want a different Diagnostic Script than
# {INFORMIXDIR}\etc\evidence.bat, which is default.

# System Archive Tape Device
TAPEDEV NUL
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 10240 # Maximum amount of data to put on
tape (Kbytes)

# Log Archive Tape Device
LTAPEDEV NUL
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log
tape (Kbytes)

# Optical
STAGEBLOB # Informix Dynamic Server/Optical
staging area
OPTICAL_LIB_PATH 859-1 # Location of Optical Subsystem
driver DLL

# System Configuration
SERVERNUM 0
DBSERVERNAME mapp_dep_tr
DBSERVERALIASES # List of alternate dbservernames
NETTYPE soctcp,1,,NET # Override sqlhosts nettype parameters
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 200000 # Maximum number of locks
BUFFERS 1000 # Maximum number of shared buffers
NUMAIOVPS 1 # Number of IO vps
PHYSBUFF 32 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
LOGSMAX 50 # Maximum number of logical log files
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0xc000000 # Shared memory base address
SHMVIRTSIZE 8192 # 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 C:\APP_DEP\

# 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 C:\TMP\bar_act.log
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 15
BAR_BSALIB_PATH libbsa.dll #Location of ISM XBSA dll
RESTARTABLE_RESTORE off #To support restartable
restore..values on/off

# Informix Storage Manager variables
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs

# Read Ahead Variables
RA_PAGES 4 # Number of pages to attempt to read
ahead
RA_THRESHOLD 2 # Number of pages left before 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

# DUMP*:
# The following parameters control the type of diagnostics information
which
# is preserved when an unanticipated error condition (assertion
failure) occurs
# during Dynamic Server operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR C:\APP_DEP\
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this
aborts Dynamic Server)
DUMPCNT 1 # Number of shared memory or gcore
dumps for a single user's session

# FILLFACTOR:
FILLFACTOR 90 # Fill factor for building indexes

# method for Dynamic Server to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get
time from OS(slow)

# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES 32 # Maximum number of decision support
queries
DS_TOTAL_MEMORY 4096 # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support
scans
DATASKIP off # List of dbspaces to skip

# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 1 # To hint the optimizer
ONDBSPACEDOWN 1 # Dbspace down option: 0 = CONTINUE, 1
= ABORT, 2 = WAIT
LBU_PRESERVE 0 # Preserve last log for log backup
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)

# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0

# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL -1

# Optimizer DIRECTIVES ON (1/Default) or OFF (0)
DIRECTIVES 1

Stephane VUILLIN wrote:
> Hi,
>
> One of my customers has an informix error code -204. His NSDK
> application returns this error code when accessing to database. The
> workstation configuration is :
> - Windows NT 4.0 SP6a
> - IDS Workgroup Edition 7.31.TC5
> - Informix Client 2.20TC1
> - NSDK 1.60
>
> I tested several cases :
> - Windows NT4 SP6a + IDS 7.31 + Client 2.20
> - Windows NT4 SP6a + IDS 7.31 + Client 2.81
> - Windows NT4 SP6a + IDS 9.21 + Client 2.20
> - Windows NT4 SP6a + IDS 9.21 + Client 2.81
> - Windows XP SP1 + IDS 7.31 + Client 2.20
> - Windows XP SP1 + IDS 7.31 + Client 2.81
> - Windows XP SP1 + IDS 9.21 + Client 2.20
> - Windows XP SP1 + IDS 9.21 + Client 2.81
> I never had this error when I used the same application.
>
> Can you explain me why this error could happen?

You can check the error messages with "finderr 204"
In NT you should have it on the menus

204 is a floating point error...

Regards