Schedule stuff

Schedules

Nodes without associated schedules

tsm: SERVER1> SELECT node_name FROM nodes WHERE node_name NOT IN (SELECT node_name FROM associations)

NODE_NAME

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

NODE_TEMP

SERVER-04

...

Number of nodes without associated schedules

tsm: SERVER1> SELECT COUNT(*) FROM nodes WHERE node_name NOT IN (SELECT node_name FROM associations)

Unnamed[1]

-----------

12

Nodes with associated schedules

tsm: SERVER1> SELECT node_name FROM nodes WHERE node_name IN (SELECT node_name FROM associations)

NODE_NAME

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

NODE01

NODE02

NODE03

NODE04

Information about schedules and associations (2 tables)

tsm: SERVER1> SELECT associations.domain_name, associations.node_name, associations.schedule_name, -

client_schedules.description, client_schedules.action, client_schedules.options, -

client_schedules.objects, client_schedules.starttime FROM associations associations, -

client_schedules client_schedules WHERE associations.domain_name = client_schedules.domain_name -

AND associations.schedule_name = client_schedules.schedule_name ORDER BY associations.domain_name, -

associations.node_name, associations.schedule_name

DOMAIN_NAME: AIX

NODE_NAME: NODE01

SCHEDULE_NAME: Schedule1

DESCRIPTION: Backup Online of database XX

ACTION: COMMAND

OPTIONS:

OBJECTS: /opt/tivoli/tsm/scripts/bkp_weekly.sh

STARTTIME: 21:15:00

DOMAIN_NAME: AIX

NODE_NAME: NODE01

SCHEDULE_NAME: Schedule2

DESCRIPTION: Backup Incremental of Operating System

ACTION: INCREMENTAL

OPTIONS:

OBJECTS: /usr/ /opt/ /var/ /etc/ /home/

STARTTIME: 09:00:00

...

Some cool information about node, associations and schedules

tsm: SERVER1> SELECT associations.domain_name, associations.node_name, associations.schedule_name, -

client_schedules.description, client_schedules.action, client_schedules.options, -

client_schedules.objects, client_schedules.priority, client_schedules.startdate, -

client_schedules.starttime, client_schedules.duration, client_schedules.durunits, -

client_schedules.period, client_schedules.perunits, client_schedules.dayofweek, -

client_schedules.expiration, client_schedules.chg_time, client_schedules.chg_admin, -

client_schedules.profile, client_schedules.sched_style, client_schedules.enh_month, -

client_schedules.dayofmonth, client_schedules.weekofmonth FROM associations associations, -

client_schedules client_schedules WHERE associations.domain_name = client_schedules.domain_name -

AND associations.schedule_name = client_schedules.schedule_name ORDER BY associations.node_name, -

associations.domain_name, associations.schedule_name

DOMAIN_NAME: AIX

NODE_NAME: SERVER-01

SCHEDULE_NAME: SERV01_ARC_APP_WEEKLY

DESCRIPTION: Archive Weekly

ACTION: ARCHIVE

OPTIONS: -archmc=MC_AIX_WEEKLY

OBJECTS: /app2/

PRIORITY: 5

STARTDATE: 2006-05-01

STARTTIME: 06:01:00

DURATION: 1

DURUNITS: HOURS

PERIOD: 1

PERUNITS: WEEKS

DAYOFWEEK: TUESDAY

EXPIRATION:

CHG_TIME: 2007-07-03 10:35:12.000000

CHG_ADMIN: ADMIN

PROFILE:

SCHED_STYLE: CLASSIC

ENH_MONTH:

DAYOFMONTH:

WEEKOFMONTH:

DOMAIN_NAME: NT

NODE_NAME: SERVER-02

SCHEDULE_NAME: BD_OFF_DOMINO_MONTHLY

ACTION: COMMAND

OPTIONS:

OBJECTS: d:\tsm\tsmscripts\tdp_dom_offline_monthly.cmd

PRIORITY: 2

STARTDATE: 2006-05-01

STARTTIME: 21:00:00

DURATION: 1

DURUNITS: HOURS

PERIOD:

PERUNITS:

DAYOFWEEK: Sun

EXPIRATION:

CHG_TIME: 2007-05-24 09:08:14.000000

CHG_ADMIN: ADMIN

PROFILE:

SCHED_STYLE: ENHANCED

ENH_MONTH: Any

DAYOFMONTH: Any

WEEKOFMONTH: First

...