scalereport_commcell_status.sql:This script outputs the status of a commcell reporting various parameters like   jobs completed, bytes transferred, jobs in the queue etc.

Steps for execution:

QOperation execscript -sn scalereport_commcell_status.sql


This script gives the output in the following format:


Column Name 		Description

--------------------------------------------------------------------------------------

Query			Brief explanation of what the next columns indicate.

LastHour		Output calculated for the last one hour.

Last24Hours		Output calculated over the last twenty four hours.

Units			The denomination of the last two columns.




Row Name 			Description

--------------------------------------------------------------------------------------


CHUNKS CLOSED			Number of chunks closed per hour in the commcell 
				(sum of chunks closed in the last 24 hours divided by 24 hours; 
				 and how many were closed in the last hour)

NO. OF RESERVATIONS		Number of reservations made per hour.
				(sum of reservations in the last 24 hours divided by 24 hours; 
				 and how many were made in the last hour)

BKP JOBS COMPLETED		Number of jobs completed successfully.
				(sum of completed jobs in the last 24 hours divided by 24 hours;
				 and how many were completed in the last hour)

BKP JOBS COMPLETED IN ONE ATMPT	Percentage OF Jobs completed in a single attempt.
				(of those that completed in the last 24 and last one hours)

AVG NO. OF ATMPTS PER BKP JOB	Average number of attempts a job took to complete.
				(of those that completed in the last 24 and last one hours)

JOBS IN QUEUE(QUEUED)		NUmber of jobs in queued state.
				(current state)

JOBS IN QUEUE(PENDING)		Number of jobs in pending state.
				(current state)

JOBS IN QUEUE(WAITING)		Number of jobs in waiting state.
				(current state)

JOBS IN QUEUE(SUSPENDED)	Number of jobs in suspended state.
				(current state)

N0. OF JOBS CRNTLY RUNNING	Count of jobs which are currently running.
				(current state)

NO. OF MOUNTS/HOUR		Number of mounts per hour.
				(sum of all mounts in the last 24 hours divided by 24 hours;
				 sum of all mounts in the last hour)
				

MAX NO. OF BKP STREAMS 		Maximum number of streams transferring data
				(of streams that were up in the last 24 hours and within the last 1 hour)

AVG NO. OF BKP STREAMS 		Average of streams transferring data
				(of streams that were up in the last 24 hours and within the last 1 hour)

AVG JOB THROUGHPUT 		Average job throughput in GB/hr/Job
				( Calculated by summing up all data written by jobs (that were started in the last 1/24 hours)
				  and dividing that by the sum of the job run times)
				  Note: No exclusions are made for admin jobs;
					    jobs that are still running are also not included.


SIZE OF CHUNKS			Total size of chunks in GB/hr
				(sum of all data written in commcell within the last 24/1 hours and divided by the time frame)