dicowins
ADSM.ORG Member
I created this script
'select cast((NODE_NAME) as char(20)) as "NODE",cast((REPORTING_MB) as char(20)) as "MB",cast((FILESPACE_NAME) as char(50)) as "FS",TYPE from OCCUPANCY where REPORTING_MB>0.00'
This is the Structure of OCCUPANCY
Fieldname Length
--------------------------------------------------- ---------------------
FILESPACE_ID 4
FILESPACE_NAME 1025
LOGICAL_MB 31
NODE_NAME 65
NUM_FILES 8
PHYSICAL_MB 31
REPORTING_MB 31
STGPOOL_NAME 31
TYPE 4
However when I run script
NODE MB FS TYPE
----------------- --------------------- ----------------------------------------------------------------------------------------------------- -----
N1IBNPRP01 29.37 /usr/local Bkup
RV_RVI_DATACENTE .02 \VMFULL-NUTHMirthPRD Bkup
FV_FH_DATACENTER .79 \VMFULL-NUTH-FOM05 Bkup
RV_RVI_DATACENTE .83 \VMFULL-VIRTUAL-SQL Bkup
RV_RVI_DATACENTE should be RV_RVI_DATACENTER !
Edited by marclant to fix font size to be readable.
'select cast((NODE_NAME) as char(20)) as "NODE",cast((REPORTING_MB) as char(20)) as "MB",cast((FILESPACE_NAME) as char(50)) as "FS",TYPE from OCCUPANCY where REPORTING_MB>0.00'
This is the Structure of OCCUPANCY
Fieldname Length
--------------------------------------------------- ---------------------
FILESPACE_ID 4
FILESPACE_NAME 1025
LOGICAL_MB 31
NODE_NAME 65
NUM_FILES 8
PHYSICAL_MB 31
REPORTING_MB 31
STGPOOL_NAME 31
TYPE 4
However when I run script
NODE MB FS TYPE
----------------- --------------------- ----------------------------------------------------------------------------------------------------- -----
N1IBNPRP01 29.37 /usr/local Bkup
RV_RVI_DATACENTE .02 \VMFULL-NUTHMirthPRD Bkup
FV_FH_DATACENTER .79 \VMFULL-NUTH-FOM05 Bkup
RV_RVI_DATACENTE .83 \VMFULL-VIRTUAL-SQL Bkup
RV_RVI_DATACENTE should be RV_RVI_DATACENTER !
Edited by marclant to fix font size to be readable.
Last edited by a moderator: