Step 2--Creating DB2 for VM DBSPACEs: DSQ2DBSC

Note

Skip this step if one or more of the following are true:

You are installing QMF into a remote database server.
The database you are installing QMF Version 7.2 into has QMF Version 3.1 or later already installed.
There are sufficient public DBSPACEs available for the DB2 for VM database of the sizes indicated in the installation worksheet (Table 30). You can check this by invoking ISQL and issuing the following:
```
SELECT * FROM SYSTEM.SYSDBSPACES
  WHERE  DBSPACETYPE=1 AND OWNER=''
```

To create the DBSPACEs required by QMF, do the following:

Access the QMF distribution and production disks.
Ensure that the QMF installation control file QMFV720E INSTALL exists on the distribution disk.
Ensure that you have an A-disk to generate a temporary file.
Run the exec: DSQ2DBSC.
This exec will:
- Use the QMFV720E INSTALL file on the QMF distribution disk to determine whether or not this is a new or migration install. If this is a new install, all ten DBSPACEs are created. If this is a migration from QMF V2R4 or an earlier release, only one DBSPACE is created.
- Prompt you to enter the storage subpool you want to use.
- Create the 'dbname SQLADBSP A' file ('resid SQLADBSP A' file if the database you are installing QMF into is Version 7.2) on your A-disk. ('dbname' is the database name and 'resid' is the resource ID for your DB2 for VM database.)
Send the 'dbname SQLADBSP ' file (or 'resid SQLADBSP') file to the database virtual machine.
Log onto the database virtual machine and stop the database. (Typically with the SQLEND command.)
Receive the 'dbname SQLADBSP' (or 'resid SQLADBSP') file to the A-disk.
Access the DB2 for VM service disk (DASD 193) as the V-disk.
Run the SQLADBSP exec, by entering:
```
SQLADBSP DB(dbname)
```
where dbname is the name of the DB2 for VM database. DBSPACE(s) is added based on the information in the dbname SQLADBSP file.
You receive the following message:
```
 dbname SQLADBSP WAS FOUND.
 SHOULD THIS FILE BE USED FOR ADD DBSPACE?
```
Answer YES.

You receive a message inquiring whether or not you want to modify the dbname SQLADBSP file.
- To edit the file, answer YES.
- To continue without editing, answer NO.
Release the DB2 for VM service disk (DASD 193).
Restart the database and continue with the installation, by entering:
```
SQLSTART DB(dbname)
```
where dbname is the name of the DB2 for VM database.
Run the following query using ISQL to verify that the new DBSPACEs are available for QMF:
```
SELECT * FROM SYSTEM.SYSDBSPACES
  WHERE  DBSPACETYPE=1 AND OWNER=''
 
```
To run this query, as a minimum you need to have SELECT authority on table SYSTEM.SYSDBSPACES, or have DB2 DBA authority, which implies the SELECT privilege.

[ Previous Page | Next Page | Contents | Index ]