Qbatch Going Down

[aruls]

Hello all Jde users,

Version : One World B7322
OS : AIX UNIX 4.3
Database : Oracle 8.0.5.0.0 Enterprise Edition

Problem : My qbatch goes down when any of my user deletes a job while it is
still processing. I am trying to determine who the culprit is however, this
is not easy. There are no traces left on the server & I have checked with
JDE support staff & they said that the only way is to turn on the jde logs
on the server. However, that would slow down the whole system.

Does anyone out there have any solution on this matter?

Please help.

Thank you.


Arul Rajah

 

[gerd_renz3]

Arul,

disable the DELETE button in P986116. This way your culprit can´t delete the traces of the job after it was killed. It will remain with status ´E´ .
Try to monitor your QBATCH queue. As soon as it goes down you check the last jobs that finished with ´E´ and probably find your evil-doer.
You can also run a Unix command like
ps -fu jde | grep runbatch >> your.log
every minute or so. As soon as QBATCH goes down you find the last jobs that ran.

Good luck, Gerd


Em Wednesday, December 19, 2001 em 06:56:36 AM, [email protected] escreveu:



--
ISM - Solucoes na Internet

http://www.ismnet.com.br/

 

[mjf]

Arul

This was also a problem in B732.2 on NT. We found that to terminate a job
successfully, put all other jobs in the jobqueue on hold before terminating
the active job. We also applied security so that only system administrators
could terminate jobs. This enabled us to work around the problem

Regards

Marty Fleming
Business Analyst
Richmond Limited

Phone: +64 +6 8786464 Ext 8168
Fax : +64 +6 8780959
Email: mailto:[email protected]
Web Page: http://www.Richmond.co.nz/

Site Specifications
OneWorld: Xe
Database: Oracle 8i
Enterprise Server: Intel NT
Clients O/S: NT4, WIN2K, Citrix

 

[libbi_fletcher]

We found that terminating the job OUTSIDE of OneWorld on an AS400 screen
works much better or it seems you are deleting QBATCH or ending the jobq
itself.


Libbi Fletcher
HoMedics, Inc.
M.I.S. Department
248-863-3001 ext. 1281
[email protected]

 

[MSiebenschuh]

I totally agree we moded the P986110B so that a user can't delete a job
unless it is in a D or E status. If they need to kill a job that has started
then they call us and we kill it from the UNIX side.

Mark Siebenschuh
Enterprise Software Systems Administrator
Physician Sales and Service
4345 Southpoint Blvd.
Jacksonville, FL 32216
904-332-3092




Mark Siebenschuh
HP9000/Oracle 8.0.5/JDE XE/Lots of Citrix