Informix Error code -204
Posted in 2003
Topics: Storage & Space Management, Error Codes & Troubleshooting, Server Administration, Transactions, Locking & Isolation, Logging & Checkpoints, Networking & sqlhosts Configuration, Licensing & Editions, Versions, Editions & End-of-Life
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 SerialNumber AAC#J860444
15:10:12 Informix Dynamic Server Initialized -- Complete DiskInitialized.
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 SerialNumber AAC#J860444
15:12:49 Informix Dynamic Server Initialized -- Shared MemoryInitialized.
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 SerialNumber AAC#J860444
11:36:48 Informix Dynamic Server Initialized -- Shared MemoryInitialized.
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 mirroredroot
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 indistributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No =
0)
MULTIPROCESSOR 0 # 0 for single-processor, 1 formulti-processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one
NOAGE 0 # Process aging
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