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 AT VM.MARIST DOT 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
|