How to get list of onbar backups using TSM

Dear All, I am new to TSM, I have configured the Informix DB server which backups to TSM using Onbar. The backups are working fine as show in the onbar log. Now, I need to get a list of all succesfull backups for this server, so that I could select the appropriate backup for restore. Kindly help me that how could I list all the backups available at TSM? so that i could transfer them to any other server and could do the restore. I have looked into all the options of onbar command but could not find any option that lists the backups? So plese guide me that how could i do this? Thanks in advance for for any help! Regards, Khan

You will need to use TSM (I assume that's Tivoli Storage Manager) commands to list its catalog! Onbar and Informix don't know anything about archives older that the latest one at each level because the storage manager (ie TSM) can have rules about aging out and deleting older archives. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Sep 16, 2013 at 5:21 PM, O KHAN <theultimateboy@hotmail.com> wrote: > Dear All, > > I am new to TSM, I have configured the Informix DB server which backups to > TSM > using Onbar. > The backups are working fine as show in the onbar log. > > Now, I need to get a list of all succesfull backups for this server, so > that I > could select the appropriate backup for restore. > > Kindly help me that how could I list all the backups available at TSM? so > that > i could transfer them to any other server and could do the restore. > > I have looked into all the options of onbar command but could not find any > option that lists the backups? > > So plese guide me that how could i do this? > > Thanks in advance for for any help! > > Regards, > Khan > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0160b998d3847f04e6878102

From the CLI of the TSM client, set the configuration file to connect to the TDP Informix (Example: dsmc-optfile = /opt/ tivoli/tsm/client/api/bin/dsm.opt) and run the command: q backup /<servername >/*/* If you want to see even the inactive backup command is: q backup -inactive /<servername>/*/* The screen output is this: tsm> q backup -inactive /ol_test1150_shm/*/* Size Backup Date Mgmt Class A/I File ---- ----------- ---------- --- ---- API 118,784 B 07/10/2009 15:06:45 MGMT_INFOR A /ol_test1150_shm/ol_test1150_shm/0/23 API 83,968 B 07/10/2009 15:30:11 MGMT_INFOR A /ol_test1150_shm/ol_test1150_shm/0/24 API 56,530,944 B 07/10/2009 15:29:50 MGMT_INFOR A /ol_test1150_shm/ol_test1150_shm/datidbs/0 API 9,170,944 B 07/10/2009 15:29:40 MGMT_INFOR A /ol_test1150_shm/ol_test1150_shm/indicidbs/0 API 4,096 B 07/10/2009 15:29:30 MGMT_INFOR A /ol_test1150_shm/ol_test1150_shm/logdbs/0 API 4,096 B 07/10/2009 15:30:00 MGMT_INFOR A /ol_test1150_shm/ol_test1150_shm/physdbs/0 API 9,031,680 B 07/10/2009 15:29:17 MGMT_INFOR A /ol_test1150_shm/ol_test1150_shm/rootdbs/0 API 56,530,944 B 07/10/2009 15:06:04 MGMT_INFOR I /ol_test1150_shm/ol_test1150_shm/datidbs/0 API 9,170,944 B 07/10/2009 15:06:14 MGMT_INFOR I /ol_test1150_shm/ol_test1150_shm/indicidbs/0 API 4,096 B 07/10/2009 15:06:34 MGMT_INFOR I /ol_test1150_shm/ol_test1150_shm/logdbs/0 API 4,096 B 07/10/2009 15:06:24 MGMT_INFOR I /ol_test1150_shm/ol_test1150_shm/physdbs/0 API 9,027,584 B 07/10/2009 15:05:51 MGMT_INFOR I /ol_test1150_shm/ol_test1150_shm/rootdbs/0 tsm> Paolo Il 16/09/2013 23:21, O KHAN ha scritto: > Dear All, > > I am new to TSM, I have configured the Informix DB server which backups to TSM > using Onbar. > The backups are working fine as show in the onbar log. > > Now, I need to get a list of all succesfull backups for this server, so that I > could select the appropriate backup for restore. > > Kindly help me that how could I list all the backups available at TSM? so that > i could transfer them to any other server and could do the restore. > > I have looked into all the options of onbar command but could not find any > option that lists the backups? > > So plese guide me that how could i do this? > > Thanks in advance for for any help! > > Regards, > Khan > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >