Running the Job Count Utility (JCU) for Control-M v6.2.01

Admin007 · Post by **Admin007** » 15 Dec 2008 8:00

When attempting to run the JCU from command line on AIX UNIX server running 64bit java I get the following error:

=====================================================================
| CONTROL-M JOB COUNT UTILITY VERSION 1.0.0.02 June 2005
=====================================================================

java.io.FileNotFoundException: /opt/cmsv_dev/ADMIN/JCU/reports/daily_20081215.dat (No such file or directory)
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Io exception: The Network Adapter could not establish the connection
Exception in thread "main" java.lang.NullPointerException
at agentcheckutility.CollectJobs.getOverview(CollectJobs.java:889)
at agentcheckutility.CollectJobs.<init>(CollectJobs.java:836)
at agentcheckutility.RunTimer$RunTimerTask.runJcuReport(RunTimer.java:674)
at agentcheckutility.RunTimer$RunTimerTask.run(RunTimer.java:172)
at agentcheckutility.RunTimer.<init>(RunTimer.java:76)
at agentcheckutility.AgCheck.main(AgCheck.java:118)

Anyone have any ideas what the issue is and what I can do to resolve it?

Walty · Post by **Walty** » 17 Dec 2008 9:10

Hi,
Check your <dbhost> parameter.

JCU Command Line Syntax:

jcu [gui] [help] ecs/[500|600|610] dbtype/[Oracle|Sybase|MSSQL]
dbhost/<hostname> dbport/<port number> dbuser/<userid>
dbpass/<password> [dbsid/<sid name] [dcexcluded/<names>]
[details] [maxuse] [maxday]

Argument Description

help             Display help and syntax
gui              Run the utility with graphical user interface.
ecs              EM version such as "610" or ECS version such as "500" or "600"
dbtype        Database type which EM or ECS stores data on, Oracle, Sybase, MSSQL
dbhost         Database Server hostname.
dbport        Database Server listening port.
dbuser        EM/ECS administrator user id.
dbpass       EM/ECS administrator password
dbsid         Database instance SID name (Oracle only)
dcexcluded  List of datacenters to be excluded from the report (separated by forward slashes)
details         Report includes additional information related to nodes, tasktype, application type
maxuse       Generate summary report on maximum usage.
maxday       Report the date with the highest load of job ordered.

1) My execution (v 6.13 and Oracle)

jcu ecs/610 dbtype/Oracle dbhost/<DB hostname> dbport/<DB listening port> dbuser/emuser dbpass/<EM password> dbsid/<Oracle SID>

=====================================================================
| CONTROL-M JOB COUNT UTILITY VERSION 1.0.0.02 June 2005
=====================================================================

CONTROL-M Jobs Count Report Date: Wed, Dec 17 2008 Time: 08:36
Report file: daily_20081217.dat

--------------------------------------------------------------
Datacenter Name: QCTM01
Datacenter Code: Q01
Datacenter Platform: Distributed System
Datacenter Version: 613
Datacenter Hostname: qctm01

Total number of Jobs in DC: 14473
Total number of Executions in DC: 22497
Total number of Nodes in DC: 226

Total number of Tasktype Job in DC: 11553
Total number of Tasktype Command in DC: 1034
Total number of Tasktype Dummy in DC: 160
Total number of Tasktype External in DC: 0
Total number of Tasktype Scheduling Group in DC: 1726

Application Jobs in DC:
Total number of Application Type BIM in DC: 41
Total number of Application Type FILE_TRANS in DC: 1839
Total number of Application Type OS in DC: 12593

jdj420 · Post by **jdj420** » 18 Dec 2008 4:55

where can i get this utility and any documentation for it? i currently run a script that takes the ctmlog and parses out the return codes associated with a job ending ok but i like the way this utility breaks it down.

Walty · Post by **Walty** » 19 Dec 2008 8:29

The utility JCU (Control-M job count utility) is unsupported by BMC, it is only provided on demand (Control-M/EM v6.1.x & 6.2.x)

The calculation of this tool is based on the active network (old net) of the previous day.
You can see how many executions for each job had, how many jobs where ordered on a specific datacenter or a specific nodeid.

In version 6.3.x you have same result with 2 reports on Reporting Facility Tool:

1) Workload Distribution report
2) Extreme Peak Usage report

Run reporting facility and :

- Select Create report with new template
- In Report categories select General, in Report type select your report (1 or 2)

jdj420 · Post by **jdj420** » 19 Dec 2008 4:33

any chance you can send me the template you used in your explanation? i don't have a whole lot of time to try and figure it out and i really like your format.

Admin007 · Post by **Admin007** » 22 Dec 2008 3:35

First, thank you for your assistance. I was able to get the JCU running on my Windows desktop. Initially I was attempting on AIX but I am running java 64bit and it is not compatible.

Second, the format shown in the prior example is standard for the JCU. Contact BMC and request a zip file for the JCU be sent to you.

Lastly, does anyone know if BMC charges for task licenses based on ALL datacenters peak load days combined or only for the the ONE datacenter that had the highest load day of any datacenter? I run 7 datacenters and the single highest load day of one datacenter is 4,000. But if I take all 7 datacenters and add up their highest load day, I am at 8,000 tasks.

jdj420 · Post by **jdj420** » 29 Dec 2008 9:09

first, thank you for the information on how to obtain the jcu utility. i installed it and have successfully generated a report.

secondly and this is a two part question:

1. can you run the utility for previous days?
2. can you run the utility for a different time period? (ex. my newday processing occurs at 09:00 so i would want the report to run right after newday for the previous 24 hours, so an example would be 01/01/08 09:00 thru 01/02/08 08:59).

any assistance you can provide would be greatly appreciated. thanks again!