Recent content by noober

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 there a way to pass parameters/variables into a passthrough query?

Thanks guys! I have been working with access for a couple of years but I never realized what a "passthru query" was! Works great!

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...

Sounds like PHV has what I need, but I would love to see your example too mrmovie...sounds like your doing something clever.

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...

Hello hervedba, Appears to be on my test machine and hopefully I will not have any troub le this weekend when I upgrade one of my production servers. The ML2 did break my sendmail configuration for some reason and it took me awhile to figure out exactly why but now everything is a green light...

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.

Does it fail both ways between target and host2? For instance can you do an rsh from the target TO host2 but not from host2 TO the target? Also, does user account come into play at all...as in will it work when you are logged on as root where it fails for others? Or not work for root but does...

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