473,785 Members | 2,714 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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
Feb 14 '06 #1
4 1888
BobTheDataBaseB oy <"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
Feb 14 '06 #2
Knut Stolze wrote:
BobTheDataBaseB oy <"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.t xt 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

Feb 15 '06 #3
BobTheDataBaseB oy wrote:
Knut Stolze wrote:
BobTheDataBaseB oy <"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.t xt 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
Feb 15 '06 #4
BobTheDataBaseB oy <"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
Feb 15 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1403
by: llama | last post by:
Hello, Don't want to touch off a religious war, but does anyone have any firsthand experience with perl scripts running under windows 2000 either IIS or apache? I've lately done a lot of one off development of sites using perl scripts under IIS on win2K server lately. My latest project has the potential of becoming much more legacy. FOr now, perl should easily do the job (about 20-ish users per day tops). But what if this thing scales...
4
2136
by: GO | last post by:
I have a custom Perl application (programmed by myself) that is used to rename files. For some reason, within the last month, it is no longer working properly. Prior to this I've been using it for several years without problem. It's a relatively simple program that reads the file names from the current directory and replaces strings of text issued from command-line parameters. But now, for some unknown reason, it looks in the root of...
2
2205
by: mos | last post by:
I want to put a MySQL 4.1 database on a Win2k laptop but the problem is it contains confidential client information. It has to be Window because applications accessing the database are written in Windows. The problem is laptops do get stolen quite often, even when running on someone's unattended desk. Most security chains can be cut with a small pair of bolt cutters. I have to convince my boss that if the laptop disappears it won't put...
3
2119
by: Matthew P. Seltzer | last post by:
All- This is a bit 'out there,' but, here goes. I have copied the WinSxS folder from a WinXP box to my Win2K box. I would like to be able to apply XP control styles to my Win2K VB.NET apps. Given what I have copied into my WinSXS folder, would I be able to use a combination of assembly manifests and isolated Win32 assemblies to do this? According to MSDN, comctl32.dll, Version 6, which is bundled with WinXP, is not redistributable. My...
1
3774
by: Mike | last post by:
Need some help please. Trying to restore a 7.2 DB from one machine to a newer machine running 8.2. Upon restoring I get: SQL2519N The database was restored, but the restored database was not migrated to the current release. Error "<sqlcode>" with tokens "<tokens>" is returned. Explanation: The backup image contains a previous release of the database. After the database files were restored, an attempt was made
2
3076
by: bbxrider | last post by:
win2k adv server/ iis5.0/vb6.0/ado and/or odbc connections on client machine i have an mdb on win2k adv server machine and want internet read/write to it from both a non-windows, red hat, webserver using asp/vbscript and a win xp/2000 machine with vb6.0/ado with or without odbc set up how do you set up the win2k server machine and/or mdb??? i know enough that some application/service needs to be listening on some port so far i have the...
6
2264
by: alanknipmeyer | last post by:
Hi, I`m in the process of migrating a Access 2002 (Run in 2000 mode) from Windows 98 to Win2K Server. It is a shared resource via a file share on the 98 Server. Client systems are Win98 with the shared drive mounted and the application run via the shared drive. I have tried once before, but came across some file locking issues. I thought i had addressed these file locking issues, but it came apparent I hadn't when data started to get...
4
1342
by: Adrian Parker | last post by:
I have a web app that has one problem when deployed on win2003 but works fine on win2k. On a page, I have a button that causes a reload of the page with a different set of querystring values (to move to next week) the codebehind the button just says Response.Redirect("mypagename.aspx?year=2005&month=11&day=21")
4
1334
by: Slasher186 | last post by:
Hi all, First of all, I'm sorry if I posted at the wrong section here, but I can't seem to find the VB 6.0 newsgroup ? I'm developing my apps with VB 6.0 sp5 installed on win xp. I have create an exe file that runs fine on both winxp and win2k. However, when I try to execute that file on win 98 machine, there are errors. This error may vary between "EOF or BOF expected.." or "Error 13, Type mismatch". I've tried over and over again to do...
1
1437
by: Ruben | last post by:
I created a simple form that includes a hyperlink field which when clicked, launches any given pdf file saved in a multi-user network. The problem is: It ONLY seems to work well when launched from a workstation operating under Win2k. When launched from a workstation operating under XP, files open succesfully only once then fail to open the next time the database is reopened. The database then simply shuts down asking if the error...
0
9643
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9480
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10319
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10087
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9947
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7496
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5380
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
3645
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2877
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.