|  | 
 
  
    | RSS Feed - WebSphere MQ Support | RSS Feed - Message Broker Support |  
 
  
	|    |  |  
  
	| inst_db script - MQSI NEON Database | « View previous topic :: View next topic » |  
  	| 
		
		
		  | Author | Message |  
		  | a269652 | 
			  
				|  Posted: Fri May 10, 2002 12:45 am    Post subject: |   |  |  
		  | Novice
 
 
 Joined: 09 May 2002Posts: 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 |  |  
		  |  |  
		  | kirani | 
			  
				|  Posted: Sun May 12, 2002 11:58 am    Post subject: |   |  |  
		  | Jedi Knight
 
 
 Joined: 05 Sep 2001Posts: 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 |  |  
		  |  |  
		  | samimohd | 
			  
				|  Posted: Sun May 12, 2002 3:29 pm    Post subject: |   |  |  
		  | Novice
 
 
 Joined: 25 Mar 2002Posts: 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 |  |  
		  |  |  
		  | suneelsh | 
			  
				|  Posted: Thu May 16, 2002 8:56 am    Post subject: |   |  |  
		  |  Acolyte
 
 
 Joined: 13 Apr 2002Posts: 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 |  |  
		  |  |  
		  |  |  |  
  
	|    |  | 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
 
 |  |  |  |