Friday, October 23, 2015

Adding Swap Space on a Solaris System

Become a superuser (root) by typing:
```
% su
Password: root-password
```
Create a file in a selected directory to add swap space by typing:
```
mkfile number[m|k|b] /directory/swap-file-name
```
where number is an amount of swap space, followed by either m for megabyte, k for kilobyte, or b for block. The directory is a directory in which you have permission to add swap space. The swap-file-nameis the name of the swap file you are creating.
For example, to create a 16-megabyte swap file named 16mswapin the foodirectory, type the following:
```
mkfile 16m /foo/16mswap
```
See the mkfile(1M) man page for more information.

Verify that the file was created by typing:

ls -l /directory/swap-file-name

The new file appears in the directory. For example:

ls -l /foo/16mswap
-rw------T   1 root     other    16777216 Dec 12 14:24 /foo/16mswap

Run the swap command to specify the additional swap space by typing:
```
swap -a /directory/swap-file-name
```
Verify that the extra swap space was added by typing:
```
swap -s
```
The output shows the allocated swap space. For example:
```
swap -s
total: 289336k bytes allocated + 27008k reserved = 316344k used, 298336k available
```

Configure NTP server for time adjustment.

Installing NTP Server

NTP packages are available under default repositories. You just login to your server as root user and execute following command.

# yum install ntp

Configure NTP Server

Sync Local Time from pool.ntp.org

First we need to keep synchronize time of this server. For this we will use NTP POOL cluster servers to synchronize time of local system. NTP POOL project is providing large number of cluster servers. Lets edit NTP configuration file and update following values

# vim /etc/ntp.conf

server 0.centos.pool.ntp.org iburst
server 1.centos.pool.ntp.org iburst
server 2.centos.pool.ntp.org iburst
server 3.centos.pool.ntp.org iburst

As NTP pool providing large number of server spread world-wide. We suggest to use any near by servers also. You can find nearby servers at http://www.pool.ntp.org/en/.

Allow LAN Systems

Now configure your ntp server to allow LAN systems to keep synchronize their time from this server. To do it add following entry in configuratio nfile

 restrict 192.168.1.0 mask 255.255.255.0 nomodify notrap

Add caption

Restart NTP Server

NTP server listen on UDP port 123. After making all above configuration, Let’s restart NTP server using following commands.

For CentOS/RHEL 7 and Fedora 21

# systemctl start ntpd
# systemctl enable ntpd

For CentOS/RHEL 6/5 and Fedora 20/19

# service ntpd start
# chkconfig ntpd on

Thursday, October 22, 2015

MegaCli64 Command Usage

MegaCli64 Command Usage Cheat Sheet

Here is a MegaCli64 PDF cheat sheet created by Moritz Mertinkat.

Get Information from All Physical Disks

The -a command line switch specifies the Array ID, in this case All Array IDs.

# ./MegaCli64 -PdList -aAll

Get Virtual Disk Information

The -a command line switch specifies the Array ID, in this case All Array IDs.

# ./MegaCli64 -LDInfo -Lall -aAll

Get the Number of Virtual Drives Configured on Each Adapter

The -a command line switch specifies the Array ID, in this case All Array IDs.

# ./MegaCli64 -LdGetNum -aAll

Get the Number of Array Controllers

# ./MegaCli64 -adpCount

Blink Hard Drive Lights

Start Blinking

The -a command line switch specifies the Array ID, in this case Array ID 0.

# ./MegaCli64 -PdLocate -start -physdrv[:] -a0

Stop Blinking

The -a command line switch specifies the Array ID, in this case Array ID 0.

# ./MegaCli64 -PdLocate -stop -physdrv[] -a0

Set Dedicated Hot Spare

The following physical drive was Unconfigured(good):

Enclosure Device ID: 4
Slot Number: 16
Device Id: 154
Sequence Number: 1
Media Error Count: 0
Other Error Count: 0
Predictive Failure Count: 0
Last Predictive Failure Event Seq Number: 0
Raw Size: 140014MB [0x11177328 Sectors]
Non Coerced Size: 139502MB [0x11077328 Sectors]
Coerced Size: 139392MB [0x11040000 Sectors]
Firmware state: Unconfigured(good)
SAS Address(0): 0x500000e117951c52
SAS Address(1): 0x0
Connected Port Number: 0(path0) 
Inquiry Data: FUJITSU MBE2147RC       D905D304PB30AAGJ

When looking at all of the physical drives by running MegaCli64 -PdList -aAll, Array #: 0, 1, 2, 3, 4 were missing a hotspare.
The following command added the Unconfigured(good) physical drive above as a dedicated hotspare:

The -a command line switch specifies the Array ID, in this case Array ID 0.

# ./MegaCli64 -PDHSP -Set -Dedicated -Array0,1,2,3,4 -PhysDrv [4:16] -a0

Friday, October 9, 2015

Install TSM Client on CentOS/RHEL

HowTo : Install TSM Client on CentOS/RHEL

TSM

This guide describes the process of installation and basic configuration of TSM (Tivoli Storage Manager) Client on CentOS/RHEL.

Downloading the TSM Client

Download the archive with the latest TSM Client for your OS from IBM public FTP.
For example, lets download and unpack TSM Client 6.3.1.0 for Centos 6.3 64-Bit :
# mkdir -p /tmp/tsminstall
# cd /tmp/tsminstall
# wget ftp://public.dhe.ibm.com/storage/tivoli-storage-management/maintenance/client/v6r3/Linux/LinuxX86/BA/v631/6.3.1.0-TIV-TSMBAC-LinuxX86.tar
# tar xvf 6.3.1.0-TIV-TSMBAC-LinuxX86.tar
After unpacking you should see the following files :
README_enu.htm
README_api_enu.htm
TIVsm-API64.x86_64.rpm
TIVsm-BA.x86_64.rpm
TIVsm-BAhdw.x86_64.rpm
TIVsm-JBB.x86_64.rpm
TIVsm-APIcit.x86_64.rpm
TIVsm-BAcit.x86_64.rpm
TIVsm-filepath-6.3.1-0-rhel55.x86_64.rpm
TIVsm-filepath-6.3.1-0-rhel60.x86_64.rpm
TIVsm-filepath-6.3.1-0-sles10sp3.x86_64.rpm
TIVsm-filepath-6.3.1-0-sles11sp1.x86_64.rpm
gskcrypt64-8.0.14.14.linux.x86_64.rpm
gskssl64-8.0.14.14.linux.x86_64.rpm
The packages that are needed for installation are highlighted.

Installing TSM Client

1. Resolving Dependences

Install gskcrypt and gskssl. Normally, these libraries can be found in an archive with the TSM Client.
# rpm -ivh gskcrypt64-8.0.14.14.linux.x86_64.rpm
# rpm -ivh gskssl64-8.0.14.14.linux.x86_64.rpm

2. Installing TSM Client

Use yum localinstall to installing TSM client from rpm files. In this case the enabled repositories will be used to resolve dependencies.
# yum localinstall TIVsm-API64.x86_64.rpm
# yum localinstall TIVsm-BA.x86_64.rpm
You can remove the temporary folder, if the installation has completed successfully.
# rm -rf /tmp/tsminstall

TSM Client Configuration

Add the TSM client service to autostart :
# chkconfig --add dsmcad
# chkconfig dsmcad on
Create configuration files from the samples :
# cd /opt/tivoli/tsm/client/ba/bin/
# cp dsm.opt.smp dsm.opt
# cp dsm.sys.smp dsm.sys
Open configuration files and append your settings.
Read more about TSM Client Configuration Files
The content of /opt/tivoli/tsm/client/ba/bin/dsm.sys - Example :
SErvername TSM-SERVER-1
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 192.168.0.5
PASSWORDAccess generate
NODename CLIENT-NODE-12345
SCHEDMODe PROMPTED
MANAGEDServices schedule
ERRORLOGName /opt/tivoli/tsm/client/ba/bin/dsmerror.log
ERRORLOGRetention 7 D
SCHEDLOGName /opt/tivoli/tsm/client/ba/bin/dsmsched.log
SCHEDLOGRetention 7 D
DEDUPLICATION yes
The content of /opt/tivoli/tsm/client/ba/bin/dsm.opt - Example :
SErvername TSM-SERVER-1

TSM Server Configuration

Register the new node on your TSM Server.
Perform the following steps in the TSM Server's console, if you haven't registered the new node yet.

1. Register the new node

tsm> register node [NODE-NAME] [NODE-PASSWORD] domain=[DOMAIN]
Example :
tsm> register node CLIENT-NODE-12345 PASSW0RD domain=STANDARD

2. Associate the new node with a schedule

tsm> define assoc [DOMAIN] [SCHEDULE] [NODE-NAME]
Example :
tsm> define assoc STANDARD INCR_20H CLIENT-NODE-12345
These step are enough. Now logout and go back to your server.

Completing the TSM Client Configuration

Establish the first connection to TSM server from the client :
# dsmc query session
Enter the 'user id' (the name of your node) and the 'password'.
If the session was successfully established, the password will be stored, and you won't need to type it anymore.
Start the TSM client service :
# service dsmcad start
In a few minutes check the last schedule logs. Verify that the next backup has been successfully scheduled.
# tail /opt/tivoli/tsm/client/ba/bin/dsmsched.log
In case of any problems check the last error logs :
# tail /opt/tivoli/tsm/client/ba/bin/dsmerror.log

TSM SQL Select Commands

TSM ( Tivoli Storage Manager ) SQL Select Commands

SQL for Tivoli Storage Manager

Useful SQL Statements for TSM

This page has a collection of useful SQL statements for IBM Tivoli Storage Manager (TSM). Here you can find out a lot of selects that will help you to get information from TSM and to construct your own SQL statements.

1. Database and Recovery Log

a. List all information from db table

b. TSM database utilization (%)

c. TSM log recovery utilization (%)

d. Selecting specific columns from db table

e. Number of database volumes not synchronized

f. Number of log volumes not synchronized

2. Nodes

a. Number of nodes

b. Number of nodes per domain

c. Number of nodes per platform

d. Nodes locked

e. Number of nodes locked

f. Number of nodes sessions

g. TSM clients version

h. Number of files per client

i. Space and number of files stored per client

j. Data stored per client (GB)

3. Schedules

a. Nodes without associated schedules

b. Number of nodes without associated schedules

c. Nodes with associated schedules

d. Number of nodes associated per schedules

e. Information about schedules and associations (2 tables)

f. Some cool information about node, associations and schedules

4. Drives and Paths

a. Some information about paths

b. Some information about drives

c. Number of drives not online

d. Number of drives not online in library 3584

e. Number of paths not online

f. Information about drives utilization

5. Management class

a. Management classes per domain

b. Management classes per domain of policy set ACTIVE

c. Default management class per domain of policy set ACTIVE

d. Management classes of a specifc domain of policy set ACTIVE

e. Management classes of policy set ACTIVE that a specific node can use

f. Management classes with backup copy group information

g. Management classes with archive copy group information

6. Copy Groups

a. Destination pool of each management class (type: archive copy group)

b. Destination pool of each management class (type: backup copy group)

c. Some information about archive copy group

d. Some information about backup copy group

7. Activity Log

a. Search in the activity log for missed schedules in the last 2 hours

b. Search in the activity log for messages with Error severity in the last 1 hour

c. Search in the activity log for successful, missed or failed schedules in the last 1 day

d. Search in the activity log for a specific ANR in the last 1 day

Database and Recovery Log

List all information from db table

tsm: SERVER1> SELECT * FROM db

AVAIL_SPACE_MB: 85000

CAPACITY_MB: 80000

MAX_EXTENSION_MB: 5000

MAX_REDUCTION_MB: 11808

PAGE_SIZE: 4096

USABLE_PAGES: 20480000

USED_PAGES: 16856530

PCT_UTILIZED: 82.3

MAX_PCT_UTILIZED: 85.2

PHYSICAL_VOLUMES: 17

BUFF_POOL_PAGES: 65536

TOTAL_BUFFER_REQ: 5555310

CACHE_HIT_PCT: 98.6

CACHE_WAIT_PCT: 0.0

BACKUP_RUNNING: NO

BACKUP_TYPE:

NUM_BACKUP_INCR: 0

BACKUP_CHG_MB:

BACKUP_CHG_PCT: 14.5

LAST_BACKUP_DATE: 2007-07-22 16:11:23.000000

DB_REORG_EST:

DB_REORG_EST_TIME:

TSM database utilization (%)

tsm: SERVER1> SELECT pct_utilized FROM db

PCT_UTILIZED

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

82.3

TSM log recovery utilization (%)

tsm: SERVER1> SELECT pct_utilized FROM log

PCT_UTILIZED

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

0.0

Selecting specific columns from db table

tsm: SERVER1> SELECT avail_space_mb,capacity_mb, pct_utilized, max_pct_utilized,last_backup_date FROM db

AVAIL_SPACE_MB     CAPACITY_MB     PCT_UTILIZED     MAX_PCT_UTILIZED       LAST_BACKUP_DATE
--------------     -----------     ------------     ----------------     ------------------
           85000           80000             82.3                 85.2             2007-07-22
                                                                              16:11:23.000000

Number of database volumes not synchronized

tsm: SERVER1>SELECT COUNT(*) FROM dbvolumes WHERE ( NOT copy1_status='Synchronized' OR NOT copy2_status='Synchronized' OR NOT copy3_status='Synchronized' )

Unnamed[1]

-----------

Number of log volumes not synchronized

tsm: SERVER1> SELECT COUNT(*) FROM logvolumes WHERE ( NOT copy1_status='Synchronized' OR NOT copy2_status='Synchronized' OR NOT copy3_status='Synchronized' )

Unnamed[1]
-----------
0

Nodes

Number of nodes

tsm: SERVER1> SELECT SUM(num_nodes) FROM domains

Unnamed[1]

-----------

165

tsm: SERVER1> SELECT COUNT(*) FROM nodes

Unnamed[1]

-----------

165

Number of nodes per domain

tsm: SERVER1> SELECT domain_name,num_nodes FROM domains

DOMAIN_NAME NUM_NODES

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

AIX 47

EXCHANGE 4

NT 69

VMWARE 10

Number of nodes per platform

tsm: SERVER1> SELECT platform_name,COUNT(*) FROM nodes GROUP BY platform_name

PLATFORM_NAME Unnamed[2]

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

AIX 20

Linux86 36

TDP Domino 2

TDP MSSQL Win32 1

WinNT 100

Nodes locked

tsm: SERVER1> SELECT node_name FROM nodes WHERE locked='YES'

NODE_NAME

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

NODE_TEMP

NODE99

Number of nodes locked

tsm: SERVER1> SELECT COUNT(*) FROM nodes WHERE locked='YES'

Unnamed[1]

-----------

Number of nodes sessions

tsm: SERVER1> SELECT COUNT(*) FROM sessions WHERE session_type='Node'

Unnamed[1]

-----------

TSM clients version

tsm: SERVER1> SELECT node_name, VARCHAR(client_version)||'.'|| VARCHAR(client_release)||'.'|| VARCHAR(client_level)||'-'|| VARCHAR(client_sublevel) FROM nodes

NODE_NAME              Unnamed[2]
------------------     ------------------
NODE01                 5.3.4-8
NODE02                 5.3.0-14
NODE03                 5.1.6-2
NODE04                 5.3.4-0
...

Number of files per client

tsm: SERVER1> SELECT node_name, SUM(num_files) FROM occupancy GROUP BY node_name

NODE_NAME Unnamed[2]

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

NODE01 20

NODE02 18300

NODE03 1418470

NODE04 509837

...

Space and number of files stored per client

tsm: SERVER1> SELECT node_name,CAST(FLOAT(SUM(physical_mb)) / 1024 AS DEC(8,2))as "Space in GB", SUM(num_files)as"Number of files" FROM occupancy GROUP BY node_name

NODE_NAME Space in GB Number of files

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

SERVER-01 1540.50 1260371

SERVER-02 9.60 130357

SERVER-03 3279.86 1318259

SERVER-04 5191.91 310516

...

Data stored per client (GB)

tsm: SERVER1> SELECT node_name,CAST(FLOAT(SUM(logical_mb)) / 1024 AS DEC(8,2)) FROM

occupancy GROUP BY node_name

NODE_NAME Unnamed[2]

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

SERVER-01 364.01

SERVER-02 227.52

SERVER 03 8338.89

SERVER-04 3341.81

...

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]

-----------

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

Number of nodes associated per schedules

tsm: SERVER1> SELECT domain_name, schedule_name, count(*) FROM associations GROUP BY domain_name, schedule_name

DOMAIN_NAME SCHEDULE_NAME Unnamed[3]

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

AIX DAILY 24

AIX WEEKLY 17

LINUX DAILY 38

...

Information about schedules and associations (2 tables)

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

...

Drives and Paths

Some information about paths

tsm: SERVER1> SELECT source_name,source_type,destination_name,destination_type,library_name, device FROM paths

SOURCE_NAME SOURCE_TYPE DESTINATION_NAME DESTINATION_TYPE LIBRARY_NAME DEVICE

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

TSM-SERVER1 SERVER 3584 LIBRARY /dev/smc0

TSM-SERVER1 SERVER DRIVE01 DRIVE 3584 /dev/rmt0

TSM-SERVER1 SERVER DRIVE02 DRIVE 3584 /dev/rmt1

TSM-SERVER1 SERVER DRIVE03 DRIVE 3584 /dev/rmt2

TSM-SERVER1 SERVER DRIVE04 DRIVE 3584 /dev/rmt3

Some information about drives

tsm: SERVER1> SELECT library_name,drive_name,device_type, read_formats,write_formats,drive_state,

drive_serial FROM drives

LIBRARY_NAME: 3584

DRIVE_NAME: DRIVE01

DEVICE_TYPE: LTO

READ_FORMATS: ULTRIUM3C,ULTRIU

WRITE_FORMATS: ULTRIUM3C,ULTRIU

DRIVE_STATE: EMPTY

DRIVE_SERIAL: 000782XXXX

LIBRARY_NAME: 3584

DRIVE_NAME: DRIVE02

DEVICE_TYPE: LTO

READ_FORMATS: ULTRIUM3C,ULTRIU

WRITE_FORMATS: ULTRIUM3C,ULTRIU

DRIVE_STATE: LOADED

DRIVE_SERIAL: 000782XXXX

LIBRARY_NAME: 3584

DRIVE_NAME: DRIVE03

DEVICE_TYPE: LTO

READ_FORMATS: ULTRIUM3C,ULTRIU

WRITE_FORMATS: ULTRIUM3C,ULTRIU

DRIVE_STATE: LOADED

DRIVE_SERIAL: 000782XXXX

Number of drives not online

tsm: SERVER1> SELECT COUNT(*) FROM drives WHERE NOT online='YES'

Unnamed[1]

-----------

Number of drives not online in library 3584

tsm: SERVER1> SELECT COUNT(*) FROM drives WHERE NOT online='YES' and library_name='3584'

Unnamed[1]

-----------

Number of paths not online

tsm: SERVER1> SELECT COUNT(*) FROM paths WHERE NOT online='YES'

Unnamed[1]

-----------

Information about drives utilization

tsm: SERVER1> SELECT library_name, drive_name, drive_state, volume_name, allocated_to, online FROM drives

LIBRARY_NAME DRIVE_NAME DRIVE_STATE VOLUME_NAME ALLOCATED_TO ONLINE

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

LIBRARY3 DRIVE01 LOADED TAPE86 libclient_1 YES

LIBRARY3 DRIVE02 LOADED TAPE17 libclient_3 YES

LIBRARY3 DRIVE03 EMPTY YES

LIBRARY3 DRIVE04 EMPTY YES

LIBRARY3 DRIVE05 LOADED TAPE73 libclient_2 YES

LIBRARY3 DRIVE06 LOADED TAPE28 libclient_1 YES

LIBRARY3 DRIVE07 EMPTY YES

LIBRARY3 DRIVE08 LOADED TAPE66 libclient_3 YES

...

Management class

Management classes per domain

tsm: SERVER1> SELECT domain_name, set_name, class_name, defaultmc FROM mgmtclasses

DOMAIN_NAME SET_NAME CLASS_NAME DEFAULTMC

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

AIX AIX DAILY Yes

AIX AIX WEEKLY No

AIX ACTIVE DAILY Yes

AIX ACTIVE WEEKLY No

LINUX LINUX ARCH1 Yes

LINUX ACTIVE ARCH1 Yes

...

Management classes per domain of policy set ACTIVE

tsm: SERVER1> SELECT domain_name, class_name, defaultmc FROM mgmtclasses WHERE set_name='ACTIVE'

DOMAIN_NAME CLASS_NAME DEFAULTMC

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

AIX DAILY Yes

AIX WEEKLY No

LINUX ARCH1 Yes

...

Default management class per domain of policy set ACTIVE

tsm: SERVER1> SELECT domain_name, class_name, defaultmc FROM mgmtclasses WHERE set_name='ACTIVE' AND defaultmc='Yes'

DOMAIN_NAME CLASS_NAME DEFAULTMC

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

AIX AIX Yes

LINUX ARCH1 Yes

...

Management classes of a specifc domain of policy set ACTIVE

tsm: SERVER1> SELECT domain_name, class_name, defaultmc FROM mgmtclasses WHERE set_name='ACTIVE' AND domain_name='AIX'

DOMAIN_NAME CLASS_NAME DEFAULTMC

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

AIX DAILY Yes

AIX WEEKLY No

...

Management classes of policy set ACTIVE that a specific node can use

tsm: SERVER1> SELECT nodes.domain_name, nodes.node_name, mgmtclasses.class_name, mgmtclasses.defaultmc FROM nodes, mgmtclasses WHERE nodes.domain_name=mgmtclasses.domain_name AND set_name='ACTIVE' AND node_name='NODE1'

DOMAIN_NAME NODE_NAME CLASS_NAME DEFAULTMC

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

AIX NODE1 DAILY Yes

AIX NODE1 WEEKLY No

...

Management classes with backup copy group information

tsm: SERVER1> SELECT mgmtclasses.domain_name, mgmtclasses.set_name, mgmtclasses.class_name, mgmtclasses.defaultmc, bu_copygroups.verexists, bu_copygroups.verdeleted, bu_copygroups.retextra, bu_copygroups.retonly, bu_copygroups.destination FROM mgmtclasses mgmtclasses, bu_copygroups bu_copygroups WHERE mgmtclasses.domain_name = bu_copygroups.domain_name AND mgmtclasses.set_name = bu_copygroups.set_name AND mgmtclasses.class_name = bu_copygroups.class_name AND mgmtclasses.set_name='ACTIVE' ORDER BY mgmtclasses.domain_name, mgmtclasses.set_name, mgmtclasses.class_name

DOMAIN_NAME SET_NAME CLASS_NAME DEFAULTMC VEREXISTS VERDELETED RETEXTRA RETONLY DESTINATION

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

STANDARD ACTIVE STANDARD Yes 2 1 30 60 BACKUPPOOL

AIX ACTIVE MC_AIX_TDP No NOLIMIT NOLIMIT 60 60 BACKUPPOOL

AIX ACTIVE LOGBKUP No 1 1 1 90 BACKUPPOOL

AIX ACTIVE MC_AIX_DAILY YES 1 0 14 30 S3584

...

Management classes with archive copy group information

tsm: SERVER1> SELECT mgmtclasses.domain_name, mgmtclasses.set_name, mgmtclasses.class_name, mgmtclasses.defaultmc, ar_copygroups.retver, ar_copygroups.destination FROM mgmtclasses mgmtclasses, ar_copygroups ar_copygroups WHERE mgmtclasses.domain_name = ar_copygroups.domain_name AND mgmtclasses.set_name = ar_copygroups.set_name AND mgmtclasses.class_name = ar_copygroups.class_name AND mgmtclasses.set_name='ACTIVE' ORDER BY mgmtclasses.domain_name, mgmtclasses.set_name, mgmtclasses.class_name

DOMAIN_NAME SET_NAME CLASS_NAME DEFAULTMC RETVER DESTINATION

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

STANDARD ACTIVE STANDARD Yes 365 ARCHIVEPOOL

AIX ACTIVE FOREVER No NOLIMIT S3584

AIX ACTIVE MC_AIX_WEEKLY Yes 30 BACKUPPOOL

WINDOWS ACTIVE MC_WIN_WEEKLY Yes 30 BACKUPPOOL

...

Copy Groups

Destination pool of each management class (type: archive copy group)

tsm: SERVER1> SELECT domain_name, class_name, destination FROM ar_copygroups

DOMAIN_NAME CLASS_NAME DESTINATION

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

AIX MC_AIX_DAILY AIX_DAILY

AIX MC_AIX_MONTHLY AIX_MONTHLY

AIX MC_AIX_NOLIMIT AIX_NOLIMIT

...

Destination pool of each management class (type: backup copy group)

tsm: SERVER1> SELECT domain_name, class_name, destination FROM bu_copygroups WHERE set_name='ACTIVE'

DOMAIN_NAME CLASS_NAME DESTINATION

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

AIX MC_AIX_DAILY AIX_DAILY

AIX MC_AIX_TDP AIX_DAILY

...

Some information about archive copy group

tsm: SERVER1> SELECT domain_name,set_name,class_name,retver,destination FROM ar_copygroups

DOMAIN_NAME SET_NAME CLASS_NAME RETVER DESTINATION

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

AIX ACTIVE MC_AIX_DAILY 7 AIX_DAILY

AIX ACTIVE MC_AIX_MONTHLY 365 AIX_MONTHLY

AIX ACTIVE MC_AIX_NOLIMIT NOLIMIT AIX_NOLIMIT

AIX STANDARD MC_AIX_DAILY 7 AIX_DAILY

AIX STANDARD MC_AIX_MONTHLY 365 AIX_MONTHLY

AIX STANDARD MC_AIX_NOLIMIT NOLIMIT AIX_NOLIMIT

...

tsm: SERVER1> SELECT domain_name,set_name,class_name,retver,destination FROM ar_copygroups WHERE set_name='ACTIVE'

DOMAIN_NAME SET_NAME CLASS_NAME RETVER DESTINATION

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

AIX ACTIVE MC_AIX_DAILY 7 AIX_DAILY

AIX ACTIVE MC_AIX_MONTHLY 365 AIX_MONTHLY

AIX ACTIVE MC_AIX_NOLIMIT NOLIMIT AIX_NOLIMIT

...

Some information about backup copy group

tsm: SERVER1> SELECT domain_name,set_name,class_name,verexists,verdeleted,retextra,retonly,destination FROM bu_copygroups

DOMAIN_NAME SET_NAME CLASS_NAME VEREXISTS VERDELETED RETEXTRA RETONLY DESTINATION

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

AIX ACTIVE MC_AIX_DAILY 2 1 7 15 AIX_DAILY

AIX ACTIVE MC_AIX_TDP NOLIMIT NOLIMIT 15 15 AIX_DAILY

AIX STANDARD MC_AIX_DAILY 2 1 7 15 AIX_DAILY

AIX STANDARD MC_AIX_TDP NOLIMIT NOLIMIT 15 15 AIX_DAILY

...

Activity Log

Search in the activity log for missed schedules in the last 2 hours

tsm: SERVER1> SELECT date_time,message FROM actlog WHERE originator='SERVER' AND message LIKE'ANR2578W%' AND date_time>=current_timestamp-2 hours

DATE_TIME MESSAGE

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

2007-07-26 ANR2578W Schedule

14:00:01.000000 ORACLE_HOME in

domain AIX for

node SERVER-1

has missed its

scheduled start

up window.

Search in the activity log for messages with Error severity in the last 1 hour

tsm: SERVER1> SELECT date_time,message FROM actlog WHERE originator='SERVER' AND severity='E' AND date_time>current_timestamp-1 hours

DATE_TIME MESSAGE

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

2007-07-27 ANR2034E QUERY

10:22:17.000000 SPACETRIGGER: No

match found using

this criteria.(

SESSION: 252982)

Search in the activity log for successful, missed or failed schedules in the last 1 day

tsm: SERVER1> SELECT date_time,severity,message FROM actlog WHERE originator='SERVER' AND ( message LIKE'ANR2507I%' OR message LIKE'ANR2751I%' OR message LIKE'ANR2578W%' OR message LIKE'ANR2579E%') AND date_time>timestamp(current_date)-(1)days

DATE_TIME SEVERITY MESSAGE

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

2007-07-25 I ANR2507I Schedule

00:14:48.000000 IN_APP1 for domain

NT started at

07/24/07 22:30:00

for node SERVER-2

completed

successfully at

07/25/07

00:14:48.(SESSIO-

N: 233833)

2007-07-25 E ANR2579E Schedule

00:30:03.000000 INC_APP2 in domain

NT for node

SERVER-3

failed (return

code 1).(SESSION:

234285)

2007-07-25 W ANR2578W Schedule

00:40:01.000000 ORACLE_HOME in

domain AIX for

node SERVER-1

has missed its

scheduled start

up window.

Search in the activity log for a specific ANR in the last 1 day

tsm: SERVER1> SELECT date_time,severity,message from actlog WHERE message LIKE'ANR8438I%' and date_time>timestamp(current_date)-(1)days

DATE_TIME SEVERITY MESSAGE

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

2007-07-27 I ANR8438I CHECKOUT

09:21:19.000000 LIBVOLUME for

volume R00135L3

in library 3584

completed

successfully.(SE-

SSION: 252515,

PROCESS: 470)

2007-07-27 I ANR8438I CHECKOUT

09:21:28.000000 LIBVOLUME for

volume R00049L3

in library 3584

completed

successfully.(SE-

SSION: 252515,

PROCESS: 471)

8. Summary

a. Summary of archive operations in the last 7 days

b. Summary of backup operations in a specific range

c. Statistics of archive, backup, restore and retrieve operations per node in the last 7 days (GB)

d. Summary of Operations in the Last 24 Hours (GB)

e. Volumes reclaimed in the last 48 Hours

f. Volumes reclaimed in the last 48 Hours (better date format?!)

9. Volumes

a. Number of scratch volumes

b. Number of scratch volumes in library 3584

c. Number of scratch volumes for each library

d. Number of volumes per device class

e. Number of volumes per storage pool

f. Number of volumes unavailable

g. Number of volumes in error state

h. Volumes with write or read errors in the library

i. Number of volumes per library

j. Volume information ordered by (%) reclaim

k. Full volumes with utilization (%) less than XX

l. Full volumes with reclaimable space (%) greater than XX

m. Full volumes with reclaimable space (%) greater than XX in the library

n. Volumes in a specific storage pool with reclaimable space (%) greater than XX

o. Number of tapes per storage pool in the library

p. Some information about volumes in the library

q. Some information about volumes in the library - another way

r. Nodes that have data stored in a specifc volume

s. Number of nodes that have data stored per volume

t. Number of volumes in the library per owner (useful in a library manager environment)

10. Storage Pools

a. Compare size and number of files between two storage pools

b. Utilization (%) of storage pool disk_pool

c. Maximum scratch volumes allowed and number of volumes used per stgpool (needs tsm version +5.3)

11. Volume History

a. Number of full tsm db backups in the last 24 hours

b. Number of full or incremental tsm db backups in the last 24 hours

c. Information about tsm db backups in the last 48 hours

12. DRM

a. Information about drm volumes

b. Information about drm volumes in the library

c. Information about drm volumes in the library (another way)

d. Information about drm volumes in the library with state different from "MOUNTABLE"

e. Drm volumes with tsm db backups

f. Number of Volumes per DRM State

13. Sessions

a. Number of nodes sessions

b. Number of nodes sessions in Media Wait state

c. Nodes sessions in Media Wait state

d. Nodes using tapes (drives)

e. Information about sessions from a specific node

f. Performance of nodes sessions

14. Backups

a. Search a specific file from a Node

b. Search a specific file from a node with more details

c. Objects backed up of a specific node in the last 24 hours

15. Processes

a. Information about the currently running processes

16. Other

a. Total client data stored (TB)

b. Total client data stored (TB) (another way - auditocc is updated by audit lic command, take care)

c. Some TSM Server information

d. SQL Table Catalog

Summary

Summary of archive operations in the last 7 days

tsm: SERVER1> select cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as "Archive data in GB" from summary where activity='ARCHIVE' and end_time>timestamp(current_date)-(7)days

Archive data in GB

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

14508.09

Summary of backup operations in a specific range

tsm: SERVER1> SELECT CAST(FLOAT(SUM(bytes))/1024/1024/1024 AS DEC(8,2)) AS "Backed up data in GB" FROm summary WHERE activity='ARCHIVE' AND start_time >{ts '2007-06-01 00:00:00'} AND start_time <{ts '2007-07-01 00:00:00'}

Backed up data in GB

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

38829.70

Statistics of archive, backup, restore and retrieve operations per node in the last 7 days (GB)

tsm: SERVER1> SELECT entity, activity, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8,2)) FROM summary WHERE end_time>current_timestamp-(7)DAY and ( activity='ARCHIVE' OR activity='BACKUP' OR activity='RESTORE' OR activity='RETRIEVE' ) GROUP BY entity, activity

ENTITY ACTIVITY Unnamed[3]

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

SERVER-01 ARCHIVE 81.14

SERVER-01 BACKUP 261.68

SERVER-01 RESTORE 2.91

SERVER-02 ARCHIVE 171.51

SERVER-02 BACKUP 0.00

SERVER-03 ARCHIVE 17.64

SERVER-04 ARCHIVE 168.32

SERVER-04 BACKUP 530.77

...

Summary of Operations in the Last 24 Hours (GB)

tsm: SERVER1> SELECT activity, cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as "GB" FROM summary WHERE activity<>'TAPE MOUNT' AND activity<>'EXPIRATION' AND end_time>current_timestamp-24 hours GROUP BY activity

ACTIVITY GB

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

BACKUP 858.56

FULL_DBBACKUP 1.15

MIGRATION 496.28

RECLAMATION 652.14

STGPOOL BACKUP 496.10

Volumes reclaimed in the last 48 Hours

tsm: SERVER1> SELECT start_time, end_time-start_time AS ELAPTIME, activity, number, entity, mediaw, successful FROM summary WHERE activity='RECLAMATION' AND end_time>current_timestamp-48 hours

START_TIME ELAPTIME ACTIVITY NUMBER ENTITY MEDIAW SUCCESSFUL

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

2008-11-20 0 00:22:31.000000 RECLAMATION 704 DAILY (VOL076L4) 15 YES

12:00:15.000000

2008-11-20 0 00:23:01.000000 RECLAMATION 704 DAILY (VOL066L4) 13 YES

12:22:46.000000

2008-11-20 0 00:13:40.000000 RECLAMATION 704 WEEKLY (VOL008L4) 16 YES

12:45:48.000000

2008-11-22 0 00:40:18.000000 RECLAMATION 715 DAILY (VOL092L4) 51 YES

12:00:29.000000

2008-11-22 0 00:29:51.000000 RECLAMATION 715 DAILY (VOL100L4) 21 YES

12:40:47.000000

Volumes reclaimed in the last 48 Hours (better date format?!)

tsm: SERVER1> SELECT substr(char(start_time),1,19) AS START_TIME, substr(char(end_time - start_time),1,10) AS "ELAPTIME (D HHMMSS)", activity, number, entity, mediaw, successful FROM summary WHERE activity='RECLAMATION' AND end_time>current_timestamp-48 hours

START_TIME ELAPTIME (D HHMMSS) ACTIVITY NUMBER ENTITY MEDIAW SUCCESSFUL

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

2008-11-20 0 00:22:31 RECLAMATION 704 DAILY (VOL076L4) 15 YES