Hello,
we also had this problem once. To solve it, we had to take caching OFF on
the specific storage pool.

Regards,

René Lambelet - *3543 - *A581 
Nestec SA - 55, Av. Nestlé - CH-1800 Vevey
Tel: ++41/21/924'35'43 / Fax: ++41/21/924'45'89
E-Mail: rene.lambelet AT nestle DOT com



> -----Original Message-----
> From: Johan Gouws [SMTP:johang AT HOLLARD.CO DOT ZA]
> Sent: Wednesday, June 24, 1998 12:59 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      SQLconnect agent: ANR0534W on server
> 
> Hi ADSMers 
> 
> I have been trying to run a backup of a SQL database with size 22gig. It
> is backing up to a backuppool of 6.4 gig with a dlt autochanger defined as
> the migration pool with migration left on default i.e hi=90 lo=30. The
> backup runs until the 6.4 gig is full and then the following message
> appear: 
> 
> ANR0534W TRANSACTION FAILRD FOR SESSION 1646 FOR NODE DWHSQL(WINNTDB) -
> SIZE ESTIMATE EXCEEDED AND SERVER IS UNABLE TO OBTAIN ADDITIONAL > SIZE 
> ESTIMATE EXCEEDED AND SERVER IS UNABLE TO OBTAIN ADDITIONAL SPACE IN
> STORAGE POOL BACKUPPOOL.
> 
> The storage hierarchy is set up to move from backuppool to the tapepool
> but for some reason this does not happen. The only thing that I could
> think of that could change this was checking the waiting for tape mounts
> on the SQL client. 
> 
> As it is still running I still don't know if the outcome will be
> possitive.
> Did anybody experience the same problem ????
> 
> Thanx
> Johan Gouws
> Johang AT hollard.co DOT za
> +2711 2401386