Installation and Upgrade Guide

Resuming Normal Operations

G06.24 Software Installation and Upgrade Guide—528593-005

12-10

Start User and System Applications

You can now start your application software. Follow your site’s procedures for

executing the system configuration and startup (command) files to accomplish this.

DSM/SCM is often started automatically by a system command file. If not, you must

start it manually as described next.

Before Starting DSM/SCM

Initialize SQL

1. Check that TMF is started:

> TMFCOM STATUS TMF

2. Save a copy of the existing ZZSQLCI2 file on the $SYSTEM disk. For example:

> FUP DUP $SYSTEM.SYSTEM.ZZSQLCI2,$SYSTEM.BKUPZSQL.*, SAVEALL

3. Enter:

> SQLCI INITIALIZE SQL; EXIT;

4. Copy the ZZSQLCI2 file saved previously back to the $SYSTEM disk. For

example:

> FUP DUP $SYSTEM.BKUPZSQL.ZZSQLCI2, $SYSTEM.SYSTEM.*, SAVEALL

Cold Start the Pathway Configuration

1. Verify your current configuration against the cold start configuration in PATHHOST

(or PATHTARG) to check that the current configuration reflects all changes you

have made.

2. Run the PATHCOLD macro from the ZDSMSCM subvolume to cold start the

Pathway configuration.

Note. ZZSQLCI2 is a temporary file that contains the SQLCI2 program. SQLCI2 is the

process through which the NonStop SQL/MP conversational interface (SQLCI)

communicates with the NonStop SQL/MP executor to request various functions. After SQL

initialization is complete, ZZSQLCI2 is renamed and becomes the permanent SQLCI2

program.

HP recommends that you always have a current backup copy of the

$SYSTEM.SYSTEM.ZZSQLCI2 file in case you need to initialize SQL later for some

reason. If you cannot find a copy of ZZSQLCI2 on the $SYSTEM disk, use DSM/SCM to

Export the file from the software archive. (ZZSQLCI2 is a component file of the TSQLCI2

product, T9198.)

For more information, see the SQL/MP Installation and Management Guide. For

information on exporting the file from the Archive, see the DSM/SCM online help.