View Single Post

   
  #2 (permalink)  
Old 02-26-2008, 04:20 PM
Fred Nurk
 
Posts: n/a
Default Re: DBI1222W error when migrate the instance from 5.2 to 7.2

Try the following:

A) Rename sqldbdir and sqdbbak in the ~/sqllib/dbdirectory
B) Catalog your databases -
db2 catalog db <dbanme> on <path>
c) Run the migration again.

Please ensure that you have a offline back for each of the databases within
the instance.

Cheers,

"Vikrant" <icanhearyou@rediffmail.com> wrote in message
news:d236b1b8.0312060005.26c0090c@posting.google.c om...
> Hi DB2/UDB Gurus,
>
> I got the same problem , when I am migrating DB2/UDB 5.2 to 7.2 EE
> under AIX.
>
> Is this a known problem ?,
>
> I would sincerely appreciate (well if you want to have money, that is
> also possible, I am serious)
>
> I am sure someone must have found the trick or solution. Help me, help
> me ...
>
> Is database directrory of AIX is corrupted ?, how come db2imigr could
> corrupt AIX directory ?,
>
> If db2imigr of DB2/UDB 7.2 could corrupt the directory, then in my
> view there is a small bug in db2imigr script of DB2/UDB 7.2
>
> Is there any fix for it ?, If this problem 'publicaly' reported on 14
> July 2003, then I am sure DB2 Labs must have taken action by providing
> fix for it?
> We have so talented DB2 people from DB2 education, 'power' DBAs and
> from DB2 Labs on this forum, I feel some one must have a fix for it.
>
> Thanks,
> VKG
>
>
>
> ================== Old post, but no response ==================
> From: James (jamesyang@163.net)
> Subject: DBI1222W error when migrate the instance from 5.2 to 7.2
> This is the only article in this thread
> View: Original Format
> Newsgroups: comp.databases.ibm-db2
> Date: 2003-07-14 11:04:34 PST
>
>
> I want to migrate the instance "db2sp1" and issue:
>
> # ./db2imigr -u db2sp1 db2sp1
>
> db2ckmig was successful. Database(s) can be migrated.
>
> DBI1222W The system database directory is corrupted and cannot
> be migrated.
>
> Explanation: Either the primary and backup system database
> directory files are not the same or system database directory is
> corrupted.
>
> User Response: Remove system database directry and re-catalog
> all database entry.
>
>
> I am quite sure there is nothing wrong with database directory as I
> droped all the databases already!
>
> Who can tell me what is wrong and how to migrate it?
>
> Due to some reasons, I can not install UDB 7.2 directly, must upgrade!
> But I do not care about the database!
>
> Thanks in advance
> jamesyang@163.net



Reply With Quote