Re: Re: Query help joining 2 tables

2020-01-17 Thread Bronder, David M
Note that the occupancy counts will also include archive and HSM files, which may or may not be expected, unless you add "AND OC.Type='Bkup'" to the outer WHERE clause. Another thing that can inflate the occupancy counts (again, may or may not be expected) is use of traditional copy pools. =Dave

Re: Query help joining 2 tables

2020-01-17 Thread Hall, Lynn
Discovered a join problem. Need to have both node_name and Filespace_ID in the equivalence between the tables. Otherwise you are joining only on the Filespace_ID which can be the same for multiple nodes. Thus giving large errors. SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name,

Adoption of Cloud Container Storage Pools

2020-01-17 Thread Jansen, Jonas
Hi, is there anybody out there using cloud container storage pools at bigger scale? We plan to replace abbot 1.5PB of disk by cloud container storage pools using RedHat Ceph 3 as Cloud target. Are there known pitfalls? Kind regards, Jonas --- Jonas Jansen IT Center Gruppe: Server &