Have you tried to search the IBM web site for possible solutions? http://www.ibm.com/us/ and in the Search box, enter: ANS1309W There are a few hits that might help.
Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 03/31/2008 04:13:09 AM: > Hi All, > > We've got an issue regarding the TDPSQL. > > We have a TSM Server on Windows v5.4.1.0. > We have a SQL Server 2005. > Client wise we tried with the following configurations: > > 1: > The TSM BAclient (for the API) was v5.4.0.2 with a > The TDP for SQL was v5.2.1.6 > > 2: > The TSM BAclient is upgraded to v5.5.0.0 > The TDP for SQL is upgraded to v5.5.0.0. > > Both kept the same problem. > > The problem says: ANS1309I (RC9) The requested data is offline (see 3 & 4:) > On another machine it runs smoothly but we can't pinpoint the problem. > In the TDP SQL Gui we can choose the databases but when trying to backup... > We've tried with local system account as well as a specified account. > The SQL data is on-line and accessible. > > 3: > ===================================================================================================== > 31-03-2008 09:30:47 Request : FULL BACKUP > 31-03-2008 09:30:47 Database Input List : msdb > 31-03-2008 09:30:47 Group Input List : > 31-03-2008 09:30:47 File Input List : > 31-03-2008 09:30:47 Number of Buffers : 3 > 31-03-2008 09:30:47 Buffer Size : 1024 > 31-03-2008 09:30:47 Number of SQL Buffers : 0 > 31-03-2008 09:30:47 SQL Buffer Size : 1024 > 31-03-2008 09:30:47 Number of Stripes specified : 1 > 31-03-2008 09:30:47 Estimate : - > 31-03-2008 09:30:47 Truncate Log? : - > 31-03-2008 09:30:47 Wait for Tape Mounts? : No > 31-03-2008 09:30:47 TSM Options File : C:\Program > Files\Tivoli\TSM\TDPSql\dsm.opt > 31-03-2008 09:30:47 TSM Nodename Override : - > 31-03-2008 09:30:47 Sqlserver : xxxxSQL05 > 31-03-2008 09:30:47 > 31-03-2008 09:30:48 ACO5436E A failure occurred on stripe number (0), rc = 418 > 31-03-2008 09:30:48 ANS1309I (RC9) The requested data is offline. > 31-03-2008 09:30:48 Backup of msdb failed. > 31-03-2008 09:30:48 ANS1309I (RC9) The requested data is offline. > 31-03-2008 09:30:48 Total SQL backups selected: 1 > 31-03-2008 09:30:48 Total SQL backups attempted: 1 > 31-03-2008 09:30:48 Total SQL backups completed: 0 > ===================================================================================================== > > 4: > ===================================================================================================== > Beginning log backup for database DB_MOSSIA_CONFIG01, 1 of 14. > Full: 1 Read: 46602752 Written: 45088768 Rate: 35.085,26 Kb/Sec > Full: 1 Read: 46602752 Written: 45088768 Rate: 17.598,72 Kb/Sec > Full: 1 Read: 46602752 Written: 45088768 Rate: 14.667,55 Kb/Sec > Backup of DB_MOSSIA_CONFIG01 failed. > ANS1309I (RC9) The requested data is offline. > > Beginning log backup for database DB_MOSSIA_SSP01_ADMIN01, 2 of 14. > Full: 0 Read: 5622272 Written: 5622272 Rate: 14.680,48 Kb/Sec > Backup of DB_MOSSIA_SSP01_ADMIN01 failed. > ANS1309I (RC9) The requested data is offline. > ===================================================================================================== > > 5: > ===================================================================================================== > LASTPRUNEDate 31-03-2008 08:28:49 > SQLSERVer xxxxSQL05 > FROMSQLserver xxxxSQL05 > SQLAUTHentication INTegrated > MOUNTWaitfordata No > DIFFESTimate 20 > BUFFers 3 > BUFFERSIze 1024 > STRIPes 1 > SQLBUFFers 0 > SQLBUFFERSIze 1024 > LOGPrune 10 > LANGuage ENU > DATEformat 2 > NUMBERformat 5 > TIMEformat 1 > ===================================================================================================== > > Anyone? > > Thanks in advance. > Jop
