Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
pais:db2dpfmultinode [2016/08/04 18:40]
master
pais:db2dpfmultinode [2016/08/04 18:46] (current)
master [Update DB2 instance]
Line 100: Line 100:
 2 node30.cci.emory.edu 0 2 node30.cci.emory.edu 0
 </​code>​ </​code>​
- +===== Install DB2 Spatial Extender ​=====
-<font 18px/​inherit;;​inherit;;​inherit>​Install DB2 Spatial Extender</​font>​+
  
 ==== Setup DB2 Spatial Extender on master node ==== ==== Setup DB2 Spatial Extender on master node ====
Line 153: Line 152:
 ''​sudo /​home/​db2/​V9.7/​instance/​db2iupdt db2inst1''​ ''​sudo /​home/​db2/​V9.7/​instance/​db2iupdt db2inst1''​
  
-Note that above installations may need to shut down DB2 if it is running, by running ''​db2stop force'' ​ from ''​db2inst1'' ​ user.+Note that above installations may need to shut down DB2 if it is running, by running ''​db2stop force''​ from ''​db2inst1''​ user.
  
-Try to start db2 (''​db2start''​) from ''​db2inst1'' ​ to test if it works.+Try to start db2 (''​db2start''​) from ''​db2inst1''​ to test if it works.
  
 During our installation,​ we have following error when running ''​db2start'':​ During our installation,​ we have following error when running ''​db2start'':​
Line 161: Line 160:
 "​SQL5043N Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully"​ "​SQL5043N Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully"​
  
-  - +<​code>​
 db2 get dbm cfg |grep SVCE db2 get dbm cfg |grep SVCE
- 
 TCP/IP Service name (SVCENAME) = TCP/IP Service name (SVCENAME) =
- 
 SSL service name (SSL_SVCENAME) = SSL service name (SSL_SVCENAME) =
 +</​code>​
  
-This is due to empty SVCENAME. Run following command under ''​db2inst1'' ​ to update it:+This is due to empty SVCENAME. Run following command under ''​db2inst1''​ to update it:
  
 ''​db2 update dbm cfg using SVCENAME db2c_db2inst1''​ ''​db2 update dbm cfg using SVCENAME db2c_db2inst1''​
Line 181: Line 178:
 </​code>​ </​code>​
  
-Try to start //​db22admin// ​ server from ''​dasusr1'' ​ user by running ''​db2admin start''​.+Try to start //​db22admin//​ server from ''​dasusr1''​ user by running ''​db2admin start''​.
  
 If admin server can't start, recreate it. If admin server can't start, recreate it.