I just installed DB2 Personal Developer's Edition V8.2 (FP7) over my old
DB2 V7.2 instance but I'm having some problems. Can anyone help?
The first problem is that my migration didn't go too well. I got this
during the setup wizard:
The migration of the instance "DB2" has failed. The return value is "-2".
When I looked at the databases in the Control Center, they all seemed to be
there, including the ones created during the install (TDC_MD, DWCTRLDB,
DWCTBC) but when I tryed to list the tables in them, I got errors from all
but the new ones. In all cases (except the new databases) I got "Not
connected" for that database in the "All Databases" view but then got
SQL0535N (The database requires migration.) when I clicked on the
"Connect" icon. In other cases, I got SQL1039C (I/O Error while accessing
the database directory.) This table summarizes the results:
Database Result (after connecting)
CONTACTS SQL0535N
CONVSP01 SQL0535N
DWCTBC seems fine
DWCTRLDB seems fine
RH01 SQL1039C
SAMPLE SQL0535N
SDAC SQL1039C
SFL SQL1039C
TBC_MD seems fine
Since the migration apparently didn't work, I launched the InfoCenter,
looked up Migration and started down the checklist for preparing for
migration. When I tried the 'db2licd -end' command, I got SQL1024N (No
database connection). I don't know if that is okay or if it is a problem so
I kept going.
I did a db2ckmig on each of my databases. This table summarizes the
results:
Database Result of db2ckmig
CONTACTS ** ERROR ** Database cannot be connected.
CONVSP01 ** ERROR ** Database cannot be connected.
DWCTBC not tried since this is new DB
DWCTRLDB not tried since this is new DB
RH01 Database can be migrated.
SAMPLE Database can be migrated.
SDAC Database can be migrated.
SFL Database can be migrated.
TBC_MD not tried since this is a new DB
Why am I getting these 'database cannot be connected' errors? How do I get
around them? Why are they only happening on two of the databases when I do
db2ckmig? Why am I not "not connected" when I look at all of my old
databases in the "All Databases" view: is that "working as designed" or
does it indicate a problem? If it is a problem, what do I need to do about
it?
I decided to try doing the migrations on the ones that db2ckmig liked.
I did 'migrate database sample' first and it appeared to complete normally.
When I look at Sample now in the Control Center everything looks just fine
in the "All Databases" view. However, when I go down to look at the tables
in the Tables folder, there aren't any. Not even the catalog tables.
If I look at Views for Sample, I get lots of SYSIBM, SYSCAT and SYSSTAT
views, including some unfamiliar ones whose names start with 'XML'. I
assume those are new in V8.2.
But I'm baffled by how there can be no tables in the Sample database after
the migration, especially when views, which can't exist without their
underlying tables, seem to be plentiful.
Naturally, I am very reluctant to attempt converting any more of the
databases if the tables are going to get deleted! What's going on here?
How do I get my migrations to work correctly so that I can start using them
in DB2 V8.2?
By the way, I could live without database RH01 if I had to so I tried
migrating it too, in case database SAMPLE was an exception. It failed right
away on SQL1039C. Can anyone tell me why I'm getting these and how to get
past this problem?
---
I'm guessing that the other problem reported by the Setup Wizard is not too
serious but I'd like someone to confirm that and tell me how to resolve the
problem:
An error occurred while running the command
"C:\Program Files\SQLLIB\bin\dasmigr.exe DB2DAS00 to initialize
and/or migrate the DB2 tools catalog database. The return value is
"14".
Unfortunately, there is no SQL code that I can use to look this up in the
Messages manual....
Sorry for the long post! If anyone could help me, I'd appreciate it!
--
Henry