Search results for query: *

Hi all. System has been rebooted in a while and its sitting at 82% utilized paging space (lsps -a). I shouyld be able to reboot it this weekend, but I am still juggling...what will happen if I dont reboot before it gets up to 95-100%?

If only you could harness your super powers for the purposes of good.

Can someone help me with probably a dumb question. I have a big texy file, like 800,000 lines, and I want to count the number of pipes ("|") in the file. Seems like a no brainer, but when I sat down to do it I just totally brain farted and cant figure out how.

Hey yall. I got a batch process that loads about a million records from one table into five other tables. It uses prepared cursors to do the select intos by the way. Well, we see that this job runs like a dog during the business day but after hours and on weekends it flys like no get out! On...

Hi all. Someone here noticed that if you try to get the current time in a stored procedure, the routine only returns the time when that SP started...trying to add time stamps in different parts of an SP and running into this. Any suggestions?

I would like to be able to run a query and ignore an index that is in place on the table being used...is there some trick with SQL or a way to do this? I am just doing some time tests, with indexs versus without.

Sweet - Are you a moderator here? I have noted the exceptional quality of your posts.

I havent! I am just sort of curious as to what would happen... One time when I was little I stuck my tongue in an empty light bulb socket out of curiousity, so I think this question must be along those lines.

Hello mjldba, Can you fill me in on why you went with seperating your indices from there tables? I have been considering trying this to improve peformance on at least one VERY HUGE table but I have been a little nervous and I wonder how I might gauge the return if any?

Anyone ever see error "mgm_reinit:reinit already active.

What happens when I do the following: 1. disable index on table x 2. insert 10000 records to table x 3. enable index on table x Does the database realize what I did and start some process to review the inserted data and incorporate it into the index? If not, is there a way to make it do so...

Thank you Mr. vpshriyan, thats just what I needed.

I have read several different descriptions of how I should be (or shouldnt be) using the AIO VPs with informix. I am running a version of unix that supports KAIO and I do have it turned but I also have 3 AIO VPs running. Whats the proper way to do this? Running 9.40.