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
