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 Wanet Telecoms Ltd 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: byrdfarmer
  • Content: Threads
  • Order by date
  1. byrdfarmer

    what if paging space hits %100?

    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%?
  2. byrdfarmer

    how to count a specific character in a file?

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

    dumb dumb question about insert performance

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

    get current time in stored procedure

    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?
  5. byrdfarmer

    how do I run a query and ignore an index?

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

    anyone ever specifiy a link to /dev/null as a chunk?

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

    change PDQ_MAXPRIORITY via ONMODE -D errors

    Anyone ever see error "mgm_reinit:reinit already active.
  8. byrdfarmer

    disable indexes during an insert to table

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

    AIO vs KAIO confusion

    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.

Part and Inventory Search

Back
Top