10.1 List of operation items

The following table lists the HADB server's operational items.

Table 10‒1: List of HADB server's operation items
No.	Operation items			Reference
1	Scheduled operation	HADB server startup		10.2.1 Starting the HADB server
2		HADB server termination		10.2.2 Terminating the HADB server
3		Changing and confirming the HADB server operation mode		10.2.3 HADB server operation modes
4		Setting up the HADB server to restart automatically		10.2.4 Setting up the HADB server to restart automatically
5		Database backup		10.3 Backing up a database
6		Monitoring	Checking the messages	10.4 Checking the messages
7			Monitoring the resource usage	10.5 Monitoring the resource usage (list of messages to be monitored)
8			Checking the memory usage	10.6 Checking the memory usage
9			Checking the threads running on the HADB server	10.7 Checking the threads running on the HADB server
10			Checking the transaction processing status	10.8 Checking the transaction processing status
11			Checking the database status and usage	10.9 Checking the database status and usage
12			Checking the HADB server operation information	10.10 Performing statistical analysis (checking HADB server operation information)
13			Acquiring and checking SQL statement execution log information (SQL trace information)	10.11 Running SQL tracing
14			Working with the system log files	10.12 Working with the system log files
15	Unscheduled operation	Base table operations		11.1 Base table operations
16		Viewed table definition, retrieval, and deletion		11.2 Viewed table operations
17		Index operation		11.3 Index operations
18		Performing operations on regular multi-chunk tables and archivable multi-chunk tables		11.4 Performing operations on multi-chunk tables
19		Collecting cost information		11.5 Collecting cost information
20		HADB user management		11.6 Managing HADB users
21		Managing user privileges and the schema operation privilege		11.7 Managing user privileges and the schema operation privilege
22		Managing access privileges		11.8 Managing access privileges
23		Handling schemata		11.9 Handling schemas
24		Handling data DB areas		11.10 Handling data DB areas
25		Handling the work table DB area		11.11 Handling the work table DB area
26		Using buffers		11.12 Performing operations on buffers
27		Checking client group settings		11.13 Checking client group settings
28		Operating centralized management of client definitions		11.14 Operating centralized management of client definitions
29		Retrieving data from CSV files		11.15 Handling of data retrieval from CSV files
30		Performing synonym search operations		11.16 Performing synonym search operations
31		Reorganizing system tables		11.17 Reorganizing system tables
32		Using the updated-row columnizing facility		11.18 Using the updated-row columnizing facility (maintaining the retrieval performance for column store tables)
33		Operating the audit trail facility		12. Audit Trail Facility Operations
34	Tuning	Improving processing performance		13.1 Tuning to improve processing performance
35		Tuning to shorten SQL statement execution time by re-examining the buffers		13.2 Tuning to shorten SQL statement execution time by re-examining the buffers
36		Shortening command execution time		13.3 Tuning to shorten command execution time
37		Reducing memory usage		13.4 Tuning to reduce memory usage
38		Tuning to shorten SQL statement execution time by re-examining the hash table area size		13.5 Tuning to shorten SQL statement execution time by re-examining the hash table area size
39		Tuning to shorten SQL statement execution time by re-examining the hash group area size		13.6 Tuning to shorten SQL statement execution time by re-examining the hash group area size
40		Tuning to shorten SQL statement execution time by re-examining the join order of `INNER` `JOIN` to which hash join is applied		13.7 Tuning to shorten SQL statement execution time by re-examining the join order of INNER JOINs to which a hash join is applied
41		Tuning to shorten SQL statement execution time by re-examining the size of the hash filter area		13.8 Tuning to shorten SQL statement execution time by re-examining the hash filter area size
42		Tuning to shorten SQL statement execution time by re-examining the table-definition pool size		13.9 Tuning to shorten SQL statement execution time by re-examining the table-definition pool size
43	Operation when an error occurs	Checking whether abnormal termination has occurred		14.1 Error-handling flow
44		Collecting troubleshooting information		14.2 Collecting troubleshooting information (adbinfoget command)
45		Deleting the collected troubleshooting information		14.3 Deleting troubleshooting information (adbinfosweep command)
46		Troubleshooting		15. Troubleshooting

To Page Top