SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 05:03 PM
| ||||
| ||||
 DB2 restore on Windows NT Hi, I want to restore a DB2 7.x database on Windows NT with a backup taken from AIX 4. The backup image is PROD.0.db2prod.NODE0000.CATN0000.20040129050501.00 1 I try to restore this in Windows 2000 server under DB2 instance. I read a manual which mentioned that the directory structure when restoring database should be <database_alias.backup_type>\<instance_name>\<node _number>\<catalog_node_number>\<date> I created a folder structure D:\PROD.0\DB2\NODE0000\CAT0000\20040129 and named the dump as 050501.0 But I get the following error when I restore SQL2542N No match for a database image file was found based on the source database alias "PROD" and timestamp "20040129050501" provided. I used the command db2 restore db prod from d taken at 20040129050501 redirect Kindly help me out.      |
|
02-26-2008, 05:03 PM
| |||
| |||
| Re: DB2 restore on Windows NT You cannot do cross platform backup/restores. Use db2move to copy the data. Deepak wrote: >Hi, > >I want to restore a DB2 7.x database on Windows NT with a backup taken >from AIX 4. The backup image is >PROD.0.db2prod.NODE0000.CATN0000.20040129050501.0 01 >I try to restore this in Windows 2000 server under DB2 instance. I >read a manual which mentioned that the directory structure when >restoring database should be ><database_alias.backup_type>\<instance_name>\<nod e_number>\<catalog_node_number>\<date> > >I created a folder structure >D:\PROD.0\DB2\NODE0000\CAT0000\20040129 and named the dump as 050501.0 > >But I get the following error when I restore >SQL2542N No match for a database image file was found based on the >source database alias "PROD" and timestamp "20040129050501" provided. > >I used the command >db2 restore db prod from d taken at 20040129050501 redirect > >Kindly help me out. > > -- Anton Versteeg IBM Certified DB2 Specialist IBM Netherlands |
|
02-26-2008, 05:03 PM
| |||
| |||
| Re: DB2 restore on Windows NT see inline... Regards, Joachim Müller "Deepak" <deepakr@chn.cognizant.com> schrieb im Newsbeitrag news:18a55f0d.0402100247.6c71f622@posting.google.c om... > Hi, > > I want to restore a DB2 7.x database on Windows NT with a backup taken > from AIX 4. The backup image is > PROD.0.db2prod.NODE0000.CATN0000.20040129050501.00 1 > I try to restore this in Windows 2000 server under DB2 instance. I > read a manual which mentioned that the directory structure when > restoring database should be > <database_alias.backup_type>\<instance_name>\<node _number>\<catalog_node_num ber>\<date> > > I created a folder structure > D:\PROD.0\DB2\NODE0000\CAT0000\20040129 and named the dump as 050501.0 ##############################################-> 050501.001 > > But I get the following error when I restore > SQL2542N No match for a database image file was found based on the > source database alias "PROD" and timestamp "20040129050501" provided. > > I used the command > db2 restore db prod from d taken at 20040129050501 redirect > > Kindly help me out. |
|
02-26-2008, 05:03 PM
| |||
| |||
| Re: DB2 restore on Windows NT Anton, didn't see that, you are right (little endian and big endian). That did'nt work. We in Germany said: "Wer lesen kann ist klar im Vorteil..." Regards, Joachim Müller "Joachim Mueller" <jom0309@[--spam--]douglas-informatik.de> schrieb im Newsbeitrag news:c0aj2e$t64$1@news.dtag.de... > see inline... > > Regards, > > Joachim Müller > > "Deepak" <deepakr@chn.cognizant.com> schrieb im Newsbeitrag > news:18a55f0d.0402100247.6c71f622@posting.google.c om... > > Hi, > > > > I want to restore a DB2 7.x database on Windows NT with a backup taken > > from AIX 4. The backup image is > > PROD.0.db2prod.NODE0000.CATN0000.20040129050501.00 1 > > I try to restore this in Windows 2000 server under DB2 instance. I > > read a manual which mentioned that the directory structure when > > restoring database should be > > > <database_alias.backup_type>\<instance_name>\<node _number>\<catalog_node_num > ber>\<date> > > > > I created a folder structure > > D:\PROD.0\DB2\NODE0000\CAT0000\20040129 and named the dump as 050501.0 > ##############################################-> 050501.001 > > > > > But I get the following error when I restore > > SQL2542N No match for a database image file was found based on the > > source database alias "PROD" and timestamp "20040129050501" provided. > > > > I used the command > > db2 restore db prod from d taken at 20040129050501 redirect > > > > Kindly help me out. > > |
|
02-26-2008, 05:04 PM
| ||||
| ||||
| Re: DB2 restore on Windows NT Correction: You cannot do cross platform backup/restores unless the source and target both are one of AIX, HP and/or Solaris. Anton Versteeg wrote: > You cannot do cross platform backup/restores. > Use db2move to copy the data. > > Deepak wrote: > >> Hi, >> >> I want to restore a DB2 7.x database on Windows NT with a backup taken >> from AIX 4. The backup image is >> PROD.0.db2prod.NODE0000.CATN0000.20040129050501.00 1 >> I try to restore this in Windows 2000 server under DB2 instance. I >> read a manual which mentioned that the directory structure when >> restoring database should be >> <database_alias.backup_type>\<instance_name>\<node _number>\<catalog_node_number>\<date> >> >> >> I created a folder structure >> D:\PROD.0\DB2\NODE0000\CAT0000\20040129 and named the dump as 050501.0 >> >> But I get the following error when I restore SQL2542N No match for a >> database image file was found based on the >> source database alias "PROD" and timestamp "20040129050501" provided. >> >> I used the command >> db2 restore db prod from d taken at 20040129050501 redirect >> >> Kindly help me out. >> >> > |
Linear Mode
