Any Unix Wizards About...........bit Of A Crisis

[Dave-Ellen]

trying to run end of year reports for a large London Borough (has to be done before 12 tonite) and some muppet has manages to close the system so nothing will run.

the system scheduler says its running when its not...................no real techies are available until Monday morning

I can access the UNIX prompt and was wondering if there was any command I can run to get the thing working again.............

if i do stop_sched hbctlivedb it says its stopped the db

I then do start_sched hbctlivedb and it says its running

I can't chenge the invoke times on the jobs (if that was the problem) thru the front end.............try to QBF them and it just hangs...........

totally confuzzled..........any help gratefully rec'd

[Niraj]

Dave, is it the database you can't access? What db are you using?

I'm not a UNIX wiz, but obviously can try to help with my IT knowledge.

(just did a quick search on the net... is your database approaching 2Gb?)

Can you use the command line to navigate to the location of where the db is stored?

[Dave-Ellen]

i can access the db its tables etc.............there is a batch job that opens and closes the system............it has closed it...............but will not open it just hangs............looking for kill commands

unix box is AIX

[Johndcfc]

Probably too late and might not work (linux not unix) but cant you run something similar to:

ps xa

to list all the processes and find the number of the job then

kill -9 numberofprocess

[Dave-Ellen]

Probably too late and might not work (linux not unix) but cant you run something similar to:

ps xa

to list all the processes and find the number of the job then

kill -9 numberofprocess

thanks...i did the first bit (diff command) but the second bit was what i was after !

prob fixed anyway...think someone switched the server off & rebooted

[Mike_B]

I doubt anyone was accessing the db that time of night. Just bounce the box - usually does the trick and sounds like it did this time too!!