Notes about DB2

1. When creating a table, the following message is displayed:

The create table or declare global temporary TABLE statement does not specify a tablespace and cannot be found.
Has a sufficient page size (at least "<page size>") and has the correct type (for temporary tables declared,
Is user temporary), and the authorization identifier "<User Name>" has the use privilege on it.

Solution: Modify the database page size and change page_size from 4 K to 8 K.

 

2,DB2 list database directoryCommand to display the Database List

DB2 list database directory on C:Command to display the Database List at the specified location

 

3. Differences between "Delete" and "Remove" databases in the db2cc Control Center

"Remove" only removes the node from the local directory node, but it still exists. You can add it again in the next addition.