Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pengzhang
  • Content: Threads
  • Order by date
  1. pengzhang

    Could not get result if querying on an indexed column

    Hi there, I'm currently working on Informix 9.21TC5 on Windows 2000 machine. I have a program (written in E/SQL) to load all text files into a Informix database. I found several times that after re-loading, I could get the data output from SQLEditor if I do a full table scan like...
  2. pengzhang

    Is it a bug in IDS 9.4 TC2?

    Hi, I've tried the following script(in dbacess) on IDS 9.4 TC2 on two Windows 2000 machines, IDS server will be brought down (the same script works fine on IDS 9.21) Could someone try it for me on your environment? Thanks Peng --- Start of Informix testing scripts CREATE FUNCTION...
  3. pengzhang

    How to prevent IDS server from taking the whole CPU

    Hi, I'm running a IDS on a Windows 2000 machine with just one CPU. Sometimes I found that oninit took 95+% CPU and caused other application failure. Is there a way to configure Informix so that it would not take too much CPU resource. Thanks Peng
  4. pengzhang

    Informix is hung after one day or so

    Hi there, Have you guys seen the following problem before? Environment: Informix 9.21 TC5 is installed on Windows 2000 SP3 and a third party tool is installed on the same machine which has nothing with Informix but it may use ODBC. Both service is running. All test were done on the same...
  5. pengzhang

    My Informix server seemed hung there, can someone help me

    Hi there, After some load test, my Informix server seemed hung there. I checked the Informix log, didn't seem to see anything wrong; and I checked the locks and no deadlock. The following is some output from onstat command, seemed to me that some user threads are waiting for a condition, but...
  6. pengzhang

    General exception error has occurred in the optimizer

    Hi there, I just run a complicated SQL from SQL editor. And I got the following error message: [Informix][Dynamic Server 2000][rrrpdb] SQL Error (-874): General exception error has occurred in the optimizer. But the strange thing is that I ran the same query against other servers with the same...
  7. pengzhang

    Could someone help me with "Load a file into database error"?

    Hi There, I'm a late comer with the informix adminstrator. One of my customer encountered an error when loading a flatfile into a table. The error message is as follows: load from 'e:\temp\accountinfo.txt' insert into accountinfo; -- [Informix][Dynamic Server 2000][rrrpdb] SQL Error (-847) ...
  8. pengzhang

    Write a command script to be run by SQL Editor

    Hi There, Can I write a command script file run by SQL Editor or something else and the script is smart enough to detect if a table or database object exists before it creates the object. I can do it in SQL Server where I can use "if exists (...)". But can I do it in Informix? Thanks
  9. pengzhang

    Can I use "Load" statement in E/SQL

    Hi There, I can use "Load" statement in SQLEditor, but when I tried to use "Load" statement in a E/SQL program, I have some problmes. Does anybody know how (if) I could do this? Basically, I'm trying to write a program to do automatically and periodly data flushing and...
  10. pengzhang

    Does anybody know some tools to analyze SQL code against the schema?

    Hi Guys, I'm looking for tools for Informix (or some general tools for all databases) to analyze SQL code against the schema to see if there are some performance issues? Thanks
  11. pengzhang

    How do I know in which dbspace log files are

    I want to find out in an existing informix setup the location of logical log files. Can I use onstat or something else? Thanks
  12. pengzhang

    Question with OLTP and DSS applications at the same time

    Hi Guys, Currenly we have an environment which needs both OLTP and DSS applications at the same time. I tried to build two databases to server for them. And I was using load/unload timely replicate data from realtime database to statistic database. Since the two databases were on the same...

Part and Inventory Search

Back
Top