RE: informix begginer on xp
Art,
Is the rootsize big enough?....
Doing the basics... 51.2MB - 2 MB physlog = 49.2MB - 12MB logs = 37.2
MB.
I think that's big enough in the olden days for a tiny engine on unix,
but I know nothing of windows installs, and I think it was stated this
is a 9.4 engine.
Will informix on windows be ok with the truncated pathnames such as:
> MSGPATH C:\\PROGRA~1\\Informix\\ika.log # System message log file path
> CONSOLE C:\\PROGRA~1\\Informix\\conika.log # System console message path
> BAR_ACT_LOG C:\\PROGRA~1\\Informix\\bar_ika.log #Path of log file for
Is the shmbase from the default ok? (SHMBASE 0xC000000L)
[keyy@punkass.com]Iksatongafin,
Check the machine notes for informix. They are in in your install
dir...
What's your XP system event viewer telling you when you try starting the
DB? Check your system messages and such, maybe your XP machine is
complaining.
> MSGPATH C:\\PROGRA~1\\Informix\\ika.log # System message log file path
> CONSOLE C:\\PROGRA~1\\Informix\\conika.log # System console message path
If the DB is talking to you.... It'll probably be there, unless the
"progra~1" truncations is confusing it.
Art,
Speaking of the truncated names..... Would this instance perhaps need
DELIMIDENT set before startup... . Maybe, like unix, the tilde (~) is
not understood without delimident and quotes?
....2 cents...
Norma Jean
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Art S. Kagel
Sent: Wednesday, November 10, 2004 5:52 PM
To: informix-list@iiug.org
Subject: Re: informix begginer on xp
On Wed, 10 Nov 2004 13:43:05 -0500, iksatongafin wrote:
Does the ROOTPATH file (C:\\IFMXDATA\\ika\\rootdbs_dat.000) exist? Is it
the full 51.2MB? If not, you killed the oninit too soon, the time spent
was in creating and padding the initial chunk. It's one problem with
using COOKED files for IDS chunks.
Art S. Kagel
> onconfig.ika
> ----------------------
> #*********************************************************************
> *****
> #
> # INFORMIX SOFTWARE, INC.
> #
> # Title: onconfig.std
> # Description: Informix Dynamic Server Configuration Parameters #
> #*********************************************************************
> *****
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name
> ROOTPATH C:\\IFMXDATA\\ika\\rootdbs_dat.000 # Path for device containing
> ROOTOFFSET 0 # Offset of root dbspace into device
ROOTSIZE 51200 # Size of root dbspace (Kbytes)>
> # Disk Mirroring Configuration Parameters
>
> MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for
MIRROROFFSET 0 # Offset into mirrored>
> # Physical Log Configuration
>
> PHYSDBS rootdbs # Location (dbspace) of physical log
> PHYSFILE 2000 # (Kbytes)>
> # Logical Log Configuration
>
> LOGFILES 6 # Number of logical log files
LOGSIZE 2000 # (Kbytes)LOG_BACKUP_MODE MANUAL
>
> # Diagnostics
>
> MSGPATH C:\\PROGRA~1\\Informix\\ika.log
> CONSOLE C:\\PROGRA~1\\Informix\\conika.log
>
> # BACKUPLOGS=Y
ALARMPROGRAM C:\\PROGRA~1\\Informix\\etc\\alarmprogram.bat
> TBLSPACE_STATS 1>
> # SYSALARMPROGRAM - Full path of ...
>
> # System Archive Tape Device
> TAPEDEV \\\\.\\TAPE0 # Tape device path
> TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 10240 # Maximum (Kbytes)>
> # Log Archive Tape Device
> LTAPEDEV NUL # Log tape device path
> LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 10240 # Max (Kbytes)>
> # Optical
> STAGEBLOB # Optical staging area
> OPTICAL_LIB_PATH # ptical Subsystem driver DLL
>
> # System Configuration
>
SERVERNUM 0
DBSERVERNAME ika
DBSERVERALIASES # List of alternate
NETTYPE onsoctcp,1,,NET # Override sqlhosts nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
>
> MULTIPROCESSOR 0
> NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 0
> NOAGE 0 # Process aging
> AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity>
> # Shared Memory Parameters
>
> LOCKS 2000 # Maximum number of locks
> BUFFERS 2000
NUMAIOVPS # Number IO vps
> PHYSBUFF 32
LOGBUFF 32
CLEANERS 1
SHMBASE 0xC000000L
SHMVIRTSIZE 8192
SHMADD 8192
SHMTOTAL 0
> CKPTINTVL 300
LRUS 8 #
> LRU_MAX_DIRTY 60
> LRU_MIN_DIRTY 50
TXTIMEOUT 300
> STACKSIZE 64>
> # Dynamic Logging
> # DYNAMIC_LOGS:
> # 2 : server automatically add a new logical log when necessary.
(ON) #
> 1 : notify DBA to add new logical logs when necessary. (ON) # 0 :
cannot
> add logical log on the fly. (OFF) #
> # When dynamic logging is on, we can have higher values for
> LTXHWM/LTXEHWM, # because the server can add new logical logs during
> long transaction rollback.
> # However, to limit the number of new logical logs being added,
> LTXHWM/LTXEHWM # can be set to smaller values.
> #
> # If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller
> values # to avoid long transaction rollback hanging the server due to
> lack of logical # log space, i.e. 50/60 or lower.
>
> DYNAMIC_LOGS 2
> LTXHWM 70
> LTXEHWM 80>
> # 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
> DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
> DRTIMEOUT 30 # DR network timeout (in sec) DRLOSTFOUND \\tmp # 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 memory for any CDR queue (Kbytes) CDR_QHDR_DBSPACE # CDR
> queue dbspace (default same as catalog) CDR_QDATA_SBSPACE # CDR queue
> smart blob space CDR_QDATA_SBFLAGS 2 # Log/no-log (default no log)
> CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)>
> # Backup/Restore variables
> BAR_ACT_LOG C:\\PROGRA~1\\Informix\\bar_ika.log #Path of log file for
> onbar.exe BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 10
> BAR_XFER_BUF_SIZE 15 BAR_BSALIB_PATH C:\\ISM\\2.20\\bin\\libbsa.dll #
> Location of ISM XBSA DLL
>
> RESTARTABLE_RESTORE ON #To support restartable restore..values on/off>
> # Informix Storage Manager variables
> ISM_DATA_POOL ISMData
> ISM_LOG_POOL ISMLogs
>
> # Read Ahead Variables
> RA_PAGES # Number of pages to attempt to read ahead
RA_THRESHOLD> # 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 c