db2ckmig failure

[Prince Kumar]

I am trying to run db2ckmig on my new db2 v8 ESE instance on AIX 5.2.
My previous db2 version was V7.1.

when I issue the db2ckmig for the db, I get the following error.

% db2ckmig sample -l /tmp/db2ckmig.log

db2ckmig was unsuccessful. Please look at logfile for more details.

% cat /tmp/db2ckmig.log

Version of DB2CKMIG being run: VERSION 8.

Database: 'SAMPLE'

** ERROR **

Database cannot be connected.

% db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL08015"
with level identifier "02060106".
Informational tokens are "DB2 v8.1.1.48", "s040212", "U496793", and
FixPak "5".
Product is installed at "/usr/opt/db2_08_01".
% db2 connect to sample
SQL1032N No start database manager command was issued.
SQLSTATE=57019

% db2start
06-20-2004 00:25:07 2 0 SQL1063N DB2START processing was
successful.
06-20-2004 00:25:07 4 0 SQL1063N DB2START processing was
successful.
06-20-2004 00:25:07 1 0 SQL1063N DB2START processing was
successful.
06-20-2004 00:25:08 3 0 SQL1063N DB2START processing was
successful.
SQL1063N DB2START processing was successful.

% db2 connect to sample
SQL5035N The database requires migration to the current release.

How would I find the cause of the error from db2ckmig? It just says
Database cannot be connected.

Note: The same command was successful earlier and I started the
database migration. But the DB migration was hung and had to cancell
it. Now, before issuing the db migration, I thought of issuing the
db2ckmig again and got the above error. I would like to know what
causes the error on db2ckmig? would it be the failed "migrate db"?.
truss, is not showing much info either.

Thanks.

[Ian]

Prince Kumar wrote:

I am trying to run db2ckmig on my new db2 v8 ESE instance on AIX 5.2.
My previous db2 version was V7.1.

when I issue the db2ckmig for the db, I get the following error.

% db2ckmig sample -l /tmp/db2ckmig.log

db2ckmig was unsuccessful. Please look at logfile for more details.

% cat /tmp/db2ckmig.log

Version of DB2CKMIG being run: VERSION 8.

Database: 'SAMPLE'

** ERROR **

Database cannot be connected.

% db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL08015"
with level identifier "02060106".
Informational tokens are "DB2 v8.1.1.48", "s040212", "U496793", and
FixPak "5".
Product is installed at "/usr/opt/db2_08_01".

You're supposed to run db2ckmig _before_ you migrate the instance,
so you can fix errors first.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[dba2adm]

Thanks Ian for your response.

As I mentioned earlier, I did the ckmig before starting the migration.
Then when I did the migration, the process was hung and had to
terminate/kill. Now, if I restart the migration it may be ok, but I am
not sure, as the migration process may again run db2ckmig. So, I
thought of doing the db2ckmig again ust to validate whether the db is
in migratable state.

Thanks,

Ian <ia*****@mobileaudio.com> wrote in message news:<40**********@corp.newsgroups.com>...

Prince Kumar wrote:

I am trying to run db2ckmig on my new db2 v8 ESE instance on AIX 5.2.
My previous db2 version was V7.1.

when I issue the db2ckmig for the db, I get the following error.

% db2ckmig sample -l /tmp/db2ckmig.log

db2ckmig was unsuccessful. Please look at logfile for more details.

% cat /tmp/db2ckmig.log

Version of DB2CKMIG being run: VERSION 8.

Database: 'SAMPLE'

** ERROR **

Database cannot be connected.

% db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL08015"
with level identifier "02060106".
Informational tokens are "DB2 v8.1.1.48", "s040212", "U496793", and
FixPak "5".
Product is installed at "/usr/opt/db2_08_01".

You're supposed to run db2ckmig _before_ you migrate the instance,
so you can fix errors first.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Prince Kumar]

Sorry for the confusion. I posted the message from the machine where
my friend is logged in to the forum.

Thanks,

db*****@yahoo.com wrote in message news:<90**************************@posting.google. com>...

Thanks Ian for your response.

As I mentioned earlier, I did the ckmig before starting the migration.
Then when I did the migration, the process was hung and had to
terminate/kill. Now, if I restart the migration it may be ok, but I am
not sure, as the migration process may again run db2ckmig. So, I
thought of doing the db2ckmig again ust to validate whether the db is
in migratable state.

Thanks,

Ian <ia*****@mobileaudio.com> wrote in message news:<40**********@corp.newsgroups.com>...

Prince Kumar wrote:

I am trying to run db2ckmig on my new db2 v8 ESE instance on AIX 5.2.
My previous db2 version was V7.1.

when I issue the db2ckmig for the db, I get the following error.

% db2ckmig sample -l /tmp/db2ckmig.log

db2ckmig was unsuccessful. Please look at logfile for more details.

% cat /tmp/db2ckmig.log

Version of DB2CKMIG being run: VERSION 8.

Database: 'SAMPLE'

** ERROR **

Database cannot be connected.

% db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL08015"
with level identifier "02060106".
Informational tokens are "DB2 v8.1.1.48", "s040212", "U496793", and
FixPak "5".
Product is installed at "/usr/opt/db2_08_01".

You're supposed to run db2ckmig _before_ you migrate the instance,
so you can fix errors first.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Amar]

You have to run db2ckmig before you migrate your "instance" Seems like
you already have migrated your instance. Furthermore I "think"
db2imigr for instance
migration runs db2ckmig as well. So if you have migrated your instance
with db2imigr, then you don't have to run db2ckmig anymore.

Jeegar.


gs**@yahoo.com (Prince Kumar) wrote in message news:<62**************************@posting.google. com>...

Sorry for the confusion. I posted the message from the machine where
my friend is logged in to the forum.

Thanks,

db*****@yahoo.com wrote in message news:<90**************************@posting.google. com>...

Thanks Ian for your response.

As I mentioned earlier, I did the ckmig before starting the migration.
Then when I did the migration, the process was hung and had to
terminate/kill. Now, if I restart the migration it may be ok, but I am
not sure, as the migration process may again run db2ckmig. So, I
thought of doing the db2ckmig again ust to validate whether the db is
in migratable state.

Thanks,

Ian <ia*****@mobileaudio.com> wrote in message news:<40**********@corp.newsgroups.com>...

Prince Kumar wrote:

> I am trying to run db2ckmig on my new db2 v8 ESE instance on AIX 5.2.
> My previous db2 version was V7.1.
>
> when I issue the db2ckmig for the db, I get the following error.
>
> % db2ckmig sample -l /tmp/db2ckmig.log
>
> db2ckmig was unsuccessful. Please look at logfile for more details.
>
> % cat /tmp/db2ckmig.log
>
> Version of DB2CKMIG being run: VERSION 8.
>
> Database: 'SAMPLE'
>
> ** ERROR **
>
> Database cannot be connected.
>
> % db2level
> DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
> "SQL08015"
> with level identifier "02060106".
> Informational tokens are "DB2 v8.1.1.48", "s040212", "U496793", and
> FixPak "5".
> Product is installed at "/usr/opt/db2_08_01".
You're supposed to run db2ckmig _before_ you migrate the instance,
so you can fix errors first.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Amar]

For clarity, database migration command "db2 migrate db sample" does not run
db2ckmig.

Jeegar

gs**@yahoo.com (Prince Kumar) wrote in message news:<62**************************@posting.google. com>...

Sorry for the confusion. I posted the message from the machine where
my friend is logged in to the forum.

Thanks,

db*****@yahoo.com wrote in message news:<90**************************@posting.google. com>...

Thanks Ian for your response.

As I mentioned earlier, I did the ckmig before starting the migration.
Then when I did the migration, the process was hung and had to
terminate/kill. Now, if I restart the migration it may be ok, but I am
not sure, as the migration process may again run db2ckmig. So, I
thought of doing the db2ckmig again ust to validate whether the db is
in migratable state.

Thanks,

Ian <ia*****@mobileaudio.com> wrote in message news:<40**********@corp.newsgroups.com>...

Prince Kumar wrote:

> I am trying to run db2ckmig on my new db2 v8 ESE instance on AIX 5.2.
> My previous db2 version was V7.1.
>
> when I issue the db2ckmig for the db, I get the following error.
>
> % db2ckmig sample -l /tmp/db2ckmig.log
>
> db2ckmig was unsuccessful. Please look at logfile for more details.
>
> % cat /tmp/db2ckmig.log
>
> Version of DB2CKMIG being run: VERSION 8.
>
> Database: 'SAMPLE'
>
> ** ERROR **
>
> Database cannot be connected.
>
> % db2level
> DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
> "SQL08015"
> with level identifier "02060106".
> Informational tokens are "DB2 v8.1.1.48", "s040212", "U496793", and
> FixPak "5".
> Product is installed at "/usr/opt/db2_08_01".
You're supposed to run db2ckmig _before_ you migrate the instance,
so you can fix errors first.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Prince Kumar]

Thanks Amar and others,

I ran the the migrate database again and it went thru fine.

Regards,
Prince.

he*******@yahoo.com (Amar) wrote in message news:<47**************************@posting.google. com>...

For clarity, database migration command "db2 migrate db sample" does not run
db2ckmig.

Jeegar

gs**@yahoo.com (Prince Kumar) wrote in message news:<62**************************@posting.google. com>...

Sorry for the confusion. I posted the message from the machine where
my friend is logged in to the forum.

Thanks,

db*****@yahoo.com wrote in message news:<90**************************@posting.google. com>...

Thanks Ian for your response.

As I mentioned earlier, I did the ckmig before starting the migration.
Then when I did the migration, the process was hung and had to
terminate/kill. Now, if I restart the migration it may be ok, but I am
not sure, as the migration process may again run db2ckmig. So, I
thought of doing the db2ckmig again ust to validate whether the db is
in migratable state.

Thanks,

Ian <ia*****@mobileaudio.com> wrote in message news:<40**********@corp.newsgroups.com>...
> Prince Kumar wrote:
>
> > I am trying to run db2ckmig on my new db2 v8 ESE instance on AIX 5.2.
> > My previous db2 version was V7.1.
> >
> > when I issue the db2ckmig for the db, I get the following error.
> >
> > % db2ckmig sample -l /tmp/db2ckmig.log
> >
> > db2ckmig was unsuccessful. Please look at logfile for more details.
> >
> > % cat /tmp/db2ckmig.log
> >
> > Version of DB2CKMIG being run: VERSION 8.
> >
> > Database: 'SAMPLE'
> >
> > ** ERROR **
> >
> > Database cannot be connected.
> >
> > % db2level
> > DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
> > "SQL08015"
> > with level identifier "02060106".
> > Informational tokens are "DB2 v8.1.1.48", "s040212", "U496793", and
> > FixPak "5".
> > Product is installed at "/usr/opt/db2_08_01".
>
>
> You're supposed to run db2ckmig _before_ you migrate the instance,
> so you can fix errors first.
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 100,000 Newsgroups - 19 Different Servers! =-----