| Author |
Message
|
| amittalekar |
 Posted: Tue Aug 27, 2002 1:59 pm Post subject: Workflow Server - DB2 remote connectivity |
 |
|
Disciple
Joined: 03 Apr 2002
Posts: 166
Location: VA, USA
|
Hi,
I have installed DB2 client, MQ series server & Workflow server on one unix box. There is another machine where db2 server is installed. I want to create remote runtime database on the Db2 server using fmczutil utility.
DB2 client catalog, connection is already done.
Using this utility when i specify the remote server details and go for creating runtime database i get following error
A database error sql code -805
SQLD805N Package FMC.FMCDBTOP not found
sql state = 51002
Anybody has come across this problem ????? |
|
| Back to top |
|
 |
| vennela |
| Posted: Tue Aug 27, 2002 5:25 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
I haven't come across this SQLD805N error but check these before you try to create a remote database
1. During the catalog, have you given the correct port number (or if TCP/IP, service name SVCENAME ).
2. Have you given the correct instance while cataloging. Reconfirm this on the client machine by doing a DB2 instance listing ( db2ilist works I guess). If you can't see your instance then do a terminate
3. Can you ATTACH to the node from the client machine. Do a ATTACH DETACH to confirm. (Before that see if you have started DB2 server)
4. Try creating a sample database on the server machine (command is db2sampl ). Try connecting to this database and do a select * from SAMPLE .
5. Check all the authorizations.
If you can do all this then you must be all set to create a runtime database.
I always maintain that creating a sample database and doing a query from the client machine always helps beacuse we don't yet have the remote runtime database to ping. |
|
| Back to top |
|
|
| amittalekar |
| Posted: Wed Aug 28, 2002 4:29 am Post subject: |
|
|
Disciple
Joined: 03 Apr 2002
Posts: 166
Location: VA, USA
|
| I have already done all the steps which u mensioned. Also verified the client connectivity. There is no problem. The error occurs when I run workflow configuration utility to create runtine (or use existing) database. |
|
| Back to top |
|
|
| vennela |
| Posted: Wed Aug 28, 2002 5:20 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
Ok.
Now few more checks
1. Do you have the same version and release of DB2 client as DB2 server
2. Do you have both the admin client and runtime client. The absence of DB2 Admin client will cause the installation of the remote database to fail. Ususally the symptoms include SQL0805N (-805).
Check these and try again.
---
venny |
|
| Back to top |
|
|
| Ratan |
| Posted: Tue Sep 03, 2002 11:56 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
Vennela, I had been using a remote run-time database and always used just the Run-time DB2 client and it never gave a problem to me. Did you really ever run into the error you mentioned for not having the admin client?
-Laze |
|
| Back to top |
|
|
| amittalekar |
| Posted: Thu Sep 05, 2002 5:16 am Post subject: |
|
|
Disciple
Joined: 03 Apr 2002
Posts: 166
Location: VA, USA
|
lazeknight, On the remote DB2 Server do I need to put anything in the classpath or Other than DB2 server do I need anything else?
Please tell me in detail... |
|
| Back to top |
|
|
| Ratan |
| Posted: Wed Sep 11, 2002 8:17 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
I did not come across a problem like yours ever before. Check to see if you are able to connect to the remote instance. Do an attach and detach. If everything is fine with the catalog, there should not be any problem. check if you are giving the remote database locations properly. There is nothing needed to be done on the DB2 server.
Let us know if you solved the problem.
-Laze |
|
| Back to top |
|
|
|
|
