TSM v6.3 schema for log table

2015-02-25 Thread Rhodes, Richard L.
The v6.3 schema has the following entries:

TSMDB1 LOG ACTIVE_LOG_DIR   VARCHAR  220
TSMDB1 LOG AFAILOVER_FREE_FS_MB DECIMAL  10
TSMDB1 LOG FAILOVER_LOG_DIR VARCHAR  220
TSMDB1 LOG AFAILOVER_TOL_FS_MB  DECIMAL  10
TSMDB1 LOG AFAILOVER_USED_FS_MB DECIMAL  10
TSMDB1 LOG ARCHLOG_FREE_FS_MB   DECIMAL  10
TSMDB1 LOG ARCHLOG_TOL_FS_MBDECIMAL  10
TSMDB1 LOG ARCHLOG_USED_FS_MB   DECIMAL  10
TSMDB1 LOG ARCH_LOG_DIR VARCHAR  220
TSMDB1 LOG FREE_SPACE_MBDECIMAL  10
TSMDB1 LOG MIRLOG_FREE_FS_MBDECIMAL  10
TSMDB1 LOG MIRLOG_TOL_FS_MB DECIMAL  10
TSMDB1 LOG MIRLOG_USED_FS_MBDECIMAL  10
TSMDB1 LOG MIRROR_LOG_DIR   VARCHAR  220
TSMDB1 LOG TOTAL_SPACE_MB   DECIMAL  10
TSMDB1 LOG USED_SPACE_MBDECIMAL  10

Is this correct - that free_space_mb, total_space_mb, and used_space_mb apply 
to active_log_dir??  That is, the MB for these entries are related to the 
ACTIVE_LOG_DIR _only_.  I assume this because failover, arch and mir log 
entries have their own MB entries.

Thanks

Rick



-
The information contained in this message is intended only for the personal and 
confidential use of the recipient(s) named above. If the reader of this message 
is not the intended recipient or an agent responsible for delivering it to the 
intended recipient, you are hereby notified that you have received this 
document in error and that any review, dissemination, distribution, or copying 
of this message is strictly prohibited. If you have received this communication 
in error, please notify us immediately, and delete the original message.


Re: TSM v6.3 schema for log table

2015-02-25 Thread Zoltan Forray
Seems to be.  This is what I get from a Q LOG F=D

10:17:31 AM   HADES : q log f=d
  Active Log Directory: /tsmlog
   Total Space(MB): 65,536
Used Space(MB): 569
Free Space(MB): 64,967
 Archive Log Directory: /tsmarchlog
Total Size of File System (MB): 201,586.68
Space Used on File System (MB): 18,709.09
Free Space(MB): 182,877.59
  Mirror Log Directory:
Total Size of File System (MB):
Space Used on File System (MB):
Free Space(MB):
Archive Failover Log Directory:
Total Size of File System (MB):
Space Used on File System (MB):
Free Space(MB):

This is a .csv output from TSMManager Database Explorer utility of the LOG
table:

ACTIVE_LOG_DIR,AFAILOVER_FREE_FS_MB,AFAILOVER_LOG_DIR,AFAILOVER_TOL_FS_MB,AFAILOVER_USED_FS_MB,ARCHLOG_FREE_FS_MB,ARCHLOG_TOL_FS_MB,ARCHLOG_USED_FS_MB,ARCH_LOG_DIR,FREE_SPACE_MB,MIRLOG_FREE_FS_MB,MIRLOG_TOL_FS_MB,MIRLOG_USED_FS_MB,MIRROR_LOG_DIR,TOTAL_SPACE_MB,USED_SPACE_MB,
/tsmlog,182877.00,201586.00,18709.00,/tsmarchlog,64967.00,65536.00,569.00,



On Wed, Feb 25, 2015 at 9:43 AM, Rhodes, Richard L. 
rrho...@firstenergycorp.com wrote:

 The v6.3 schema has the following entries:

 TSMDB1 LOG ACTIVE_LOG_DIR   VARCHAR  220
 TSMDB1 LOG AFAILOVER_FREE_FS_MB DECIMAL  10
 TSMDB1 LOG FAILOVER_LOG_DIR VARCHAR  220
 TSMDB1 LOG AFAILOVER_TOL_FS_MB  DECIMAL  10
 TSMDB1 LOG AFAILOVER_USED_FS_MB DECIMAL  10
 TSMDB1 LOG ARCHLOG_FREE_FS_MB   DECIMAL  10
 TSMDB1 LOG ARCHLOG_TOL_FS_MBDECIMAL  10
 TSMDB1 LOG ARCHLOG_USED_FS_MB   DECIMAL  10
 TSMDB1 LOG ARCH_LOG_DIR VARCHAR  220
 TSMDB1 LOG FREE_SPACE_MBDECIMAL  10
 TSMDB1 LOG MIRLOG_FREE_FS_MBDECIMAL  10
 TSMDB1 LOG MIRLOG_TOL_FS_MB DECIMAL  10
 TSMDB1 LOG MIRLOG_USED_FS_MBDECIMAL  10
 TSMDB1 LOG MIRROR_LOG_DIR   VARCHAR  220
 TSMDB1 LOG TOTAL_SPACE_MB   DECIMAL  10
 TSMDB1 LOG USED_SPACE_MBDECIMAL  10

 Is this correct - that free_space_mb, total_space_mb, and used_space_mb
 apply to active_log_dir??  That is, the MB for these entries are related to
 the ACTIVE_LOG_DIR _only_.  I assume this because failover, arch and mir
 log entries have their own MB entries.

 Thanks

 Rick



 -

 The information contained in this message is intended only for the
 personal and confidential use of the recipient(s) named above. If the
 reader of this message is not the intended recipient or an agent
 responsible for delivering it to the intended recipient, you are hereby
 notified that you have received this document in error and that any review,
 dissemination, distribution, or copying of this message is strictly
 prohibited. If you have received this communication in error, please notify
 us immediately, and delete the original message.




-- 
*Zoltan Forray*
TSM Software  Hardware Administrator
Hobbit / Xymon Administrator
Virginia Commonwealth University
UCC/Office of Technology Services
zfor...@vcu.edu - 804-828-4807
Don't be a phishing victim - VCU and other reputable organizations will
never use email to request that you reply with your password, social
security number or confidential personal information. For more details
visit http://infosecurity.vcu.edu/phishing.html