Chapter 6: Create Database

Databases created on PCs or database servers store data in ANSI. To use these databases, with EBCDIC enabled products such as IMS Option and CICS Option, you must have a database created with an alternate collating sequence. If you use any of the IBM tools to create the database, all data will be returned to your application in ANSI collating sequence. IBM does provide some examples of how to create databases with alternate collating sequences but the EBCDIC to ANSI translation that IBM uses may be different from the translation used in Mainframe Express. Therefore it is very important that you use the Create Database tool in Host Compatibility Option to create the database.

6.1 Create Database tool

To display the Create Database tool (see Figure 6-1) select HCO > Create Database, on the IDE Tools menu.

Figure 6-1: Create Database Tool

The following elements make up the Create Database Tool:

Menu bar
Toolbar
Status line
Entry fields for database-name, description, log file and disk drive

6.2 The Toolbar

The following list shows the buttons in the toolbar and the functions that they invoke:

Button	Function
	Run the Create Database command. This command takes quite a while to complete.
	Display the online HCO User's Guide,which is a hypertext file that describes how the Create Database tool works.

When options are not available, they are grayed out.

6.3 The Menu Bar

The menu bar is an alternate way of invoking Create Database functions. The menu bar is composed of three menus: Database, Options and Help.

6.3.1 The Database Menu

The Database menu is used to either run a command or to exit the tool. You can also display this menu by right-clicking in the Create Database window (see Figure 6-1).

Option	Function
Create DB	Run the Create Database command. This command takes quite a while to complete.
Exit	Exit Create Database tool

6.3.2 The Options Menu

The Options menu enables you to control specific options to be used when creating a database. These options can be pre-defined. See the chapter Setting INI Options for more details. The settings depend on your current environment and what you have set as defaults.

Menu Option	Function
Codepage - Mainframe Express	If checked, the current Mainframe Express codeset is used to define ANSI to EBCDIC collating sequence when you create a database
Codepage - Select	If checked, you have selected a pre-defined collating sequence. The Select Code page window is displayed each time you check this option.
Display log	If checked, the log file is displayed after the Create Database command has completed
Database - Local	If checked, you create a database on your local machine
Database - Remote	If checked, you create a database on a remote database server. The Select Server window is displayed each time you check this option.

6.4 Entry Fields

Regardless of where you are creating a database, you have to provide the following information in the entry fields on the Create Database window before you can run any command:

Entry Field	Data
Database	The name of the database (eight characters maximum, must start with either a letter, $, # or @)
Description	A short description of the database (30 characters maximum)
Log File	The name of the log file to write messages to. This field is pre-set using configuration file. See the chapter Setting INI Options for more details.
Drive	The logical disk drive where you want the database to be installed. If you set the value to DEFAULT, the database is created using the default database path DFTDBPATH Default Database Path. See IBM *DB2 Command Reference* manual for more details. If you are creating a database on a remote database server, Host Compatibility Option allows DEFAULT only to be specified. This field is pre-set using the configuration file.

6.5 Creating a Local Database

To create a local database, you must:

Specify all the entry fields listed previously
Select Local on the Options menu (if you did not pre-set this setting in configuration file or you want to change value from default setting)
Set Codepage on the Options menu to be used (if you did not preset this setting in the configuration file or you want to change value from default setting)
Either click Run or select Create DB on the Database menu

You must have SYSADM or SYSCTL authority to run this command.

6.6 Creating a Remote Database

Figure 6-2: Select Server Window

To create a database on a remote server, you must:

Have DB2/CS V2.1 or later server software installed
Be running from a Windows NT PC client
Do the following:

Specify all the entry fields listed previously
Select Remote on the Options menu.
You see the Select Server window (see Figure 6-2). You must select the server on which your database is to be created. If no servers are listed, you must catalog the database server before you can continue. See the chapter Catalog Server for more details. You must also type a logon id and password for connecting to the database server.
Set Codepage on the Options menu to be used (if you did not preset this setting in the configuration file or you want to change the value from its default setting)
Either click Run or select Create DB on the Database menu.

You must have SYSADM or SYSCTL authority to run this command.

Setting INI Options

Catalog Server