| Author | 
		  Message
		 | 
		
		  | thindk00 | 
		  
		    
			  
				 Posted: Fri Aug 26, 2005 8:18 am    Post subject: mqsisetdbparms | 
				     | 
			   
			 
		   | 
		
		
		   Voyager
 
 Joined: 16 May 2001 Posts: 75 Location: UK 
  | 
		  
		    
			  
				Hi,
 
 
Somewhere along the line an administrator of our WBIMB environment has issued the "mqsisetdbparm" command to ensure a WBIMB broker uses a different user id and password when connecting to a particular database.  
 
 
How can we find out what the current settings applied to our broker are?  I've had a look at the Broker databases and can't find anything there, any ideas of a command or where to look for this information?  We're using Solaris, WBIMB 5.0.1 CSD3.
 
 
TIA,
 
 
Kulbir. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | jefflowrey | 
		  
		    
			  
				 Posted: Fri Aug 26, 2005 8:26 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Grand Poobah
 
 Joined: 16 Oct 2002 Posts: 19981
  
  | 
		  
		    
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | thindk00 | 
		  
		    
			  
				 Posted: Fri Aug 26, 2005 8:29 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Voyager
 
 Joined: 16 May 2001 Posts: 75 Location: UK 
  | 
		  
		    
			  
				Hi,
 
 
How does this work on Solaris?
 
 
Thanks,
 
 
Kulbir. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | JT | 
		  
		    
			  
				 Posted: Fri Aug 26, 2005 8:30 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Padawan
 
 Joined: 27 Mar 2003 Posts: 1564 Location: Hartford, CT. 
  | 
		  
		    
			  
				
   
	| Quote: | 
   
  
	| How can we find out what the current settings applied to our broker are? | 
   
 
 
You won't be able to determine the value of the password, as it's encrypted in the Password file. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | thindk00 | 
		  
		    
			  
				 Posted: Fri Aug 26, 2005 8:32 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Voyager
 
 Joined: 16 May 2001 Posts: 75 Location: UK 
  | 
		  
		    
			  
				That's ok, just the user id will do for now.  Just need to find out which user id the broker is attempting to use for a particular Data Source.
 
 
Thanks. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | JT | 
		  
		    
			  
				 Posted: Fri Aug 26, 2005 8:33 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Padawan
 
 Joined: 27 Mar 2003 Posts: 1564 Location: Hartford, CT. 
  | 
		  
		    
			  
				
   
	| Quote: | 
   
  
	| How does this work on Solaris?  | 
   
 
 
As Jeff stated, it's located in the DSN folder of the broker's registry: /var/mqsi/registry/<broker-name>/DSN/<data-source>/ | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | thindk00 | 
		  
		    
			  
				 Posted: Fri Aug 26, 2005 8:44 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Voyager
 
 Joined: 16 May 2001 Posts: 75 Location: UK 
  | 
		  
		    
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |