SEO

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

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

"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