Need Help To delete a job

DSDexter · Post by **DSDexter** » Thu Apr 17, 2008 5:24 am

Hi All,

I am struggling to delete a job. Error Message I get is It's being accessed by another user. When I veiw the process in DS Administator I am able to veiw the job that is locked at record level. I took the PID,UserNo and Inode No. from DS Administrator. When I view the process in Unix. I dont see any process running for that PID.

So I cant KILL that process from Unix.
Secondly Cleanup resources is not working. And to make matter worst I dont have administratir rights on the project so that I can go through the standard procedure and UNLOCK the job.

Is there any other approach I can try? Any help will be appreciated.

hamzaqk · Post by **hamzaqk** » Thu Apr 17, 2008 5:29 am

At the Shell
------------

- Execute the following commands:
cd $DSHOME
. dsenv
bin/uvsh

- If the job is locked, execute the following:
UNLOCK RECORD jobname ALL

Then go in the repository and delete the job

DSDexter · Post by **DSDexter** » Thu Apr 17, 2008 5:41 am

hamzaqk wrote:At the Shell
------------

- Execute the following commands:
cd $DSHOME
. dsenv
bin/uvsh

- If the job is locked, execute the following:
UNLOCK RECORD jobname ALL

Then go in the repository and delete the job

I dont have Admin rights as mentioned earlier in my post.So the above procedure will not work for me.

hamzaqk · Post by **hamzaqk** » Thu Apr 17, 2008 5:58 am

cant do much then

chulett · Post by **chulett** » Thu Apr 17, 2008 6:18 am

You don't need admin rights to unlock if you can log on as the user that holds the lock... can you?

DSDexter · Post by **DSDexter** » Thu Apr 17, 2008 6:49 am

chulett wrote:You don't need admin rights to unlock if you can log on as the user that holds the lock... can you? ...

Craig,

I am using the same user-id against which the lock is is, But still when I try to unlock the job, It throws a message Insufficient privileges to perform lock maintenance. So does the theory, who locks! can unlock! fail here? Alos why cant I see the process running on my Unix Screen?

I ran

Code: Select all

ps -ef | grep dsapi

and Also

Code: Select all

ps -ef | grep '8791'

where 8791 is my PID which It got from Administrator, But I shows no records.

chulett · Post by **chulett** » Thu Apr 17, 2008 7:27 am

Sorry, guess I was thinking of something else - a DS.TOOLS 'logout', whih removes any locks as well. For this, you'll need to turn it over to an Admin AFAIK.

What does 'LIST.READU' or DS.TOOLS show?

DSDexter · Post by **DSDexter** » Thu Apr 17, 2008 7:32 am

It shows the job in active locks category.

DSDexter · Post by **DSDexter** » Thu Apr 17, 2008 7:40 am

Craig This is what I am getting

Code: Select all

>LIST.READU EVERY

Active Group Locks:                                    Record Group Group Group
Device.... Inode....  Netnode Userno  Lmode G-Address.  Locks ...RD ...SH ...EX
  63208824       533        0     45   7 IN       2800      1     0     0     0
  63208720       668        0  35601  12 IN       1000      1     0     0     0
  63208807      1006        0  57503  28 WR       4000      0     0     0     0
  63208824       396        0  43508  31 IN       1000      1     0     0     0
  63177716      1480        0     45  37 IN        800      7     0     0     0
  63208807      1006        0  57503  37 WR          0      0     0     0     0
  63177716        28        0  42766  40 IN        800      9     0     0     0
  63177716        28        0  42766  51 IN       1000      4     0     0     0
  63208824       533        0     45  60 IN        800      1     0     0     0
  63208824      2754        0  39010  61 IN       1000      1     0     0     0
  63208706       413        0  55268  70 IN       2000      1     0     0     0
  63208807      1006        0  57503  81 WR       2000      0     0     0     0
  63208824       533        0  42766  86 IN       A800      1     0     0     0
  63208771       534        0  43475  87 IN       A800      1     0     0     0

Active Record Locks:
Device.... Inode....  Netnode Userno  Lmode   Pid Login Id Item-ID.............
  63208824       533        0  52412   7 RL 13124 evdfadm  RT_CONFIG69
  63208720       668        0  35601  12 RL 29935 TenduG   RT_LOG113
  63208824       396        0  56745  31 RU  8791 evdfadm  src2rawEvdfFSEarnsLodRaw
  63177716      1480        0  56745  37 RL  8791 evdfadm  evdf&!DS.ADMIN!&
  63177716        28        0  56745  51 RU  8791 evdfadm  0D2234B0-118C-431E-981E-35BDE17208A3-BOS-PROD-TS-415:8791

Can you tell me why so many entries are created for a single PID? And what do they mean

attu · Post by **attu** » Thu Apr 17, 2008 9:50 am

Code: Select all

63208824       396        0  56745  31 RU  8791 evdfadm  src2rawEvdfFSEarnsLodRaw

Your job name..

Code: Select all

  63177716      1480        0  56745  37 RL  8791 evdfadm  evdf&!DS.ADMIN!&

The project you are in - evdf

Code: Select all

63177716        28        0  56745  51 RU  8791 evdfadm  0D2234B0-118C-431E-981E-35BDE17208A3-BOS-PROD-TS-415:8791

mac address, computer name and PID
[/code]

DSDexter · Post by **DSDexter** » Fri Apr 18, 2008 6:05 am

Code: Select all

  63177716      1480        0  56745  37 RL  8791 evdfadm  evdf&!DS.ADMIN!&

Hi Attu,

Thanks ofr that information, Can you tell me what &!DS>ADMIN!& indicate above

ray.wurlod · Post by **ray.wurlod** » Fri Apr 18, 2008 4:00 pm

evdf&!DS.ADMIN!& is a special value that is used to create a shared lock of the same name to indicate that there is a client connected to the evdf project. This is used by several Administrator utilities to check quickly whether they can have exclusive access (no connected clients) to the project. Hence the "&!DS.ADMIN!&".