SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 10:02 AM
| ||||
| ||||
 DB backup/restore blocksize issue We backup the DB2 on Windows NT to tape without setting the block size, when I resotre this db from the tape: initial tape on \\.\tape0 using 512 restore db xxx from \\.\tape0 then DB2 will tell me the "backup image is currput". I'm checking the backup immage by "db2ckbkp \\.\tape0", it seems it is O.K. Who can tell me how can I restore the database? TIA jamesyang@163.net      |
|
02-26-2008, 10:02 AM
| |||
| |||
| Re: DB backup/restore blocksize issue James wrote: > We backup the DB2 on Windows NT to tape without setting the block > size, when I resotre this db from the tape: > > initial tape on \\.\tape0 using 512 > restore db xxx from \\.\tape0 > > then DB2 will tell me the "backup image is currput". > > I'm checking the backup immage by "db2ckbkp \\.\tape0", it seems it is > O.K. > > Who can tell me how can I restore the database? If you didn't specify the block size during the backup, then don't specify it either when restore. Regards, FRX > > > TIA > jamesyang@163.net |
|
02-26-2008, 10:03 AM
| ||||
| ||||
| Re: DB backup/restore blocksize issue James wrote: > But if I did not specify the block size when restore, there is an I/O > error when access the tape(I forgot the SQL error number). > > Another suspect: > > We backed up the database directly to an DDS4 (20/40G) 4mm tape. Does > the program check the tape capability when out of space? when the tape is full, the backup process will be pending and tell you it is full and allow you to change another one. > Does the > program use hardware compress by default? I don't think so. |
 |
« Log Corruption - V 7.2 on Windows 2000 server - has anyone seen this?
|
DB2 V.8.1 FP2 problem with compiling SP on AIX »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 02:45 PM.
