User Guide

SAP AG November 2002
Call
You have the following options for calling the graphical user interface of the SQL Studio:
Choose Start → Programs → SAP DB → SQL Studio. Log on to the desired database
instance.
•
• You can start SQL Studio from the command line. In this case, you can transfer options
[Page 66] to the SQLSTO program.
See also:
SQL Studio: SAP DB 7.3 [See SAP DB Library]
→ Starting SQL Studio [See SAP DB Library]
SYSDBA
The SYSDBA user (database system administrator) is a special database user [Page 136] of
the database user class [Page
28] SYSDBA. The SYSDBA user is the first database user that
is created when a new database instance [Page 132] is installed. Enter a user name and
password for this user.
Each database instance has one single SYSDBA user.
The SYSDBA user’s password can be changed once the database registration has finished.
The SYSDBA user is very important, especially when database instances are installed. The
SYSDBA user is responsible for setting up the system and for creating other database users.
The SYSDBA user is the owner of system tables. When system tables are uploaded, the
upload tool logs on to the database instance as SYSDBA.
The SYSDBA is able to define data and database procedures. The SYSDBA can also grant
other users privileges for these database objects.
Task
A task is executed by the database instance [Page 132]. An overview of all database tasks
can be found in User kernel thread (UKT) [Page
14].
Thread
A whole series of operating system threads (often referred to as kernels) belong to a
database instance [Page 132].
We differentiate between UKTs (user kernel threads) and special threads.
The required number of UKTs and of special threads depends on the hardware configuration,
the number of volumes [Page
153] used, and the database parameters that were set.
User Kernel Thread (UKT) [Page
14]
•
Special Thread [Page
17]
•
• Operating-System-Dependent Special Thread [Page
18]
User Manual: SAP DB 151