ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » inst_db script - MQSI NEON Database

Post new topic  Reply to topic
 inst_db script - MQSI NEON Database « View previous topic :: View next topic » 
Author Message
a269652
PostPosted: Fri May 10, 2002 12:45 am    Post subject: Reply with quote

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
View user's profile Send private message
kirani
PostPosted: Sun May 12, 2002 11:58 am    Post subject: Reply with quote

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA

Try connecting to NEON database, either directly or thru a client. Have you registered the database for ODBC?
_________________
Kiran


IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries

Back to top
View user's profile Send private message Visit poster's website
samimohd
PostPosted: Sun May 12, 2002 3:29 pm    Post subject: Reply with quote

Novice

Joined: 25 Mar 2002
Posts: 21

When creating NEON database using inst_db, make sure that you are in the DB2 command line environment. Also you do not have to create a database separately. The script file, will ask you for the option for the name of the database. Give the name of the database here and it will create you the database as well as the odbc connections to the database.


Sami.

mohammed@us.ibm.com
Back to top
View user's profile Send private message Send e-mail
suneelsh
PostPosted: Thu May 16, 2002 8:56 am    Post subject: Reply with quote

Acolyte

Joined: 13 Apr 2002
Posts: 69
Location: Pune,India

finally in inst_db you will be asked to 1-install, 0-refresh

try giving 0 and see.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » inst_db script - MQSI NEON Database
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.