chad_small
ADSM.ORG Moderator
- Joined
- Dec 17, 2002
- Messages
- 2,262
- Reaction score
- 52
- Points
- 0
- Location
- Gilbert, AZ
- Website
- www.tsmadmin.com
When querying the occupancy table I came across something odd when it appeared the results were way off.
Protect: TSM50>select varchar(node_name,45)as NODE_NAME, varchar(filespace_name,20)as FS_NAME, -
cont> sum(reporting_mb) as REPORTING_MB from occupancy group by node_name, filespace_name -
cont> order by reporting_mb desc
NODE_NAME FS_NAME REPORTING_MB
---------------------------------------------- ----------- ------------------
1046718101.64
AD00018.CLT01.ULX.DEC1.AS19229.NET.ORA /adsmorc 115977163.30
AD00055.CLT01.ULX.DEC1.AS19229.NET.ORA /adsmorc 75026959.52
Notice the first line shows no NODE_NAME and no FILESPACE_NAME
Protect: TSM50>select * from occupancy where node_name=''
NODE_NAME:
TYPE:
FILESPACE_NAME:
STGPOOL_NAME: STG-CNTR-ARCH-DISK
NUM_FILES: 47118
PHYSICAL_MB:
LOGICAL_MB:
REPORTING_MB: 4570827.69
FILESPACE_ID:
NODE_NAME:
TYPE:
FILESPACE_NAME:
STGPOOL_NAME: STG-CNTR-DISK
NUM_FILES: 113703772
PHYSICAL_MB:
LOGICAL_MB:
REPORTING_MB: 1042147273.95
FILESPACE_ID:
Anyone seen this before?
Protect: TSM50>select varchar(node_name,45)as NODE_NAME, varchar(filespace_name,20)as FS_NAME, -
cont> sum(reporting_mb) as REPORTING_MB from occupancy group by node_name, filespace_name -
cont> order by reporting_mb desc
NODE_NAME FS_NAME REPORTING_MB
---------------------------------------------- ----------- ------------------
1046718101.64
AD00018.CLT01.ULX.DEC1.AS19229.NET.ORA /adsmorc 115977163.30
AD00055.CLT01.ULX.DEC1.AS19229.NET.ORA /adsmorc 75026959.52
Notice the first line shows no NODE_NAME and no FILESPACE_NAME
Protect: TSM50>select * from occupancy where node_name=''
NODE_NAME:
TYPE:
FILESPACE_NAME:
STGPOOL_NAME: STG-CNTR-ARCH-DISK
NUM_FILES: 47118
PHYSICAL_MB:
LOGICAL_MB:
REPORTING_MB: 4570827.69
FILESPACE_ID:
NODE_NAME:
TYPE:
FILESPACE_NAME:
STGPOOL_NAME: STG-CNTR-DISK
NUM_FILES: 113703772
PHYSICAL_MB:
LOGICAL_MB:
REPORTING_MB: 1042147273.95
FILESPACE_ID:
Anyone seen this before?
Last edited: