Hi,

how about this?

Run this on the machine where the backup was done as user informix from
the command line:

dsmc q b -inactive "/on94shm/on94shm/*/*"

and replace in my example on94shm with the name of your DBSERVERNAME
variable. You can also replace the wildcard to restrict your search
further. Follow these instructions carefully, otherwise dsmc will tell
you it can not find anything.

Backup objects have the follow form:

Dbspace backups (0|1|2 are the archive level):

"/<DBSERVERNAME>/<DBSERVERNAME>/<DBspaceName>/<0|1|2>"

Logical Logs:

"/<DBSERVERNAME>/<DBSERVERNAME>/<Servernum>/<Log-unique-id>"

Have fun

-- Steffen.

Traveller2003 wrote:

> Hi All ,
>
> I need some help as I am have dicfficulty finding any examples of
> Tivoli dsmc commands to see what has been backup up.
>
> Informix 9.4UC3
> Solaris 8
> Tivoli 5.1.6.2 client.
>
> I have no access to the Tivoli managemnet server but have access to
> client from which the backup is done. The server side has been set up
> for me by the Tivoli admin. I backup using onbar -b -w and bar_act.log
> log tells me everyhting is great. Which means all the info seems to
> have gone to the management server ?
>
> What I want to do is check on the server using the "dsmc" command line
> interface to see what has been backed up and how the information is
> stored. Have used Netbackup previously and you can query the object
> using netbackup commands. But in Tivoli there seems to be a total void
> of Information on the IBM site and google and Informix group on using
> "dsmc". Now I know this is strictly speaking a Tivoli issue but was
> hoping to get a bit of help. Knowing how friendly this group is an all
> :-)
>
> All help appreciated and TIA.
>
> Traveller2003
>
> p.s Any information I find I will donate once finished to IIUG in FAQ
> ;-)
>
>

sending to informix-list

Hi Steffen ,

The output from the dsmc q b -inactive "/process_tcp/process_tcp/*/*"
command give me the following output.

Size Backup Date Mgmt Class A/I File
---- ----------- ---------- --- ----
API 177,754 KB 16-08-2004 15:26:36 DEFAULT A
/process_tcp/process_tcp/datadbs01/0
API 177,754 KB 16-08-2004 15:25:55 DEFAULT A
/process_tcp/process_tcp/rootdbs/0


What does the size relate to ? The size is the same for both dbspaces
yet datadbs01 is about 3gig. So I am not quite sure why the sizes are
the same. I know that onbar backups at the binary level and therefore
does not backup all the 3gig but I would have expected to see a size
difference in the rootdbs and datadbs01.

I may be missing the obvious :-)


Any ideas any more commands to check this out ? Also do you have a
sample copy of dsm.opt and include/exclude files. i.e Do you specify
the dbspaces in the include/exclude files.


Thanks for the help.

Cheers

Traveller2003