v8.1 (win2K) database files into v8.2

[BobTheDataBaseBoy]

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

[Knut Stolze]

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

[BobTheDataBaseBoy]

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

[Serge Rielau]

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

[Knut Stolze]

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