topic Re: How to KILL process using sdemon? in Data Management Questions

How to KILL process using sdemon?

MuzammilAK — Thu, 20 May 2010 07:02:26 GMT

Dear All,

Of late, I am having tough time with this one.

I have below query whihc returns locks information.

select table_registry.table_name,
                                table_locks.sde_id,
                                table_locks.registration_id,
                                process_information.owner as ProcessOwner,
                                process_information.start_time,
                                process_information.server_id,
                                table_registry.owner as TableOwner
                                from sde.table_locks table_locks,
                                sde.table_registry table_registry,
                                sde.process_information process_information
                                where table_locks.registration_id = table_registry.registration_id
                                and table_locks.sde_id =process_information.sde_id;

With the result from above, I am trying to KILL the process using sdemon as shown below:

sdemon -o kill 42345 -p sde -N

where 42345 is process id,
          sde is sde admin password.

But i get below error:

'Invalid DBA password!'

i have also tried giving that account 'alter symbol' privileges. But same error.

Please help!!.

Regards
Muzammil

Re: How to KILL process using sdemon?

MilesWacker — Thu, 20 May 2010 16:09:25 GMT

Dear All,

Of late, I am having tough time with this one.

I have below query whihc returns locks information.

select table_registry.table_name,
                                table_locks.sde_id,
                                table_locks.registration_id,
                                process_information.owner as ProcessOwner,
                                process_information.start_time,
                                process_information.server_id,
                                table_registry.owner as TableOwner
                                from sde.table_locks table_locks,
                                sde.table_registry table_registry,
                                sde.process_information process_information
                                where table_locks.registration_id = table_registry.registration_id
                                and table_locks.sde_id =process_information.sde_id;

With the result from above, I am trying to KILL the process using sdemon as shown below:

sdemon -o kill 42345 -p sde -N

where 42345 is process id,
          sde is sde admin password.

But i get below error:

'Invalid DBA password!'

i have also tried giving that account 'alter symbol' privileges. But same error.

Please help!!.

Regards
Muzammil

Try sdemon -o kill -t 42345 -p sde -i SDESERVICE -s SDESERVER

Re: How to KILL process using sdemon?

ForrestJones — Thu, 20 May 2010 22:56:52 GMT

Try sdemon -o kill -t 42345 -p sde -i SDESERVICE -s SDESERVER

mwack is correct. To see the the users connected and their sde id (S-ID) you may also run the following:

sdemon -o info -I users -i <SDESERVICE> -s <SDESERVER>

The number for the -t parameter for kill is the sde id.