query occupancy command - file names

[Paul_Dudley]

The query occupancy command below shows 283 files in the bkplto6pool storage 
pool for this filespace. Is it possible to get a list of the file names?



tsm: TSMANL>query occ ANLDBPROD_SQL stgp=bkplto6pool type=backup



Node Name  Type Filespace  FSID Storage  Number of  
  Physical Logical

NamePool NameFiles  
 Space   Space


  OccupiedOccupied


  (MB)(MB)

--  --  -- --- 
--- ---

DBPROD-Bkup DBPROD-   17   BKPLTO6PO- 283 
9,771,429.0 9,771,429.0

_SQL\data\00-   OL  
0   0

 01







Thanks & Regards

Paul





Paul Dudley

IT Operations

ANL Container Line

pdud...@anl.com.au

61-3-8842-5603








ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named add
ressees. Any unauthorised dissemination or use is strictly prohibited. If you 
received
this e-mail in error, please immediately notify the sender by return e-mail 
from your s
ystem. Please do not copy, use or make reference to it for any purpose, or 
disclose its
 contents to any person.

Re: TSM Schema - what is a MB

[Maurice van 't Loo]

It's actually MiB, so based on 1024 per k.

Regards,
Maurice van 't Loo

2016-08-03 19:19 GMT+02:00 Rhodes, Richard L. :

> This is probably a dumb question, but I can't seem to find the answer.
>
> In the TSM DB2 schema, where fields are labeled _MB, does MB
> mean units of 1,000,000 or 1,048,576?
>
> For example,
>
> field:  TSMDB1 OCCUPANCY PHYSICAL_MB  DECIMAL 14
>
> If I get a value of 123, is that 123 units of 1,000,000, or is it 123456
> units of 1048576?
>
>
> Thanks
>
> Rick
>

TSM Schema - what is a MB

[Rhodes, Richard L.]

This is probably a dumb question, but I can't seem to find the answer.

In the TSM DB2 schema, where fields are labeled _MB, does MB mean 
units of 1,000,000 or 1,048,576?

For example,

field:  TSMDB1 OCCUPANCY PHYSICAL_MB  DECIMAL 14

If I get a value of 123, is that 123 units of 1,000,000, or is it 123456 units 
of 1048576?


Thanks

Rick