Case study 30: Create project for Sybase ASE installation on Solaris 10.
Platform: Solaris 10
Sybase ASE version: All
Background story: In document for Sybase installation for Solaris, there is a procedure for adding a project, which will control resources for Sybase ASE server (and sybase user). This procedure is not so clear, and there are also some things which are problematic in that document.
Task: Describe the procedure for creating project for Sybase ASE installation on Solaris 10.
Solution: This description presumes that user sybase is created and that Sybase will be installed under this user. Also, sybase user belongs to dba group. Also, all commands given here should be executed as root user. Some commands will have to be executed as sybase user but that will be emphasized.
First of all check which project is assigned for sybase user. To do this, execute following command:
id -p sybase
and You will get something like this:
uid=103(sybase) gid=270(dba) projid=3(default)
From this output, it can be seen that default project is assigned for sybase user. Later I will explain what it also can mean. What we do want is to create sybase user dedicated project.
To add project for sybase user, execute following statement:
projadd -U sybase -G dba -c 'For use by Sybase' user.sybase
"user.sybase" is the name of the project.
To see the list of projects use following command:
To verify if project is assigned to sybase user, execute following command:
After these steps we have project created and assigned to sybase user. Now we are going to add resource values(kernel parameters) to this project. For example, if You want to set shared memory parameter to 7 GB, execute following command:
Note that there is no space between values in brackets and that command should be in one line.
To check project attributes for sybase users, login as sybase user and execute following:
prctl -i project user.sybase
This represent the end of this task. Also, one useful command for working with project is:
which will delete existing project.
Conclusion: In Sybase documentation You will see that documentation says that project name should be "project-sybase". If You create that project with projadd command and sybase user, You will see that once You execute a command to see if newly created project is assigned to sybase user, You will see that sybase user is still assigned to default project. My presumption is that there is some problem with "-" (hyphen) in given project name. So, use project name I suggested, or You can also use project name with one word.