Welcome! » Log In » Create A New Profile

Re: Select from occupancy numfiles aberration

Posted by Richard Cowen 
Richard Cowen
Re: Select from occupancy numfiles aberration
December 13, 2017 09:59AM
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
This message was imported via the External PhorumMail Module
Sorry, only registered users may post in this forum.

Click here to login