"Fred Nurk" <frnurk@nospam.yahoo.com.au> wrote in message news:<3fd37f9d$0$13634$afc38c87@news.optusnet.com. au>...
> 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
Hi Fred,

Thanks for making interesting suggetion. This is what had been done 23 Nov 2003.
drwxr-xr-x 2 db2vkg sysadm 512 Nov 23 13:43 security
drwxrwsr-x 2 db2vkg sysadm 512 Nov 23 18:55 sqldbdir
drwxrwsr-x 2 db2vkg sysadm 512 Nov 23 16:52 sqldbdir_org
drwxrwsrwx 2 db2vkg sysadm 512 Nov 24 19:43 tmp
loanhost:db2vkg 4> cd sqldbdir
loanhost:db2vkg 5> ls -l
total 12
-rw-rw-r-- 1 db2vkg sysadm 932 Nov 24 19:43 sqldbbak
-rw-rw-r-- 1 db2vkg sysadm 932 Nov 24 19:43 sqldbdir
-rw-rw-r-- 1 db2vkg sysadm 540 Nov 23 18:55 sqldbins
loanhost:db2vkg 6> cd ..
loanhost:db2vkg 7> cd sqldbdir_org
loanhost:db2vkg 8> ls -l
total 12
-rw-rw-r-- 1 db2vkg sysadm 932 Nov 23 16:52 sqldbbak
-rw-rw-r-- 1 db2vkg sysadm 932 Nov 23 16:52 sqldbdir
-rw-rw-r-- 1 db2vkg sysadm 540 Nov 23 16:52 sqldbins

Interstingly db2imigr file size becomes 0 (zero) , when migration fails.
Have you faced the same problem, while migrating 5.2 to 7.2EE ?

Thanks,
VKG