Richard KoflerBio

227 messages in this archive (83 questions asked, 144 answers given) — 2008-12-06 17:54:30 to 2014-12-03 12:21:56

Threads

• eliminate duplicate rows
• Optimizing IDS for SSD
• Mutex logs on logical log flip
• Informix Memory Large Pages Sizes
• Actual Number of Pages In-Use by a Table
• Rename a partition
• ALTER FRAGMENT adding multiple fragments
• ALTER FRAGMENT to a dbspace with a differnt page s
• Cooked VS Raw
• Informix on HP MoonShot
• What is all this I/O when doing a light append to
• Upgrade to 11.7 from 11.5 -- Performance improveme
• External Table + zipped files..
• B-tree height (2 messages)
• IDS and P Series
• Informix is now on facebook
• Re: Upgrade to 11.70 from 11.50 results in low Read Ahead Utilization
• Monitoring Informixservers
• IDS information center
• Amazon EC2....
• Re: HP/UX to Linux - raw space setup question
• How long did the last level 0 backup take?
• Unknown SQLCODE error
• Re: Memory Management
• Re: Memory Management
• Re: Memory Management
• Re: Memory Management
• Insert into failed
• 569 Cannot reference an external database with log
• What is the best tool to unload records from a tab (3 messages)
• Speaking of rumors...
• Re: Linux LVM snapshot
• Looking for ESQL/C Multithreaded Source Code Example
• Gary Speaks!
• why update statistics after IDS upgrade ?
• IDS BUFFER POLL CONFIG *NM*
• Re: IDS 11.50.xC6 is out...
• Performance of CPU/Core. (2 messages)
• Performance - Sun SPARC T2 (2 messages)
• Now for some interesting news...
• WITH NO LOG and ORDER BY problem (2 messages)
• Re: SSD --- The reliability of
• Re: Char versus varchar
• Re: SSD --- The reliability of
• Anyone playing with this sort of configuration?
• IDS11.50.xC4 upgrades
• Insert into an indexed table is really SLOW! (2 messages)
• Re: a little help with query.
• Storage recommendations for OLTP
• How to Turn Off Automated Update Statistics in IDS 11.50
• Index fragmentation
• interesting monitoring of cloud computing
• UPDATE STATISTICS Performace Improvement
• Re: Configuring IDS for multi-threaded processors
• Configuring IDS for multi-threaded processors (2 messages)
• ER literature
• observations when testing V11.50.UC4 (2 messages)
• more observations when testing V11.50.UC4
• Personal Data Guardianship Code -- OT?
• Cannot drop database in IDS 11.50.FC4
• CREATE DBSPACE SQL Admin API Command - need help (2 messages)
• RE: 11.50.xC4 Compression with workgroup edition?
• /proc/sys/vm/min_free_bytes
• Re: 11.50.xC4 Compression with workgroup edition?
• Reducing logical log space
• Re: Interesting ontape command for IDS10 and 11 users
• Informix --> SolidDB with Cognos 8 / Report-Net
• 2 gig file limit on solaris 2.7 IDS 7.3 ontape?
• Format integer to "00" in store procedure
• Re: Checkpoint durations
• Re: Checkpoint durations
• Weird one
• When to use ANSI-compliant database
• get last 4 digits of an integer
• Row Count
• Informix external directives ?
• ontape -s -L 0 performance on Win2k3_x64
• TPS
• Re: WingZ 1989 World Tour - any info?
• update statistics at the same time
• VMWARE and Informix Databases
• SEQUENTIAL SCANS
• IDS 10.0
• Timestamps into a TRACE logfile - current time in stored procedures
• Suppressing Column on SELECT
• Re: Numbering of primary keys in sorted order
• Re: Out of Box Experience for Cheetah. (2 messages)
• Numbering of promary keys in sorted order
• Re: Update Statistics Guidelines
• Re: temp tables and serial columns
• Re: HPL vs. Select Into
• Improving efficiency on char column searches
• How to migrate date from another machine?
• Re: Another IDS Feature Request
• Re: Enough of the "DB2" thread, let's talk about Fragmented Tables
• Re: IDS 10 disk configuration
• Re: IDS 10 disk configuration
• Re: ra_pages and io rate (3 messages)
• Re: Measurements: (was: Raw vs. Cooked files)
• IBM Informix HA Agent for SUN Cluster
• Re: HPLoader Configuration
• Re: Update Statistics
• Re: Raw vs. Cooked files
• Re: large chunks
• large chunks
• RE: large chunks
• Re: large chunks
• Re: Onstat -g ses only for DBSA?
• RE: Onstat -g ses only for DBSA?
• Oracle to Informix migration
• Re: Delete Only 50 rows from table
• Re: Delete Only 50 rows from table
• Re: Informix Performance Issues
• Re: Informix Performance Issues
• RE: Considering the Upper Limit on Extents
• Re: Considering the Upper Limit on Extents
• Re: Single cpu vp woe
• Re: Unloading to two destinations
• Washington Area Informix User Group meeting - January 27, 2005
• HP Loader problems !
• RE: When table extent was added
• Re: ER and inplace upgrade 7.31 to 9.40
• Re: script to rebuild dbspaces from onstat -d
• Re: Assert failed - memory block header corruption IDS 9.4UC2 Solaris 9
• vacation in Estonia :)
• Re: is there a way to disable a trigger or do I just have to drop?
• seeking opinion on using Veritas agent on AIX (IBM Unix) to do ontape backups
• need help with onstat -C & B-tree cleaning threads / IDS 9.40 (2 messages)
• Re: Problems faced during migration from Informix to oracle
• Re: Expanded chunk capacity mode in 9.40 (2 messages)
• Expanded chunk capacity mode in 9.40
• Why there is no controlfile in Informix like Oracle ?
• Corruption in old and unsupported v7 database ...
• Re: onbar -b -w
• Re: Testing backups ...
• Re: Testing backups ...
• Re: It's not funny any more!
• Re: MIME
• Configuration and usage of high performance loader in SAP
• port a sql server partitioning approach over to informix
• Re: Configuration and usage of high performance loader in SAP
• Re: Comment on my config
• Re: Informix in the SAN environment
• oninit processes are huge
• Re: ONCONFIG for 9.40 offered for comment
• Re: query performance tools
• Re: query performance tools
• Re: CREATE TABLE in volatile memory ?
• sorting dates in ksh
• Re: Long checkpoints on AIX/IDS7.31/IBM Shark
• Re: Performance advice
• Re: Performance advice
• Re: Informix
• Re: Incremental Archive performance issue......
• Re: Incremental Archive performance issue......
• Re: The old raw devices chestnut.
• ER: target loses inserts
• Re: Whatcha' wanta have?????
• Re: Which Linux?
• Re: dbexport to disk & 2GB limit question
• Re: ER and HA environment questions
• Re: IDS HPL features....
• Re: Whatcha' wanta have?????
• large disks
• Re: Problem loading data - 9.21.FC4 (2 messages)
• Re: ER performance
• Informix platform selection
• Re: Select the tablespace of the fragment containing the selected row
• Re: Problem loading data - 9.21.FC4
• Re: Onpladm create job.
• Onpladm create job.
• Re: Quarterly RAID5 Rant - enhanced
• onpladm load job with spec file (includes simple but lengthy test case)
• Re: Naming Convention for Informix Database Objects (2 messages)
• Re: Fw: Large Databases
• Re: 9.40 buggy!
• Re: ER problem HPUX - Linux
• Re: PDQ
• Re: High lngspins - IDS 9.30 UC2
• Re: Recommended BUFFERS Wont Work for import
• Re: High lngspins - IDS 9.30 UC2
• Re: Large delete
• Re: dbload +Steuerzeichen am Zeilenende
• Re: Using HPL for migration
• Re: Seeking Red Hat startup script or oninit/onmode exit codes...
• Re: daily migration of Informix 9.4 databases from AIX to RedHat
• daily migration of Informix 9.4 databases from AIX to RedHat
• Re: Tivoli (TSM) / Onbar Imported Restore, how to?
• Re: char to int conversion
• Informix under Linux - real crap !
• Re: Installation of Informix 9.30 on Linux RH 9.0
• Re: onbar's CPU usage
• Re: Disk Layout recommendation (2 messages)
• Re: ONTAPE backup on disk: limit of 2Gb
• Re: onbar's CPU usage
• Re: SuSE SLES 8: raw devices broken after kernel update?
• preserving sort order
• Informix 9.4: poll
• access tables in a db2 database
• Re: Online custom logging
• Re: Where to find dbselect()?
• stored procedures and informix crash (2 messages)
• Monolithic vs fragmented indices
• Logical logs full
• Good backup
• IDS 2000 SOFTWARE
• Re: IDS 2000 SOFTWARE
• Re: Problem with Long Checkpoints