You can't easily see files on the server.  You can see filespaces, disks or
mount points, though.  The server didn't back up the file so the server
can't restore it or even see it, again easily.  There are some show
commands that can peer at files, but they aren't supported.

If you are interested in seeing utilization statistics, not at the file
level, try query occupancy.

Kelly