Recent content by toddyl

Another group provide data in a flat file and a batch job runs which updates the lots on a daily basis. I dont have access to this system and can only see the resultant output. In the example above on day T they sold off all of lot 1, 50 units, and 25 units of lot2. On T+1 as lot 1 was no...

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

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

xwb, Thanks for your help. What you said corrected the problem and its working now. Cant believe something so simple could cause all the issues I had. Cheers, toddyl

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

Annihilannic, Thanks for getting back to me. The doc I have on the app says it uses standard Unix Regular expressions. The values after the word RANGE are taken as the pattern to match. I therefore need to come up with something that will match everything but the ranges above. Cheers, Toddyl

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

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

I have no access or insight into the logging tool so am unable to change that. The only option available to me is to induce/replicate the error so that the Error log eventually contains the message and my monitoring script picks this up. Thanks for the feedback -- its great to get an insight...

Its using its own logger. Unfortunately I have no idea how this works or how to adjust the logger. From what you are saying it looks as if I cannot simply insert my error message into the log but will instead have to find a way or emulating and error so that one appears in the log. Thanks.

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

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

Hi, Thanks for your response. It looks as if I may not be able to use partitioning as I appear to be locked down to using only the 1 tablespace -- part of the rules here unfortunately. Is there any other way I can rebuild this table to help improve performance? Thanks for your help, Tom

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

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