Type a 1 - 8 character name for your new database. The name:
Note: To avoid potential problems, do not use the special characters @, #, and $ in a database name if you intend to use the database in a communications environment. Also, because the characters @, #, and $ are not common to all keyboards, do not use them if you plan to use the database in another country.
Unless you override the default drive, the user tables, catalog tables, and temporary tables are stored here. The database configuration file and the database recovery log are also stored here.
You can create new table spaces on different drives after you create the database. You can also use the newlogpath parameter to change the location of the database log files.
Unless you override the default directory, the user tables, catalog tables, and temporary tables are stored here. The database configuration file and the database recovery log are also stored here.
You can create new table spaces on different directories after you create the database. You can also use the newlogpath parameter to change the location of the database log files.
Type a 1 - 8 character name for your new database. (Use the same naming rules as for database name.)
Database alias names are local synonyms given to local or remote databases. These names must be unique to the System Database Directory. You cannot create a database with the same name as a database alias because the alias for a new database defaults to the database name.
Note: To avoid potential problems, do not use the special characters @, #, and $ in a database name if you intend to use the database in a communications environment. Also, because the characters @, #, and $ are not common to all keyboards, do not use them if you plan to use the database in another country.
Optional: Type a description of your database for clarification. It can be 1 - 30 characters in length.
The description will appear as a comment in the details view of databases.
To change the comment, right-click the Database object and select Alter.
Click the down arrow to display a list of possible nodes. Highlight the one you want to use.
The system catalog tables will be created on this node.
Opens the Read/Write Specifications window, where you can change the extent and prefetch sizes for the table space.
Shows the performance parameters for the drives where any containers will be stored. The overhead and transfer rates are used by DB2 to optimize database performance.
Click Change to change the overhead or transfer rates for the selected drive.
Opens the Specifications for Drive window, where you can change the overhead and transfer rates for the selected drive.
Specifies the locale for this database. This value is stored in the Database Configuration file. You can read this value on the Environment page of the Configure Database notebook.
Once you have created the database, you cannot go back and change this value.
Click the down arrow to display a list of countries and languages, and then select one. Valid territory codes and code sets for the selected country and language appear in the lists below this field.
Specifies the territory for data entered in this database. The territory is used for string comparisons (default collating sequence) and character conversions. This value is stored in the Database Configuration file. You can read this value on the Environment page of the Configure Database notebook.
Once you have created the database, you cannot go back and change this value.
Click the down arrow to display a list of valid territory codes for the selected country, and then select one.
Specifies the code set for data entered in this database. The code set is used for string comparisons (default collating sequence) and character conversions. This value is stored in the Database Configuration file. You can read this value on the Environment page of the Configure Database notebook.
Once you have created the database, you cannot go back and change this value.
Click the down arrow to display a list of valid code sets for the selected country, and then select one.
Sorts items according to the database locale, and characters are compared using the database code set and locale.
The string comparison method, or collating sequence, cannot be changed once the database has been created.
Sorts items according to their hexadecimal representation.
The string comparison method, or collating sequence, cannot be changed once the database has been created.