2006-3-10 16:03
aixstudy
TSM q system 所显示的信息分析,交流交流
q system 所显示的信息分析:
************************************************
*** ---> Q STATUS 系统状态
**************************************************
Storage Management Server for AIX-RS/6000 - Version 5, Release 2, Level 2.0
Server Name: TSM
Server host name or IP address:
Server TCP/IP port number: 1500
Server URL:
Crossdefine: Off
Server Password Set: No
Server Installation Date/Time: 03/07/06 19:20:34
Server Restart Date/Time: 03/09/06 04:15:06
Authentication: On
Password Expiration Period: 90 Day(s)
Invalid Sign-on Attempt Limit: 0
Minimum Password Length: 0
WEB Admin Authentication Time-out (minutes): 720
Registration: Closed
Subfile Backup: No
Availability: Enabled
Accounting: Off
Activity Log Retention Period: 1 Day(s)
Activity Summary Retention Period: 30 Day(s)
License Audit Period: 30 Day(s)
Last License Audit: 03/07/06 19:21:51
Server License Compliance: Valid
Central Scheduler: Active
Maximum Sessions: 25
Maximum Scheduled Sessions: 12
Event Record Retention Period: 10 Day(s)
Client Action Duration: 5 Day(s)
Schedule Randomization Percentage: 25
Query Schedule Period: Client
Maximum Command Retries: Client
Retry Period: Client
Scheduling Modes: Any
Log Mode: Normal
Database Backup Trigger: Not Defined
BufPoolSize: 2,048 K
Active Receivers: CONSOLE ACTLOG
Configuration manager?: Off
Refresh interval: 60
Last refresh date/time:
Context Messaging: Off
Server-free Status: Not Supported
Server-free Batch Size:
Table of Contents (TOC) Load Retention: 120 Minute(s)
Machine Globally Unique ID: 70.43.83.36.ad.cc.11.da.a5.63.08.6
3.c0.a8.01.32
Archive Retention Protection: Off
**************************************************
*** ---> Q OPTION
**************************************************
Server Option Option Setting Server Option Option Setting
----------------- -------------------- ----------------- --------------------
CommTimeOut 60 IdleTimeOut 15
BufPoolSize 2048 LogPoolSize 512
MessageFormat 1 Language en_US
Alias Halt HALT MaxSessions 25
ExpInterval 24 ExpQuiet No
EventServer Yes MirrorRead DB Normal
MirrorRead LOG Normal MirrorWrite DB Sequential
MirrorWrite LOG Parallel TxnGroupMax 40
MoveBatchSize 40 MoveSizeThresh 500
StatusMsgCnt 10 RestoreInterval 1,440
UseLargeBuffers Yes DisableScheds No
NOBUFPREfetch No AuditStorage Yes
REQSYSauthoutfile Yes SELFTUNEBUFpools No
ize
SELFTUNETXNsize No DBPAGEShadow No
DBPAGESHADOWFile dbpgshdw.bdt MsgStackTrace On
QueryAuth None LogWarnFullPerCe 90
nt
ThroughPutDataTh 0 ThroughPutTimeTh 0
reshold reshold
NOPREEMPT ( No ) Resource Timeout 60
TEC UTF8 Events No
TCPPort 1500 TcpAdminport 1500
HTTPPort 1580 TCPWindowsize 0
TCPBufsize 16384 TCPNoDelay No
CommMethod TCPIP CommMethod ShMem
CommMethod HTTP MsgInterval 1
ShmPort 1510 FileExit
UserExit FileTextExit
AssistVCRRecovery Yes AcsAccessId
AcsTimeoutX 1 AcsLockDrive No
AcsQuickInit No SNMPSubagentPort 1521
SNMPSubagentHost 127.0.0.1 SNMPHeartBeatInt 5
TECHost TECPort 0
UNIQUETECevents No UNIQUETDPTECeven No
ts
Async I/O No Direct I/O Yes
SHAREDLIBIDLE No 3494Shared No
**************************************************
*** ---> Q PROCESS
**************************************************
ANR0944E QUERY PROCESS: No active processes found.
**************************************************
*** ---> Q SESSION
**************************************************
Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name
Number Meth State Time Sent Recvd Type
od
------ ------ ------ ------ ------- ------- ----- -------- --------------------
633 HTTP Run 0 S 0 0 Admin WebBrow ADMIN
ser
**************************************************
*** ---> Q DB F=D
**************************************************
Available Space (MB): 316
Assigned Capacity (MB): 16
Maximum Extension (MB): 300
Maximum Reduction (MB): 12
Page Size (bytes): 4,096
Total Usable Pages: 4,096
Used Pages: 271
Pct Util: 6.6
Max. Pct Util: 7.0
Physical Volumes: 2
Buffer Pool Pages: 512
Total Buffer Requests: 23,425
Cache Hit Pct.: 99.29
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 1.12
Percentage Changed: 105.54
Last Complete Backup Date/Time:
**************************************************
*** ---> Q DBVOLUME * F=D
**************************************************
Volume Name (Copy 1): /usr/tivoli/tsm/server/bin/db.dsm
Copy Status: Sync'd
Volume Name (Copy 2):
Copy Status: Undefined
Volume Name (Copy 3):
Copy Status: Undefined
Available Space (MB): 16
Allocated Space (MB): 16
Free Space (MB): 0
Volume Name (Copy 1): /usr/tivoli/tsm/server/bin/db01.dsm
Copy Status: Sync'd
Volume Name (Copy 2):
Copy Status: Undefined
Volume Name (Copy 3):
Copy Status: Undefined
Available Space (MB): 300
Allocated Space (MB): 0
Free Space (MB): 300
**************************************************
*** ---> Q LOG F=D
**************************************************
Available Space (MB): 88
Assigned Capacity (MB): 8
Maximum Extension (MB): 80
Maximum Reduction (MB): 4
Page Size (bytes): 4,096
Total Usable Pages: 1,536
Used Pages: 240
Pct Util: 15.6
Max. Pct Util: 16.6
Physical Volumes: 2
Log Pool Pages: 128
Log Pool Pct. Util: 0.31
Log Pool Pct. Wait: 0.00
Cumulative Consumption (MB): 7.81
Consumption Reset Date/Time: 03/07/06 19:20:37
**************************************************
*** ---> Q LOGVOLUME * F=D
**************************************************
Volume Name (Copy 1): /usr/tivoli/tsm/server/bin/log.dsm
Copy Status: Sync'd
Volume Name (Copy 2):
Copy Status: Undefined
Volume Name (Copy 3):
Copy Status: Undefined
Available Space (MB): 8
Allocated Space (MB): 8
Free Space (MB): 0
Volume Name (Copy 1): /usr/tivoli/tsm/server/bin/log01.dsm
Copy Status: Sync'd
Volume Name (Copy 2):
Copy Status: Undefined
Volume Name (Copy 3):
Copy Status: Undefined
Available Space (MB): 80
Allocated Space (MB): 0
Free Space (MB): 80
***************************************************** ---> Q VOLUME **************************************************
Volume Name Storage Po Device Cl Estimated Pct Volume
ol Name ass Name Capacity Util Status
(MB)
------------------------ ----------- ---------- --------- ----- --------
/usr/tivoli/tsm/server/ ARCHIVEPOOL DISK 8.0 0.0 On-Line
bin/archive.dsm
/usr/tivoli/tsm/server/ BACKUPPOOL DISK 8.0 0.0 On-Line
bin/backup.dsm
/usr/tivoli/tsm/server/ SPACEMGPOOL DISK 8.0 0.0 On-Line
bin/spcmgmt.dsm
***************************************************** ---> Q STGPOOL * F=D **************************************************
Storage Pool Name: ARCHIVEPOOL
Storage Pool Type: Primary
Device Class Name: DISK
Estimated Capacity (MB): 8.0
Pct Util: 0.0
Pct Migr: 0.0
Pct Logical: 100.0
High Mig Pct: 90
Low Mig Pct: 70
Migration Delay: 0
Migration Continue: Yes
Migration Processes: 1
Next Storage Pool:
Reclaim Storage Pool:
Maximum Size Threshold: No Limit
Access: Read/Write
Description:
Overflow Location:
Cache Migrated Files?: No
Collocate?:
Reclamation Threshold:
Maximum Scratch Volumes Allowed:
Delay Period for Volume Reuse:
Migration in Progress?: No
Amount Migrated (MB): 0.00
Elapsed Migration Time (seconds): 0
Reclamation in Progress?:
Volume Being Migrated/Reclaimed:
Last Update by (administrator): SERVER_CONSOLE
Last Update Date/Time: 03/07/06 19:20:53
Storage Pool Data Format: Native
Copy Storage Pool(s):
Continue Copy on Error?:
CRC Data: No
Storage Pool Name: BACKUPPOOL
Storage Pool Type: Primary
Device Class Name: DISK
Estimated Capacity (MB): 8.0
Pct Util: 0.0
Pct Migr: 0.0
Pct Logical: 100.0
High Mig Pct: 90
Low Mig Pct: 70
Migration Delay: 0
Migration Continue: Yes
Migration Processes: 1
Next Storage Pool:
Reclaim Storage Pool:
Maximum Size Threshold: No Limit
Access: Read/Write
Description:
Overflow Location:
Cache Migrated Files?: No
Collocate?:
Reclamation Threshold:
Maximum Scratch Volumes Allowed:
Delay Period for Volume Reuse:
Migration in Progress?: No
Amount Migrated (MB): 0.00
Elapsed Migration Time (seconds): 0
Reclamation in Progress?:
Volume Being Migrated/Reclaimed:
Last Update by (administrator): SERVER_CONSOLE
Last Update Date/Time: 03/07/06 19:20:53
Storage Pool Data Format: Native
Copy Storage Pool(s):
Continue Copy on Error?:
CRC Data: No
Storage Pool Name: DB2_POOL
Storage Pool Type: Primary
Device Class Name: DB2
Estimated Capacity (MB): 0.0
Pct Util: 0.0
Pct Migr: 0.0
Pct Logical: 100.0
High Mig Pct: 90
Low Mig Pct: 70
Migration Delay: 0
Migration Continue: Yes
Migration Processes:
Next Storage Pool:
Reclaim Storage Pool:
Maximum Size Threshold: 1
Access: Read/Write
Description:
Overflow Location:
Cache Migrated Files?:
Collocate?: No
Reclamation Threshold: 60
Maximum Scratch Volumes Allowed: 5
Delay Period for Volume Reuse: 0 Day(s)
Migration in Progress?: No
Amount Migrated (MB): 0.00
Elapsed Migration Time (seconds): 0
Reclamation in Progress?: No
Volume Being Migrated/Reclaimed:
Last Update by (administrator): ADMIN
Last Update Date/Time: 03/09/06 01:53:34
Storage Pool Data Format: Native
Copy Storage Pool(s):
Continue Copy on Error?:
CRC Data: No
Storage Pool Name: SPACEMGPOOL
Storage Pool Type: Primary
Device Class Name: DISK
Estimated Capacity (MB): 8.0
Pct Util: 0.0
Pct Migr: 0.0
Pct Logical: 100.0
High Mig Pct: 90
Low Mig Pct: 70
Migration Delay: 0
Migration Continue: Yes
Migration Processes: 1
Next Storage Pool:
Reclaim Storage Pool:
Maximum Size Threshold: No Limit
Access: Read/Write
Description:
Overflow Location:
Cache Migrated Files?: No
Collocate?:
Reclamation Threshold:
Maximum Scratch Volumes Allowed:
Delay Period for Volume Reuse:
Migration in Progress?: No
Amount Migrated (MB): 0.00
Elapsed Migration Time (seconds): 0
Reclamation in Progress?:
Volume Being Migrated/Reclaimed:
Last Update by (administrator): SERVER_CONSOLE
Last Update Date/Time: 03/07/06 19:20:54
Storage Pool Data Format: Native
Copy Storage Pool(s):
Continue Copy on Error?:
CRC Data: No
**************************************************
*** ---> Q DOMAIN
**************************************************
Policy D Activated Activated Number of Description
omain Na Policy S Default Register
me et Mgmt Cla ed Nodes
ss
--------- --------- --------- ---------- ------------------------
DB2 DB2_SET DB2_MC 1
STANDARD STANDARD STANDARD 1 Installed default policy
domain.
**************************************************
*** ---> Q MGMTCLASS
**************************************************
Policy D Policy S Mgmt Cla Default Description
omain Na et Name ss Name Mgmt Cla
me ss ?
--------- --------- --------- --------- ------------------------
DB2 ACTIVE DB2_MC Yes
DB2 DB2_SET DB2_MC Yes
STANDARD ACTIVE STANDARD Yes Installed default manag
ement class.
STANDARD STANDARD STANDARD Yes Installed default manag
ement class.
**************************************************
*** ---> Q COPYGROUP * * * STANDARD TYPE=BACKUP
**************************************************
Policy D Policy S Mgmt Cla Copy Gro Versions Versions Retain Retain
omain Na et Name ss Name up Name Data Ex Data De Extra V Only
me ists leted ersions Version
--------- --------- --------- --------- -------- -------- -------- -------
DB2 ACTIVE DB2_MC STANDARD 2 1 30 60
DB2 DB2_SET DB2_MC STANDARD 2 1 30 60
STANDARD ACTIVE STANDARD STANDARD 2 1 30 60
STANDARD STANDARD STANDARD STANDARD 2 1 30 60
**************************************************
*** ---> Q COPYGROUP * * * STANDARD TYPE=ARCHIVE
**************************************************
Policy D Policy S Mgmt Cla Copy Gro Retain
omain Na et Name ss Name up Name Version
me
--------- --------- --------- --------- --------
STANDARD ACTIVE STANDARD STANDARD 365
STANDARD STANDARD STANDARD STANDARD 365
**************************************************
*** ---> Q SCHEDULE
**************************************************
ANR2034E QUERY SCHEDULE: No match found using this criteria.
**************************************************
*** ---> Q ASSOCIATION
**************************************************
ANR2034E QUERY ASSOCIATION: No match found using this criteria.
**************************************************
*** ---> Q DEVCLASS * F=D
**************************************************
Device Class Name: DB2
Device Access Strategy: Sequential
Storage Pool Count: 1
Device Type: FILE
Format: DRIVE
Est/Max Capacity (MB): 1,000.0
Mount Limit: 1
Mount Wait (min):
Mount Retention (min):
Label Prefix:
Library:
Directory: /tape
Server Name:
Retry Period:
Retry Interval:
Shared:
High-level Address:
Minimum Capacity:
WORM: No
Scaled Capacity:
Last Update by (administrator): ADMIN
Last Update Date/Time: 03/09/06 01:48:22
Device Class Name: DISK
Device Access Strategy: Random
Storage Pool Count: 3
Device Type:
Format:
Est/Max Capacity (MB):
Mount Limit:
Mount Wait (min):
Mount Retention (min):
Label Prefix:
Library:
Directory:
Server Name:
Retry Period:
Retry Interval:
Shared:
High-level Address:
Minimum Capacity:
WORM: No
Scaled Capacity:
Last Update by (administrator):
Last Update Date/Time: 03/07/06 19:20:34
**************************************************
*** ---> select platform_name,count(*) from nodes group by platform_name
**************************************************
PLATFORM_NAME Unnamed[2]
---------------- -----------
2
**************************************************
*** ---> select stgpool_name,devclass_name,count(*) as "VOLUMES" from volumes group by stgpool_name,devclass_name
**************************************************
STGPOOL_NAME DEVCLASS_NAME VOLUMES
------------------ ------------------ -----------
ARCHIVEPOOL DISK 1
BACKUPPOOL DISK 1
SPACEMGPOOL DISK 1