SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 06:04 AM
| ||||
| ||||
 v8.1 (win2K) database files into v8.2 was having a real mess trying to upgrade v8.1.6 to v8.2.3 (aka FP10). so i just deleted the failed 8.1/2, and did a fresh install of 8.2, having been assured by our DBA types that 8.2 could find the files left from the 8.1 databases. these are testing databases, so they aren't critical, but it would make life simpler if that could be done. looking through help, here, and the UDB on-line library, doesn't come up with any syntax. nor have the DBA types. ah well. i ran db2updv8 after the initial upgrade, but it errored, and the timestamps on the directories/files didn't change. btw, while the upgrade went to completion without error, i was getting 'memory can not be "read" ' errors from javaw and db2bp when trying to access data. screens, config assist for example, came up ok. re-running the upgrade did error out. is mine a unique experience?? i sort of hope so. the upgrade doc read like it was all really simple. BTDB      |
|
02-27-2008, 06:04 AM
| |||
| |||
| Re: v8.1 (win2K) database files into v8.2 BobTheDataBaseBoy <"xxx at rcn dot com"> wrote: > was having a real mess trying to upgrade v8.1.6 to v8.2.3 (aka FP10). > so i just deleted the failed 8.1/2, and did a fresh install of 8.2, > having been assured by our DBA types that 8.2 could find the files > left from the 8.1 databases. these are testing databases, so they > aren't critical, but it would make life simpler if that could be > done. looking through help, here, and the UDB on-line library, > doesn't come up with any syntax. nor have the DBA types. ah well. > > i ran db2updv8 after the initial upgrade, but it errored, and the > timestamps on the directories/files didn't change. You did follow the steps in the readme, i.e. 1. install V8.2 2. run "db2iupt" to update the instance 3. catalog all databases from the previous install if you did remove the instance 4. run "db2updv8" on all databases If you did do that, it would be extremely helpful if you could tell us the actual error message. > the upgrade doc read like it was all really simple. It is. -- Knut Stolze DB2 Information Integration Development IBM Germany |
|
02-27-2008, 06:04 AM
| |||
| |||
| Re: v8.1 (win2K) database files into v8.2 Knut Stolze wrote: > BobTheDataBaseBoy <"xxx at rcn dot com"> wrote: > >> was having a real mess trying to upgrade v8.1.6 to v8.2.3 (aka FP10). >> so i just deleted the failed 8.1/2, and did a fresh install of 8.2, >> having been assured by our DBA types that 8.2 could find the files >> left from the 8.1 databases. these are testing databases, so they >> aren't critical, but it would make life simpler if that could be >> done. looking through help, here, and the UDB on-line library, >> doesn't come up with any syntax. nor have the DBA types. ah well. >> >> i ran db2updv8 after the initial upgrade, but it errored, and the >> timestamps on the directories/files didn't change. > > You did follow the steps in the readme, i.e. > > 1. install V8.2 > 2. run "db2iupt" to update the instance > 3. catalog all databases from the previous install if you did remove the > instance > 4. run "db2updv8" on all databases > > If you did do that, it would be extremely helpful if you could tell us the > actual error message. > >> the upgrade doc read like it was all really simple. > > It is. > well, it gets complicated. as some threads here show, there is no db2iupt. there is db2iupdt, but according to the on-line lib, its purpose on windows is to support partitioned databases, which i didn't choose when i did the install. neither is mentioned in the FixPackReadme.txt i got with FP-10. section 1.4.1 only mentions db2updv8 as an option, not requirement. ran the db2 update ... jdk_path ... but i still get memory exception in javaw.exe, for example, when choosing the drive in Configuration Assistant to update one of these databases to Local. i was able to import the generate.spf, so i can see the databases, that i had before, and am able to connect to the remote ones, but not the local ones. i have 1.5.0_06 and have for a while. 8.1.6 ran fine with it. will call the 800 number tomorrow. unless Serge is lurking and finds this familiar <G>. BTDB |
|
02-27-2008, 06:04 AM
| |||
| |||
| Re: v8.1 (win2K) database files into v8.2 BobTheDataBaseBoy wrote: > Knut Stolze wrote: > >> BobTheDataBaseBoy <"xxx at rcn dot com"> wrote: >> >>> was having a real mess trying to upgrade v8.1.6 to v8.2.3 (aka FP10). >>> so i just deleted the failed 8.1/2, and did a fresh install of 8.2, >>> having been assured by our DBA types that 8.2 could find the files >>> left from the 8.1 databases. these are testing databases, so they >>> aren't critical, but it would make life simpler if that could be >>> done. looking through help, here, and the UDB on-line library, >>> doesn't come up with any syntax. nor have the DBA types. ah well. >>> >>> i ran db2updv8 after the initial upgrade, but it errored, and the >>> timestamps on the directories/files didn't change. >> >> >> You did follow the steps in the readme, i.e. >> >> 1. install V8.2 >> 2. run "db2iupt" to update the instance >> 3. catalog all databases from the previous install if you did remove the >> instance >> 4. run "db2updv8" on all databases >> >> If you did do that, it would be extremely helpful if you could tell us >> the >> actual error message. >> >>> the upgrade doc read like it was all really simple. >> >> >> It is. >> > well, it gets complicated. > > as some threads here show, there is no db2iupt. there is db2iupdt, but > according to the on-line lib, its purpose on windows is to support > partitioned databases, which i didn't choose when i did the install. > > neither is mentioned in the FixPackReadme.txt i got with FP-10. section > 1.4.1 only mentions db2updv8 as an option, not requirement. > > ran the db2 update ... jdk_path ... but i still get memory exception > in javaw.exe, for example, when choosing the drive in Configuration > Assistant to update one of these databases to Local. > > i was able to import the generate.spf, so i can see the databases, that > i had before, and am able to connect to the remote ones, but not the > local ones. > > i have 1.5.0_06 and have for a while. 8.1.6 ran fine with it. > > will call the 800 number tomorrow. unless Serge is lurking and finds > this familiar <G>. I'm always lurking, but my hit ratio for non SQL problems is pathetic. -- Serge Rielau DB2 Solutions Development IBM Toronto Lab |
|
02-27-2008, 06:04 AM
| ||||
| ||||
| Re: v8.1 (win2K) database files into v8.2 BobTheDataBaseBoy <"xxx at rcn dot com"> wrote: > as some threads here show, there is no db2iupt. there is db2iupdt, but > according to the on-line lib, its purpose on windows is to support > partitioned databases, which i didn't choose when i did the install. You are correct. It is db2iupdt (I always forget the 'd' ;-)); and apparently you don't need that on Windows in your case. > i have 1.5.0_06 and have for a while. 8.1.6 ran fine with it. 1.5.0_06 is Java 5 (1.5)? I'm not completely sure, but I think DB2 only supporst Java 4 so far. -- Knut Stolze DB2 Information Integration Development IBM Germany |
Linear Mode
