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 Rhinorhino 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: toddyl
  • Content: Threads
  • Order by date
  1. toddyl

    LEAD Function

    Hi, I have the following scenario in relation to the holding of financial stocks: On 01-Sept-2011 I bought two seperate lots in a stock -- 50 units and 100 units, as depicted below, for day T: Day,Lot_Nbr,Units_Hld,Acq_date ============================== T,1,50,01-Sept-2011...
  2. toddyl

    fopen and getw not working as expected

    Hi, I am working on a Solaris server and have a piece of C code that is meant to read in a text file that contains an integer and it should then increment the integer by 1, use it and then write the new value to the text file. My code has: FILE *uniq_id_file; -- this line is declared near the...
    • toddyl
    • Thread
    • Replies: 1
    • Forum: C
  3. toddyl

    Global Variable and Compiler issue

    Hi, I have no knowledge of C but have been asked to modify a file to carry out a task. What I am trying to do is to use a global variable to replace a particular variable in a config file. Under the include section I have added the following: int globalvar; In the main() section I have...
    • toddyl
    • Thread
    • Replies: 4
    • Forum: C
  4. toddyl

    Regular Expressions -- Not a particular word

    Hi, I have an app that uses unix regular expressions to match subjects it will store in its memory cache. I have setup several apps as follows: RANGE: KEY_RANGE_1.[A-T].* RANGE: KEY_RANGE_2.[U-Z].* RANGE: KEY_ROUND.[A-Z].* RANGE: KEY_TOTAL.[0-9].* I need to setup an app that will get all the...
  5. toddyl

    SQLLDR and to_timestamp

    Hi, I have data in the format of server, process, day, time, cpu and value which I am loading into a database table using sqlldr. The day is in the format of DD/MM/YYYY and time is HH24:MI. I am trying to introduce a new column called TIMESTMP of type TIMESTAMP so that I can build an index on...
  6. toddyl

    Writing to a file that is in use by a process

    Hi, I have a third party process running on a unix box that writes to a log file. The log file is automatically updated every 30 seconds with various stats etc. This file is monitored by another application to see if various errors occur and raised alerts if any are found. I want to test this...
  7. toddyl

    Forecasting algorithm

    Hi, I have been given an Excel sheet for server CPU usage with the following columns in it: Day, Time, Value. I have used the Excel functionality to apply forecasting to this but it is not accurate enough for my needs. Does anyone know of a forecasting algorithm I can apply to this data to...
  8. toddyl

    Partitioning and performance

    Hi, I have a stats table where I am getting 1 minute data from hundreds of server which have serveral processes each on them. The stats themselves are various counters which give me a rate of updates per minute. The table I created used the following SQL: CREATE TABLE STAT_RATE (...
  9. toddyl

    Getting average and max values in PL/SQL

    Hi, I have a table, category_rate, where I am collecting stats per process as follows: Server Process Category Day Time Value ================================================ serv1 a1 Update_FL 15/9 09:00 100 serv1 a2 Update_FL 15/9 09:00 95 serv2 b1...
  10. toddyl

    CPU and Memory Usage per process

    Hi, I have a mix of Linux and Solaris servers and have been getting CPU and Memory usage for these using the sar command. I have been asked by Management if I can break these stats down to a per process basis as they wish to see what processes on what servers are most using the resources. I...
  11. toddyl

    Graphing oracle data

    Hi, Forgive me if this is in the wrong forum but I'm unsure where to start. I have several tables in my Oracle 10g database that related to performace, ie: CPU usage on a server over time. I am looking for a tool that I can download that will easily allow me to graph this data. Ideally the...
  12. toddyl

    Storing time/value data

    Hi, I am collecting data, using Perl, on a per minute basis from a large number of systems. The columns on the data I am pulling back are: server, process, day, time, value. For example: myserver, proc1, 2008/01/18, 09:00, 12345 There is a huge amount of this data that I now need to load into...
  13. toddyl

    Getting Server information via Cygwin

    Hi, I've developed a Perl script which runs on Unix/Linux servers and gets server information. Part of this script looks up things like /etc/release (or /etc/redhat-relase on Linux) and runs uname to get various OS info. I've now been asked to find a way to run this script on our Windows...
  14. toddyl

    Variable "%subcat" will not stay shared

    Hi, I have a perl script where I am trying to get a category and subcategories for an item. I've managed to identify the category and am estimating the subcategories based on the counts of certain occurances. To do this I've created a hash and if certain criteria are met then the count of the...
    • toddyl
    • Thread
    • Replies: 2
    • Forum: Perl
  15. toddyl

    SSH prompting for password

    Hi, I created a script that would update the authorized_keys file on remote servers with the SSH RSA key for my central server. This script also generates and retrieves the SSH RSA key for the remote server and adds it to my central servers authorized_keys. By doing this I was able to connect...
  16. toddyl

    Corruption when transfer Solaris file to Linux

    Hi, I'm trying to gather various information about my servers and have put together a perl script to do this. One of the things I'm interested in is CPU information. Early on I check if the system is Solaris or Linux and run the appropriate commands. On Solaris I am running kstat -m cpu_info...
  17. toddyl

    Distributing SSH Keys

    Hi, I have an internal development environment which consists of 20 servers (a mix of LINUX and SOLARIS) and I wish to load the ssh rsa key that I generated on my central server onto these. So far I have generated my ssh key file for my central server using the command ssh-keygen -t rsa -f...
  18. toddyl

    Materialized View logs issue

    Hi, I have serveral Materialized views which are based on several tables. Each of these tables have a Materialized view log associated with them. There's been trouble in the past and these views have been dropped, recreated, altered etc. After much change the views now appear to be working...
  19. toddyl

    Selecting LONG type

    Hi, I have a table and one of the columns, say x, is of type LONG. I can do a select a, b, c, x from my_table and have no problems in getting the data I require. I now want to output this to a csv file so I set spool to a file, say output.csv and run the following: spool ../../output.csv...
  20. toddyl

    Cannot access SunFire 280R

    Hi, We have a SunFire 280R that I cannot connect into from the network. I got a serial cable and connected my laptop to the serial port of the machine. I used HyperTerminal to connect and was prompted to login. I entered the root username and attempted to enter the password I was given. It said...

Part and Inventory Search

Back
Top