RE: SQL2059W A device full warning was encountered on device "PRD#BTABD".

RE: SQL2059W A device full warning was encountered on device "PRD#BTABD".

 

  

Please look into "Re-Directed Restore" process.

.... Sushanta


-----Original Message-----
From: quigleyd
[mailto:db2udbdba-ezmlmshield-x3444167.[Email address protected]
Sent: Thursday, May 08, 2008 9:09 AM
To: LazyDBA Discussion
Subject: Re: SQL2059W A device full warning was encountered on device
"PRD#BTABD".

A little more info. The tablespace was originally setup with 1
container. I
tried to break it into 6. I changed it back to 1 container and now the
restore
is running. Why can't I restore it into the new layout. Never have
seen that
before. The 4k table space is at its maximum.

Quoting [Email address protected]

> I ran a backup to disk, it completed successfully, but its now getting
a
> SQL2059W A device full warning was encountered on device "PRD#BTABD".
> during the restore. Any way around this? Db2 V8 FIXPAK 12.
>
> David Q
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>


David Q

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




******************************************************************************************
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, Alltel requests
that you immediately notify the sender and asks that you do not read the message or its
attachments, and that you delete them without copying or sending them to anyone else.



DB2 & UDB email list listserv db2-l LazyDBA home page