| Author | 
		  Message
		 | 
		
		  | opmind | 
		  
		    
			  
				 Posted: Tue Nov 08, 2005 6:15 am    Post subject: Problem WBI 5 after migrate db2 7.2.13 to db2 8 fixpak10 | 
				     | 
			   
			 
		   | 
		
		
		   Acolyte
 
 Joined: 04 Dec 2001 Posts: 68
  
  | 
		  
		    
			  
				hello there ...
 
 
i've got a problem. Under AIX. 
 
 
We installed some month ago WBI under DB2 7 2 fixpack 13 and everything runs very well ... CSD6 for WBI is ok. 
 
 
Last week, we migrated db2 to v8 fixpack 10. 
 
 
After that, here's the fun thing : 
 
Broker starts, 
 
ConfigMgr starts ... 
 
 
but I've got serious error messages in /var/adm/user.log : 
 
 
Nov  8 14:55:06 x02762pa MQSIv500[2072652]: (XTEST_BK.par défaut)[1]BIP2111E: Message broker internal error: diagnostic information 'DynamicSubscriptionEngine'. : XTEST_BK.8e3d9196-0601-0000-0080-822dd17f96d3: /build/S500_P/src/DataFlowEngine/JavaNodeLibrary/ImbPubSubDatabase.cpp: 228: ImbPubSubDatabase::ImbPubSubDatabase: DynamicSubscriptionEngine: DynamicSubscriptionEngine
 
 
Nov  8 14:55:06 x02762pa MQSIv500[2072652]: (XTEST_BK.par défaut)[1]BIP2321E: Database error: ODBC return code '-1'. : XTEST_BK.8e3d9196-0601-0000-0080-822dd17f96d3: /build/S500_P/src/DataFlowEngine/ImbOdbc.cpp: 213: ImbOdbcHandle::checkRcInner: : 
 
Nov  8 14:55:06 x02762pa MQSIv500[2072652]: (XTEST_BK.par défaut)[1]BIP2322E: Database error: SQL State '42724'; Native Error Code '-444'; Error Text '[IBM][CLI Driver][DB2/6000] SQL0444N  Routine "SQLTABLES" (specific name "TABLES") is implemented with code in library or path ".../sqllib/function/unfenced/db2schem", function "sqltables" which cannot be accessed.  Reason code: "4".  SQLSTATE=42724 '. : XTEST_BK.8e3d9196-0601-0000-0080-822dd17f96d3: /build/S500_P/src/DataFlowEngine/ImbOdbc.cpp: 366: ImbOdbcHandle::checkRcInner: : 
 
 
Any Clue ? I don't see anything... 
 
 
Cyril | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | fschofer | 
		  
		    
			  
				 Posted: Tue Nov 08, 2005 6:57 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Knight
 
 Joined: 02 Jul 2001 Posts: 524 Location: Mainz, Germany 
  | 
		  
		    
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | opmind | 
		  
		    
			  
				 Posted: Tue Nov 08, 2005 7:20 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Acolyte
 
 Joined: 04 Dec 2001 Posts: 68
  
  | 
		  
		    
			  
				Nope   It doesn't work ... | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | wschutz | 
		  
		    
			  
				 Posted: Tue Nov 08, 2005 7:22 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Knight
 
 Joined: 02 Jun 2005 Posts: 3316 Location: IBM (retired) 
  | 
		  
		    
			  
				After fp10 was applied, did you update the db2 instance? _________________ -wayne | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | opmind | 
		  
		    
			  
				 Posted: Tue Nov 08, 2005 7:26 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Acolyte
 
 Joined: 04 Dec 2001 Posts: 68
  
  | 
		  
		    
			  
				I just did db2updv8 on my Broker DataBase ... 
 
It's already with FixPack 10 ... | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | wschutz | 
		  
		    
			  
				 Posted: Tue Nov 08, 2005 9:37 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Knight
 
 Joined: 02 Jun 2005 Posts: 3316 Location: IBM (retired) 
  | 
		  
		    
			  
				(not 100% sure), but don't you also need to issue "db2iupdt <instance name> after applying a FP? _________________ -wayne | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |