| Author | 
		  Message
		 | 
		
		  | lcl3977 | 
		  
		    
			  
				 Posted: Tue Sep 12, 2006 7:43 pm    Post subject: how many db I have set to the broker? | 
				     | 
			   
			 
		   | 
		
		
		   Apprentice
 
 Joined: 04 Jul 2006 Posts: 27
  
  | 
		  
		    
			  
				as we know, we can use mqsisetdbparms to set the db information to the broker.
 
but how I know how many db I have set to the broker?
 
is there someone know? I have find it in help document.but there is no value info. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | fjb_saper | 
		  
		    
			  
				 Posted: Sun Sep 17, 2006 7:17 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Grand High Poobah
 
 Joined: 18 Nov 2003 Posts: 20768 Location: LI,NY 
  | 
		  
		    
			  
				Look at your ODBC config. All DBs set up (correctly) in the  ODBC config of the broker should be reachable by the broker. Enjoy    _________________ MQ & Broker admin | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | lcl3977 | 
		  
		    
			  
				 Posted: Tue Sep 19, 2006 10:36 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Apprentice
 
 Joined: 04 Jul 2006 Posts: 27
  
  | 
		  
		    
			  
				I thank you may not know my idear.
 
 
for example ,I can write 10 ODBC config in .odbc.ini .but I have mqsisetdbparms for 6 times.may be I mqsisetdbparms  by the same ODBC config but the different db user name.
 
 
I want know how many I have mqsisetdbparms  to the broker .
 
Is there some command to list it? or I can find it in the broker'db? | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | brokerDev | 
		  
		    
			  
				 Posted: Wed Sep 20, 2006 12:53 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Acolyte
 
 Joined: 21 Jun 2006 Posts: 53
  
  | 
		  
		    
			  
				| If you're using unix/aix. Try having a look in var/mqsi/registry/broker name/DSN | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | lcl3977 | 
		  
		    
			  
				 Posted: Mon Sep 25, 2006 7:32 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Apprentice
 
 Joined: 04 Jul 2006 Posts: 27
  
  | 
		  
		    
			  
				thank you for your help.
 
I'am using AIX.
 
brokerDev you are right!!!
 
I find, in window,the confing infomation is in regedit .
 
you can search it. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |