[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
[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)配置及登陆,如需转载请自行联系原博主。