| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DB2 Upgrade from 7.2 FP8 to 8.1 FP5 |
« View previous topic :: View next topic » |
| Author |
Message
|
| kriersd |
 Posted: Wed Jun 02, 2004 8:23 am Post subject: DB2 Upgrade from 7.2 FP8 to 8.1 FP5 |
 |
|
Master
Joined: 22 Jul 2002
Posts: 209
Location: IA, USA
|
Has anyone done this before??
I just tried to start my Workflow configuration and I get a -998 error. I have tried all the usual "-998" fixes and nothing works. I was told that there are a number of things that need to be changed after the upgrade but I still get the error. Below are the items I was told to change after the upgrade was complete. Did I miss something.
| Quote: |
The User mqm should have set in its .profile
export EXTSHM=ON
This allows to start the Queue Manager with extended shared memory.
In addition, the qm.ini has to be changed in the seciton XAResourceManager:
XAResourceManager:
Name=db2inst1 FMCDB
SwitchFile=/usr/lpp/fmc/db2swit/db2swit
XAOpenString=DB=FMCDB, toc=t, UID=fmc, PWD=fmtest
ThreadOfControl=THREAD
For DB2 V8, FP3 is the minimum maintenance level required. Our tests
have been performed with FP5.
To avoid XA problems during db2stop, you need to make the following
changes:
db2set db2envlist=EXTSHM
export EXTSHM=ON
db2start
|
Here is the error messages from the fmcerr.log.
| Code: |
WebSphere MQ Workflow 3.4 Error Report
Report creation = 06/02/04 11:16:06
Related message = FMC31020E The server could not be started.
Error location = File=/projects/fmc/drvp/lbld/v340/objopt/db2cs/fmcdbac1/fmcdbsvs.cxx, Line=3635, Function=FmcDatabase::Serve
r::selServerSetting(const long *, const FmcString &, const FmcString &, const FmcString &, FMC_SERVER &, FMC_SYSTEM &, FMC_SYS
TEM_GROUP &, FMC_DOMAIN &) const
Error data = FmcSQLException, Sqlcode=-998, Sqlerrmc=9, Sqlerrp=SQLXAPI , Sqlerrd[0]=0, Sqlerrd[1]=9, Sqlerrd[2]=0, Sqler
rd[3]=0, Sqlerrd[4]=0, Sqlerrd[5]=0, Sqlwarn= , Sqlstate=58005
WebSphere MQ Workflow 3.4 Error Report
Report creation = 06/02/04 11:16:06
Related message = FMC31000E A database error occurred. SQL code: -998.
Error location = File=/projects/fmc/drvp/lbld/v340/aix/src/fmcssrva.cxx, Line=763, Function=FmcServerAdapter::Init(FmcSFServe
rCtrl &)
Error data = FmcExtException, MsgID=31000, MsgParam=-998, , , , , , ,
|
_________________
Dave Krier
IBM WebSphere MQ Workflow V3.4 Solution Designer |
|
| Back to top |
|
 |
| mm1978 |
| Posted: Wed Jun 02, 2004 10:34 am Post subject: |
|
|
Apprentice
Joined: 06 Sep 2003
Posts: 42
|
I did. But on Windows XP. I was getting the same error because after I migrated to DB2 8.1 from DB2 7.1, while installation the DB2 path in the regedit was not pointing to the new location (C:\Program Files\IBM\SQLLIB\) instead it was pointing to previous DB2 7.1 directory. I had to manually change the path and restart the system to take the effect.
Hope you solve the problem soon.
mm |
|
| Back to top |
|
|
| kriersd |
| Posted: Wed Jun 23, 2004 10:33 am Post subject: |
|
|
Master
Joined: 22 Jul 2002
Posts: 209
Location: IA, USA
|
The problem was because I had multiple versions of DB2 on the system.
I created a soft link to the db2lib.a file in the mqm/lib directoryand everyting works fine now. Once I upgraded all of the DB2 instances on the system I no-longer needed the soft link.
| Code: |
| ln -s /usr/opt/db2_08_FP5/lib/libdb2.a /usr/mqm/lib/libdb2.a |
_________________
Dave Krier
IBM WebSphere MQ Workflow V3.4 Solution Designer |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
