Overall Content Based on Solaris Development Environment

xiaoxiao2021-03-06  35

Network elite

Software development and practice, network communication software development and management, TCP / IP protocol

«Network Elite Bug Report (Constantly Update) | Back to Main Page | H.350 Standard Central Video, SIP End Point Directory»

2004

January 12, 2011

Operating system based on the overall concept of the Solaris development environment

Network elite

Overall Content Based on Solaris Development Environment

The Whole Conceive of Development Environment Based on Solaris

Drama: Nethero, Gu XX

Nanjing XX Communication Co., Ltd. Technology Center

2003

year

12

month

31

day

table of Contents

Preface ... 3

Tectonic article ... 4

1. Development tools ... 4

1.1. Editing tools ... 4

1.2. Compilation Tools ... 5

1.3. Debug tool ... 6

1.4. Test tool (performance test) ... 6

1.5. Test tool (function test) ... 8

1.6. Build tools ... 9

1.7. Operation Tools ... 10

2. Management Tools ... 11

2.1. Rational Suite Enterprise. 11

2.2. Project Management Tools ... 15

2.3. Demand change tools ... 20

2.4. Version Management Tools ... 22

2.5. Document Management Tools ... 23

2.6. Bug tracking tools ... 24

Information ... 27

3. Documentation ... 27

3.1. Operating system ... 27

3.2. Development Language ... 28

3.3. Database ... 29

Practice ... 36

4. Installation process ... 36

4.1. Operating system ... 36

4.2. Management Tools ... 36

Forehead

Sun Solaris Because of its powerful concurrency and stability becomes the preferred choice for network applications. Considering that our department will use the Sun Solaris operating system and carry out product development, we have a comprehensive understanding of Solaris's development environment, and write our understanding of our knowledge. Zhi is letting you learn quickly from the Solaris system and can quickly put it into product development.

Of course, this article is just a holistic architecture of a fast, and concise Solaris development environment. It has no deep into the Solaris system, and has not deepened into the framework of software development, but it is a systematic combination, Just like the computer software we use, we don't need too much to understand how the software is issued from the initial definition to the final package. What we need to know how to work together, this is productivity.

For this idea, we list tools that can be applied to our development environment and find out their installation steps and related information clues. These are just the pre-work of such a system, and the data to be supplemented behind, I hope we can configure an excellent development environment to provide guarantees for designing excellent products.

2 Who is this article?

Company, departmental leadership

System management personnel

Solaris product R & D personnel

Personnel want to learn from UNIX and Solaris

2 supporting information

Main information: ftp: //192.168.5.55/ OS / Solaris /

Network article: http://blog.msnfans.com/nethero/

Generic articles

Description: Unified format of "Tools":

2 xx nature tool

Title 2, black body, third, bold

Such as: development tool

2 xx tool

Title 3, Song, No. 3, Brade: Editing Tools

2 xx tool name

Title 4, Arial, No. 4, Bold

Such as: vi

2 Tool Introduction

Text, Song, No. 5, Bold

2 Installation steps

Text, Song, No. 5, Bold

2 related information

Text, Song, No. 5, Bold

Note: The title 2, 3, 4 select the system default font.

Development tool

1.1. Edit Tool

2 vi

2 Tool Introduction

VI (pronounce Vee-Eye) means "visual" (Visual, take the first two letters), you can see the text of the entire screen when editing.

Reasons for selecting VI: The VI editor is the standard editor under all UNIX and Linux systems, which is powerful in any latest text editor.

Of course, it has some shortcomings: there are three different modes (command mode, bottom row mode, insert mode, the first two are commonly known as command mode), the operation is not very convenient; there is no integrated development capability, need to be replaced Different tools.

Three modes: edit mode insert mode naming mode;

After typing $ VI, start the VI, first enter the edit mode;

After you type i, a, o or other commands in edit mode, you can enter the insert mode;

After pressing the ESC in the insert mode, switch to the edit mode.

Type in editing mode: You can enter naming mode;

Type down in command:

: q Exit in the absence of a modification

: q! Abandon all modifications, withdraw from the editor

2 Installation steps

The VI editor is installed during the installation of the Solaris.

2 related information

"UNIX reference"

"VI Editor FAQ"

Ftp://192.168.5.55/os/solaris/development Tools / Vi /

1.2. Compilation Tool

2 GCC

2 Tool Introduction

The most important software development tools in Linux and UNIX are GCC. GCC is a GNU's C and C compiler. In fact, GCC can compile three languages: C, C and Object C (an object-oriented extension of C language). The C and C source programs can be compiled and connected with the GCC command.

2 Installation steps

GCC, installation, and debugging step reference in the Sun Solaris operating system: http://www.fanqiang.com/a1/b3/20010625/180800666.html

1 A GCC software that acquires consistent for operating systems and operating system versions

If you have to be in Solaris

2.5.1

Use GCC to get the GCC

FTP: //ftp.cdit.edu.cn/pub/unix/solaris/sparc25/gcc-2.7.2.1.gz

2 Unzip. Gz said it is a file that is compressed by Gzip. You need to first decompress with Gzip / Gunzip software. $ Gunzip GCC-

2.7.2

.1.GZ 3 After installing the decompression, the installation package is installed. The installation package in the Solaris operating system has a set of special commands and programs #pkgadd -d ./gcc-2.7.2.1 In the next installation, there will be an interactive installation process.

2 related information

"UNIX reference";

"The Linux GCC HOWTO Chinese Translation V0.2";

Using and Porting GNU CC ";

Ftp://192.168.5.55/os/so//development Tools / GCC / 1.3. Debug Tool

2 GDB

2 Tool Introduction

The GNU debugger is called GDB, which is an interactive tool that works in character mode. In the X WINDOW system, there is a front-end graphics tool for GDB, called XXGDB. GDB is a powerful debugger that completes the following debug tasks:

* Set breakpoints;

* Monitor the value of the program variable;

* Single step execution of the program;

* Modify the value of the variable.

2 Installation steps

GDB and GCC are both a development tool that the system itself is. There is a corresponding option during the Solaris installation process.

2 related information

http://thunder.prohosting.com/~linuxlib/books/linuxfaq/program-gdb.html

Ftp://192.168.5.55/ / OS / Solaris / Development Tools / GDB /

1.4. Test Tool (Performance Test)

Performance testing is the operational performance of the test software, often in combination with intensity test, requires prevention of performance indicators, such as the maximum time limit of transmission connection, the error rate, the accuracy of the calculation, and the time limit of the recording And recovery time limit, etc. The principle of performance test tools is usually through recording, playback scripts, using flowers to simulate users to create site loads, generate and record various performance indicators, generate analysis results, to complete performance test tasks.

Comparison of mainstream commercial performance test tools

Attributes

Loadrunner

Qaload

Webload

Produce company

Mi

Compuware

RADVIEW

price

expensive

Expensive

general

Installation configuration complexity

simple

simple

general

Operability

Complicated

simple

simple

Support test object

Performance Monitoring / Enterprise Architecture (J2EE and .NET) Test of Various Middleware / Database / Application Server

Customer / Server System, Enterprise Resource Configuration (ERP), and E-Commerce Applications

Web Application

Support platform

Windows, UNIX or Linux

HP-UX, IBM AIX, Sun Solaris, Linux, NT / 2K

UNIX Windows

Support database

DB2, SQLSERVER, ORCALE, SYBASE

ADO

, DB2, Oracle, Sybase, SQLServer, ODBC

ADO

, DB2, Oracle, Sybase, SQLServer, ODBC

supporting agreement

Web, http (s), soap, streaming, wap, winsock, xml

HTTP, SSL, SOAP, XML, Streaming, Media

XML, Java, EJB, ActiveX, WAP, HTTP, SNMP, REAL / M $ streaming

Scripting language

Similar to C

C / C and VC

JavaScript

Automatic data generation

Y

Y

Y

Script debugging

Y

Y

Y

Report customization

Y

Y

Y

function points

Create a virtual user, create a real load, positioning performance, analyze the results in precise location problems, and repeat the high performance of the system issued by the system

The prediction system performance is used to find bottlenecks by repeated testing. From the control center to manage global load tests, quickly create simulated tests, verify application scalability.

Powerful professional website performance test, virtual multi-user

Virtual user upper limit number

Tens of thousands

Hundred thousand thousands

Theoretically unlimited, but is limited by the machine, and the accuracy of the operation too much impact

company website

Http://www.merc-int.com

http://www.compuware-china.com

http://www.radview.com

There are two free test software:

2 OpenSTA

2 Tool Introduction

Open source project, the URL is http://www.opensta.org. The function is powerful, the custom function setting is complete, but the settings are completed by script, and Script must be written.

2 WAS, MS Web Application Stress Tool

2 Tool Introduction

Microsoft, the output result is plain text, not HTML format, but the content is not inferior.

1.5. Test Tool (Function Test)

Enterprise function test tools have proved that the application software is predictable. By automatically capturing, determining and reproducing the user's interaction, function test tool identifying defects and ensuring transactions across multiple applications and databases can be used innocently and maintain reliability.

2 WinRunner

2 Tool Introduction

WinRunner is a corporate feature detection tool. WinRunner automates functional tests to ensure that enterprise applications run in a scheduled manner. It records the process of business in the form of a test script (Script) and supports improvements to the script as the development or update of the corresponding application. The execution script and report results are reused for scripts in the entire application cycle. WinRunner provides a complete functional test plan for your business applications.

2 Qarun

2 Tool Introduction

QARUN provides fast and efficient creation and execution test scripts, verifying tests and analyzing the feature of the test results. It can maintain test synchronization by accelerating running cycles, improve the ultimate users of testing investment returns and quality applications.

The advantage of this tool:

* Create test and execution test

* Test verification

* Test results analysis

* Improved data functions

* Extensive support

* Centralized knowledge base

* Website analysis

* Intelligent test script

* Automatic synchronization

1.6. Build tool

2 Make

2 Tool Introduction

In large development projects, there are usually dozens to hundreds of source files. If you are manually type a GCC command, it will be very inconvenient. Therefore, people usually use the MAKE tool to automatically complete the compilation. These tasks include: If only a few source files are modified, only these source files are recompiled; if a header file is modified, you recompile all the source files that contain the header file. This automatic compilation can greatly simplify development efforts to avoid unnecessary recompilation.

In fact, the Make tool completes and automatically maintains compilation through a file called Makefile. Makefile needs to be written in a syntax, which describes how to compile individual source files and connect to generate executables, and define dependencies between source files.

When a source file is modified, if other source files rely on this file, you should also recompile all source files that depend on the file. The Makefile file is a lot of compilers, including compilers under Windows NT Maintaining Common Method for Compile Information, just modifying the Makefile file through the friendly interface in an integrated development environment.

By default, GNU Make Tools Search Makefile in the order in the current working directory:

* Gnumakefile

* Makefile

* Makefile

In UNIX systems, use Makefile as a Makfile file. If you want to use other files as makefile, you can specify your Makefile file similar to the following MAKE command: $ make -f makefile.debug

2 Installation steps

Make is the development tool that the system itself. There is a corresponding option during the Solaris installation process.

2 related information

There is no comprehensive information on this area, and you can find some articles written in "http://blog.msnfans.com/nethero/ programming".

1.7. Operation Tool

2 @run

2 Tool Introduction

2 Installation steps

2 related information

2. Management Tools

In the entire development cycle of the software, the management of the software is the key to its success or failure. We can find that the scientific management of software is a powerful weapon that works in the opponent from a success of many large software companies.

Because software management tools can be divided into two, one is a platform-related management tool (such as version management, BUG tracking, etc.), the other is the platform open management tool (such as project management, demand management, document management, etc. ). Therefore, in this section, it is mainly to specifically pointed out that "version management tools, BUG Tracking Tool" is required to support the Solaris platform, and other management tools can complete the appropriate work under the Windows platform.

2.1. Rational Suite

Enterprise

2 Rational Suite

Enterprise

2 Tool Introduction

Rational Software Tools can be used on Windows, UNIX, Linux, and Machine Platform, which can support most languages, IDE, and operating environments, including: Java, Eclipse, C / C / C #, Visual Basic .NET, Microsoft. NET, COM / , CORBA, more than 100 development environments for real-time and embedded system developers, as well as the latest Internet / Web service standards.

1. The software development process guidelines follow the UML standard, with software development process guidelines, including demand management, object-oriented analysis, program development, software testing, and software build management, support iteration Software engineering technology such as development processes, architectural priority, risk-oriented and use cases.

2. Requering Management Tools (Rational RequisitePro) enables the user to organize a visual tool for software engineering project requirements. It combines Microsoft Word and demand storage libraries (repository), enabling users to easily establish relationships between demands within the actual software engineering project lifecycle, change changes.

3. Visualized UML Object-Oriented Analysis and Design (Rational Rose) is the most complete, accounting modeling model, supporting enterprise process analysis, object-oriented analysis and design and component architecture design.

4. The software configuration management tool (Rational Clearcase) ClearCase is a software configuration management tool. Provide version control features for any software project output (Artifact), including program modules, execution code, library, and various software project files, including program modules, execution code, library, and various software project files. And provide workspace management, system build management, team parallel development, and complete build management capabilities such as building status reports.

5. Change Management Tools (Rational ClearQuest) Change Management Tools for the Demand for Windows or Browser. Provide any changes in project members tracking and managing software development, including common software defect tracking. 6. Software error correction tool For the C / C program, make the programmer correct all kinds of errors during program execution, such as memory errors, etc.

7. Software Performance Evaluation Tool (Rational Visual Quanti) expands Calling Tree to quickly evaluate the performance of the application, correctly indicate the performance bottleneck to eliminate performance bottlenecks.

8. Covering the Test Range Evaluation Tool (Rational Visual Purecoverage) For C / C , Visual Basic or Java programs, the programmer or software test engineer completely identifies the test statistics of the test application to facilitate identification and pointed out that has not been tested. code.

9. Software Document Automatic Generation Automation In the software development process, such as software demand files, software design documents, test planning documents, and change report files, etc., can significantly reduce document production Process and cost. Integrate with the Rational Software Development tool, keep the original data and documentation at any time.

2 Install Step for Windows

I. Preparation 1. First confirm that the Windows 2000 or Windows XP Pro operating system is used, and if it is Windows 2000, confirm that Service Pack 2 has been installed. 2. Download the Rational Suite Enterprise Edition installation package. The downloaded URL is: ftp://ftp2.rational.com/public/v2002/RATIONALSUIIIIIITEENTERPRISEFORWINDOWS.2002.05.00.305.000.EXE (approximately 640MB) 3. Download the crack compression package including FlexLm License Server license files. The downloaded URL is: http://upload.smiling.com/file/96995/rolseflx.zip (approximately 200KB) which includes several files such as Rational_Server_Perm.dat, FlexLm.cpl, Suite Objects.dll.

4. Unpack the license cracked file that just downloaded the Rational Suite Enterprise Edition.

Second. Installation

1. Double-click Start and run Rational 2002 installer RationalsuItemPriseForWindows.2002.05.00.305.000.EXE.

2. Decompose the entire installation package, after a long time, there is a Thank you, click the button.

3. A selection product screen, click "Rational Suite Enterprise" in the product list box, then click the button.

4. A confirmation dialog will pop up, prompting this product license agreement, select whether you want to continue installed without confiating. Click to determine.

5. A license agreement screen, click the "Accept Agreement" radio button, .

6. The selection installation type screen appears (here you can choose the installation path, pay attention to the full installation of about 1.5GB of space). Click "Custom" to customize installation, .

7. Select the installation details screen, here you can check the specific products you want to install by selecting the tree selector in the feature list box. After the selection, .

8. The update shared component screen appears, mainly updating the following two components:

Microsoft Visual Basic 6 Service Pack 3

Seagate Crystal Reports 8 runtime

Click the button.

9. A confirmation screen appears, .

10. Start writing the registry and copy the file.

11. The "RESTART Windows" screen appears close to the installation. Select the "RESTART" option, click the button, restart the machine.

12. Some necessary installation tasks will continue after restarting. If there is an error during the installation process, an error message will appear and put all installation errors in an error summary screen, .

13. The installation completion screen appears, click the button.

14. Install the Rational License Key Administrator wizard, close these windows.

15. In order to install the license agreement, start Rational 2002 installation RationalSuiteEnterpriseForWindows.2002.05.00.305.000.exe.

16. The thank you, click the button.

17. A warning dialog may be popped up, do not take it, .

18. Select the product screen, click "Rational FlexLm License Server" in the product list box, then click the button.

19. A license agreement screen, select the radio button of "Accept Agreement", .

20. The selection installation type screen appears, then only "Typical" typical installation is available, .

21. A confirmation screen appears, .

22. Start copy files.

23. The installation completion screen appears, click the button.

24. A warning dialog will pop up, prompting the invalid data from the license server, do not use it, .

25. Close the pop-up Rational License Key Administrator wizard and other windows. If you have an error prompt box that connects the FlexLm license Server, it is also closed.

26. Restart the machine.

27. The FlexLm License Manager setting is then opened in the control panel. Under the "Control" sign, click the button to stop the appropriate license service. After the crack is completed, you need to click here the button to start the corresponding license service. .

3. Crack

1. Locate the Rational_Server_Perm.dat file from the release path of the license broker, and open it with Notepad or other text editor.

Find the following text inside:

Server ANY

Daemon Rational "Pathto / Rational.exe"

Replace the to replace the computer name as the native network identifier.

PathTo "pathTo / rate.exe" is replaced with the absolute path name of the Rational Public Folder. For example: "pathto / runture.exe" is rewritten into "c: / program files / ru", save the file after modification.

2. Copy the modified license cracked file Rational_Server_Perm.dat, copy to the Rational public folder, such as "C: / Program Files / Rational / Common", and overwrite its original file. (If necessary, you will also copy Suite Objects.dll in the package to the Rational public folder and overwrite its original file. But the Suite Objects.dll in the cracked package belongs to Rational 2001, which covers the Rational2002 Suite Objects. The DLL file may cause the Robot and other programs that cannot be used by calling the entry for the correct DLL function.)

3. Copy the flexlm.cpl file in the crack folder to the System32 folder under the Windows system path, such as "C: / WinNT / System32", and override the original file. This file is an extension file for the Windows Control Panel, without it, there will be no FlexLm License Manager Manager on the Control Panel. After copying it, be sure to restart the system.

4. Many times, you need to manually modify the Path system environment variable, add C: / Program Files / Rational / Common to the PATH list. Otherwise, it will be reported by the path of the DLL file necessary to find the run program. If necessary, the Suite Objects.dll file in the Rational Public Folder is also copied to the folder (such as C: / Program Files / Rational / Rose) where ROSE is located. If there is a need to copy the license.dll file in the Rational Public Folder, you can also copy to the folder (such as C: / Program Files / Rational / Rose) of ROSE.

5. Open the Windows Control Panel and launch the FlexLm License Manager Manager. In the Control tag, click the Status button if "License Server Up (Master) appears, then the Rational Suite is already installed. If there is no License Server Up (Master), please click the Stop button first, then click the Start button to restart Try the protocol server, it may be solved.

6. If the above is completed, if it is still not, then directly open the Rational License Key Administrator on the Start menu, select the first "Point to a Rational License Server to Get My Licenses", select "Single License "Server", then enter the machine name to run the license server, that is, Server Name can be used by the computer name. PORT can enter the next management window and there is no error prompt, representing the license server configuration, Rational The product should be available.

2 related information

FTP://192.168.5.55/os/sailis/ management Tools / Rational tool software, and this information is also very rich, so you don't list.

2.2. Project Management Tool

2 MS Project

2 Tool Introduction

Microsoft launched MS Project 2000 in April 2000, in particular the Web-based Project Central module, allowing it from the desktop project management tool to enterprise-level project management tools, can perform different projects and resources Unified management, the function is more powerful. MS Project 2000 includes two parts: MS Project 2000 and Project2000 Central.

MS Project 2000 is used for project manager, and it is planned to formulate, manage and control. Project 2000 not only manages general projects, but also has the ability to manage complex large projects. Complex large projects is characterized by more tasks, more participating in units, complex relationships, so that project management software must have high processing capabilities and coordination. Project 2000 can handle 1 million task items, while calculating 1000 handling group projects, the task-level link between different projects, enables complex control of the project to be implemented, supporting modern information exchange tools, with Microsoft Series products Good interface, easy to expand the project management function.

Project2000 Central includes server-side and clients. At the server side, the support platform includes: MS NT 4.0, or above MS IIS 4.0, MS SQL Server 7.0 (or Oracle 8.x, or Microsoft Database Engine). On the client, use the browser orientation server. The main features of MS Project 2000 Central include: project members accept tasks; Working Group members can see tasks in all projects related to them, they can view their tasks in the "Gantt Map" and do these tasks Group, sorting, and screening; view project information; Workgroup members can view the latest information on the entire project; create new tasks; workgroup members can create new tasks, and can send these new tasks to the project manager, merged by the project manager to the project Document; Feedback task execution; project members can feedback the completion of the task, fill in the system, complete the percentage, etc., the project manager can establish a message rule; can be specified to automatically accept all the workgroup members to update the update of all working groups or only accept specific members Work delegation, the workgroup member can delegate the task to other workgroup members, so that the project manager can send the task to the working group length or leader, and then reassign the task to each resource.

Microsoft Project Server is a supporting program that works with Microsoft Project Standard and Microsoft Project Professional, which can work harmonize between project managers, workgroup members, and risk bearers. These personnel can use Microsoft Project Server information using Web-based user-friendly interface called Microsoft Project Web Access.

2 Installation steps

Now use MS Project 2002 Professional and MS Project Server2002 to introduce installation methods, a higher installation of MS Project software installation is similar.

I. MS Project 2002 Project 2002 PROFESSIONAL installation

Similar to the installation of other products of MS Office.

Second, Project Central first introduces the relationship between Project Central and Project, Project Central is a supporting product of Project, facilitating workgroup members, project managers, and other risk bearer cooperation planning projects. Using Project Central allows the workgroup member to exchange and process item information in a Web site.

Before installing Project Central, you must confirm that you have installed IIS or PWS and work is normal. Project Central installer requires that you choose to be a typical installation or a custom installation. If you have installed SQL 7 or MSDE on your machine, Project Central will automatically select yourself to define installation methods and prompt you to specify the location of the project database. There is a problem here. You need to explain: Project Central custom installation requires you to specify the location of the project database. If it is installed for the first time, you may not know where the so-called project database is found. This is because Project Central's installer does not automatically create a project database, you need to create a project database yourself! ! ! Oh, but don't be afraid, MS has no soil to let users build a library with our own.

Let me introduce how to create a project database: 1: to / pjcntrl / isapi / 2052 directory 2: Perform OSQL -U -P -i crtTable.sqlosql -u -p -d -i insdefsq.sqlosql -u -p -d -i INSDEFSI.SQL

For example, if the account name is "SA", the password is "ProjectPW", the command should be: OSQL -U SA -P ProjectPw -i CrtTable.SQL Note: All of the parameters above are sensitive. Next, continue the installer until the installation ends. At this point you should have http: // local / projectcent, to access your Project site.

Supplement: For Oracle, you cannot create a database by default installation. You can only create a custom database.

Project2002 Installation Problem Solution

Some time ago, everyone often discussed some issues of Project2002, which have also been confused. Now, I feel that there is a better solution for these issues, written out for your reference.

1. Problem for issuing project file This is due to the restriction of Project2002Server, before I proposed the way to block the ENTERPRISE Feature option of Project2002, now there is a regular way to solve this problem, please refer to Point 2.

2. How to connect from Project2002 Client to Project Server Many friends aware of the issue of Global Template, this is true. The specific solution is: a) Open Project Client in Workoffline, create a blank document B) Select "Tools" - "Enterprise Options" - "Microsoft Server Accounts". Click "Add" button in the pop-up window. Fill in "Account Name" and your address server address and user name (must be created). "When starting" Select "Manual" d) Select "File" - "Save" - ​​The type is selected as "template". It is recommended not to use the default position (not easy to find), put it on the desktop. e) Select "Tools Menu" - "Enterprise Options" - "Restore Enterprise Global", select your "Account Name" in the pop-up window, "Global Template" specifies the file you just saved. f) Turn off the Project Client, after logging in to your "Account Name", you can connect to Project Server and you can publish the project file with the "Enterprise Feature" mode. Note: If "Enterprise Feature" is previously blocked, remember to recover before this. 3. SHARPOINT Team Services If your sharpoint team services is Chinese version, and Project is English, I suggest you configure SharePoint Team Services for Project. I used to do this before, and the result put my SQL Server. But if you are interested, you can try it, because I am not sure if it will be like this, but I don't dare to try it again because the price is too big. Note: Do not confuse SharePoint Team Services and SharePoint Portal Server, although the names and features are similar, but two different products.

Project2002 Central Installation Tutorial

First, introduce the relationship between Project Central and Project, Project Central is a supporting product of Project, facilitating workgroup members, project managers and other risk bearer cooperation planning projects. Using Project Central allows the workgroup member to exchange and process item information in a Web site.

Before installing Project Central, you must confirm that you have installed IIS or PWS and work is normal. Project Central installer requires that you choose to be a typical installation or a custom installation. If you have installed SQL 7 or MSDE on your machine, Project Central will automatically select yourself to define installation methods and prompt you to specify the location of the project database. There is a problem here. You need to explain: Project Central custom installation requires you to specify the location of the project database. If it is installed for the first time, you may not know where the so-called project database is found. This is because Project Central's installer does not automatically create a project database, you need to create a project database yourself! ! ! Oh, but don't be afraid, MS has no soil to let users build a library with our own. Let me introduce how to create a project database: 1: to / pjcntrl / isapi / 2052 directory 2: Perform OSQL -U -P -i crtTable.sqlosql -u -p -d -i insdefsq.sqlosql -u -p -d -i INSDEFSI.SQL

For example, if the account name is "SA", the password is "ProjectPW", the command should be: OSQL -U SA -P ProjectPw -i CrtTable.SQL Note: All of the parameters above are sensitive. Next, continue the installer until the installation ends. At this point you should have http: // local / projectcent, to access your Project site.

Supplement: For Oracle, you cannot create a database by default installation. You can only create a custom database.

Project2002 Installation Problem Solution

Some time ago, everyone often discussed some issues of Project2002, which have also been confused. Now, I feel that there is a better solution for these issues, written out for your reference.

1. Problem for issuing project file This is due to the restriction of Project2002Server, before I proposed the way to block the ENTERPRISE Feature option of Project2002, now there is a regular way to solve this problem, please refer to Point 2.

2. How to connect from Project2002 Client to Project Server Many friends aware of the issue of Global Template, this is true. The specific solution is: a) Open Project Client in Workoffline, create a blank document B) Select "Tools" - "Enterprise Options" - "Microsoft Server Accounts". Click "Add" button in the pop-up window. Fill in "Account Name" and your address server address and user name (must be created). "When starting" Select "Manual" d) Select "File" - "Save" - ​​The type is selected as "template". It is recommended not to use the default position (not easy to find), put it on the desktop. e) Select "Tools Menu" - "Enterprise Options" - "Restore Enterprise Global", select your "Account Name" in the pop-up window, "Global Template" specifies the file you just saved. f) Turn off the Project Client, after logging in to your "Account Name", you can connect to Project Server and you can publish the project file with the "Enterprise Feature" mode. Note: If "Enterprise Feature" is previously blocked, remember to recover before this. 3. SHARPOINT Team Services If your sharpoint team services is Chinese version, and Project is English, I suggest you configure SharePoint Team Services for Project. I used to do this before, and the result put my SQL Server. But if you are interested, you can try it, because I am not sure if it will be like this, but I don't dare to try it again because the price is too big. Note: Do not confuse SharePoint Team Services and SharePoint Portal Server, although the names and features are similar, but two different products.

Third, the installation of MS Project Server2002

1. Installation Preparation

Installing Project2002 Server requires the following software support: Windows 2000 Server (Same or higher) Windows Service Packet 3 or higher IE 6 database software MS SQL 2000 and its service packet 3 or higher MS SQL2000? Analysis? Service and its service packet 3 Or higher SharePoint (with Project2002) MS Project 2002 Server MS Project 2002 Professional (installed on the client) MS Office XP

2. Install step 2.1 Install Windows 2000 Server and its SP upgrade package, and set the network

2.2

Rise

Level IE 2.3 installation MS SLQ

2000

a. Installation will identify the name of the native, and install it by default. b. Select "Create a new SQL Server Instance" in the installation selection .. C. Install definition Select the server and client tool. d. Do not choose the default in the instance name , A letter name, such as PMServer. E. You can choose a custom installation, and then install. F. Service account in service settings in service settings, enter Windows administrator password, or other users. G. Authentication mode , Mixed mode, and enter the password of the default administrator account SA, this account is used when you forget the administrator password. Sa2000 h. After you don't understand, you will continue to install, i. Intermediate meeting next step Tips Turn off the task nspm.exe, Svchost.exe does not know what process, SVCHOST is also not caught, do not pay attention to. J. After installation, restart the machine, SQL Server will run automatically, in the enterprise manager You can see the database server we have established as ServerName / PMServer. 2.4 Install MS SQL2000 Analysis Service a. This software is not particularly installed with SQL 2000 in the same CD. 2.5

Rise

Level MS SQL2000 and Analysis Service Restart, install its SP upgrade package, pay attention to upgrade to the same version. The upgrade package of SQL2000 needs to use the SA administrator's password.

2.6 Installing SharePoint on the Project 2002 package a. Installing SharePoint Team Service (STS) Select the web default site B. Database server: 2.3.j servername / PMServer C. Login name and password, give him Sa and its password attention, if you already Not the first time you install the program, before installing STS, you must start IIS (C: / Winnt / System3 / InetSRV), delete the sub-station MS_ProjectServer_publicDocuments from the default Web site, and then in Windows start-run Type Iisreset Run IIS Then, then reinstall the STS. D. After the installation is successful, the Configuration Wizard shows the following information: Server Name: ServerName Web Server Port: 80 SharePoint Management Port: 3363 Database Server Name: ServerName / PMServer Database Name: XX_LM_W3SVC_1_Collab

2.7 Install Project 2002 Server a. In SQL's Enterprise Manager, the security login settings creates SQL users, and configures the properties Database Creater and Security Administors. (M4307, M2000) In SQL's Enterprise Manager, security In the login setting, configure servername / administrator as an administrator. Default Database XX_LM_W3SVC_1_Collab. Create User XX in Windows, set it to Administrator Group. In SQL's Enterprise Manager, the security login settings, add this Windows user to SQL ServerName / XX, and gives permission administrators. Default Database XX_LM_W3SVC_1_Collab. (PM, PM2000) B. Setup Project 2002 Server, select Custom Installation. C. Enter data server information: Create a new database, enter the name of the database server 2.6.D. Connection Using SQL Server authentication, the user established in a. D. Enter the connection information of the analysis server: Enter, analyze the server: ServerName / Administrator or XX E. Select the Web site: Default Web site. f. Enter the web server information: ServerName / ProjectServer, www.xx / projectserver g. Enter SMTP mail server information: SMTP mail server: With Outlook. port: 25 You can find H in Outlook: Connect to the Web server running STS: use the information server name 2.6.d: servername input windows user account information: servername / Administrator or xx Web server port: 80 SharePoint administration port: 3363 database server name: servername / PMSERVER database name: xx_LM_W3SVC_1_Collab login: servername / Administrator or xx i. Select Project Version: Select j. Enter admin password information as needed: This is the administrator password on the PWA. (SYS_PM2000) L. Finally start installing Project Server. m. After the installation is successful, open the IE, enter the ServerName / Project Server or Start menu -> Program -> Ms Project Server -> Configure Project Server. See the login screen: (Administrator, sys_pm2000), finally see the order The exciting gear is turning, the first time, the time of turn may be very long. In short, Project Server is installed.

2 related information

Ftp://192.168.5.55/os/solaris/ management tools / project management / ms project

2.3. Demand change tool

Demand management is the key to the smooth development of software projects. The purpose of demand management is to establish a joint understanding between customers and projects that complete customer needs. Demand management is just a tailor tailor, which is directly related to the formation of the final product.

In software development, demand is closely related to product quality. One of the important important criteria for realizing high quality is to "maintain unification with demand". In this sense, demand management is from quality to determine demand. Everyone should always understand what the specific task they do is. However, in a life cycle of a product, its demand is often in a change. In order to better manage the needs of software projects, strengthen communication with customers and teamwork work, and companies need professional tools to centralize management project needs.

2 Rational Requisite Pro

2 Tool Introduction

User can organize a visual tool for software engineering project requirements. It combines Microsoft Word and demand storage libraries (repository), enabling users to easily establish relationships between demands within the actual software engineering project lifecycle, change changes.

2 Installation steps

For details installation steps, please see: Installation steps in Rational Suite Enterprise.

2 related information

Ftp://192.168.5.55/os/solaris/ management Tools / Rational

2 Rational ClearQuest

2 Tool Introduction

Demand Change Management Tools with the window or browser as the interface. Provide any changes in project members tracking and managing software development, including common software defect tracking.

2 Installation steps

For details installation steps, please see: Installation steps in Rational Suite Enterprise.

2 related information

Ftp://192.168.5.55/os/solaris/ management Tools / Rational

2 Dragonfly

2 Tool Introduction

Dragonfly combines demand for document management and entry management, which makes it traceability, and can control changes in software requirements well. Through baseline management, milestone management, Dragonfly has realized the traceability of demand, increasing the enthusiasm of team development and project management, fundamentally accurately controlling demand changes. Dragonfly has a good N-Tier architecture with high configurable, expandability, and security. The client and server communicate via TCP / IP protocol, which can work normally in any local area network (LAN) and WAN (WAN) environment to meet the customer's network application requirements. Dragonfly can be perfectly integrated with the change management system butterfly and test tools. By integrating, users can easily track a status of a requirement in the project and record problems found when testing demand.

2 Installation steps

Dragonfly server

Windows NT, 2000 Professional, 2000 Advanced Server

Linux

Solaris

Dragonfly client

Windows 98 / ME / 2000 / XP

2 related information

FTP://192.168.5.55/os/solaris/ management Tools / Requirement Change Control / Dragonfly

2.4. Version Management Tools

2 cvs

2 Tool Introduction

Providing version control management means for web-based distributed collaborative development, free software, can be customized by scripting. However, the functional control is relatively weak.

2 Installation steps

Confirmation Steps Check "CVS and Nightly Build Technology".

2 related information

FTP://192.168.5.55/os/sailis/ management Tools / Version Control / CVS The following two books are located in Luo Dayuan. Regarding the management of CVS, Luo Dayong has a good study, there is a problem to consult and discuss with him.

"CVS open source software development technology". Karl Fogel. Machinery Industry Press

"CVS and Nightly Build Technology". Yang Jinfang. Tsinghua University Press

2 Rational Clearcase

2 Tool Introduction

ClearCase is a software configuration management tool. Provide version control features for any software project output (Artifact), including program modules, execution code, library, and various software project files, including program modules, execution code, library, and various software project files. And provide workspace management, system build management, team parallel development, and complete build management capabilities such as building status reports.

2 Installation steps

For details installation steps, please see: Installation steps in Rational Suite Enterprise.

2 related information

Ftp://192.168.5.55/os/solaris/ management Tools / Rational

Zhang Wei can be said to be our expert in ClearCase and ClearQuest, he has certain theoretical research and practice. The following book is provided by him.

"Software Configuration Management Strategy and Rational Clearcase" .brian White. People's Posts Publishing House

2.5. Document Management Tool

2 Rational Soda

2 Tool Introduction

During software development, such as software requirements documents, software design documents, test planning documents, and change report files, automatic generated auxiliary tools, can greatly reduce document production processes and costs. Integrate with the Rational Software Development tool, keep the original data and documentation at any time.

2 Installation steps

For details installation steps, please see: Installation steps in Rational Suite Enterprise.

2 related information

Ftp://192.168.5.55/os/solaris/ management Tools / Rational

2 Document Builder

2 Tool Introduction

Document Builder is an open-ended, powerful software technology document, automatic generation and management tools. It automatically generates a variety of standard design documents according to the current most popular modeling tool Rose, and can generate any user's desired documentation by customized ways. And provide strong management functions for these documents.

2 Installation steps

Application platform Windows 9X, NT, 2000, XP, ME

2 related information

Ftp://192.168.5.55/os/solaris/ management Tools / Document Management / Document Bulider

2.6. BUG Tracking Tool

2 bugzilla

2 Tool Introduction

A well-known website introduces Bugzilla:

Bugzilla is the leading open-source / free software bug tracking system, with high-profile installations at mozilla.org, GNOME, Red Hat, and NASA, among others. It features a comprehensive set of fields, attachment management, inter-bug dependencies , email notification of changes, a powerful query interface, reporting, and Web, XML, email, and console interfaces. It can be managed entirely using a Web-based UI. The user UI is customizable using templates. here we can see, Bugzilla It is a BUG management system that supports web interface management. The main thing is that Bugzilla is a popular vulnerability tracking collection system written in Perl, which is easy to install and modify under multiple UNIX and Linux operating systems.

There are some sites on the Internet, such as http://amrl.ev.ntu.edu.tw/bugzilla/. Everyone can go to experience (account: tingqi@postel.com.cn; password: postel), some of its features, of course, the interface is simple, but as long as it is easy to use. In addition, there is currently a Chinese Bugzilla, which can replace its interface to Chinese.

2 Installation steps

Download: You can find the downloaded program from here.

Installation: There is a full file description here. The following simply records the installation process:

1. Install the Perl module, use fast installation:> # perl -mcpan -e 'install "bundle :: bugzilla"' query about many questions, using non-preset answers to no cache, Never scan cache, (this seems complete Installing the CPAN's action, not too like just install Bugzilla's Perl module, "Finally, the bugzilla's bundle is started, but there is a problem in the mysql section.) (This is the relationship between the mysql-devel suite, after the RPM is installed) .) (But there will be a lot of script when Make Test, but guess this is because of the issue of account, no matter it.) Install the GD module, (Option) it wants to libgd 2.0.x (?) Version And we are slightly low (

2.0.1

),installation failed. (To rpmfind to find GD file, there is no higher version for redhat, so it is temporarily ignored that this project) is also ignored to other Option modules.

2. Install Bugzilla to put bugzilla-

2.16.3

Unzip in / var / www / amrl / in decompression, rename the directory to bugzilla, change the Bugzilla owner to apache, enter MySQL, Grant SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP, REFERENCES ON Bugs. * to bugs @ localhost identified by ''; flush privilege; setting / usr / bonsaitools / bin / perl link to / usr / bin / perl executes the password of the BUGS in LocalConfig (in MySQL) Setting) SU Apache (must first modify the / etc / passwd's account, so that the login shell is used to use / bin / bash) to execute checksetup.pl This time you will be asked to enter the Administrator email account (temporarily using my Let's use the user name (real), password (just like MT) he reminded that he wants to sendMail 8.7 or more to send a letter, we use Sendmail-8.12.8-9.80, so there should be no problem. After the installation instructions 4.2, there are some additional settings, and there is no payment at this time. In addition, it is necessary to perform the following settings in Apache to be executed. Alias ​​/ Bugzilla / / / VAR / WWW / AMRL / BUGZILLA / ORDER ALOW, DENY Allow from All allowOverride All Options Execcgi AddHandler CGI-Script .cgi directoryindex index.cgi

3. Management configuration settings must be first login, find the right side of the EDIT item below, there is a parameters item, please set the meaning of the column parameter parameters after entering: http://www.bugzilla.org/docs216 /html/parameters.html maintainer: chliang@ms1.hinet.net (是) URLBASE: http://amrl.ev.ntu.edu.tw/bugzilla/ Other default values, but in the end ( Close to) There is a commenton * (a lot) option, which represents those things to have Comment. This part is very important, in http://www.bugzilla.org/docs216/html/parameters.html has probably introduces those comparison needs to start, and is currently as follows: CommentonAccept: if this option is on, the user Needs to enter a short comment if he accepts the bug Off commentonclearresolution: If this option is on, the user needs to enter a short comment if the bugs resolution is cleared Off commentonconfirm: If this option is on, the user needs to enter a short comment when confirming a bug Off commentonresolve: If this option is on, the user needs to enter a short comment if the bug is resolved On commentonreassign: If this option is on, the user needs to enter a short comment if the bug is reassigned On commentonreassignbycomponent: If this option is on, the user needs to enter a short comment if the bug is reassigned by component On commentonreopen: If this option is on, the user needs to enter a short comment if the bug is reopened On commentonverify: If this option is on, The user neseds to enter a short comment if the bug is verified on commentonclose: if TH Is Option IS ON, THE User Needs to Enter A Short CommentUPlicate: if this option is on, the user neseds to enter a short case if the bug is marked as duplicate ON to this, the installation process is roughly appropriate. 2 related information

Http://www.bugzilla.org/documentation.html

Using the method Reference: The Bugzilla Guide In addition, how to combine with CVS, refer to Integrating Bugzilla With Third-Party Tools.

FTP: //192.168.5.55/OS/solaris/ management Tools / Bug Tracking / Bugzilla

Description: Unified format of "Information":

2 xx information

Title 2, black body, third, bold

Such as: Documentation

2 xx theme

Title 3, Song, No. 3, Bao

Such as: operating system

2 xx instance

Title 4, Arial, No. 4, Bold

Suilaris

2 Introduction

Text, Song, No. 5, Bold

2 Installation steps

Text, Song, No. 5, Bold

2 Recommended books

Text, Song, No. 5, Bold

2 Recommended site

Text, Song, No. 5, Bold

2 related information

Text, Song, No. 5, Bold

Note: The title 2, 3, 4 select the system default font.

3. Documentation

3.1. Operating system

2 Solaris

SOLA RIS 8 can increase the network cache accelerator, web paging speed by 4 times; IPv 6 makes the number of IP addresses are infinite; Java HO TM provides Java 2 (TM) platform; database performance is increased by 70%; Integrated Iplanet Dire CTORY server (E-commerce LDAP address catalog) Group technology, 4 64 64-bit processors (8 can be supported later); automated dynamic restructuring; thermal patching ability; dynamic upgrade; IP multiplexing technology.

In addition, the Solaris 8 operating system also provides a comprehensive environmental bundled software package. The software in this package is: Sun Star Office Office Suite; iplanet authentication management system; Apache web server; Oracle 8i database; Oracle Migration Workbench (SQL Server porting tool).

2 Recommended books

Solaris Advanced System Administrator Guide

Solaris Guide

"UNIX Daquan"

"UNIX reference"

Unix Manual

2 Recommended site

http://www.sun.com

Http://www.chinaunix.net

http://www.fanqiang.com;

2 related information

ftp://192.168.5.55/os/solaris/documents/solaris/

3.2. Development Language

2 C / C

2 Recommended books

"TCP-IP Details 1: Agreement"

"TCP-IP Details 2: Implementation"

"TCP-IP Details 3: TCP transaction protocol, HTTP, NNTP, and UNIX domain protocol"

Unix Programmer's Manual

Unix Network Programming

"Unix Environment Advanced Programming"

2 Recommended site

http://www.sun.com

Http://www.chinaunix.net

http://www.fanqiang.com;

2 related information

ftp://192.168.5.55/os/solaris/documents/development Languages ​​/

3.3. Database

In the Solaris development environment, the database you can use is Oracle, Sybase .. Compare the pros and cons, installation and use of each database in Solaris.

UNIX workstation and server combination (recommended):

1. Solaris x86 oracle combination

This is the unbolded analog environment of the Sun Oracle environment. For developers, in addition to 32 BIT and 64 BIT and data alignment order (already high byte, low byte problem), there is almost no difference. Playing this environment, replacing the SPARC environment can basically play. Unfortunately, there is no support for commercial software. However, Sun claims that Sun One Application Server will quickly support Solaris x86, and finally have commercial J2EE servers support Solaris x86. In addition, Solaris X86 contains PPPoe Client, and IPFilter, which can also use a router / firewall; 2. Solaris 8 Sybase combination

Suitable for Web programming for JSP: Java Server Page.

2 Oracle

2 Introduction

1. Introduction Oracle is a large-scale relational database based on the advanced structured query language (SQL), which is popular in a large number of regular data. It is one of the current most popular client / server architectural architectures. Second, Features 1, Oracle7.x has introduced shared SQL and multi-cable server architectures. This reduces Oracle's resource, and enhances Oracle's ability to support more users with fewer resources on the low-end hardware platform, and hundreds of users can support hundreds of users on the high-end platform. 2. Provide safety and confidentiality management based on role-based division. There is a good performance in database management functions, integrity check, security, and consistency. 3, support a large number of multimedia data, such as binary graphics, sound, animation, and multi-dimensional data structures. 4. Provide the interface software Pro * series with the third-generation advanced language, which can embed the SQL statement and procedural (PL / SQL) statement in primary languages ​​such as C, C , and manipulate data in the database. Plus it has many excellent front desk development tools such as Power Build, SQL * Forms, Visia Basic, etc., which can quickly occur, based on client PC platform applications, and have good portability. 5, provide new distributed database capabilities. The data in the remote database can be readily read by the network, and there is a technique of symmetrical replication.

2 Installation steps

Install Oracle8.17 under Solaris. Do: 1 with root users: 1. GroupAdd DBA 2. Useradd -d dba -d $ oracle_home -m -s / bin / sh oracle3. The last line of modifying the / etc / group file is as follows: DBA :: 100: Oracle4. The last line of modifying the / etc / passwd file is as follows: Oracle: x: 1001: 100 :: / Oracle_home: /bin/sh5.mkdir / oracle; Chown -r Oracle: DBA /Oracle6.# VI / ETC / SYSTEM Add: set shmsys: shminfo_shmmax = (0.5 * physical memory) * 1024 * 1024's value set shmsys: shminfo_shmmin = 1SET SHMSYS: shminfo_shmmni = 100set shmsys : shminfo_shmseg = 100set semsys: seminfo_semmni = 100set semsys: seminfo_semmsl = 100set semsys: seminfo_semmns = 200set semsys: seminfo_semopm = 100set semsys: seminfo_semvmx = 32767set ulimit = 30000007 passwd oracle8.. Reboot II. Use Oracle users: vi /etc/oracle/.profile (.cshrc) Add:

#evn for install oracleSet Oracle_Base / Data / U01 / ORACLESET ORACLE_HOME / DATA / U01 / ORACLE / PRODUCT /

8.1.7

SET ORACLE_TERM XSUN 5SET LD_LIBRARY_PATH $ ORACLE_HOME / LIB: / USR / OpenWIN / LIB: / USR / DT / LIBSET CLASSPATH.: / DATA / U01 / ORACLE / PRODUCT / JDBC / LIB / CLASS111.ZIP: / DATA / U01 / ORACLE / PRODUCT / JDBC/LIB/nls_charset11.zip:/export/home/oracle/trade_progset path.: / export / home / oracle / trade_prog: / bin: / usr / openwin / bin: / usr / bin: / usr / ucb: / usr / local / bin: / data / u01 / oracle / product / binset NLS_LANG AMERICAN_AMERICA.ZHS16CGB231280 # set NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBKset ORACLE_SID orclset DISPLAY 192.168.0.190:0.0

2. Exit, log in with Oracle to take effect in the new environment. CD / CDROM / CDROM0 ;./ Runinstaller (Note, he will tell you the location of root.sh) 4. When prompted by the user to enter the user group, run / cdrom / cdrom0 / oracle as root

8.1.7

The /rapstall/orainstroot.sh script (sa ;./*.sh )5. When installing to 100%, run /Data/roacle/product/8.1.7/root.sh scripts as root (note to see the prompt, he will tell you the location of root.sh)

three. After installation, use Oracle users to do 1. Run $ oracle_home / 8.1.7

/ bin / svrmgrl2. Connect Internal3. SHUTDOWN4. STARTUP5. If you start SQLPLUS, you can use the internal user to log in.

2 Recommended books

"Oracle8i Beginner Guide"

"Oracle8i Database Administrator Manual"

"Oracle data high availability"

2 Recommended site

http://www.chinaunix.net/jh/19/index.html

http://www.whservice.com/bbs/forum.asp?forum_id=4&cat_id=1

Http://www.racle.com.cn/

2 related information

ftp://192.168.5.55/ os / solaris / documents / database / oracle /

2 Sybase

2 Introduction

(1) Version 1984, Mark B. Hiffman and Robert EPStern created Sybase and launched a Sybase database product in 1987. Sybase mainly has three versions, one is the version running under the UNIX operating system, and the other is version of the Novell NetWare environment, and the third is the version running in the Windows NT environment. Sybase 10 and Syabse 11 for Sco Unix is ​​currently widely used for UNIX operating systems.

(2) Features of the SYBASE database (1) It is based on a client / server architecture database, a general relational database, is based on master / slave models. In the master / slave structure, all applications are running on a machine. Users are just through the end command or simply view the results of the application run. In the customer / server structure, the application is running on multiple machines. A machine is another system of customers, or a server for another machine. These machines are connected through a local area network or a wide area. The benefits of the client / server model are: ● It supports sharing resources and balancing the load between multiple devices ● Allows the environments of multiple hosts to make full use of various systems that have been used.

(2) It is a truly open database because of the client / server structure, the application is divided into multiple machines. Further, the application running on the client does not have to be a Sybase product. For general relational databases, in order for applications written in other languages ​​to access the database, it provides precompilation. Sybase database, not just simply provide precompiled, and publicly publishing application interface DB-libs, encouraging third parties to write DB-LIB interfaces. Since the open customer DB-lib allows the exact same call to be used in different platforms, it is easy to access the DB-LIB application to another platform.

(3) It is a high-performance database Sybase truly attractive place or its high performance. Reflected in the following aspects: ● Programmable database creates a programmable database by providing a stored procedure. The stored procedure allows users to write their own database subroutines. These subroutines are precompiled, so they do not have to compile, optimize, generate query plans for each call, so the query speed is much faster. ● Event-driven trigger trigger is a special stored procedure. You can start another stored procedure through the trigger to ensure the integrity of the database. ● Another innovation of the architecture of the multi-cellized Sybase database is multi-line. The general database relies on the operating system to manage the connection to the database. When multiple users are connected, the performance of the system will decrease significantly. The Sybase database does not allow the operating system to manage the process and manage the connection to the database as part of your own. In addition, Sybase's database engine also manages a part of hardware resources, such as port, memory, hard drive, bypassing operating system, and improves performance. (3) The composition of the Sybase database is mainly composed of three parts: (1) a connection database management system for database management and maintenance, a set of front-ends supporting the establishment and development of database application systems Tool Sybase SQL ToolSet; (3) Connect the other vendors in the heterogeneous environment and any type of data to connect together Sybase Open Client / Open Server.

2 Installation steps

profileSYBASE = / usrlocal / vlol001 / sybaseDSQUERY = e3500export SYBASE DSQUERYSYBASE_FTS = FTS-12_0export SYBASE_FTSSYBASE_REP = REP-12_0export SYBASE_REPPATH = / usr / bin: / usr / ucb: / etc: .export PATHPATH = / usrlocal / vlol001 / sybase / ASE-12_0 / bin: / usrlocal / vlol001 / sybase / ASE-12_0 / install: / usrlocal / vlol001 / sybase / REP-12_0 / bin: / usrlocal / vlol001 / sybase / OCS-12_0 / bin: $ PATHexport PATHSYBASE_OCS = OCS-12_0export SYBASE_OCSSYBASE_ASE = ASE-12_0export SYBASE_ASELM_LICENSE_FILE = / usrlocal / vlol001 / sybase / SYSAM-1_0 / licenses / license.dat: $ LM_LICENSE_FILEexport LM_LICENSE_FILELD_LIBRARY_PATH = / usrlocal / vlol001 / sybase / ASE-12_0 / lib: / usr / local / openwin / lib: / USRLOCAL / VLOL001 / SYBASE / FTS-12_0 / LIB: / USRLOCAL / VLOL001 / SYBASE / OCS-12_0 / lib: / usr / local / openwin / lib: / usr / lib: / usrlocal / Vlol001 / Sybase / SQLREMOTE / LIB: $ Ld_library_pathexport ld_library_pathsybase_sysam = sysam-1_0export sybase_sysamstty istripdisplay = E3500: 0.0export Display

***** Sybase's naked device cannot use 0 cylinders *******

After installation, some necessary processing work (give SA encryption code, add the tape drive to DUMPDEVICE, expand the size of Tempdb, parable Temp on Master Device,) isql -usa -puse mastergocosp_password null, "password" goSP_Dropserver Localgo

SP_ADDSERVER FOO, LOCALGOSP_DROPDEVICE TAPEDUMP 12GOSP_DROPDEVICE TAPEDUMP2GOSP_ADDUMPDEVICE TAPEDUMP2GOSP_ADDUMPDEVICE "TAPE", "DDS2_TAPE", "/ DEV / RMT / 0CN", 7000GO

Disk init name = "tempdb_dev", physname = "/sybase/devs/tempdb.dev", vdevno = 4, size = 25600GO

ALTER DATABASE TEMPDBON TEMPDB_DEV = 50GOUSE TEMPDBGOSP_DROPSEGMENT "default", tempdb, mastergosp_dropsegment "logsegment", tempdb, mastergosp_dropsegment "system", Tempdb, Mastergo

2 Recommended books

Sybase System Administrator's Manual

Sybase Developer Guide

Sybase Database System Management Guide

"Sybase PowerDesigner DataArchitect"

2 Recommended site

http://www.chinaunix.net/jh/21/

http://www.sybase.com.cn

http://www.loveunix.net/index.php?showforum=30

2 related information

ftp://192.168.5.55/ os / Solaris / Documents / Database / Sybase /

Practice articles

4. Installation process

4.1. Operating system

Please see: "Solaris 8 x86 Installation Report".

4.2. Management Tool

Please see: "Management Tools".

转载请注明原文地址:https://www.9cbs.com/read-53129.html

New Post(0)