Re: TDP for Informix expiring backup files

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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Stapleton, Mark
Sent: Wednesday, May 19, 2004 4:55 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TDP for Informix expiring backup files


From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 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