Use > Discovery Modules > Database > HPE NonStop Discovery > HPE NonStop Discovery Commands

HPE NonStop Discovery Commands

This section describes each of the commands used by HPE NonStop discovery.

This section includes:

ClosedCommand: gtacl -p scf info lif ';$zzlan.*';

  • Sample Output 

    SCF - T9082H01 - (16JUL10) (30MAR10) - 11/08/2010 01:32:10 System \NON_STOP_SYSTEM
(C) 1986 Tandem (C) 2006 Hewlett Packard Development Company, L.P.
SLSA Info LIF
Name               Associated Object     MAC Address         Type
$ZZLAN.LANA        G4SA0.0.A             01:01:01:01:01:01   Ethernet
$ZZLAN.LANB        G4SA0.0.B             02:02:02:02:02:02   Ethernet
$ZZLAN.LANC        G4SA0.0.C             03:03:03:03:03:03   Ethernet
$ZZLAN.LAND        G4SA0.0.D             04:04:04:04:04:04   Ethernet
Total Errors = 0    Total Warnings = 0

  • Modeled CITs: Interface

    Attribute

    Value

    Comment

    Name

    LANA

    		 

    Interface MAC Address

    01:01:01:01:01:01

    		 

    Interface Description

    G4SA0.0.A

    		 
ClosedCommand: gtacl -p scf info subnet ';$*.*';

  • Sample Output (partial) 

    SCF - T9082H01 - (16JUL10) (30MAR10) - 11/08/2010 04:05:58 System \MEASYOS
(C) 1986 Tandem (C) 2006 Hewlett Packard Development Company, L.P.
TCPIP Info SUBNET \MEASYOS.$ZSM1.*
Name     Devicename     *IPADDRESS       TYPE     *SUBNETMASK  SuName   QIO *R
#SN01    \MEASYOS.LANC   10.10.10.10   ETHERNET  %HFFFFFC00           ON  N
#LOOP0                   127.0.0.1       LOOP-BACK %HFF000000           OFF N
TCPIP Info SUBNET \MEASYOS.$ZTC0.*
Name     Devicename     *IPADDRESS       TYPE     *SUBNETMASK  SuName   QIO *R
#SN01    \MEASYOS.LANC   10.10.10.10   ETHERNET  %HFFFFFC00           ON  N
#LOOP0                   127.0.0.1       LOOP-BACK %HFF000000           OFF N

  • Modeled CITs: IP, Network

    Attribute

    Value

    Comment

    IP Address

    10.10.10.10

    Only "ETHERNET" type is considered

    IP Network Mask

    %HFFFFFC00

    A network mask represented in HEX format

    Container

    LANC

    The name of the interface where this IP is connected to

    Note The Network CIT is also created from this command.

ClosedCommand: mxci

  • Sample Output 

    Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.3.4
(c) Copyright 2003, 2004-2010 Hewlett-Packard Development Company, LP.

  • Values Taken

    SQL/MX version value is taken from the output. In this case, it is 2.3.4.

ClosedCommand: set schema nonstop_sqlmx_measyos.system_schema;

  • Sample Output 

    --- SQL operation complete.

  • Modeled CITs

    None

ClosedCommand: select cat_name, cat_uid from catsys;

  • Sample Output 

    CAT_NAME                                                           CAT_UID
-----------------------------------------------------------------  --------------------
C                                                                  0101010101010101010
NONSTOP_SQLMX_MEASYOS                                              0202020202020202020
--- 2 row(s) selected.

  • Modeled CITs - NonStop SQL/MX

    Attribute

    Value

    Comment

    Name

    NonStop SQL/MX

    This value is a constant

    Catalog UUID

    0101010101010101010

    		  

    The Database instance name

    NONSTOP_SQLMX_MEASYOS

    		  
ClosedCommand: select schema_name, cat_uid from schemata;

  • Output 

    SCHEMA_NAME                                                        CAT_UID
-----------------------------------------------------------------  --------------------
DEFINITION_SCHEMA_VERSION_1200                                     0101010101010101010
S                                                                  0202020202020202020
DEFINITION_SCHEMA_VERSION_1200                                     0202020202020202020
--- 7 row(s) selected.

  • Modeled CITs: Database Schema

    Attribute

    Value

    Comment

    Name

    DEFINITION_SCHEMA_VERSION_1200

    This is the schema ID

    Container

    0101010101010101010

    		  
ClosedCommand: exit

  • Sample Output 

    End of MXCI Session
ClosedCommand: gtacl -p sqlci

  • Sample Output 

    SQL Conversational Interface - T9191H01^ACM - (01OCT09)
(C) 1987 COMPAQ (C) 2006 Hewlett Packard Development Company, L.P.
ClosedCommand: fileinfo $system.system.sqlci2, detail;

  • Sample Output 

    $SYSTEM.SYSTEM.SQLCI2                 8 Nov 2010,  6:22
    ENSCRIBE ( VALID SQL PROGRAM )
    CATALOG $QA1.SQL
    PROGRAM CATALOG VERSION 1
    PROGRAM FORMAT VERSION  350
    TYPE U
    FORMAT 1
    CODE 100
    EXT ( 56 PAGES, 56 PAGES, MAXEXTENTS 978 )
    ODDUNSTR
    NO AUDITCOMPRESS
    OWNER -1
    SECURITY (RWEP): NUNU
    MODIF: 21 Dec 2008, 23:22, OPEN
    CREATION DATE: 21 Dec 2008, 23:21
    LAST OPEN:  8 Nov 2010,  6:22
    EOF 364544 (0.3% USED)
    EXTENTS ALLOCATED: 4

  • Values Taken 

    QA1.SQL
ClosedCommand: select catalogname from $QA1.SQL.catalogs;

  • Sample Output 

    CATALOGNAME
-------------------------
\MEASYOS.$QA1.H03SQLMP
\MEASYOS.$QA1.SQL
\MEASYOS.$QA2.PERSNL
\MEASYOS.$SFF04.SALES
\MEASYOS.$SGT01.INVENT
\MEASYOS.$SGT01.PERSNL
\MEASYOS.$SGT02.SALES
\MEASYOS.$SGT03.INVENT
\MEASYOS.$SYSTEM.SRK
\MEASYOS.$SYSTEM.VIMAL
--- 10 row(s) selected.

  • Modeled CITs: Database

    Attribute

    Value

    Comment

    Name

    NonStop SQL/MX

    This value is a constant

    Database instance name

    $QA1.H03SQLMP

    		  

Send Help Center feedback