| Author |
Message
|
| lung |
 Posted: Tue Apr 22, 2003 7:43 pm Post subject: Error configuring MQ Workflow for the first time |
 |
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
Okay, First of all I like to say I've never use MQ Workflow before...
Anyway, after everything installed, the only program I can run is the MQSeries Workflow Configuration Utility. I created a new MQSeries Workflow configuration, and clicked on Server, Runtime, and Buildtime.
Clicked next, next, and next (all using default values) and finally Done. While creating a new database and so forth, I receive this error message...
| Code: |
| FMC33148E DB2 CLI call 'SQLExecDirect(CREATE TAB)' ended with error: '[IBM][CLI Driver][DB2/NT] SQL0298N Bad container path'. |
Anyone here can help me? 
FYI, I am running this on Windows 2000 Pro. And I was using WMQI on this same machine with no problems at all... (DB2 was configured to run WMQI, but this shouldn't impact MQ Workflow, right?  )
Thanks in advance! |
|
| Back to top |
|
 |
| vennela |
| Posted: Wed Apr 23, 2003 6:22 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
It's more of a DB2 error than an MQWF error. See DB2 docs to find the reasons for getting SQL0298N.
You should pay attention to what value is used for "Containers location" in New DB2 Database page.
Also post the versions of
DB2
MQ
MQWF
-------
Venny |
|
| Back to top |
|
|
| Ratan |
| Posted: Wed Apr 23, 2003 9:11 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
Is it possible you are giving a wrong drive name. I believe I had seen a similar error when I was specifying a wrong drive name.
If possible save your configuration input and post it here. That could help.
-Ratan. |
|
| Back to top |
|
|
| lung |
| Posted: Wed Apr 23, 2003 6:13 pm Post subject: |
|
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
Thanks for the reply.
DB2 docs do not seem to supply any useful information regarding SQL0298N as the database was created by MQ Workflow, and not manually by me...
The following are the version of my components...
DB2 - 7
MQ - 5.2.1
MQWF - 3.3.2
I'm using the default value for 'Container Location', that is some directory defined by MQ Workflow in my only hard disk, and that's the C drive.
Thanks for all your help!
EDIT: This is the log generated.
| Code: |
FMC33740I Creating the Runtime database. This may take a while ( > 10 Min ) ...
FMC33136I Generating database layout.
FMC33153W The managed by value for tablespaces belonging to group INDEX is not customizable.
FMC33110I The database manager is already active.
FMC33115I Creating the database - FMCDB
FMC33116I Please wait... This may take a while.
FMC33117I Database FMCDB has been created.
FMC33120I Updating the database configuration.
FMC33132I Creating tablespaces.
FMC33148E DB2 CLI call 'SQLExecDirect(CREATE TAB)' ended with error: '[IBM][CLI Driver][DB2/NT] SQL0298N Bad container path'.
FMC33902E Error while creating Runtime database FMCDB occurred.
See the log file c:\program files\mqseries workflow\cfgs\fmc\log\@fmczrt.log for more information. |
Notice the line FMC33153W The managed by value for tablespaces belonging to group INDEX is not customizable., is this the cause of the problem? How do I fix this? |
|
| Back to top |
|
|
| amittalekar |
| Posted: Thu Apr 24, 2003 5:56 am Post subject: |
|
|
Disciple
Joined: 03 Apr 2002
Posts: 166
Location: VA, USA
|
Try this, may be one of the reasons
1)go to drive (may be ur C drive ) properties screen, found by right clicking on a disk drive and going to the properties tab.
2)There is a check box, that by default, is checked, called "Allow Indexing Service to index this disk for fast file searching".
3) this should be checked, if not checked it & then try again |
|
| Back to top |
|
|
| Ratan |
| Posted: Thu Apr 24, 2003 8:39 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
I hope you are specifying the container location as 'c:'.
If the problem is not yet solved, try posting the saved configuration file. That helps.
-Ratan. |
|
| Back to top |
|
|
| amittalekar |
| Posted: Thu Apr 24, 2003 12:32 pm Post subject: |
|
|
Disciple
Joined: 03 Apr 2002
Posts: 166
Location: VA, USA
|
also, what db2 fix pack u are using?
If u are using db2 7.1 , u should have atleast fixpack 5. |
|
| Back to top |
|
|
| lung |
| Posted: Thu Apr 24, 2003 5:28 pm Post subject: |
|
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
Setting "Allow Indexing Service to index this disk for fast file searching" to checked seems to have solved the problem, although this line still exist
| Code: |
| FMC33153W The managed by value for tablespaces belonging to group INDEX is not customizable. |
Anyway, thanks lots!!!  Now if I just know how to use this thing...  |
|
| Back to top |
|
|
| amittalekar |
| Posted: Fri Apr 25, 2003 5:06 am Post subject: |
|
|
Disciple
Joined: 03 Apr 2002
Posts: 166
Location: VA, USA
|
| that's fine... this will not cause any issues... |
|
| Back to top |
|
|
|
|
