6.3.2 Changing the status of chunks in normal and wait statuses
This example changes the status of the following chunks for table TABLE01 as follows:
-
Changing the chunks with chunk IDs 1 through 3 to wait status
-
Changing the chunks with chunk IDs 4 through 6 to normal status
- Organization of this subsection
(1) Checking the chunk status
Before you change the chunk status, use one of the following methods to check the status of the target chunks:
-
Execute the adbdbstatus command.
-
Retrieve information from the CHUNK_STATUS column in the STATUS_CHUNKS system table.
(2) Executing the adbchgchunkstatus command
adbchgchunkstatus -u ADBUSER01 ...1 -p '#HelloHADB_01' ...2 -w 1-3 ...3 -n 4-6 ...4 TABLE01 ...5
- Explanation:
-
-
Specifies the authorization identifier of the HADB user who executes the adbchgchunkstatus command.
-
Specifies the password for the authorization identifier that is specified in the -u option.
-
Specifies the chunk IDs of the chunks whose status is to be changed from normal status to wait status.
-
Specifies the chunk IDs of the chunks whose status is to be changed from wait status to normal status.
-
Specifies the table to be processed (TABLE01).
-