| Author |
Message
|
| a269652 |
 Posted: Fri May 10, 2002 12:52 am Post subject: |
 |
|
Novice
Joined: 09 May 2002
Posts: 11
|
MQ for NT 5.1/ MSQI for NT 2.0.1 & CDS04 fixpack / UDB 6.1/
I have created a NEON formatter & rules database using DB2 client control center (signed on as db2admin/db2admin) &b tablespaces etc. Try to run 'inst_db db2admin db2admin NEON' & get following error. Any suggestions please?
Database name is: (NEON).
Log file name is: (inst_db.log).
Database product is: (db2).
Database server user name is: (db2admin).
Database server user password is: (db2admin).
Attempting to connect to database.
Loading file (connect).
Database Connection Information
Database server = DB2/NT 6.1.0
SQL authorization ID = DB2ADMIN
Local database alias = NEON
DB20000I The TERMINATE command completed successfully.
SQL load command succeeded for (connect).
Errors occurred while loading the SQL file (connect).
Failed to connect to database.
|
|
| Back to top |
|
 |
| shogan |
| Posted: Fri May 10, 2002 2:44 am Post subject: |
|
|
Novice
Joined: 09 May 2002
Posts: 15
|
If you are running inst_db from a standard DOS window, then open up a DB2 command window as follows :
Start=> IBM DB2 ==> Command window
Run inst_db from this window.
Also run apitest, msgtest etc. from this window as well |
|
| Back to top |
|
|
| vmcgloin |
| Posted: Fri May 10, 2002 3:07 am Post subject: |
|
|
Knight
Joined: 04 Apr 2002
Posts: 560
Location: Scotland
|
Have you created the odbc connection?
In your db2 command window, can you connect to the database?
connect to NEON user db2admin using db2admin
Regards,
Vicky
[ This Message was edited by: vmcgloin on 2002-05-10 04:08 ] |
|
| Back to top |
|
|
| Ward |
| Posted: Fri May 10, 2002 3:08 am Post subject: |
|
|
Voyager
Joined: 27 Jun 2001
Posts: 98
Location: Europe
|
did you create an ODBC connection ?
Ward |
|
| Back to top |
|
|
| a269652 |
| Posted: Fri May 10, 2002 4:36 am Post subject: |
|
|
Novice
Joined: 09 May 2002
Posts: 11
|
Thanks for your suggestions guys.
Yes I did configure an ODBC connection & was able to connect to the database 'NEON' via the db2 command line successfully using db2admin/db2admin. I am also invoking the 'inst_db' cmd from the 'install.sql' directory using the db2 command window, as suggested by the manual. |
|
| Back to top |
|
|
| mqs_guy |
| Posted: Fri May 10, 2002 6:29 am Post subject: |
|
|
Acolyte
Joined: 09 May 2002
Posts: 71
|
Hi,
Did you create 4 tablespaces?? check the sqllib directory to see, if you can find the indexes, you would have created for the 4 tablespaces...
See, if you have logged in as db2admin/db2admin...Also see, if you have added all mq* rights to the user db2admin..and it is a member of mqm group.
Then goto Db2->Client Configuration Assistant and see if you have registered the database..and try connecting again..
Or drop the database, recreate a new one, see, the database name can be case sensitive..so take care abt that..perform the steps above and then try issuing inst_db command.
|
|
| Back to top |
|
|
| a269652 |
| Posted: Fri May 10, 2002 7:06 am Post subject: |
|
|
Novice
Joined: 09 May 2002
Posts: 11
|
Thanks mqs_guy.
I dropped the old database & generated a new one this morning. Yes 4 tablespaces were created after the database & the indexes are resident in the 'sqllib'. I did this via db2 control center after logging in as db2admin/db2admin. db2admin does have all mq* rights & is a member of the mqm group. I have tested the connection via the Client Config. Asst. using db2admin & the db2 command window, on both counts this was successful. All to no avail! |
|
| Back to top |
|
|
| suneelsh |
| Posted: Thu May 16, 2002 8:51 am Post subject: |
|
|
Acolyte
Joined: 13 Apr 2002
Posts: 69
Location: Pune,India
|
| please check to see if all the db2 services are up and running. |
|
| Back to top |
|
|
|
|
