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!

  • Congratulations strongm 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: *

  1. peterneve

    Uptime lying? Phantom reboot?

    Actually doing some more digging around this appears to be a Red Hat bug: https://bugzilla.redhat.com/show_bug.cgi?id=97373 I guess a kernel upgrade is in order!
  2. peterneve

    Uptime lying? Phantom reboot?

    I've just had a server which did something a bit strange. The monitoring software flagged it as down, but when I logged in, all of the proccesses were up still. The server didn't reboot, but the uptime utility shows about 30 minutes. There is an empty boot log and many linux processes have been...
  3. peterneve

    Using a value in the data base as a variable.

    Hi Dave, Thanks very much, your code worked a treat and is alot neater than mine. I didnt understand the Union command, but have just looked it up on the web and its cool :) thanks again, Pete
  4. peterneve

    Using a value in the data base as a variable.

    Hi Mufasa, thanks for the prompt reply. I am trying to use existing data in the table. sorry my explanation was a bit naff. i want to add another frequency, 4. once the query is run this is how i want the table to look, the table name is "all_freqs". FREQ OTHER_FREQ 1 2 1...
  5. peterneve

    Using a value in the data base as a variable.

    Hi All, I have posted a couple of times but in the wrong forum so hopefully its 3rd time lucky!! I have an oracle 8i database that i would like to query and update. There is a table which contains three frequencies which also reference the other frequncies and other arbitrary data. FREQ...
  6. peterneve

    32bit compatibilty on 64bit whitebox linux

    Hi All, I am trying to find an rpm that will give 32 bit compatibilty to my 64bit whitebox Linux. On the vmware website it said for Debian or Ubuntu OS the rpm ia32-libs should work. Does anyone know what the whitebox equivalent is? thanks for you help Pete
  7. peterneve

    Count rows in every table

    Thanks Mufasa, You script works well, but some of the databases that I have tried it on haven't got any statistics. How do I gather statistics. Is it a simple matter?
  8. peterneve

    Count rows in every table

    Excellent! It works really well, but wasn't quite what I was expecting. I have added an @tab_counts.sql at the end of the script before the exit to get the output in one go, but is there a way to get the data into columns that are readable by, for example TOAD or PHP? Thanks.
  9. peterneve

    Count rows in every table

    Hi, I'm trying to do a simple query, which must be doable, but I can't get my head around it. I just want a query to count the number of rows in every table in a schema, with the output looking something like table_name | row count tablename1 | 213 tablename2 | 0 tablename3 | 50 etc... Any ideas
  10. peterneve

    error with vmware on linux whitebox

    Hi egr, I am running whitebox enterprize linux. The VMware is the free server download. so far i have been working through the libraries and dependencies with rpm files and downloading a new each time as there is always some conflict. If i was to install 32bit libraries, can i do this with an...
  11. peterneve

    error with vmware on linux whitebox

    Hi All, I have installed linux whitebox on a server and now wish to install EMC vmware. I have unpacked the tarball and excuted the rpm, once i did this i ran the vmware-config.pl, i then got asked for my serial number, once i entered this i got the following error; error while loading shared...
  12. peterneve

    tail and grep together

    I have also tried tail -f largefile | awk '/something/{getline;print}' >> newfile which produces nothing, although it works without the -f. Thanks,
  13. peterneve

    tail and grep together

    tail -f largelogfile | grep something >> newlogfile doesn't seem to produce anything in newlogfile. Even this would be a start.
  14. peterneve

    tail and grep together

    I need to write a simple script that reads a continuous live log file, and if I find a particular string, write the next line to another log file. I've tried vaiour tail -f | grep combinations. This should be simple, but I can't get it so work. Any ideas?
  15. peterneve

    Send datagram over UDP in shell

    Thanks. In the end I have used netcat. Amazing little tool.
  16. peterneve

    Upgrading CPUs and licenses

    Thanks. There was no need to do anything with licenses on the actual machines for either Oracle or Informix. Obviously we had to buy the license from oracle/informix to be legal but we just upgraded the machines and rebooted. No need to apply the license. No problems.
  17. peterneve

    Send datagram over UDP in shell

    Is there a simple way to send some data over UDP from a shell script for UNIX? Thanks in advance!
  18. peterneve

    Upgrading CPUs and licenses

    Hi, I have a couple of servers that are going to have extra CPU's installed. We have bought extra licenses for account for this, but does anyone know how you go about applying the license when upgrading the CPU's? Thanks, Pete
  19. peterneve

    pcAnywhere file transfers

    Hi, I am looking into ways of automatically downloading files form a machine only accessible through pcAnywhere. Does anyone know if this can be done through something like a vbscript? Thanks!
  20. peterneve

    Simple query on two columns

    If I use OR then I get files 100,102,104

Part and Inventory Search

Back
Top