Thursday, January 24, 2019

Control-M/Server fails to start, and the following message is displayed: Another instance of this script is running now, or may have previously ended abnormally

Control-M/Server fails to start, and the following message is displayed: Another instance of this script is running now, or may have previously ended abnormally solution : 1. Connect to the Control-M/Server database using the command "SQL" then run the following query: select count(*) from CMR_RESOURCELOCK where RESOURCE_NAME='server_started'; 2. If no record is returned, run the following SQL insert command to insert the missing record into the CMR_RESOURCELOCK table: insert into CMR_RESOURCELOCK (resource_name,resource_type,lastend) values ('server_started','7','0'); commit; 3. If one record is returned, run the following SQL command to verify what value is set for the "lastend" column for this record in the CMR_RESOURCELOCK table: select resource_name, resource_type, lastend from CMR_RESOURCELOCK; If the "lastend" value is not "0", set it as follows: update CMR_RESOURCELOCK set lastend=0 where resource_name='server_started'; commit; 4. Confirm that the row was successfully inserted: select count(*) from CMR_RESOURCELOCK where RESOURCE_NAME='server_started'; The command will return one record 5. Exit from the SQL prompt and run the following commands to reinitialize and start Control-M Server: init_prflag start_ctm

Saturday, January 19, 2019

Ctmsec use/How to list, update, delete, and copy users in the Control-M Security database.

Use the following command to list user authorizations: ctmsec -USER_LIST <user> Use the following command to update user authorizations: ctmsec -USER_UPDATE <user> <description> <group> Use the following command to delete user authorizations: ctmsec -USER_DELETE <user> Use the following command to copy user authorizations from one user to another: ctmsec -USER_COPY <from_user> <to_user>

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Awesome Deals | Bloggerized by Mahendra - 24x7FunOnline