Re: [ADSM-L] TSM v6.3 schema for log table

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. <
rrhodes AT firstenergycorp DOT 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_MB    DECIMAL      10
> TSMDB1 LOG ARCHLOG_USED_FS_MB   DECIMAL      10
> TSMDB1 LOG ARCH_LOG_DIR         VARCHAR      220
> TSMDB1 LOG FREE_SPACE_MB        DECIMAL      10
> TSMDB1 LOG MIRLOG_FREE_FS_MB    DECIMAL      10
> TSMDB1 LOG MIRLOG_TOL_FS_MB     DECIMAL      10
> TSMDB1 LOG MIRLOG_USED_FS_MB    DECIMAL      10
> TSMDB1 LOG MIRROR_LOG_DIR       VARCHAR      220
> TSMDB1 LOG TOTAL_SPACE_MB       DECIMAL      10
> TSMDB1 LOG USED_SPACE_MB        DECIMAL      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
zforray AT vcu DOT 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