Search results for query: *

Hello. I want to do some CPU stress testing on my RS6000 (running Aix 5.2) and I was wondering if anyone had a simple script that I might be able to use to do so? I want to create a very heavy CPU load just for background noise during application testing. Anyone?

Hi all. We have a huge table tat we insert records from another huge table into and we have a START VIOLATIONS facility set up on the target table and I am wondering how this (if it does) affects our performance? Based on everyones experience, is this a major source of oevrhead? Just wondering...

Hello. I have a process that dumps from time to time due to a known bug in the way informix frees memory. This is usually not a big deal since this process has been dumping after hours and not really causing any harm and we know its going away with an upgrade. Well, recently this job started...

Does anyone know if when you select from a view its a "dirty read" by default? And if not, is there something that someone could have done to make a select dirty? Also, is there a parm I can pass in my SQL to make sure a read is not dirty?

Is it possible to run stored procedures in access? I would like to do so between access and an informix database.

Is it possible to run Informix stored procedures from MS - Access? Ugly I know...

Hi all. I have a secure IIS server that I also use as a FTP server on a network that is relatively secure and not connected to the world in any way. My question is, is it possible to execute arbitrary commands from a FTP session connected to this server? I have a shell script that puts some...

Okay, please do not tease the dummy (me)...but does the way a SQL statements criteria filters are ordered affect its performance? For instance if I have 100 client with a sales_tot > 10000 does this: select * from tbl_sales where client_code = "0100" and sales_tot > 10000 --run...

How do I run a macro or script on open for an excel document? Anyone remember this? I think MS stopped documenting the feature since Excel'97. What I am working on needs to be backwards compatible to at least Excel 97.

If I were to schedule a job to back up my logical logs like every 15 minutes, whats the downside to that?

I am wondering if there are any performance tools out there (3rd party, home grown, etc) for informix IDS? Something that can sample and report, maybe even make suggestions like sarcheck does for unix? All crazy ideas welcome!

Anyone have a ready made speradsheet or something that will take sar data and make it pretty and report worthy? I have looked at sarcheck, but I am not sure its doing anything thats worth the cost...anyone have opinions? Anyway, I was going to just pick apart a sar file and move the data into...

Hi all. I upgraded AIX from 4.3 to 5.2 over the weekend and I am seeing a performance slowdown all of a sudden. I also noticed in topas that my WAIT% appears to jump up to 90% a whole lot and i never noticed this before. Not sure where to go...help!?!

Good morning! Anyone know how I can use vbs to execute an OS command on a unix/aix machine and return the standard output (the command output) back to vbs - at which point I will display in a iexplorer page? I do this pretty easily with sql commands and database data and have lots of little vbs...

Can someone help me undferstand what this means?: TBLspace data check for tool:informix.filewarn WARNING: data page 0x1 in tablespace 0x2b00047 appears to be more or less full than is indicated in the bitmap. Bitmap mode: 0x4, Calculated mode: 0xc. Reset the bitmap mode for...

I upgraded both my operating system to AIX 5.2 and informix to 9.40 (doing both was requred by informix) and now my database will not start. The error message indiates that I should restart the previous (below) database and backup the logs, but I did back up the logs before the upgrades and...

Can someone post an example of how to use the informix stored procedure that allows you to execute an OS command -and- display the results? Say if I wanted to use dbaccess to execute ls -l in a stored procedure, I know thats kind of dumb but just a simple example, and I wanted to see the results...

I need to move a table (and its index) from one dbspace to another due to some size limitations in the original space. Luckily its a temp table, so I am thinking that the simplest solution is to schema the table out, drop it and rebuild it in the new dbspace. Am I shooting myself in the foot or...

The following query is VERY slow, anyone help optimize? SELECT support_requests.d_submit, support_requests.req_user, support_requests.priority, support_requests.proc_user, files.file_no, client.clnt_code, files.file_stat, groups.grp_no, support_requests.report_id...

Just wondering if informix had an analagous tool to MS-SQL servers query analyzer/optimizer that will suggest indexes, etc...