Recent content by Larshg

Hi I'm using Oracle 9.2.0 I want to find out how many minutes a times stamp is older then sysdate. This is the select that I use to find my timestamp. select min(to_char(sys_creation_date,'YYYYMMDD HH24MI')) from ac_processing_accounting where file_status='RD' and...

Sorry I submittede it by mistake - here is the full version I have this SQL SELECT Count(ALARMLIST_komplet.Alarm_ID) AS AntalOfAlarm_ID, IIf(InStr(",A3,B2,B3,C1,C2,C3,","," & [NodeBusinessPrio] & ",")>0,"MEDIUM","HIGH") AS Severity, ALARMLIST_komplet.Nodename...

Hi I have this SQL AntalOfAlarm_ID Severity Nodename Primary_Responsible 242 HIGH SPLINTER Billing Drift 230 HIGH CRM1 Billing Drift 217 HIGH DELFI1 Billing Drift I would like there to be another colum that shows how many of the rows

FANTASTIC - it works... /Larshg

Hi This post has a relation to thread80-946991 I working on a T64 v5.1 system and I would like my history .sh_hostory to relate to the individual login. Its a ksh shell and I've tryede this in the .profile - without any result. export set 'HISTFILE' per session /Larshg

I've added set 'HISTFILE' per user session to .profile but it does not seem to make a difference This new system is only using 1 system disk - that means that the .sh_history file is the same on alle serveres. I've also tryede doing this in the session set HISTFILE $HOME/._sh_history_user1...

Hi I'm working on a T64 V5.1 cluster The same user is usede on all the servers, but we are many peoble using the user, and that means that the .sh_history is useless. Is there a way to make the ._sh_history dependent on the {memb} and perhaps even the session, giving each login its seperate...

Its an ORACLE database >man sqlldr No reference page found for sqlldr. My system does not contain man pages for this one. Does anyone know where I can find thise man pages? /Larshg

Hi I want to put the output from wmstat -w 5 into a database as the command runs - I have this script that right now puts the data into a file. HOST=`hostname -s` while [ : ] do echo `date +"%d%m%y-%H:%M:%S"` " " `/usr/bin/vmstat -w 1 2|tail -1` >>...

Hi I'm having IO issues on a servere, and I want to monitor this problem over time. I'm using vmstat -w 5 to monitor the problem - but I would realy like to get a timestamp infront og the lines, so that I have a chance og analysing the system. Any ideers? - I'm wundering if I should make a...

Hi I was wondering if anyone knows if there are commands to start/stop and get state of services that can be executed from the command line. And if you can guide me to some dokumentation on what options there is for control from the commandline that would be great. /Larshg

Hi I usaly do most unix script, but I'm now running some services on a bunch of Windows 2000 servere. I was wundering if it is posible to restart a service remote - The issus is that I have 14 serveres where the same service is running, and right now I have to connect to the servers via RDP...

Thanks I works like a charm. /Larshg

Changing ti MM to MI solvede one of the issues - the one with 09:00 (should probaly have spottede that one my self, but thanks) But the problem with 'HH' '00' END_CYCLE, 2004-01--02-fre 00:59, -481 Is still coursing a problem. I've tryede adding, but without result. and...

Hi I have a sql(made with help fra this thread220-903346) that select the number of minutes a timestamp is after 9:00 there are 2 problems, I seem to get the times where the job is pricisly 9:00 and also the ones where the hours is 00: This is my SQL select ETL_PROGRAM.program_name...