I tried the DSPTAP command but it only shows the size of the objects saved, there is no indication on how much space is still available.
I tried the DSPTAP command but it only shows the size of the objects saved, there is no indication on how much space is still available.
There's no way to know how much space is left on a tape mostly because this is abstracted away from the system (hardware compression, etc make it difficult to predict how much capacity is available on a tape in the first place). This isn't so much an AS/400 limitation as it is a limit in how tape devices are visible on any platform.
All you can do is issue
DSPTAP DEV(TAPXX) DATA(*SAVRST) OUTPUT(*PRINT)
to review what is on the tape, and compare that to the stated capacity figures for the type of tape you're using, but this won't give you a hard figure as to how much space is left.The ibm answer: http://www-01.ibm.com/support/docview.wss?uid=nas8N1015190 says that you could use print dsptap output to calculate (by hand) the amount of data written to the tape.
The problem here is that there is no columns for blocks and block lenght if you try to send the
I have found (Version 7.2) that the output file's RDTRL1 and RDTRL2 columns contains information about block count and size. Then , this sql command shows the total bytes written to tape:
select sum( cast (left(right(rdtrl1, 27),7) as decimal(7,0)) * cast (right(rdtrl2, 10) as decimal(10 , 0)) - 4096 ) from yourfilehere
But remember that this is not accurate if the tape driver compacts data.