6.3.1 Changing the chunk status from normal to wait

This example changes the following chunks for table TABLE01 from normal status to wait status:

Chunks with chunk IDs 1, 3 through 5, and 8

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-5,8              ...3
                  TABLE01                 ...4

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 table to be processed (TABLE01).

To Page Top