473,322 Members | 1,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Redirected Restore

Hi,
I am doing a redirected restore from an offline backup file. All
the paths and files have been created and I managed to do all the set
tablespaces commands. But once I do the "restore db <dbnamecontinue"
it gives me the following error

db2 =restore db cdbdwp1 continue
SQL2059W A device full warning was encountered on device "DATA32".
Do you want to continue(c), terminate this device only(d), abort the
utility(t) ? (c/d/t)

For data32 this was the command I had run:

db2 "set tablespace containers for 2 using (file
'/u09/db2data/cdbdwm1/data32' 1000)"

and yes, 2 is data 32

I am pasting the db2 list tablespaces out put from the original
database

************************************************** ************************************************** ***
Tablespace ID = 0
Name = SYSCATSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 2
Name = DATA32
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 3
Name = INDX32
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 4
Name = TEMP32
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 5
Name = SYSTOOLSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 6
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 7
Name = DATA4
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 8
Name = TEMP4
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
************************************************** **************************************************

This error was occuring for a long time and thats why I am trying
data32 with just 1000 pages. Can anybody help me with this? Thanks in
advance.

Jul 4 '06 #1
6 3211

Look in the db2diag.log it should be an entry for the tablespace ie
which size it requires to be able and continue with the restore

Jul 4 '06 #2
hiho,
did you check with your highwatermark?

if you do a "list tablespaces show detail", which looks like this:
Expand|Select|Wrap|Line Numbers
  1.  Tablespace ID                        = 0
  2.  Name                                 = SYSCATSPACE
  3.  Type                                 = Database managed space
  4.  Contents                             = Any data
  5.  State                                = 0x0000
  6.    Detailed explanation:
  7.      Normal
  8.  Total pages                          = 49384
  9.  Useable pages                        = 49360
  10.  Used pages                           = 36816
  11.  Free pages                           = 12544
  12.  High water mark (pages)              = 48825
  13.  Page size (bytes)                    = 4096
  14.  Extent size (pages)                  = 16
  15.  Prefetch size (pages)                = 4
  16.  Number of containers                 = 1
  17.  Minimum recovery time                = 2004-05-15-03.08.46.000000
... the significant lines are marked bold.

so if you do a redirected restore, you have to specify the new containers at least as big as the HWM.

godd luck!
Jul 4 '06 #3
can you provide the output of "db2 list tablespaces show detail"?

Asphalt Blazer 写道:
Hi,
I am doing a redirected restore from an offline backup file. All
the paths and files have been created and I managed to do all the set
tablespaces commands. But once I do the "restore db <dbnamecontinue"
it gives me the following error

db2 =restore db cdbdwp1 continue
SQL2059W A device full warning was encountered on device "DATA32".
Do you want to continue(c), terminate this device only(d), abort the
utility(t) ? (c/d/t)

For data32 this was the command I had run:

db2 "set tablespace containers for 2 using (file
'/u09/db2data/cdbdwm1/data32' 1000)"

and yes, 2 is data 32

I am pasting the db2 list tablespaces out put from the original
database

************************************************** ************************************************** ***
Tablespace ID = 0
Name = SYSCATSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 2
Name = DATA32
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 3
Name = INDX32
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 4
Name = TEMP32
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 5
Name = SYSTOOLSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 6
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 7
Name = DATA4
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 8
Name = TEMP4
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
************************************************** **************************************************

This error was occuring for a long time and thats why I am trying
data32 with just 1000 pages. Can anybody help me with this? Thanks in
advance.
Jul 4 '06 #4
Yes here it is:

Tablespaces for Current Database

Tablespace ID = 0
Name = SYSCATSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 28351
Useable pages = 28351
Used pages = 28351
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 128
Number of containers = 1

Tablespace ID = 2
Name = DATA32
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 640000
Useable pages = 639936
Used pages = 541312
Free pages = 98624
High water mark (pages) = 541312
Page size (bytes) = 32768
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

Tablespace ID = 3
Name = INDX32
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 320000
Useable pages = 319936
Used pages = 291264
Free pages = 28672
High water mark (pages) = 291264
Page size (bytes) = 32768
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

Tablespace ID = 4
Name = TEMP32
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 32768
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

Tablespace ID = 5
Name = SYSTOOLSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 2095
Useable pages = 2095
Used pages = 2095
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 64
Number of containers = 1

Tablespace ID = 6
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 64
Prefetch size (pages) = 128
Number of containers = 1

Tablespace ID = 7
Name = DATA4
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 173720
Useable pages = 173720
Used pages = 173720
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

Tablespace ID = 8
Name = TEMP4
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

and here are the commands I used to create the new database:

************************************************** *****************************************
db2 "restore db cdbdwp1 user db2inst1 using figaro$ from
/u04/db2bkup/cdbdwp1 to /u01/db2cat into cdbdwm1 redirect without
rolling forward without prompting"

db2 "set tablespace containers for 0 using (path 'SQLT0000.0')"

db2 "set tablespace containers for 2 using (file
'/u09/db2data/cdbdwm1/data32' 640000)"

db2 "set tablespace containers for 3 using (file
'/u08/db2indx/cdbdwm1/indx32' 320000)"

db2 "set tablespace containers for 4 using (path
'/u09/db2temp/cdbdwm1/temp32')"

db2 "set tablespace containers for 5 using (path 'SYSTOOLSPACE')"

db2 "set tablespace containers for 6 using (path 'SYSTOOLSTMPSPACE')"

db2 "set tablespace containers for 7 using (path
'/u09/db2data/cdbdwm1/data4')"

db2 "set tablespace containers for 8 using (path
'/u09/db2temp/cdbdwm1/temp4')"

************************************************** ************************************************

thanks

Jul 4 '06 #5
m
Asphalt Blazer wrote:
Yes here it is:

Tablespaces for Current Database

Tablespace ID = 0
Name = SYSCATSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 28351
Useable pages = 28351
Used pages = 28351
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 128
Number of containers = 1

Tablespace ID = 2
Name = DATA32
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 640000
Useable pages = 639936
Used pages = 541312
Free pages = 98624
High water mark (pages) = 541312
Page size (bytes) = 32768
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

Tablespace ID = 3
Name = INDX32
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 320000
Useable pages = 319936
Used pages = 291264
Free pages = 28672
High water mark (pages) = 291264
Page size (bytes) = 32768
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

Tablespace ID = 4
Name = TEMP32
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 32768
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

Tablespace ID = 5
Name = SYSTOOLSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 2095
Useable pages = 2095
Used pages = 2095
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 64
Number of containers = 1

Tablespace ID = 6
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 64
Prefetch size (pages) = 128
Number of containers = 1

Tablespace ID = 7
Name = DATA4
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 173720
Useable pages = 173720
Used pages = 173720
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

Tablespace ID = 8
Name = TEMP4
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

and here are the commands I used to create the new database:

************************************************** *****************************************
db2 "restore db cdbdwp1 user db2inst1 using figaro$ from
/u04/db2bkup/cdbdwp1 to /u01/db2cat into cdbdwm1 redirect without
rolling forward without prompting"

db2 "set tablespace containers for 0 using (path 'SQLT0000.0')"

db2 "set tablespace containers for 2 using (file
'/u09/db2data/cdbdwm1/data32' 640000)"

db2 "set tablespace containers for 3 using (file
'/u08/db2indx/cdbdwm1/indx32' 320000)"

db2 "set tablespace containers for 4 using (path
'/u09/db2temp/cdbdwm1/temp32')"

db2 "set tablespace containers for 5 using (path 'SYSTOOLSPACE')"

db2 "set tablespace containers for 6 using (path 'SYSTOOLSTMPSPACE')"

db2 "set tablespace containers for 7 using (path
'/u09/db2data/cdbdwm1/data4')"

db2 "set tablespace containers for 8 using (path
'/u09/db2temp/cdbdwm1/temp4')"

************************************************** ************************************************

thanks
Your SET TABLESPACES has to be at LEAST equal to the number of used
pages for the tablespace you are restoring - and a couple extra would be
better. to DATA32 needs to be 541312 pages - and the disk you are
creating this on has to have enough space....

M
Jul 5 '06 #6
m
Asphalt Blazer wrote:
Yes here it is:

Tablespaces for Current Database

Tablespace ID = 0
Name = SYSCATSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 28351
Useable pages = 28351
Used pages = 28351
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 128
Number of containers = 1

Tablespace ID = 2
Name = DATA32
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 640000
Useable pages = 639936
Used pages = 541312
Free pages = 98624
High water mark (pages) = 541312
Page size (bytes) = 32768
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

Tablespace ID = 3
Name = INDX32
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 320000
Useable pages = 319936
Used pages = 291264
Free pages = 28672
High water mark (pages) = 291264
Page size (bytes) = 32768
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

Tablespace ID = 4
Name = TEMP32
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 32768
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

Tablespace ID = 5
Name = SYSTOOLSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 2095
Useable pages = 2095
Used pages = 2095
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 64
Number of containers = 1

Tablespace ID = 6
Name = SYSTOOLSTMPSPACE
Type = System managed space
Contents = User Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 64
Prefetch size (pages) = 128
Number of containers = 1

Tablespace ID = 7
Name = DATA4
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 173720
Useable pages = 173720
Used pages = 173720
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

Tablespace ID = 8
Name = TEMP4
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 64
Prefetch size (pages) = 256
Number of containers = 1

and here are the commands I used to create the new database:

************************************************** *****************************************
db2 "restore db cdbdwp1 user db2inst1 using figaro$ from
/u04/db2bkup/cdbdwp1 to /u01/db2cat into cdbdwm1 redirect without
rolling forward without prompting"

db2 "set tablespace containers for 0 using (path 'SQLT0000.0')"

db2 "set tablespace containers for 2 using (file
'/u09/db2data/cdbdwm1/data32' 640000)"

db2 "set tablespace containers for 3 using (file
'/u08/db2indx/cdbdwm1/indx32' 320000)"

db2 "set tablespace containers for 4 using (path
'/u09/db2temp/cdbdwm1/temp32')"

db2 "set tablespace containers for 5 using (path 'SYSTOOLSPACE')"

db2 "set tablespace containers for 6 using (path 'SYSTOOLSTMPSPACE')"

db2 "set tablespace containers for 7 using (path
'/u09/db2data/cdbdwm1/data4')"

db2 "set tablespace containers for 8 using (path
'/u09/db2temp/cdbdwm1/temp4')"

************************************************** ************************************************

thanks
Besides the tablespace size and disk space used - there is another
possibility - the filesystem needs to be "large file enabled" in order
to create a singe file (DMS) that is 20GB (640000 * 32768) - OR - you
will need to create multiple containers if you have to stay under 2GB
per file

M
Jul 5 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Vikrant | last post by:
Friends, Due an application (old) install program problem, Under AIX I could only create DB2 instance, I could also catalog it. Its complex application and I am not expert in creating full...
1
by: Vikrant | last post by:
Hi Kelly This is from old response by you. What is 'callerac' parameter in REDIRECTED restore, how can I provide 'callerac' value ? Thanks, VKG =====
9
by: GL | last post by:
I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following SQL2059W A device full warning was...
1
by: Jack | last post by:
Is it possible to find out what the tablespace definitions are of database you are about to build using a redirected restore? What I am wanting to do is build a script that can take only a backup...
7
by: CCC via DBMonster.com | last post by:
We use redirected restore to refresh test from prod on different AIX 5.2 servers. The databases have the same number, size and names of cooked containers. The only difference is the fully qualified...
11
by: Chris | last post by:
I have searched this group for answers and tried the responses. I am trying to Use an full online backup from our production server and apply it to our test server. The Tablespaces in the...
1
by: Kent.Brooke | last post by:
When a backup is taken from server a and then redirected restore is done on server b, the tables and data is fine however db2advis says "explain & advise tables not created for user x properly"....
4
by: Laurence | last post by:
Hi there, Command Reference book stated for db2relocatedb command: Copy the files/devices belonging to the databases being copied onto the system where the new instance resides. The path names...
0
by: Lew | last post by:
Hi, I have a database that I am restoring to another database in the same instance using a redirected restore. It seems to work fine but what is troubling to me is in the diag log i see that it...
1
by: okonita | last post by:
Hi all, This is a very urgent issue for my team. We are trying a Redirected restore the most current online DB2 UDBv8.2 backup copy from prod disk to disk on another/test instance. Our...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shllpp 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.