dbTalk Databases Forums  

DB2 migration issue from v8.2 to v9.5 fp3

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss DB2 migration issue from v8.2 to v9.5 fp3 in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tony
 
Posts: n/a

Default DB2 migration issue from v8.2 to v9.5 fp3 - 02-22-2010 , 10:18 AM






Hi,

I migrated the DB2 databases from v8.2 to v9.5+fp3 successfully except
the following issue from db2diag.log.

__________________________________________________ __
2010-02-22-09.48.21.993163-300 I11339579A449 LEVEL: Severe
PID : 28133 TID : 534 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SYSCAT
APPHDL : 0-19150 APPID: *LOCAL.db2inst1.100222144821
AUTHID : DB2INST1
EDUID : 534 EDUNAME: db2agent (SYSCAT) 0
FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForSerialization,
probe:30
RETCODE : ZRC=0xFFFFEC55=-5035

2010-02-22-09.48.21.993514-300 I11340029A455 LEVEL: Severe
PID : 28133 TID : 534 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SYSCAT
APPHDL : 0-19150 APPID: *LOCAL.db2inst1.100222144821
AUTHID : DB2INST1
EDUID : 534 EDUNAME: db2agent (SYSCAT) 0
FUNCTION: DB2 UDB, base sys utilities,
sqeDBMgr::StartUsingLocalDatabase, probe:10
RETCODE : ZRC=0xFFFFEC55=-5035
.....
________________________________________

This message's appearing every second in the db2diag.log. Does anyone
know what happens on the database and help me to stop/fix it?

Any inputs will be much appreciated!

Reply With Quote
  #2  
Old   
whatever
 
Posts: n/a

Default Re: DB2 migration issue from v8.2 to v9.5 fp3 - 02-22-2010 , 12:58 PM






On Feb 22, 10:18*am, Tony <tonyedr... (AT) gmail (DOT) com> wrote:
Quote:
Hi,

I migrated the DB2 databases from v8.2 to v9.5+fp3 successfully except
the following issue from db2diag.log.

__________________________________________________ __
2010-02-22-09.48.21.993163-300 I11339579A449 * * *LEVEL: Severe
PID * * : 28133 * * * * * * * *TID *: 534 * * * * PROC : db2sysc 0
INSTANCE: db2inst1 * * * * * * NODE : 000 * * * * DB * : SYSCAT
APPHDL *: 0-19150 * * * * * * *APPID: *LOCAL.db2inst1.100222144821
AUTHID *: DB2INST1
EDUID * : 534 * * * * * * * * *EDUNAME: db2agent (SYSCAT) 0
FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForSerialization,
probe:30
RETCODE : ZRC=0xFFFFEC55=-5035

2010-02-22-09.48.21.993514-300 I11340029A455 * * *LEVEL: Severe
PID * * : 28133 * * * * * * * *TID *: 534 * * * * PROC : db2sysc 0
INSTANCE: db2inst1 * * * * * * NODE : 000 * * * * DB * : SYSCAT
APPHDL *: 0-19150 * * * * * * *APPID: *LOCAL.db2inst1.100222144821
AUTHID *: DB2INST1
EDUID * : 534 * * * * * * * * *EDUNAME: db2agent (SYSCAT) 0
FUNCTION: DB2 UDB, base sys utilities,
sqeDBMgr::StartUsingLocalDatabase, probe:10
RETCODE : ZRC=0xFFFFEC55=-5035
....
________________________________________

This message's appearing every second in the db2diag.log. Does anyone
know what happens on the database and help me to stop/fix it?

Any inputs will be much appreciated!
-5035 Means

SQL5035N ...Use migrate command for these databases and activate
again.


Cheers...
Shashi Mannepalli

Reply With Quote
  #3  
Old   
Tony
 
Posts: n/a

Default Re: DB2 migration issue from v8.2 to v9.5 fp3 - 02-22-2010 , 02:26 PM



On Feb 22, 12:58*pm, whatever <audheya2... (AT) gmail (DOT) com> wrote:
Quote:
On Feb 22, 10:18*am, Tony <tonyedr... (AT) gmail (DOT) com> wrote:





Hi,

I migrated the DB2 databases from v8.2 to v9.5+fp3 successfully except
the following issue from db2diag.log.

__________________________________________________ __
2010-02-22-09.48.21.993163-300 I11339579A449 * * *LEVEL: Severe
PID * * : 28133 * * * * * * * *TID *: 534 * ** * PROC : db2sysc 0
INSTANCE: db2inst1 * * * * * * NODE : 000 * * * * DB * : SYSCAT
APPHDL *: 0-19150 * * * * * * *APPID: *LOCAL.db2inst1.100222144821
AUTHID *: DB2INST1
EDUID * : 534 * * * * * * * * *EDUNAME: db2agent (SYSCAT) 0
FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForSerialization,
probe:30
RETCODE : ZRC=0xFFFFEC55=-5035

2010-02-22-09.48.21.993514-300 I11340029A455 * * *LEVEL: Severe
PID * * : 28133 * * * * * * * *TID *: 534 * ** * PROC : db2sysc 0
INSTANCE: db2inst1 * * * * * * NODE : 000 * * * * DB * : SYSCAT
APPHDL *: 0-19150 * * * * * * *APPID: *LOCAL.db2inst1.100222144821
AUTHID *: DB2INST1
EDUID * : 534 * * * * * * * * *EDUNAME: db2agent (SYSCAT) 0
FUNCTION: DB2 UDB, base sys utilities,
sqeDBMgr::StartUsingLocalDatabase, probe:10
RETCODE : ZRC=0xFFFFEC55=-5035
....
________________________________________

This message's appearing every second in the db2diag.log. Does anyone
know what happens on the database and help me to stop/fix it?

Any inputs will be much appreciated!

-5035 Means

SQL5035N ...Use migrate command for these databases and activate
again.

Cheers...
Shashi Mannepalli- Hide quoted text -

- Show quoted text -
Thanks a lot Shashi! The message is stopped in the log now.

Reply With Quote
  #4  
Old   
Mark A
 
Posts: n/a

Default Re: DB2 migration issue from v8.2 to v9.5 fp3 - 02-22-2010 , 04:05 PM



"Tony" <tonyedress (AT) gmail (DOT) com> wrote

Quote:
Thanks a lot Shashi! The message is stopped in the log now.
I would upgrade to FP 5 ASAP. FP 3 sucks.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.