ADSM-L

Re: [ADSM-L] Select from occupancy numfiles aberration

2017-12-13 12:08:35
Subject: Re: [ADSM-L] Select from occupancy numfiles aberration
From: Richard Cowen <rcowen AT CPPASSOCIATES DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 13 Dec 2017 17:03:12 +0000
Has anyone seen a case when a select from occupancy returns rows where the 
NUMFILES columns is acting as an accumulator?
SP 7.1.7.100

The command.

select 
NODE_NAME,TYPE,FILESPACE_NAME,STGPOOL_NAME,NUM_FILES,PHYSICAL_MB,LOGICAL_MB,REPORTING_MB,FILESPACE_ID
 from occupancy

Here is a sample output.

NODE_NAME,TYPE,FILESPACE_NAME,STGPOOL_NAME,NUM_FILES
SRV1UPPCSXODB01,Bkup,/backup,POOL1,1
SRV1UPWSEXODB10,Bkup,/tmp/SECUPD,POOL1,1
SRV1UPWSEXODB20,Bkup,/tmp/SECUPD,POOL1,1
SRV1UPPCSXODB01,Bkup,/admin,POOL1,1
SRV1UPPCSXODB01,Bkup,/db_backup,POOL1,1
SRV1UP451XAPP20,Bkup,/vol,POOL1,1
SRV1WPSPVEAPP12_DM01,Bkup,\VMFULL-srv1uppgukweb04,POOL1,1
SRV2_DC,Bkup,\VMFULL-provtest,POOL1,1
SRV1UPDADXODB01,Bkup,/usr4,POOL1,1
SRV1UPDADXODB01,Bkup,/usr3,POOL1,1
SRV1UPPGUKODB01,Bkup,/usr2,POOL1,1
SRV1UPINFMODB03,Bkup,/opt/InformBak,POOL1,2
SRV1UPWSEXODB21,Bkup,/tmp/SECUPD,POOL1,2
SRV2UCDADXODB-1,Bkup,/usr2,POOL1,3
SRV1UDSIMBODB01,Bkup,/usr2,POOL1,3
SRV1UPINFMODB04,Bkup,/opt/InformBak,POOL1,3
DELETED,Bkup,DELETED,POOL1,4
.....
SRV2UPCLMODB002,Bkup,/data1,POOL1,423068
SRV2UPPGUKODB01,Bkup,/usr1,POOL1,435623
SRV1UCWCMXODB01,Bkup,/usr1,POOL1,443582
SRV2UCWCMXODB01,Bkup,/usr1,POOL1,459086
SRV1UDEDIXAPP02,Bkup,/appdev,POOL1,489339
SRV1UDRASXODB01,Bkup,/usr1,POOL1,573502
SRV1UDEDIXAPP01,Bkup,/appdev,POOL1,635843
SRV2UDSIGEODB01,Bkup,/usr1,POOL1,743718
SRV2UCSIGEODB01,Bkup,/usr1,POOL1,800956
SRV2UCSIMBODB-4,Bkup,/usr1,POOL1,862419
SRV1UDRASXAPP01,Bkup,/usr1,POOL1,901929
SRV2UPSIGEODB01,Bkup,/usr1,POOL1,950103
SRV2UPSIMBODB-4,Bkup,/usr1,POOL1,981091
SRV1UPWSEXODB21,Bkup,/u01,POOL1,1076243
SRV2UPSIBPODB-1,Bkup,/usr1,POOL1,1106236
SRV1UPWSEXODB20,Bkup,/u01,POOL1,1119196

Thanks for any ideas...

Richard

<Prev in Thread] Current Thread [Next in Thread>

ADSM.ORG Privacy and Data Security by KimLaw, PLLC