system.sh

This chapter describes the options of system.sh (vbs).

The following are the options that can be used with system.sh(vbs).

$ system.sh -h
Usage: system.sh [option] [arg]
-h : dispaly usage
-p1 password : sys password
-p2 password : syscat password
-a1 Y/N : create default system users & roles
-a2 Y/N : create system tables related to profile
-a3 Y/N : register dbms stat job to Job Scheduler
-a4 Y/N : create TPR tables
pkgonly : create psm built-in packages only
-sod Y/N : separation of duties
error : print error whenever sql encounters error

The following describes each option.

Option	Description
-h	Displays the help screen.
-p1 password	Enters the password of the SYS account. (Default value: tibero)
-p2 password	Enters the password of the SYSCAT account. (Default value: syscat)
-a1	Creates a system user and grant permissions. For the initial installation, select 'Y'. Y: create a system user and grant permissions. N: retain data.
-a2	Creates a table for a profile that can specify the database user password management policy. For the initial installation, select 'Y'. Y: delete the existing table and create a new one. N: retain data. For more information about the profile, refer to "User Management and Database Security" in Tibero Administrator's Guide.
-a3	Registers a job schedule for collecting database object statistics. For the initial installation, it is recommended to select 'Y'. Y: delete the job for statistics collection and then register. N: do not register.
-a4	Creates TPR related tables for regular, automatic collection of statistics. Select 'Y' for the initial installation. Y: delete the existing table and then create a new one. N: retain data. For more information about the APM, refer to "Tibero Performance Repository" in Tibero Administrator's Guide.
pkgonly	Executes only PSM built-in package scripts.
-sod	Divides the administrator role into 3 accounts for security purposes. SYSSEC: Security Administrator SYSAUD: System Auditor SYSADM: System Administrator (Default value: N, Not supported in Windows)
error	Prints error details in the terminal when an error occurs from a specific script while executing system.sh. (Not supported in Windows)