Andrew HammBio

749 messages in this archive (231 questions asked, 518 answers given) — 2003-08-18 03:44:22 to 2011-10-27 05:45:47

Threads

• Relative grunt of Sunfire V490 vs. Dell R710 (4 messages)
• Case Insensitivity (6 messages)
• Keystroke recognition
• Re: Merry Xmas Pommy Bahstads
• Merry Xmas Pommy Bahstads
• dbimport feature/bug on 9.40HC3
• Datawarehousing with Informix
• Replication question... (2 messages)
• Comparative between DB2, Informix and Oracle
• Re: Comparative between DB2, Informix and Oracle
• Upgrade question to which the answer is probably RTFM but I can't be arsed
• Re: Upgrade question to which the answer is probably RTFM but I can't be arsed
• Re: Storing of Serial Number
• Re: Storing of Serial Number
• RE: test (2 messages)
• Re: Storing of Serial Number
• RE: Single cpu vp woe
• Re: Single cpu vp woe (2 messages)
• Re: test
• lvarchar manipulation
• Re: oops
• Re: oops
• Re: oops
• Re: oops
• Re: oops (2 messages)
• RE: oops
• Re: oops
• Re: oops
• Re: oops
• Re: Cannot find message file. Check INFORMIXDIR and DBLANG.
• Re: oops
• Cannot find message file. Check INFORMIXDIR and DBLANG. (2 messages)
• RE: oops (8 messages)
• Parameterized SQL "WHERE IN" clause?
• Re: Single cpu vp woe
• Runner C functions for TEXT and BYTE
• Re: Off Topic: Re: Informix Job Posting - UK Only
• Re: Fluffy FBI Philanthropes
• Re: DUAL table in Oracle
• DUAL table in Oracle (9 messages)
• Re: Is the C API for ER officially dead and buried?
• extents primer - what to wory about and when to worry?
• Is the C API for ER officially dead and buried?
• Re: Hidden message
• Re: OT:Is IBM going to be marketing Informix
• onmode -BC (5 messages)
• DBD::Informix 2003.04 and Perl 5.8.1
• Re: DBD::Informix Installation on Sun Solaris 2.8 Problem
• is it possible to use wait hint with cursor select?
• Re: dbimport 9.40 hates tables without owner names?
• RE: Expanded chunk capacity mode in 9.40
• Re: Anyone used WebSphere EGL to produce or compile existing 4GL?
• Re: Expanded chunk capacity mode in 9.40
• Re: Eleven FAQ's About comp.databases.informix and informix-list@iiug.org
• Re: dbimport 9.40 hates tables without owner names?
• Re: Expanded chunk capacity mode in 9.40
• Solaris 9 and KAIO (2 messages)
• Re: Expanded chunk capacity mode in 9.40
• Expanded chunk capacity mode in 9.40 (3 messages)
• Re: dbimport 9.40 hates tables without owner names?
• Re: dbimport 9.40 hates tables without owner names?
• Re: Why there is no controlfile in Informix like Oracle ?
• dbimport 9.40 hates tables without owner names? (5 messages)
• Why there is no controlfile in Informix like Oracle ? (2 messages)
• Re: Now I've seen it all
• Re: RSYNC & INFORMIX
• Re: RSYNC & INFORMIX
• Re: RSYNC & INFORMIX
• Re: Location of .4gi files (2 messages)
• Location of .4gi files
• Rootdbs full (2 messages)
• transactions et concurency
• To build better security
• High LRU writes on temporary dbspace
• Re: Logical logs from rootdbs to own logspace
• Re: Logical logs from rootdbs to own logspace
• Re: OT Re: Is it just me...
• Re: Logical logs from rootdbs to own logspace
• Unsupported or Supported
• Re: IDS BACKUP
• Re: Logical logs from rootdbs to own logspace (2 messages)
• Re: Logical logs from rootdbs to own logspace
• Unique Constraint Violation
• RE: [Maybe Spam] Re: Informix WGE with IBM DB2 Gold Bundle
• RE: Help with Transaction Log !! Urgent!!!
• Re: Logical logs from rootdbs to own logspace
• Re: Dropping views and dependencies - OUCH
• Help with Transaction Log !! Urgent!!! (2 messages)
• Dropping views and dependencies - OUCH
• Re: Mixing flavors of Informix
• Logical logs from rootdbs to own logspace
• Re: OT: Fourj's Genero
• How to analyse existing blobs (2 messages)
• Mixing flavors of Informix
• OT: Fourj's Genero
• Re: RE: Re: Bitwise operators in SQLs/4GLs (verification)]
• Re: RE: Re: Bitwise operators in SQLs/4GLs (verification)]
• Re: Lawson vs SAP, etc.
• Truncate on Informix
• Re: A Question about (CONSTRUCT in I4GL and ISQL) Perform
• Re: RE: Re: Bitwise operators in SQLs/4GLs (verification)]
• Re: OT - Re: Views question?
• Re: Re - new datablade announced for informix
• Re: Commentary on Coppereye from the UK Register
• Re: Re - new datablade announced for informix
• Re: Commentary on Coppereye from the UK Register
• Re: A Question about Perform
• Re: Views question?
• Re: ONCONFIG for 9.40 offered for comment
• Re: Views question?
• Re: Views question?
• Re: Views question?
• Re: Views question?
• Re: Database replication with 9.4
• Database replication with 9.4
• Re: database market share 2003 (5 messages)
• Re: Views question? (4 messages)
• Re: ONCONFIG for 9.40 offered for comment
• PDQ memory / non-PDQ memory
• Re: ONCONFIG for 9.40 offered for comment
• Re: ONCONFIG for 9.40 offered for comment
• ONCONFIG for 9.40 offered for comment
• Re: database market share 2003 (2 messages)
• Re: OnConfig parameters tuning (2 messages)
• Re: How to change number of logical log files ?
• Re: Informix tool related question
• Re: thank you IBM (3 messages)
• Re: database market share 2003
• Re: database market share 2003
• Re: thank you IBM
• RE: thank you IBM
• Re: OnConfig parameters tuning
• Re: database market share 2003
• Re: database market share 2003
• Re: database market share 2003
• Re: re: (ad nauseam) re: database market share 2003
• Re: database market share 2003
• RE: database market share 2003
• RE: database market share 2003
• Re: database market share 2003 (5 messages)
• My aplogies...
• Re: database market share 2003
• libcurses problem (2 messages)
• Re: DB2 Magazine
• Re: database market share 2003
• Re: 4GL and Linux
• Re: database market share 2003
• 4GL and Linux
• Re: DBD::Informix
• Re: Writing to disk or server cache?
• Re: database market share 2003
• Re: database market share 2003 (3 messages)
• Re: database market share 2003
• Re: DB2 Magazine
• Re: 4Js question (2 messages)
• Re: What do you use for VCS control
• Re: row-level locking bug?
• Re: sorting dates in ksh
• sorting dates in ksh
• Re: admin: can this disgusting stuff be deleted?
• Re: admin: can this disgusting stuff be deleted?
• admin: can this disgusting stuff be deleted? (2 messages)
• Re: Primary key, Foreign key and indexes in Informix
• RE: Primary key, Foreign key and indexes in Informix
• Primary key, Foreign key and indexes in Informix
• BUFFERS! Arghhh!!! Please help before I do something silly!
• Re: Unattended ontape
• Re: Performance advice
• Re: Performance advice
• RE: Are rowids always in increasing order?
• RE: Are rowids always in increasing order?
• Re: high buffer wait ratio
• Re: Performance advice (2 messages)
• Re: Performance advice
• Re: Performance advice
• Re: Performance advice
• Re: Performance advice
• Re: Performance advice
• Re: Semi-Annual NoRAID5 rant
• Re: Performance advice
• Re: Unattended ontape
• Re: high buffer wait ratio
• Re: Unattended ontape
• Re: Performance advice (3 messages)
• Re: high buffer wait ratio
• Re: SP, Is this you? (was: Creating a view with subscripting)
• I added memory - now what should I change in onconfig to take advantage of it?
• Re: Informix
• Re: Unattended ontape
• high buffer wait ratio (2 messages)
• SP, Is this you? (was: Creating a view with subscripting)
• Re: How long a future? (was: An interesting meeting with IBM)
• Re: An interesting meeting with IBM
• Re: How long a future? (was: An interesting meeting with IBM)
• Re: ontape vs onbar
• Re: ontape vs onbar
• Re: The old raw devices chestnut.
• RE: The old raw devices chestnut.
• Re: The old raw devices chestnut.
• Re: The old raw devices chestnut. (2 messages)
• Re: The old raw devices chestnut. (3 messages)
• Re: How long a future? (was: An interesting meeting with IBM)
• Re: An interesting meeting with IBM
• Re: An interesting meeting with IBM
• Re: An interesting meeting with IBM
• Re: 4GL standards? (was: An interesting meeting with IBM)
• Re: ontape vs onbar
• Re: oninit process
• Re: An interesting meeting with IBM
• Re: An interesting meeting with IBM (2 messages)
• 4GL standards? (was: An interesting meeting with IBM)
• Re: An interesting meeting with IBM
• Re: An interesting meeting with IBM
• Re: An interesting meeting with IBM
• An interesting meeting with IBM (2 messages)
• Re: Can't get evaluation version of Informix - THIS IS CRAP AND OUT OF ORDER
• Re: Article about supposed "murky" future for Oracle]
• Re: 4J's
• Informix to Oracle migration (5 messages)
• Description of ROWID
• [off-topic] Truly awful!
• Re: Informix to Oracle migration
• Re: ontape to a tapedrive on a different server
• Re: Whatcha' wanta have?????
• Re: Which Linux?
• RE: Whatcha' wanta have?????
• Re: Whatcha' wanta have?????
• RE: Whatcha' wanta have?????
• Re: Whatcha' wanta have?????
• Re: IDS 7.31 and (no) new features (was: Functional indexes (was: Whatcha...))
• Re: Whatcha' wanta have????? (2 messages)
• Re: Whatcha' wanta have????? (2 messages)
• Re: Informix and Linux opinions/who is running production
• Re: Do I have to have an Informix Database?
• Re: Whatcha' wanta have?????
• Which Linux?
• Re: Whatcha' wanta have?????
• Re: Whatcha' wanta have?????
• Re: Whatcha' wanta have?????
• Re: Whatcha' wanta have?????
• Re: Whatcha' wanta have?????
• Re: Whatcha' wanta have?????
• Re: Whatcha' wanta have?????
• Re: Whatcha' wanta have?????
• RE: Whatcha' wanta have?????
• Re: Informix and Linux opinions/who is running production
• Re: Re: Informix and Linux opinions/who is running production
• Re: Whatcha' wanta have?????
• Re: Informix and Linux opinions/who is running production
• Re: Informix and Linux opinions/who is running production
• Re: is it ok to use KAIO on HP-UX
• Re: THAT subject (was: Whatcha' wanta have?????)
• Re: Informix and Linux opinions/who is running production
• RE: is it ok to use KAIO on HP-UX
• Re: Whatcha' wanta have????? (2 messages)
• Re: Whatcha' wanta have?????
• Re: is it ok to use KAIO on HP-UX
• Re: Whatcha' wanta have????? (3 messages)
• Re: Whatcha' wanta have?????
• Re: Whatcha' wanta have?????
• Re: Whatcha' wanta have?????
• Re: Whatcha' wanta have?????
• Re: Technical architect / Lead - Openings..!!! (2 messages)
• Re: Whatcha' wanta have?????
• RE: Whatcha' wanta have?????
• Re: Reg. Emergency log backup during restore.....
• Re: Pentium 4 hyperthreading
• Re: Pentium 4 hyperthreading
• Re: Was: Pocket PC + Informix Now: Off Topic, as an old man reminisces ....
• [OT] Have you seen any of these? (2 messages)
• Re: CDR27 warning message in a transaction for a 2 way replication table
• Re: CDR27 warning message in a transaction for a 2 way replication table
• Re: Pocket PC + Informix
• Re: Pocket PC + Informix
• CDR27 warning message in a transaction for a 2 way replication table
• Re: Changing hostname / IP address (4 messages)
• Re: Changing hostname / IP address
• Database replication: Conflict resolution for very large tables
• Re: hi Cant load informix online 5.2 on linux -8 ( rpm file)
• Re: dbimport - memory fault
• Please ignore test
• Re: Query Optimization ... Is this all I can get??
• Re: 4GL array question
• Re: 4GL array question (4 messages)
• RE: Storing photos - I'm looking for advice.
• Re: 4GL array question
• Re: Puzzling performance issue?
• Naming Convention for Informix Database Objects
• RE: Storing photos - I'm looking for advice.
• Workgroup Edition or Enterprise
• Puzzling performance issue?
• Re: serial jumps
• serial jumps
• Re: IBM Data Management Technical Conference, Las Vegas, w/c 26th October
• Re: Progress
• Re: Progress
• Re: Oracle V Informix (2 messages)
• Select question (2 messages)
• Re: Progress
• Re: Progress
• Oracle V Informix
• Re: Progress
• Re: Question about permissions used on onconfig and sqlhosts files
• Re: Progress
• Re: Progress
• Re: Progress (2 messages)
• Re: Statistics for comp.databases.informix
• What is an Informix license ???
• Re: Progress
• Re: Question about permissions used on onconfig and sqlhosts files
• Re: Question about permissions used on onconfig and sqlhosts files
• Re: Question about permissions used on onconfig and sqlhosts files
• Re: Can you have the same table in two SE databases?
• Can you have the same table in two SE databases?
• Re: HOT Job Opportunity in Dallas!
• Re: Question about permissions used on onconfig and sqlhosts files
• Re: Question about permissions used on onconfig and sqlhosts files
• Re: Question about permissions used on onconfig and sqlhosts files
• Re: Question about permissions used on onconfig and sqlhosts files
• Re: Re: SQL Server Yukon]
• Optimizer plan for a running 4ge
• Re: HOT Job Opportunity in Dallas!
• Re: Question about permissions used on onconfig and sqlhosts files
• Re: Problem Determination Mastery tutorials - here's the scoop...
• Re: Problem Determination Mastery tutorials are now available for
• Re: Problem Determination Mastery tutorials are now available for
• Re: PDQ
• Re: High lngspins - IDS 9.30 UC2
• Re: Any HP-UX 11i users want to advise?
• oncheck -me
• Re: High lngspins - IDS 9.30 UC2 (2 messages)
• Re: Explain Plan for queries
• Re: 4GL V7.31 placeholder problem?
• Re: Server session stats
• Re: 4GL V7.31 placeholder problem?
• Re: Fw: Company thought DB2 will be better than Oracle.
• Re: Company thought DB2 will be better than Oracle.
• Re: Is it only me getting all these viruses ?
• How to stop this virus spam going around now
• Re: Is it only me getting all these viruses ?
• Re: informix alter table with syntax error in unix
• Re: Company thought DB2 will be better than Oracle.
• Re: Company thought DB2 will be better than Oracle.
• OT - Windows update virus
• Re: Raw or Buffered device?
• Re: FW: Check out this modified PC case
• Re: I4GL V7.30 and up - undocumented reserved words
• RE: Company thought DB2 will be better than Oracle.
• Re: Using ontape when the server is up ?
• Re: Fw: Company thought DB2 will be better than Oracle.
• Re: Fw: Company thought DB2 will be better than Oracle.
• Re: Company thought DB2 will be better than Oracle.
• Re: Company thought DB2 will be better than Oracle.
• Re: Using ontape when the server is up ?
• Re: Seeking Red Hat startup script or oninit/onmode exit codes...
• Re: Seeking Red Hat startup script or oninit/onmode exit codes...
• Re: Crying Wolf - was Re: Clarification please
• Clarification on SBSPACES
• Clarification please
• Re: oracle cache fusion against informix XPS?
• Re: Informix and Lawson Software
• Re: oracle cache fusion against informix XPS?
• Re: oracle cache fusion against informix XPS?
• Re: oracle cache fusion against informix XPS?
• Re: order by view
• Re: I can't believe this is a bug
• order by view
• News Server down
• Re: Tetra and Update Statistics
• Re: daily migration of Informix 9.4 databases from AIX to RedHat
• daily migration of Informix 9.4 databases from AIX to RedHat
• Re: Tetra and Update Statistics
• Re: Tetra and Update Statistics
• Re: Need Explanation
• ALTER FRAGMENT goes walkabout
• Re: Tetra and Update Statistics
• Re: Need Explanation
• Enterprise Replication - Primary Key
• Re: Informix and Lawson Software
• Re: Informix and Lawson Software
• Re: Informix and Lawson Software
• Re: Informix and Lawson Software
• Re: Informix and Lawson Software
• Re: Informix and Lawson Software
• Re: ORACLE RAC CRASHES ORBITZ
• Re: Informix and Lawson Software
• Re: waiting for log buffer??
• massive deadlocks after upgrade from 7.3 to 9.4
• Re: 4J's (2 messages)
• Re: INTERVAL FUNCTION
• Re: Alarm program on IDS9.30UC1
• 4J's
• Alarm program on IDS9.30UC1 (2 messages)
• Re: Alarm program on IDS9.30UC1
• RE: performance problems due to lock waits?
• Re: My first time...
• Re: Serial Update error
• Re: index duplicates PK, is it redundant?
• Serial Update error
• index duplicates PK, is it redundant?
• book
• RE: book
• Re: Configuration problem with Four J's
• replication
• Re: rowid
• interesting problem
• RE: omni-directional cascading Enterprise Replication
• Re: 4GL Help
• Re: please revive project 4GL++, using 4gl for Windows and New Era
• Side Effects of Setting Tables Memory Resident
• I NEED A TOOL FOR Database Management
• large chkpoints with update program running
• error 710 - help - help -help
• RE: raw device on IDE hard disk on RedHat Linux?
• Linux "terminal" for 4GL (6 messages)
• raw device on IDE hard disk on RedHat Linux? (3 messages)
• Replication Vs Mirroring
• Informix 4gl Version 7.30: INPUT ARRAY
• RE: SHMBASE Address - From Gigi
• Development Tools (3 messages)
• dbload - memory fault
• Table locking problem.
• Numbers of Locks
• Blocked Check points during onload
• msg during start up of memory and shmem
• Rowids: How do younow when the associated record is actually available???
• Using MATCHES or LIKE on non-character columns ?
• RE: Informix free
• RE: Diff between 9.21.UC3-1 and 9.21.HC3-1 (2 messages)
• multiuser application(please help)
• I4GL 7.30 HC5 problem using comments (2 messages)
• Number of LOCKS
• Any good informix periodicals/magazines/online ezines? (2 messages)
• Construct with Array?? (4 messages)
• Re: unloading a table more efficiently...
• Actual free space by Chunk/dbspaces (2 messages)
• multiuser application(please help)
• Re: loading a table more efficiently...
• Preferred Front-end Tools
• Migration from File Sys. to Raw Dev. storage mode
• which logical device = standard output?
• Re: HOORAY!! Art's Back!
• Re: drop empty dbspace & primary chunk
• HOORAY!! Art's Back!
• Re: Locking problem ... again
• Re: Taking a serial number?
• Multiple UPDATE statements in 1 file. How Do I do it? (2 messages)
• Re: Monolithic vs fragmented indices
• Unable to attach to shared memory (2 messages)
• Unload float with zero value
• Informix training manuals (3 messages)
• Locking problem ... again
• INPUT ARRAY questions (2 messages)
• Re: Informix training manuals
• Grant Permissions and Update Statistics for Procedures
• Different result between COUNT(*) & DECLARE
• RE: query,updates,iso. levels-Oracle
• Re: Listener threads and CPU VP imbalance
• Re: 4gl CURSOR Error 469 (2 messages)
• RE: number of extents
• Re: number of extents (2 messages)
• RE: SQL ... END SQL (was: Using directives within Informix 4GL)
• Re: force engine to use indexes
• Re: Using directives within Informix 4GL (2 messages)
• Re: DISK ARRAY (3 messages)
• Re: DATA TYPE QUESTION
• RE: number of extents
• Could not do a physical-order read to fetch next row
• force engine to use indexes
• dbexport question?
• Using variable as table name in a stored procedure ?
• create views
• FW: aio vp confusion again
• why login as root while installing informix 7.x
• Temp dbspaces in RAM
• RE: aio vp confusion again (2 messages)
• Informix SQL - How to place a condition on COUNT( DISTINCT) (2 messages)
• Re: aio vp confusion again
• How to trouble shoot DEADLOCK ? (2 messages)
• RE: Compiling 4GL on Linux SUSE 6.4
• Question about instance "hanging"
• Listener threads and CPU VP imbalance
• Re: killing a process
• killing a process (3 messages)
• DISK ARRAY (2 messages)
• DBSPACETEMP
• Multiple instances of Informix
• Problems with ISA 1.20 and building runners
• Re: EMERGENCY: Logs attached
• EMERGENCY: Logs attached
• sequences (3 messages)
• Monolithic vs fragmented indices
• SET LOG question
• Informix Statistic
• Re: chunk transplant (2 messages)
• Compiling 4GL on Linux SUSE 6.4
• Ontape query
• Deadlock problem...
• Re: Altering large table
• Exclusive access to engine in multi-user state (2 messages)
• chunk transplant (2 messages)
• a question about sysindexes
• Increasing file descriptor for Informix with Linux
• Index on DateTime Field (2 messages)
• Altering large table
• Dbexport/Import NT to solaris
• 9.21 Peer Installation
• TOP Process (3 messages)
• Re: No primary keys
• Check this out
• 4GL length() core dumping in 7.30.UC5
• Question about promotable locks
• No primary keys (2 messages)
• RE: No primary keys
• Serial Column
• How to end a user session...
• Re: UPDATE STATISTICS Question (2 messages)
• Re: No primary keys
• RE: No primary keys
• Re: No primary keys (2 messages)
• ROWIDs ??? (2 messages)
• Re: No primary keys
• RE: Which RAID to use?
• RE: ROWIDs ???
• problem with lock of a record (5 messages)
• fgl_start and customized runner (2 messages)
• How Does IDS Handle Dead Connections?
• Re: 4GL Question
• Solid lines on hard copy
• Getting exclusive access to a database
• Re: Can't add new chunk
• Turn Transaction Logging OFF (3 messages)
• Re: 7.31 performance problem (2 messages)
• Yet another DBEXPORT question.
• Can't add new chunk
• Re: load a table with some null lines
• WHAT DO YOU THINK
• trigger/stored procedure cancelling action?
• 4GL Question
• Re: Fwd: Identifying numeric string in a 4gl program
• Re: 4gl and NULL integers with 7.30.UC1 (2 messages)
• NFS storage for DBSpaces?
• Re: Fwd: Identifying numeric string in a 4gl program
• 4gl and NULL integers with 7.30.UC1
• Re: Page cleaners and raids
• Re: CLEANERS (3 messages)
• Re: INSERT INTO ... UNION - unsupported!?
• Re: DBSPACETEMP Problem.
• Re: INITIALIZE vs LET
• Re: Page cleaners and raids
• Page cleaners and raids (2 messages)
• TEMP table info from systables
• temporary space - doesn't scale?
• Re: INSERT INTO ... UNION - unsupported!?
• RE: Recovering data from a raw device.... (3 messages)
• RE: Recovering data from a raw device....
• Re: Isolation Level (2 messages)
• Privileges on views
• Managing large log tapes
• System wide unique keys, use a 16 byte character or 4 4 byte integers.
• RE: CLEANERS (5 messages)
• Re: CLEANERS
• blanks to null
• Test
• CLEANERS (3 messages)
• Update Stats
• Re: CLEANERS (2 messages)
• Data migration
• oninit -s at statup?
• Database in Redhat Linux
• SUBSTRING usage
• Dangers of dropping foreign key constraints? (3 messages)
• Re: Baffled by SQL - again :-))
• RE: Char and Varchar
• Are temporary tables cached during writing?
• Translating SPL to Java
• Char and Varchar
• RE: Best platform for Informix?
• Re: Database Optimiser Cost Calculation : Suggestion for formula
• Re: Whence cometh these log backups? (2 messages)
• Installing 2 different 4gl versions
• Need help on a trigger or how to overlay a table field
• Store Procedure Variables