且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

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

更新时间:2022-09-06 22:48:13

[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: 
https://szhost588-or:4283/cockpit          --- 初始以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博客tolywang的博客,原文链接:Sybase IQ 16 SAP Control Console (cockpit / SCC)配置及登陆,如需转载请自行联系原博主。