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

最新推荐文章于 2025-04-01 18:13:58 发布

转载最新推荐文章于 2025-04-01 18:13:58 发布 · 391 阅读

本文介绍了如何配置和启动Sybase Sybase Cockpit Server，包括登录方式、SQL脚本执行、后台运行方式以及环境变量设置等关键步骤。

[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博客 ” ，链接：http://blog.itpub.net/35489/viewspace-2092069/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-2092069/