Sybase IQ 16 SAP Control Console (cockpit / SCC)配置及登陸

tolywang發表於2016-05-02
[sybase@szhost588-or IQ-CMAP]$ pwd
/sybase/COCKPIT-4/plugins/IQ-CMAP

[sybase@szhost588-or IQ-CMAP]$ 
[sybase@szhost588-or IQ-CMAP]$ ls
agent-plugin.dtd                                      IQMapLog4j.properties
....  
cockpit_monitor_authority_based_privileges_setup.sql  TechnicalUserCreate.bat
cockpit_monitor_role_based_privileges_setup.sql       TechnicalUserCreate.sh
[sybase@szhost588-or IQ-CMAP]$ 

[sybase@szhost588-or IQ-CMAP]$ 
[sybase@szhost588-or IQ-CMAP]$ dbisql -c "uid=dba;pwd=sql;dbn=edw_dm" cockpit_monitor_authority_based_privileges_setup.sql
Execution time: 0.878 seconds
[sybase@szhost588-or IQ-CMAP]$ dbisql -c "uid=dba;pwd=sql;dbn=edw_dm"  cockpit_monitor_role_based_privileges_setup.sql
1 row(s) affected
1 row(s) affected
1 row(s) affected
Execution time: 0.762 seconds
[sybase@szhost588-or IQ-CMAP]$ 

[sybase@szhost588-or COCKPIT-4]$ cd bin/
[sybase@szhost588-or bin]$ ls
cockpit-console.out  cockpitd  cockpit.sh  instance  myenvClient  passencrypt  sa16

[sybase@szhost588-or bin]$ ps -ef | grep  cockpitd  
sybase    60240  28288  0 11:19 pts/1    00:00:00 grep cockpitd

[sybase@szhost588-or bin]$ sh  cockpit.sh  
Starting Cockpit Server...

---------- SYSTEM INFO ----------
.......   

Cockpit Web Console: 
         --- 初始以dba/sql登陸   

Type help for more options
cockpit> 


但是, 手工開啟的cockpit session需要在系統中保持,關閉session , cockpit 就stop了,我們需要使用如下的語句來開啟,關閉及檢視, 這種方式開啟的cockpit會在後臺執行。 
 ./cockpit.sh  --start 2>&1 >> ${COCKPIT_HOME}/log/cockpit-service.out &                 
 ./cockpit.sh  --stop 2>&1 >> ${COCKPIT_HOME}/log/cockpit-service.out &     
 ./cockpit.sh  --status    

設定sybase使用者環境變數  export   COCKPIT_HOME=/sybase/COCKPIT-4  

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-2092069/,如需轉載,請註明出處,否則將追究法律責任。

相關文章