《Sybase12.5培训.pptVIP

ASE 12.0/12.5 目录结构 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. ASE-12_5子目录 bin 大多数server工具的可执行文件 init ASE 安装日志 install 安装程序, RUNSERVER 文件，errorlog日志 scripts 可选安装脚本 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. UNIX 下环境变量 $DSLISTEN (given by the administrator) 特定的server名字 $DSQUERY (given by the administrator) 表示用工具连接server时的，缺省的server名 $SYBASE (given by the administrator) 所有sybase产品的顶级目录 $SYBASE_ASE (set by the system to “ASE-12_5”) Adaptive Server 安装的子目录 $JAVA_HOME(given by the administrator) 标识Java Development Kit (JDK) 的位置 当使用 jisql client的时候需要 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Starting UNIX Servers Simplified syntax: startserver [-f runserver_file ] Example: prompt% cd $SYBASE/$SYBASE_ASE/install prompt% startserver -f RUN_SYBASE 这是一个操作系统命令 这个命令启动一个由 RUNSERVER 指定的server 如果没有指定特定的RUNSERVER文件，就是使用默认的 “RUN_SYBASE” 文件启动。 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. The UNIX RUNSERVER File RUNSERVER 是 UNIX平台上用来启动server的文件 位置： ASE-12_5/install 包括 启动数据库的dataserver 命令 包括如下信息: Server name Location of the master device Location of the errorlog file Location of configuration file Used to allocate server memory Location of the interfaces file Used to establish connectivity with clients 你可以通过改变RUNSERVER文件来修改server的基本特性。 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 检验server是否运行 Syntax: showserver Example: prompt% showserver - UID PID PPID C STIME TTY TIME COMMAND sybase 15340 15339 0 Aug 9 ? 6:46 /home/sybase/ ASE-12_0/bin/dataserver -sPRODMFG01 -d/dev/syba sybase 8732 8731 0 Aug 7 ? 13:40 /home/sybase/ ASE-12_0/bin/dataserver -sPRODGL01 -d/dev/sybas sybase 12404 12403 0 Aug 9 ? 4:35 /