Here's a link to a thread just a couple months ago doing the same thing to list TDP Oracle backup data http://msgs.adsm.org/cgi-bin/get/adsm0403/541.html. Here's the output of doing one on my system for a TDP SQLserver node:
tsm> q fi Num Last Incr Date Type File Space Name --- -------------- ---- --------------- 1 05/19/2004 18:30:08 API:SqlData DSQL0100\data\0001 2 05/19/2004 18:30:08 API:SqlData DSQL0100\meta\0000 tsm> q ba {DSQL0100\data\0001}* Size Backup Date Mgmt Class A/I File ---- ----------- ---------- --- ---- API 68,812,801 B 03/29/2003 22:00:47 DEFAULT A DSQL0100\data\0001\ACDDataTest\full API 21,135,361 B 03/29/2003 23:00:20 DEFAULT A DSQL0100\data\0001\ACDDataTest\20030329230020\0000017F\log API 162,112 KB 05/18/2004 22:00:13 DEFAULT A DSQL0100\data\0001\ACDData\full API 20,061,185 B 05/18/2004 23:00:14 DEFAULT A DSQL0100\data\0001\ACDData\20040518230022\00000184\log API 2,097,153 B 11/23/2002 22:00:20 DEFAULT A DSQL0100\data\0001\ACDdata\full API 1,473,537 B 11/23/2002 23:00:25 DEFAULT A DSQL0100\data\0001\ACDdata\20021123230025\000001C0\log API 1,473,537 B 11/24/2002 23:00:21 DEFAULT A DSQL0100\data\0001\ACDdata\20021124230021\000001D2\log API 386,688 KB 04/12/2003 22:02:24 DEFAULT A DSQL0100\data\0001\CTAssetCenterTest\full API 15,024,129 B 04/12/2003 23:00:30 DEFAULT A DSQL0100\data\0001\ctassetcentertest\20030412230029\0000018e\l og API 15,024,129 B 04/13/2003 23:00:26 DEFAULT A DSQL0100\data\0001\ctassetcentertest\20030413230026\000001c5\l og API 15,024,129 B 04/14/2003 23:00:34 DEFAULT A DSQL0100\data\0001\ctassetcentertest\20030414230034\000001d2\l og API 391,808 KB 01/10/2004 22:01:01 DEFAULT A DSQL0100\data\0001\CTAssetCenter\full API 15,363,073 B 01/10/2004 23:00:22 DEFAULT A DSQL0100\data\0001\CTAssetCenter\20040110230024\000001CF\log API 15,363,073 B 01/11/2004 23:00:22 DEFAULT A DSQL0100\data\0001\CTAssetCenter\20040111230024\00000354\log API 15,363,073 B 01/12/2004 23:00:24 DEFAULT A DSQL0100\data\0001\CTAssetCenter\20040112230027\00000031\log API 2,097,153 B 05/15/2004 22:01:14 DEFAULT A DSQL0100\data\0001\ClientData\full API 1,478,657 B 05/15/2004 23:00:25 DEFAULT A DSQL0100\data\0001\ClientData\20040515230032\00000032\log and I know that I've done it on an AIX system to list Informix backup information. I also have some unix shell scripts from another member of this list that he uses to expire Informix log backups since they are uniquely named. The input to the shell script is the output of a QUERY BACKUP for the TDP nodename. Bill Boyer "Some days you are the bug, some days you are the windshield." - ?? -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Stapleton, Mark Sent: Wednesday, May 19, 2004 4:55 PM To: [EMAIL PROTECTED] Subject: Re: TDP for Informix expiring backup files From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bill Boyer >And from Mark's reply, the output of the data just shows the objects, size, >date/time and unless you know exactly what you're looking at, yes it is >meaningless. But this will show you the objects and allow you to EXPIRE >them >if you have the BACKDELETE=YES for the node. > >So, try 'dsmc -virtualnode=raven_ifmx'. You'll be prompted for a password. I don't believe that is correct. Remember, Mr. Oborn asked about data backed up with TDP for Informix. That data is backed up with API code, not BA code. The dsmc b/a client cannot access anything about filespaces or backups, since it doesn't access the relevant information. >From the TSM server, he *could* use QUERY OCCUPANCY on the Informix filesystems and see how much storage space the Informix data is taking up on tape and/or disk storage pools, but that's about it. If you run a QUERY FILESPACE from the server, it will 0 MB of space occupied; this is because the QUERY FILESPACE command only access data about clients backed up with the BA code. Again, I think the only way to access information about what is available for backups is with the TDP for Informix code (and possibly Informix itself), and that will only run if Informix is loaded and running on the console. Del, do I have that right? -- Mark Stapleton