Rudy FernandesBio

550 messages in this archive (173 questions asked, 377 answers given) — 2001-01-31 16:54:01 to 2004-03-19 12:09:54

Threads

• Virtual Processors and CPU-Load
• Re: Questions...questions
• how to tune buffer allocated to index data?
• onunload/onload yields error 312
• Re: Migration IDS 7.31 to 9.40
• Re: Intermittent Performance Problem - What does oninit do?
• Char to Integer
• Re: Migration IDS 7.31 to 9.40
• Set Isolation
• LRU's and CLEANERS (IDS 9.21FC1)
• Migration of Chunk
• Informix, SQL Server or Oracle
• Question
• How I can determine if my CPU VPs are starved of CPU !
• incompatible database
• Text Search Taking Too Long
• Table Updates (2 messages)
• SIMPLE 4GL PROGRAM
• Re: Automation and dbaccess
• Restore problem
• Data migration
• Re: Informix Data Replication
• Exception XIX000:-271
• SIMPLE SQL STATEMENT
• RESEND WITH MORE INFO: simple 4gl programme
• explanation of "out of space"
• HDR problem ..Plase help...
• simple 4gl programme
• Basic Questions on sybase
• Cannot modify values of insert trigger (2 messages)
• pls help, mirror chunk down
• How to know which databases and tables created/deleted yesterday?
• Can we see what OUTER is doing boys & girls?
• Trigger doing UNLOAD to file OR calling Store Procedure doing the UNLOAD to file
• "Not implemented yet" error
• Re: Indexes efficiency
• Re: sysmaster: syschkio information
• Run SQL Statement with temp table from prompt
• ESQL: modify next SERIAL value
• JDBC Probem with SELECT
• -710 error (3 messages)
• Performance dive over time
• Logical recovery during startup takes long (2 messages)
• Relating OS processes to online users
• real-time monitoring of SQL commands?
• IDS 7.30 long transaction problem
• Re: Using a variable in SQL with an Update statement
• Paging w/o cursor or temp table?
• Error Bringing Online 7.31 Up - Please Help
• Layoffs at Informix
• logical log space
• Customer dropped important large table.... (2 messages)
• Insert Cursor in a Transaction
• Identically named instances, different hosts
• ontape and LTAPEDEV = /dev/null
• Which instanses are configured?
• Rownum in Informix/Oracle
• Re: Oracle/Informix admin.
• Request system...
• lock waitors entry in syslocks
• Insert performance is poor (2 messages)
• Connecting or querying an informix database during checkpoint by using an esql/c program
• DB disc usage
• Update Statistics: Tell me the truth
• help for a key for 7.3 trial version of IDS
• temp tables
• pooled connections and prepared statements (2 messages)
• SQL Syntax Problem: LIKE on a column with additional wildcard
• Last parsed SQL statement...
• Turning off constraint checking
• Problems about locks
• dbexport
• onbar -l hangs
• Informix initializing in Linux.
• Re: Detecting trigger or stored procedure execution from client side
• Converting to ANSI C++ : Problem (3 messages)
• kernel parameters
• Re: Function Isnumeric
• Re: NUMCPUVPS
• NUMCPUVPS
• Re: how to restore archive to 2 instances on same server
• Informix User Defined Exception
• Logical log restore (3 messages)
• Dynamic server DELETE performance problem
• Changes in onconfig files
• Backup using ontape
• Database initialisation
• order by
• Re: Application performance (3 messages)
• Session begin time
• Re: I/O bottleneck, bufwaits too high
• Is it possible to do an ALTER TABLE from a VARCHAR into TEXT fiel
• Migration tool MS SQL Server to Informix
• Hooks/Triggers in Informix.
• How to display the queries' header on top with IDS2000?
• Exclusive lock on table
• help with SQL
• Re: OLTP - 50 MIllion/ hour?
• RE: How many logical log is needed
• Modifying dbexport's schema file
• Logical logs on filesystem (VXFS)
• Rolling forward logical logs?
• Load Performance problems
• Re: demo1.ec
• Re: General concurrency question
• Sort table names and maintain referential integrity
• demo1.ec
• informix IDS7.31 crawling
• Triggers and Dynamic SQL...
• Crashes? Could it be this???
• HDR & Logical Logs and Network failure
• General concurrency question (2 messages)
• Date in ESQL/C
• Looks Like Informix Is Done
• Re: Read access to informix tables
• dbexport Error 452, loc_open() failed
• Better way to test if exist
• text field
• Read access to informix tables
• Re: SQL - Trigger
• SQL - Trigger
• Re: no remote access with dbaccess
• dbaccess question
• oninit -i error
• viewing Trigger code
• long transaction
• To mirror or not to mirror
• Re: Long Transaction
• Rebuilding Indexes and Recovering Space
• Sql statement on onstat -g ses command (2 messages)
• I have the error: "1210: Date could not be converted to month/day/year format"
• Removing a TEST Informix Instance
• Problem with SELECT, please help
• SELECT QUERY between 2 differend databases on the same server (2 messages)
• HDR on Informix
• Lock mode ...
• RE: onstat: Shared memory: permission denied???
• SERIAL wrap-around
• Prepared ESQL/C vs. Stored Procedures
• cursor in SPL
• SQL Question
• Level 0 Restore errors
• DBLOAD and DBDATE. Anything going on here?
• SP Insert cost to high?
• informix server 7.3 configure question?
• Level 0 Resotre problems
• Level - 0 Restore problems
• Initiating Checkpoints manually
• Fuzzy Operations : Some clarity from Informix
• Re: Charging for Informix usage
• Primary Keys vs Unique Index
• TEXT field in Blob Space vs Table Space
• 7.30 -> 9.20 Anyone remember this?
• Possible bug IDS 7.30.UC7 on HPUX
• Thanks and Goodbye!
• SQL With Effective Dates
• Re: problems with repeatable read - whole table is locked
• Re: problems with repeatable read - whole table is locked
• RE: Logical logs
• Stored Procedure with VB is very slow
• RE: Select count(*) problem
• Re: Record Locking
• How to generate view schemas?
• How Informix Stored LONG data type?
• Tables are Locking up !!!
• De-fragmenting a table
• Transaction Log
• Re: Informix 9.14 Boolean Bug
• Related Replication
• Re: Has anyone ever done this?
• Has anyone ever done this?
• Query tracer
• Intervals in ESQL
• Help! FILTERING WITH ERROR and START VIOLATIONS aren't working
• Problem when IDS 7.30 oninit
• Re: TBLSPACE_STATS parameter
• RE: Back to Fuzzy Checkpoints
• prepares in 9.2
• onunload/onload issue
• Oracle: DECODE function <==> Informix: ???? function
• Insert rows vs. dbload (2 messages)
• Informix shutdown abnormally
• Informix Error Message
• Connection goes down -1803
• Index columns
• dr on 9.20
• Connect db2 with informix
• CLI on Windows 2000
• Re: Performance of View vs. Table
• Fuzzy checkpoints. (3 messages)
• Index creation date
• Re: An Oracle question
• Why is this an SQL syntax error?
• Can I store every sql stmt executed whe using dbaccess?
• SQL stmt. for computing the size of a database
• TSS?!
• Having a problem with text field - any ideas ?
• Re: RE: Top Databases Used (Out of the office)
• Informix problem or OS problem?
• dbspace and table size
• RE: rebuilding indexes
• Estimating table access? (2 messages)
• Select on empty table return status
• Re: "load from" and stored procedures
• Strange system crash?
• informix username and password
• problem getting the last serial value
• Re: Something like DECODE( ) in Oracle...
• Re: Top Databases Used
• text datatype question
• SQL: counting and dates
• FW: Installing JDBC drivers on HP UX
• Problems with HD space
• Re: Better locks info
• Better locks info
• Re: "load from" and stored procedures
• Cannot retrieve return value from stored procedure via ODBC
• Re: char vs. varchar
• DBEXPORT Not Working fine
• read-only access
• HOW: Export Ifmx DB -- Use DB offline -- resync db Online ???
• Keep It Clean
• Detecting the existence of a temporary table
• import informix data in other database appl
• From uni to multi
• Informix 4GL SMALLINT variables
• score bands
• Number Generation
• IDS 7.3 - Transaction in Triggered action
• Locks - Significant Overhead?
• onstat -g Question
• Updating a Table by Comparing to another...please help
• Query in Indexes...
• Re: question in ErWin
• Informix loses data !
• SysProcPlan lock problem -211
• Very Simple Really
• FW: awk function question
• Assigning a Rank to table rows
• Question on Updating columns on insert trigger of table
• Re: Urgent - please help with update sql
• Long Transactions and table locking (2 messages)
• select where (a,b) in (select a,b)...
• "select having" problem
• Transaction within a Transaction
• Problems with an index on Informix Online 7.24 (2 messages)
• Sysptntab info needed (2 messages)
• stored procedure and a UNION join
• Locking while inserting new rows.
• Re: Long checkpoints with no obvious cause
• tape backup
• Re: Long Checkpoints (2 messages)
• Re: Long Checkpoints
• GRANT on VIEW
• RE: SQL advice please
• RE: question
• Crystal Reports Locking Tables
• DB CONNECT Question
• no index used (2 messages)
• Why sequential scan???
• Re: Exclusive Lock Problem: !!
• IDS 7.31.UC5 Error 244/143
• Re: Can We Do Sed-Style Regex in 4GL?
• Conditional statements in SQL
• ESQL/C and C++?? (2 messages)
• C++/ESQL/STL
• IDS replication Solaris->Linux
• puzzling problem with query
• tablespace:tablespace`
• Stored Procedure transactions through ODBC ( CLI 2.8 )
• Serials and Stored procedures
• Decreasing page read statistic
• Using relative path for dbspaces?
• onstat -k and tblsnum?
• SQL-Error 1263 while calculating date
• Re: Outer join / index loss - strange behaviour
• Re: Trial Version of Informix?
• Finding CPU hogs
• Collection types suck?
• HPL limitations
• Query Optimizer Weirdness in Stored Procedure
• Transactions & Auto Commits - Advice needed
• onstat -g con
• Convert 4GL-programs to work with databases in transaction
• ontape or on-archive question
• Archive spanning tapes...
• Re: Integer to String Evaluation in SQL Statement (2 messages)
• Raw vs Cooked space?
• Re: Triggers & SQL
• Exists Tupel Queries ?
• HDR Experiences
• SE7.2x reorganization question
• Text Blobs and LOCATE
• IDS 7.30: can this be done with a constraint?
• On-line vs Off-line Backups
• Who takes 99% of CPU
• onstat -u shows "blocked: LONGTXN"
• Can IDS controle who allows to import or export?
• KAIO: HP-UX 10.20 / IDS 7.24
• VB6/ADO/ClientSDK2.4 Record locking issue
• [Q] AD and XP Options? How to turn them on?
• 2xQ : index size
• Handling extra hours in Time Sheet
• btree unique keys
• SE7.23: select TRIM... in unload problem
• Row size in dbschema
• ISAM Error 154 and SQL Error 245 often
• SPL and Triggers on the same table ?
• PREPARE and single/double quotes. (2 messages)
• Receiving "Changing data structure forced command termination." from onstat!
• ignorance? database lookup times
• Trigger Help...
• fragment by expression question
• Primary Key and autonumber
• RE: Bufwaits and Foreground Writes
• Bufwaits and Foreground Writes
• Need some trigger help (2 messages)
• PREPARED inserts? (4 messages)
• restoring possibly damaged logs (2 messages)
• MS SQL statement translated into Informix
• DATE argument passed from ESQLC to SPL
• SQL - Getting null values from an outer select
• esql question/tuning?
• Re: 4gl run time error "has already been defined -1351"
• Useless stats (how to calculate the median)
• btree percentages at 95%
• Quickie backup to /dev/null
• SQL Puzzle
• The SQL-statementes behind dbaccess
• statistiques for tables : please help !
• A Data Modeling Challenge
• Database name from Stored Procedure.
• SQL CONNECT
• Stored Procedures and Parameters
• Database logging and OnBar
• Select ... like (subselect) - Possible?
• moving a database
• Re: Write cache help
• Database statistics tracking.
• Row locking problems.
• onstat -p shows dskreads, dskwrites greater than pagreads, pagwrites. How come?
• CREATE TABLE & INDEX in one transaction
• RE: Monitor Informix Longtx
• do this test for me please.
• Re: LOAD FROM... stmt is very slow
• Statistics on indeces used
• RE: SQL HELP
• select question
• logs needed for a transaction !!
• dbspace not empty
• Shutdown script for linux
• Re: move dbspace/chunks on NT
• How To Eliminate Headings To Stdout?
• Need SQL help
• Re: silent truncation of varchar data
• Re: moving tables
• Re: SQL performance problem (2 messages)
• Logical Log Configuration
• Re: oninit question
• Re: Security
• DOES INFORMIX SUPPORT TIMESTAMP CONSTANT
• Return Field Names from StoredProcedure
• string handling in 4GL
• SPL: random integer
• Re: 4GL Question (Either really easy or impossible, you decide) ;*)
• dbspace prior point in time recovery
• does reference improve access time ?
• Error in Infomix Log
• Smart upd_stats routine
• Another quetion...about function
• RE: Unloading a live database
• select minof two columns
• Online index usage in one table query
• automating the index reorganization
• Unloading Null Values, 0 length strings and spaces...
• Informix performance Issues (2 messages)
• Re: Raw vs. cooked
• Capturing SQL
• UPDATING TO NULL
• Re: Db-export/Db-Import
• Re: onstat -u
• Re[2]: Last day of month..
• Re[2]: SET EXPLAIN / SQL
• Re: onload performance
• Re: Need of kill query
• Re[2]: Problem with "Changing data structure forced command
• Re: IBM AIX Kernel parameter limitations [HP issues]
• Re: drop table/procedure/...
• Re: Can I force Accept key thru i4gl?
• Re: date manip. prob with AIX & OnLine 5.05.UC6
• Re: Restore to test env
• Re: Set explain utility
• Re: Set explain utility
• Re: Certified Pro Worldwide (was:INFORMIX WISH LIST)
• Re: ACE report advice?
• RE: logical log cannot be freed
• Re: Shared Virtual Memory Usage Question
• Re: logical log cannot be freed
• Re: How to limit number of rows
• Re: Move from 5.01 to 7.21 4gl problem
• Re: Informix Bug or valid SQL?
• Re: logical and physical size
• Re: Archive
• Re: Removing duplicates from unique
• Re: About UPDATE triggers...
• Re: sql question for purge routine
• Re: How to kill a long transaction?
• Re: Syntax error? What syntax error??
• Re: Standards/reasonable programming practices
• Re: sql question for purge routine
• Re: license and user count
• Re: Syntax error? What syntax error??
• Re: Please Advice
• Re: log file in SE
• Re: license and user count
• Re: bufwaits
• Re: Force index usage
• Re: license and user count
• RE: Force index usage
• Re: ovlock=56
• Re: license and user count
• Re: Pesky informational messages in dbaccess
• Re: oninit -r
• Re: 4gl Input array question?
• Re: Closing OnLine session (2)
• Closing OnLine session (2)
• Re: Creating Views on Multiple Identical Tables
• Re: 4GL 4.0 Updating Fields
• Re: Creating Views on Multiple Identical Tables
• Re: How to restore data from tape
• RE: Spooling all SQL Statements
• Re: Help Loading table from flat file.
• Re: Closing OnLine session
• Re: Multitable select with two seperate search criteria.
• Re: Closing OnLine session
• Re: Upgrade from 5 to 7
• Re: Informix running on Linux
• Re: Permenant Recovery
• Re: Resizing Logical Logs
• Re: Why a long transaction cannot rollback?? (2)
• Re: challenging sql question
• Re: optimizing the sequence of index fields
• Re: DISPLAY Time in a 4GL program
• Re: Input --- for the "Why Not?" Dept.
• Re: Informix equivalent of savepoint
• Re: Why a long transaction cannot rollback?? (2)
• Re: Q: What instances have I?
• Re: Why a long transaction cannot rollback?? (2)
• Re: Q: What instances have I?
• Re: Why a long transaction cannot rollback?? (2)
• Re: Why a long transaction cannot rollback?? (2)
• Re: delete based on multipart key. It is possible.
• Re: Why a long transaction cannot rollback?? (2)
• Re: 4GL Input array
• Re: Cascade Deletes not working!!!
• Re: Can't compile .per
• Re: Why long transaction cannot rollback?????
• Re: delete based on multipart key
• Re: 7.22.UC1X2 Performance tuning questions....
• Re: delete based on multipart key
• Re: Freed logical log files Online 7.13 UC3
• Re: Freed logical log files Online 7.13 UC3
• Re: delete based on multipart key
• Re: ontape -c
• Re: ontape failure for DS 7.14.U
• Re: logical log tape reuse
• Re: dbschema and dbexport now outputs "contraint ..." syntax
• Re: Reliability of Informix on DEC Alpha
• Re: Q: FROM clause of SELECT statement?
• Re: Update Statistics
• Re: onmode and system shutdown
• Re: Large Delete Problem
• Re: OnLine 7.13 performance problems - comments please?
• Re: Enviromment Variable (DBESQWT)
• Re: Update Statistics
• Re: 7.22 onstat -u flags
• Re: ISQL Begin Work & Commit Work
• Re: Shutdown a instance from time to time ???
• Re: Shutdown a instance from time to time ???
• Re: On-Line 7 Performance
• Re: Recovery Strategies
• Re: User privilege
• Re: how do i exit pop up window without escaping
• Re: Quick SE-type question..anyone?
• Re: Re. Indexes
• Re: Optimizing Select count distinct statement
• Re: Varchar bug
• Varchar bug
• 4GL Version 6.x : Bugs, or just worms?
• Re: Using dbexport
• Re: ONLINE 7.2 tuned to simulate SE x.x
• Re: datetime - datetime = interval but it is always null
• ONLINE 7.2 tuned to simulate SE x.x
• Re: datetime - datetime = interval but it is always null
• Using 6.x tools with 5.x SE
• Re: avoiding huge globals files
• Re: Process Priority, How ?
• Re: 4gl: Week Ending Queyr
• Re: ** Standard Engine disaster, please help !! **
• Re: avoiding huge globals files
• Re: 4gl RUN statement. No sweat
• Re: Four easy ones
• Re: Subtotals in REPORT...
• Re: SQL question
• Re: Date calculation functions : Informix bug?
• Re: Help: update record if existed, else insert it
• Re: 4GL - Database Names
• Re: ESQL problems in migration from ON-LINE to SE
• Re: UNIX Scripts Run In Cron
• Re: UNIX Scripts Run In Cron
• Re: Screen problems ?
• Re: Code to Save & Recreate Indexes
• Re: Code to Save & Recreate Indexes
• Re: Code to Save & Recreate Indexes