Defining the Framework Task Menu Entry for Tivoli Business Systems Manager Version 2.1

The Tivoli Framework tasks can be invoked using the tgmtask command:

tgmtask -h eehost -u tmeid -k tmepw {-o tmeendpointoid|-r endpointhostname} tskname|tsklib|tskargs

where:

eehost: The event enablement or task server host name
tmeendpointoid: Object ID of the endpoint, in the format of <tmr num>.<dispatcher num>.0+
endpointhostname: Endpoint’s label
tmeid, tmepw: User ID and password to access the TMR
task information: Task name, task library name, and task arguments

With this capability, we can extend the menu for any distributed objects that we can identify as belonging to a Tivoli Management Region where a task server is defined. For simplicity, we define additional commands for resources that are defined from TEC, where an Event Enablement host is one of the attributes. We pick up a generic object that is defined as the cid of G02K and add an extension to perform a DIR command on a Windows platform or a df command on a UNIX platform. We create a Tivoli Framework task called DIRCDrv under TBSMTasks Task Library. The script that the task runs is shown below:

#!/bin/sh
if [ x\"$OS\" = x\"Windows_NT\" ] ; then
CMD.EXE /C DIR C:
else
df
fi
exit 0

We then define a stored procedure called _DIRCDrv, as shown below:

CREATE PROCEDURE _DIRCDrv
@cid ClassID,
@id ObjID,
@ReturnCode INT = NULL OUTPUT
AS
RAISERROR(‘_DIRCDrv: %s, %d’, 0, 1, @cid, @id)
DECLARE @command NVARCHAR(255)
DECLARE @userID NVARCHAR(255)
DECLARE @tmeid NVARCHAR(255)
DECLARE @epname NVARCHAR(255)

IF @cid = ‘LOB’
SELECT @cid = phy_cid, @id = phy_id FROM lob_link WHERE dst_id = @id

SELECT @tmeid = _EEhost, @epname = _MgedSystemName
FROM G02Kcname_V where id = @id
EXEC asisp_getContextUserID @userID OUTPUT

IF @tmeid is NULL
BEGIN
SELECT ‘_DIRCDrv ERROR: Could not locate EE host’
RETURN 8
END
SELECT @command = ‘tgmtask -d TME -h “‘ + @tmeid + ‘” -r “‘ + @epname + ‘” ‘
IF @userID IS NOT NULL SET @command = @command + ‘ -u “‘ + @userID + ‘” -k “********” ‘
SET @command = @command+’ “DIRCDrv|TBSMTasks|’

EXEC @ReturnCode = master..xp_cmdshell @command

RETURN @ReturnCode

GO

We then use DefineDIRCDrv.sqi file to define the method for G02K, as shown below:

include(BusinessObject.sqi)
BEGIN_METHOD(DIRCDrv, ‘Dir of C drive’,’Display C Drive’)
METHOD_PARAM(ReturnCode, ASIVARIANT, ‘RETURN Code’, ‘RETURN Code’)
METHOD_PARAM_FLAG(output)
METHOD_PARAM(Results, ASIDBTABLE, ‘Results’, ‘Results’)
METHOD_PARAM_FLAG(output)
METHOD_PARAM_FLAG(collection)
END_METHOD(DIRCDrv)
BEGIN_METHOD_CALLERS(DIRCDrv)
METHOD_CALLER(G02K)
END_METHOD_CALLERS(DIRCDrv)

We run the sh clsql DefineDIRCDrv.sqi command and invoke the SQL Query Analyzer to load the generated DefineDIRCDrv.sql. Then we run asisp_definemenuitem against the G02K object. This time, we apply to all instances using the command:

EXEC asisp_definemenuitem 'DIRCDrv', 'G02K', 0, 'DIR C Drive', NULL, NULL, 'DIRCDrv', NULL, '', 1342242816

The result of the new menu is shown below: