Checking Informix backup on Tivoli Library

Hi Everybody, I've installed TDP for Informix on one of my AIX 5.2 servers. I;m running the TDP 5.1 client and my TSM servere version is 5.2.2. It looks like the onbar backup was successful : 2004-10-21 14:55:10 3842244 5324806 /apps/informix/bin/onbar_d -b -w 2004-10-21 14:55:12 3842244 5324806 Begin level 0 backup rootdbs. 2004-10-21 14:55:12 3842244 5324806 Successfully connected to Storage Manager. 2004-10-21 14:55:13 3842244 5324806 Completed level 0 backup rootdbs (Storage Manager copy ID: 24344 0). 2004-10-21 14:55:13 3842244 5324806 Begin level 0 backup llogdbs. 2004-10-21 14:55:14 3842244 5324806 Completed level 0 backup llogdbs (Storage Manager copy ID: 24345 0). 2004-10-21 14:55:14 3842244 5324806 Begin level 0 backup plogdbs. 2004-10-21 14:55:15 3842244 5324806 Completed level 0 backup plogdbs (Storage Manager copy ID: 24346 0). 2004-10-21 14:55:15 3842244 5324806 Begin level 0 backup datadbs. 2004-10-21 14:55:25 3842244 5324806 Completed level 0 backup datadbs (Storage Manager copy ID: 24347 0). 2004-10-21 14:55:25 3842244 5324806 Begin level 0 backup objectdbs. 2004-10-21 14:55:26 3842244 5324806 Completed level 0 backup objectdbs (Storag e Manager copy ID: 24348 0). 2004-10-21 14:55:26 3842244 5324806 Begin backup logical log 2708. 2004-10-21 14:55:26 3842244 5324806 Successfully connected to Storage Manager. 2004-10-21 14:55:27 3842244 5324806 Completed backup logical log 2708 (Storage Manager copy ID: 24349 0). 2004-10-21 14:55:28 3842244 5324806 /apps/informix/bin/onbar_d complete, retur ning 0 (0x00) 2004-10-21 14:57:16 5324906 5210174 /apps/informix/bin/onbar_d -b -w 2004-10-21 14:57:17 5324906 5210174 Begin level 0 backup rootdbs. 2004-10-21 14:57:17 5324906 5210174 Successfully connected to Storage Manager. 2004-10-21 14:57:18 5324906 5210174 Completed level 0 backup rootdbs (Storage Manager copy ID: 24350 0). 2004-10-21 14:57:18 5324906 5210174 Begin level 0 backup llogdbs. 2004-10-21 14:57:19 5324906 5210174 Completed level 0 backup llogdbs (Storage Manager copy ID: 24351 0). 2004-10-21 14:57:19 5324906 5210174 Begin level 0 backup plogdbs. 2004-10-21 14:57:20 5324906 5210174 Completed level 0 backup plogdbs (Storage Manager copy ID: 24352 0). 2004-10-21 14:57:20 5324906 5210174 Begin level 0 backup datadbs. 2004-10-21 14:57:35 5324906 5210174 Completed level 0 backup datadbs (Storage Manager copy ID: 24353 0). 2004-10-21 14:57:35 5324906 5210174 Begin level 0 backup objectdbs. 2004-10-21 14:58:26 5324906 5210174 Completed level 0 backup objectdbs (Storag e Manager copy ID: 24354 0). 2004-10-21 14:58:26 5324906 5210174 Begin backup logical log 2709. 2004-10-21 14:58:26 5324906 5210174 Successfully connected to Storage Manager. 2004-10-21 14:58:27 5324906 5210174 Completed backup logical log 2709 (Storage Manager copy ID: 24355 0). 2004-10-21 14:58:28 5324906 5210174 /apps/informix/bin/onbar_d complete, retur ning 0 (0x00) 2004-10-21 15:08:00 5292256 5390412 /apps/informix/bin/onbar_d -b -w 2004-10-21 15:08:01 5292256 5390412 Begin level 0 backup rootdbs. 2004-10-21 15:08:02 5292256 5390412 Successfully connected to Storage Manager. 2004-10-21 15:08:03 5292256 5390412 Completed level 0 backup rootdbs (Storage Manager copy ID: 24356 0). 2004-10-21 15:08:03 5292256 5390412 Begin level 0 backup llogdbs. 2004-10-21 15:08:04 5292256 5390412 Completed level 0 backup llogdbs (Storage Manager copy ID: 24357 0). 2004-10-21 15:08:04 5292256 5390412 Begin level 0 backup plogdbs. 2004-10-21 15:08:07 5292256 5390412 Completed level 0 backup plogdbs (Storage Manager copy ID: 24358 0). 2004-10-21 15:08:07 5292256 5390412 Begin level 0 backup datadbs. 2004-10-21 15:08:21 5292256 5390412 Completed level 0 backup datadbs (Storage Manager copy ID: 24359 0). 2004-10-21 15:08:21 5292256 5390412 Begin level 0 backup objectdbs. 2004-10-21 15:08:22 5292256 5390412 Completed level 0 backup objectdbs (Storag e Manager copy ID: 24360 0). 2004-10-21 15:08:22 5292256 5390412 Begin backup logical log 2710. 2004-10-21 15:08:22 5292256 5390412 Successfully connected to Storage Manager. 2004-10-21 15:08:23 5292256 5390412 Completed backup logical log 2710 (Storage Manager copy ID: 24361 0). 2004-10-21 15:08:24 5292256 5390412 /apps/informix/bin/onbar_d complete, retur ning 0 (0x00) I check my storage area for the data and logs on my server and there are backups. My question : didn;t anything write to my Tivoli tape library ? How do I check this ? Does anything need to be done in the dsm.sys file to trigger the write to the tape library ? Rich

> > I check my storage area for the data and logs on my server and there > are backups. My question : didn;t anything write to my Tivoli tape > library ? How do I check this ? Does anything need to be done in the > dsm.sys file to trigger the write to the tape library ? > There is a SQL query you can run. You need to log on using dsmadmc select hl_name, ll_name, state from backups wherenode_name='DTCI-RMXDB01_TDPI' order by hl_name; It will as you if you want to run this query as it may take a long time. I responded "yes" to it and got back all the backups I had done which amounted to 3-4 as it was a test system and small. In my limited knowledge Tivoli uses a DB2 database to hold all the information which means there are tables you can query. Hope this helps. Traveller

rimo wrote: > Hi Everybody, > > I've installed TDP for Informix on one of my AIX 5.2 servers. I;m > running the TDP 5.1 client and my TSM servere version is 5.2.2. It > looks like the onbar backup was successful : > IDS version ?? There's really only one way to make sure that your backup is ok - that is to do a restore. With newer IDS versions you can do an "onbar -r -v" which will run a restore, but without writing to the dbspaces.