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. 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
hiho,
did you check with your highwatermark?
if you do a "list tablespaces show detail", which looks like this: - Tablespace ID = 0
-
Name = SYSCATSPACE
-
Type = Database managed space
-
Contents = Any data
-
State = 0x0000
-
Detailed explanation:
-
Normal
-
Total pages = 49384
-
Useable pages = 49360
-
Used pages = 36816
-
Free pages = 12544
-
High water mark (pages) = 48825
-
Page size (bytes) = 4096
-
Extent size (pages) = 16
-
Prefetch size (pages) = 4
-
Number of containers = 1
-
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!
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.
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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
=====
|
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...
|
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...
|
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...
|
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...
|
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"....
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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...
|
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...
| |