ADSM-L

Re: [ADSM-L] TDPSQL problem (ANS1309I (RC9) The requested data is offline)

2008-03-31 07:47:31
Subject: Re: [ADSM-L] TDPSQL problem (ANS1309I (RC9) The requested data is offline)
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 31 Mar 2008 07:46:25 -0400
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

<Prev in Thread] Current Thread [Next in Thread>