|   | 
	 
  
    | 
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 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 | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | kirani | 
		  
		    
			  
				 Posted: Sun May 12, 2002 11:58 am    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		   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 | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | samimohd | 
		  
		    
			  
				 Posted: Sun May 12, 2002 3:29 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		   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 | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | suneelsh | 
		  
		    
			  
				 Posted: Thu May 16, 2002 8:56 am    Post subject:  | 
				     | 
			   
			 
		   | 
		 
		
		    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 | 
		  
		  	
		   | 
		 
		
		    | 
		 
		
		  | 
		    
		   | 
		 
	   
	 | 
   
 
  
	     | 
	 | 
	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
  | 
  		 
	   
	 | 
   
 
  	 | 
	  |