没有合适的资源?快使用搜索试试~ 我知道了~
System Administration Guide
需积分: 0 0 下载量 157 浏览量
2024-01-12
14:05:01
上传
评论
收藏 11.96MB PDF 举报
温馨提示
试读
1090页
Contents System Administration Guide iii About This Book ...................................................................................................................... xxvii CHAPTER 1 Overview of System Administration.............................................. 1 Adaptive Server administration tasks............................................... 1 Roles required for system administration tasks......................... 2 Using isql to perform system administration tasks ................
资源推荐
资源详情
资源评论
System Administration Guide
Adaptive Server® Enterprise
12.5.1
DOCUMENT ID: DC31654-01-1251-02
LAST REVISED: November 2004
Copyright © 1989-2004 by Sybase, Inc. All rights reserved.
This publication pertains to Sybase software and to any subsequent release until otherwise indicated in new editions or technical notes.
Information in this document is subject to change without notice. The software described herein is furnished under a license agreement,
and it may be used or copied only in accordance with the terms of that agreement.
To order additional documents, U.S. and Canadian customers should call Customer Fulfillment at (800) 685-8225, fax (617) 229-9845.
Customers in other countries with a U.S. license agreement may contact Customer Fulfillment via the above fax number. All other
international customers should contact their Sybase subsidiary or local distributor. Upgrades are provided only at regularly scheduled
software release dates. No part of this publication may be reproduced, transmitted, or translated in any form or by any means, electronic,
mechanical, manual, optical, or otherwise, without the prior written permission of Sybase, Inc.
Sybase, the Sybase logo, AccelaTrade, ADA Workbench, Adaptable Windowing Environment, Adaptive Component Architecture,
Adaptive Server, Adaptive Server Anywhere, Adaptive Server Enterprise, Adaptive Server Enterprise Monitor, Adaptive Server
Enterprise Replication, Adaptive Server Everywhere, Adaptive Server IQ, Adaptive Warehouse, Anywhere Studio, Application
Manager, AppModeler, APT Workbench, APT-Build, APT-Edit, APT-Execute, APT-Translator, APT-Library, Backup Server, BizTracker,
ClearConnect, Client-Library, Client Services, Convoy/DM, Copernicus, Data Pipeline, Data Workbench, DataArchitect, Database
Analyzer, DataExpress, DataServer, DataWindow, DataWindow .NET, DB-Library, dbQueue, Developers Workbench, Direct Connect
Anywhere, DirectConnect, Distribution Director, e-ADK, E-Anywhere, e-Biz Impact, e-Biz Integrator, E-Whatever, EC Gateway,
ECMAP, ECRTP, eFulfillment Accelerator, Embedded SQL, EMS, Enterprise Application Studio, Enterprise Client/Server, Enterprise
Connect, Enterprise Data Studio, Enterprise Manager, Enterprise SQL Server Manager, Enterprise Work Architecture, Enterprise Work
Designer, Enterprise Work Modeler, eProcurement Accelerator, EWA, Financial Fusion, Financial Fusion Server, Gateway Manager,
GlobalFIX, iAnywhere, iAnywhere Application Alerts, iAnywhere Mobile Delivery, iAnywhere Mobile Document Viewer, iAnywhere
Mobile Inspection, iAnywhere Mobile Marketing Channel, iAnywhere Mobile Pharma, iAnywhere Mobile Sales, iAnywhere Pylon,
iAnywhere Pylon Application Server, iAnywhere Pylon Conduit, iAnywhere Pylon PIM Server, iAnywhere Pylon Pro, iAnywhere
Solutions, ImpactNow, Industry Warehouse Studio, InfoMaker, Information Anywhere, Information Everywhere, InformationConnect,
InternetBuilder, iScript, Jaguar CTS, jConnect for JDBC, Mail Anywhere Studio, MainframeConnect, Maintenance Express, Manage
Anywhere Studio, M-Business Channel, M-Business Network, M-Business Server, MDI Access Server, MDI Database Gateway,
media.splash, MetaWorks, My iAnywhere, My iAnywhere Media Channel, My iAnywhere Mobile Marketing, MySupport, Net-
Gateway, Net-Library, New Era of Networks, ObjectConnect, ObjectCycle, OmniConnect, OmniSQL Access Module, OmniSQL
Toolkit, Open Biz, Open Client, Open ClientConnect, Open Client/Server, Open Client/Server Interfaces, Open Gateway, Open Server,
Open ServerConnect, Open Solutions, Optima++, Orchestration Studio, PB-Gen, PC APT Execute, PC DB-Net, PC Net Library,
PocketBuilder, Pocket PowerBuilder, Power++, power.stop, PowerAMC, PowerBuilder, PowerBuilder Foundation Class Library,
PowerDesigner, PowerDimensions, PowerDynamo, PowerJ, PowerScript, PowerSite, PowerSocket, Powersoft, PowerStage,
PowerStudio, PowerTips, Powersoft Portfolio, Powersoft Professional, PowerWare Desktop, PowerWare Enterprise, ProcessAnalyst,
Rapport, RepConnector, Replication Agent, Replication Driver, Replication Server, Replication Server Manager, Replication Toolkit,
Report-Execute, Report Workbench, Resource Manager, RW-DisplayLib, RW-Library, S-Designor, SDF, Secure SQL Server, Secure
SQL Toolset, Security Guardian, SKILS, smart.partners, smart.parts, smart.script, SQL Advantage, SQL Anywhere, SQL Anywhere
Studio, SQL Code Checker, SQL Debug, SQL Edit, SQL Edit/TPU, SQL Everywhere, SQL Modeler, SQL Remote, SQL Server, SQL
Server Manager, SQL SMART, SQL Toolset, SQL Server/CFT, SQL Server/DBM, SQL Server SNMP SubAgent, SQL Station, SQLJ,
STEP, SupportNow, S.W.I.F.T. Message Format Libraries, Sybase Central, Sybase Client/Server Interfaces, Sybase Financial Server,
Sybase Gateways, Sybase MPP, Sybase SQL Desktop, Sybase SQL Lifecycle, Sybase SQL Workgroup, Sybase User Workbench,
SybaseWare, Syber Financial, SyberAssist, SyBooks, System 10, System 11, System XI (logo), SystemTools, Tabular Data Stream,
TotalFix, TradeForce, Transact-SQL, Translation Toolkit, UltraLite, UltraLite.NET, UNIBOM, Unilib, Uninull, Unisep, Unistring, URK
Runtime Kit for UniCode, VisualWriter, VQL, WarehouseArchitect, Warehouse Control Center, Warehouse Studio, Warehouse
WORKS, Watcom, Watcom SQL, Watcom SQL Server, Web Deployment Kit, Web.PB, Web.SQL, WebSights, WebViewer, WorkGroup
SQL Server, XA-Library, XA-Server and XP Server are trademarks of Sybase, Inc. 05/04
Unicode and the Unicode Logo are registered trademarks of Unicode, Inc.
All other company and product names used herein may be trademarks or registered trademarks of their respective companies.
Use, duplication, or disclosure by the government is subject to the restrictions set forth in subparagraph (c)(1)(ii) of DFARS 52.227-7013
for the DOD and as set forth in FAR 52.227-19(a)-(d) for civilian agencies.
Sybase, Inc., One Sybase Drive, Dublin, CA 94568.
Contents
System Administration Guide iii
About This Book ...................................................................................................................... xxvii
CHAPTER 1 Overview of System Administration.............................................. 1
Adaptive Server administration tasks............................................... 1
Roles required for system administration tasks......................... 2
Using isql to perform system administration tasks .................... 5
Using Sybase Central for system administration tasks ............. 6
System tables................................................................................... 7
Querying the system tables....................................................... 8
Keys in system tables................................................................ 9
Updating system tables ............................................................. 9
System procedures ........................................................................ 10
Using system procedures........................................................ 11
System procedure tables......................................................... 11
Creating system procedures ................................................... 12
System extended stored procedures ............................................. 13
Creating system ESPs ............................................................ 13
Logging error messages ................................................................ 13
Connecting to Adaptive Server ...................................................... 14
The interfaces file .................................................................... 14
Directory services.................................................................... 15
LDAP as a directory service .................................................... 16
Security features available in Adaptive Server............................... 19
CHAPTER 2 System and Optional Databases ................................................. 21
Overview of system databases ...................................................... 21
master database ............................................................................ 22
Controlling object creation in master ....................................... 23
Backing up master and keeping copies of system tables........ 24
model database.............................................................................. 24
sybsystemprocs database.............................................................. 25
tempdb database ........................................................................... 26
Creating temporary tables ....................................................... 26
Contents
iv
Adaptive Server Enterprise
sybsecurity database ..................................................................... 27
sybsystemdb database .................................................................. 28
pubs2 and pubs3 sample databases ............................................. 28
Maintaining the sample databases.......................................... 29
pubs2 image data.................................................................... 29
dbccdb database............................................................................ 30
sybdiag database........................................................................... 30
CHAPTER 3 System Administration for Beginners ......................................... 31
Logical page sizes.......................................................................... 31
Using “test” servers ........................................................................ 32
Understanding new procedures and features ......................... 32
Planning resources.................................................................. 32
Achieving performance goals.................................................. 33
Installing Sybase products ............................................................. 33
Check product compatibility .................................................... 34
Install or upgrade Adaptive Server.......................................... 34
Install additional third-party software....................................... 34
Configure and test client connections ..................................... 35
Allocating physical resources......................................................... 35
Dedicated vs. shared servers.................................................. 36
Decision support and OLTP applications ................................ 36
Advance resource planning..................................................... 36
Operating system configuration............................................... 37
Backup and recovery ..................................................................... 38
Keep up-to-date backups of master ........................................ 38
Automate backup procedures ................................................. 39
Verify data consistency before backing up a database........... 40
Monitor the log size ................................................................. 41
Ongoing maintenance and troubleshooting ................................... 41
Starting and stopping Adaptive Server.................................... 41
Viewing and pruning the error log ........................................... 42
Keeping records............................................................................. 42
Contact information ................................................................. 42
Configuration information ........................................................ 43
Maintenance schedules........................................................... 43
System information.................................................................. 44
Disaster recovery plan............................................................. 44
Getting more help........................................................................... 44
CHAPTER 4 Setting Configuration Parameters ............................................... 45
Adaptive Server configuration parameters..................................... 45
What are configuration parameters?.............................................. 52
Contents
System Administration Guide v
The Adaptive Server configuration file .................................... 52
How to modify configuration parameters................................. 52
Who can modify configuration parameters?............................ 53
Unit specification using sp_configure...................................... 54
Getting help information on configuration parameters ............ 54
Using sp_configure ........................................................................ 55
Syntax elements...................................................................... 56
Using sp_configure with a configuration file............................ 57
The parameter hierarchy ......................................................... 61
User-defined subsets of the parameter hierarchy: display levels 63
The reconfigure command ...................................................... 64
Performance tuning with sp_configure and sp_sysmon.......... 65
Output from sp_configure............................................................... 65
The sysconfigures and syscurconfigs tables.................................. 67
Querying syscurconfigs and sysconfigures: an example ........ 68
Details on configuration parameters .............................................. 68
Renamed configuration parameters........................................ 68
Replaced configuration parameter .......................................... 70
New configuration parameter .................................................. 70
Backup and recovery............................................................... 71
Cache manager....................................................................... 75
Component Integration Services administration...................... 80
Disk I/O.................................................................................... 84
DTM administration ................................................................. 88
Error log................................................................................... 96
Extended stored procedures ................................................... 99
General information............................................................... 102
Java services......................................................................... 103
Languages............................................................................. 106
Lock Manager........................................................................ 108
Memory use........................................................................... 116
Metadata caches................................................................... 117
Network communication ........................................................ 124
O/S resources ....................................................................... 132
Parallel queries...................................................................... 135
Physical memory ................................................................... 139
Processors ............................................................................ 145
RepAgent thread administration............................................ 147
SQL server administration..................................................... 148
Security related ..................................................................... 183
Unicode ................................................................................. 194
User environment.................................................................. 197
CHAPTER 5 Diagnosing System Problems ................................................... 207
剩余1089页未读,继续阅读
资源评论
滚动的轮胎
- 粉丝: 4
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功