Document Type | Technical Information
Category | Administration/Configuration
Applicable Product Versions | 6FS07, 7FS02
Document Number | TADTI002
Overview
This article guides you on how to shut down the DB instance when you cannot access the DB server for a specific reason.
Method
Connect to the DB Server from the Client
You may be unable to access the DB server due to server hang, lost password, or other reasons.
In this case, you can take action by connecting to the DB server from the client.
Basic Procedure
Connect to tbsql as sys and perform the shutdown operation.
Client Server) tbsql sys/tibero@ip:port/dbname
C:\Users\HongGilDong>tbsql sys/tibero@192.168.56.10:8629/wkt
tbSQL 6
TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Connected to Tibero.
SQL> tbdown abnormal
TBS-70003: Invalid command. Enter HELP or HELP <command>.
at line 1, column 8:
tbdown abnormal
^^^^^^^^
SQL> tbdown abort
DB instance was terminated.
Note that the DBA role must be granted to shut down the DB instance.Alternative Procedure (If No DBA Role)
C:\Users\HongGilDong>tbsql qa/qa@192.168.56.10:8629/wkt tbSQL 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Connected to Tibero. SQL> tbdown immediate TBR-2119: Shutdown failed. TBR-17004: Permission denied. SQL> tbdown abort TBR-2119: Shutdown failed. TBR-17004: Permission denied.