2012年9月19日

TSM4升級6.2.1 -> 6.2.4


因使用SQL語法無法顯示SpMg type欄,系統建議升級至6.2.3,目前最新為6.2.4,故升級之
http://www-01.ibm.com/support/docview.wss?uid=swg1IC70800

這次升級應該也會解決之前DB Backup link error情形

APAR status
Closed as program error.
Error description
When using SQL to query the OCCUPANCY table,  the columns

 - TYPE
 - FILESPACE_NAME
 - FILESPACE_ID

will be blank for file systems containing space managed data.

NODE_NAME: GPFS_CLUSTER
TYPE:                                            <====
FILESPACE_NAME:                                  <====
STGPOOL_NAME: SMSTGP
NUM_FILES: 1
PHYSICAL_MB: 8.19
LOGICAL_MB: 8.19
REPORTING_MB: 1512.65
FILESPACE_ID:                                    <====

A QUERY OCCUPANCY against the same file space produces the
expected results.

GPFS_CLUSTER SpMg /gpfsdata 2 SMSTGP 1 8.19 8.19
Local fix
Use QUERY OCCUPANCY instead of SELECT FROM OCCUPANCY.
Problem summary
****************************************************************
* USERS AFFECTED: All Tivoli Storage Manager server users.     *
****************************************************************
* PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
****************************************************************
* RECOMMENDATION: Apply fixing level when available. This      *
*                 problem is currently projected to be fixed   *
*                 in levels 6.1.5 and 6.2.3.                   *
*                 Note that this is subject to change at       *
*                 the discretion of IBM.                       *
****************************************************************
*
Problem conclusion
This problem was fixed.
Affected platforms: AIX, HP-UX, Sun Solaris, Linux, Windows .