Re: Which Workstation is using File Maintenance?

Hi Kevin Fox, Trudie Cook, Pete Olshavsky and Greg Wenzloff:

Thanks to all of your postings.

I will study your suggestions and hopefully resolve these type of problems in 
the future.

One additional point:

This problem sometimes comes up when a work station employee shuts down his or 
her workstation PC incorrectly whereby a File Maintenance session isn't closed 
correctly before the PC shutdown.

Will your suggestions identify this workstation?

Regards,
Al Gershen
Cost Accountant Lead
ECS Composites
Grants Pass, OR, USA
aldg3@xxxxxxxxxxx


> From: "Kevin Fox" <kdfox@xxxxxxxxxxxxxx>
> Date: 2004/02/06 Fri PM 02:52:09 PST
> To: "'MAPICS ERP System Discussion'" <mapics-l@xxxxxxxxxxxx>

> Subject: RE: Which Workstation is using File Maintenance?
> 
> Try Cross Application Support / Inquiry / Job Status.
> 
> It will tell you user and program that is running.
> 
> The file it reads is JOBACT in the AMFLIB* library.  Very easy to create a
> display in windows showing who is doing what at any given time.
> 
> Kevin Fox
> kdfox@xxxxxxxxxxxxx
> 

> From: "Trudie Cook" <trudie.cook@xxxxxxxxxxxxxxx>
> Date: 2004/02/06 Fri PM 12:11:15 PST
> To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
> Subject: RE: Which Workstation is using File Maintenance?

> It has been so long since I have run MAPICS DB that I am not sure what was 
> available in DB.   Does DB have MAPICS job status inquiry in CAS?   You could 
> also try doing a WRKOBJLCK on ITEMASA and see who has it open for update.
> 
> Trudie Cook
> MTD Products
> 
 
> 
> From: Pete Olshavsky <polshavsky@xxxxxxxxx>
> Date: 2004/02/06 Fri PM 12:23:14 PST
> To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
> Subject: Re: Which Workstation is using File Maintenance?

> Al, funny you should ask.. I just had a record lock on a job as I was reading 
> your email. A lot of times the joblog will tell you who has the record. If it 
> does not. could try CMD :
> DSPRCDLCK AMFLIBx/ITEMASA (whatever file and whatever your library designator 
> is). 
> If neither of these.. could try wrkobjlck AMFLIBx/ITEMASA and have everyone 
> get off. 
> Hope this helps
>  
> Pete Olshavsky
> 

> 
> From: Greg Wenzloff <GWenzloff@xxxxxxxxxxx>
> Date: 2004/02/06 Fri PM 12:17:03 PST
> To: "'MAPICS ERP System Discussion'" <mapics-l@xxxxxxxxxxxx>
> Subject: RE: Which Workstation is using File Maintenance?

> This works for me:
>                           
> WRKOBJLCK OBJ(ITEMASA) OBJTYPE(*FILE)       
> 
> Greg
>