DB2 migration issue from v8.2 to v9.5 fp3
in [DB2]
|
Prev: Register Free: IBM event on Cloud Computing on Feb 23rd in Delhi
Next: Limiting file system caching on RH Linux version 5
From: Tony on 22 Feb 2010 10:18 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!
From: whatever on 22 Feb 2010 12:58 On Feb 22, 10:18 am, Tony <tonyedr...(a)gmail.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
From: Tony on 22 Feb 2010 14:26 On Feb 22, 12:58 pm, whatever <audheya2...(a)gmail.com> wrote: > On Feb 22, 10:18 am, Tony <tonyedr...(a)gmail.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.
From: Mark A on 22 Feb 2010 16:05
"Tony" <tonyedress(a)gmail.com> wrote in message news:4eac567c-c963-4280-be78-77af04231b54(a)z35g2000yqd.googlegroups.com... > Thanks a lot Shashi! The message is stopped in the log now. I would upgrade to FP 5 ASAP. FP 3 sucks. |