HPlogo ALLBASE/SQL Database Administration Guide: HP 9000 Computer Systems > Appendix H SQLMigrate

SHOW 'DBEnvironmentName' VERSION

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Displays the current version number and startup parameters of the DBEnvironment specified in the command.

Scope

SQLMigrate Only

SQLMigrate Syntax

SHOW 'DBEnvironmentName' VERSION;

Parameters

DBEnvironmentName

identifies the DBEnvironment to be previewed. Any pathname you specify, unless absolute, is assumed to be relative to your current working directory.

Description

  • In addition to the version number, the DBECreator's id and current startup parameters are displayed. It is critical that an entry exists in /etc/passwd with a userid equal to the DBECreator id to ensure that SQLMigrate runs successfully.

Example

In the example below, the version of the DBEnvironment is F:



   SQLMIGRATE=> show 'PartsDBE' version;



              VERSION          RELEASE



              F                HP36217-02A.F



              DBEnvironment Creator Id = 9026

           

              CURRENT STARTUP PARAMETERS:

              SINGLE USER MODE

              DUAL LOG,

              BUFFER = (50,50)

              TRANSACTION = 2

              MAXIMUM TIMEOUT = 3600 SECONDS,

              DEFAULT TIMEOUT = 30 SECONDS,

              RUN BLOCK = 37



              LOG DBEFILE log1 AND log2 WITH PAGES = 250,

                NAME = 'tstdbe1'

                   AND 'tstdbe12';

   SQLMIGRATE=>

Feedback to webmaster