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
(2) Executing the adbchgchunkstatus command

(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.

To Page Top

(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).

To Page Top