The Star in NonStop Tandem Training & Professional Services since 1986
Polaris Learning Solutions Home PagePolaris Learning Solutions Home PageOn-Site CoursesOnline ClassesProfessional ServicesPricing and Payment TermsContact UsAbout UsOur Clients
PLMX202 - NonStop SQL/MX Management
DESCRIPTION
This course is based on SQL/MX release 2.0 (G06.23) and addresses both SQL/MP tables and SQL/MX tables. It provides a subsystem overview and covers product installation, creating and managing database objects, and database security. It also describes the important new communications layer, MXCS, which facilitates access to SQL/MX from remote clients.

This two-day course includes 25 scripts. These are run from the OSS (UNIX-like) environment, where SQL/MX is based. The scripts permit the user to display object names, object versions, and security settings without writing complex metadata queries. The course also includes MXCI obey files to simplify the setting of default schemas, and seven TACL routines to expedite subsystem maintenance.

Extensive hands-on labs will anchor the student's classroom learning.

Course Duration: 2 days (on-site only)

WHO SHOULD ATTEND
NonStop system managers, database administrators, and operators, as well as programmers and any others who need an overview of SQL/MX.

PROGRAM HIGHLIGHTS

  • SQL/MX Overview
  • SQL/MX and the ANSI standards
  • SQL/MX Database objects
  • SQL/MX Installation and Metadata
  • MXCI Command Interface
  • Database Object Management
  • Using OSS Scripts to manage objects
  • Reorganizing MX objects
  • Histograms
  • MX Tools
  • Database Security, GRANT and REVOKE
  • Connectivity Services
  • MXCS Architecture
  • ODBC Client components and setup

PREREQUISITES
The audience should have completed NonStop Features and Fundamentals (PLI210) or be familiar with the Tandem NonStop environment, including the use of editors and general utilities. The student should be familiar with NonStop systems and understand basic relational database concepts. No knowledge of ANSI standards, SQL/MP, OSS, or UNIX is presumed.

QUESTIONS/COMMENTS?
Web site:
E-mail:

Phone:
Fax:
Cell/Pager:

Mail:
http://www.polarislearning.com/
operations@polarislearning.com

+1 972-898-3206
+1 972-898-3206
+1 972-898-3206

1892 FM 2481
Bluff Dale, TX  76433
USA

COURSE DETAILS
  • Module 1 - NonStop SQL/MX Overview
    • SQL/MX and the ANSI Standard
    • SQL/MX and SQL/MP Comparison and co-existence
    • Product components in Guardian and OSS
    • Overview of SQL/MX database objects
    • Managing the SQL/MX environment with NSM/web
    • Lab 1: Familiarization with the SQL/MX environment
  • Module 2 - Installation and Metadata
    • Installing SQL/MX and the sample databases
    • Release identifier and VPROC output
    • Metadata and how to query it
    • The SHOWLABEL command
  • Module 3 - MXCI Command Interface
    • MXCI features and commands
    • Defines in MXCI
    • DISPLAY, SET, and SHOW commands
    • SHOWSHAPE and other commands
    • MXCI-only and embedded-only commands
    • Using MXCI output in an OSH script or TACL routine
    • Lab 2: Metadata and MXCI commands
  • Module 4 - Managing Database Objects
    • Namespaces
    • Partitioning
    • Creating, altering, and dropping database objects
    • Dealing with BLOB/CLOB objects
    • Using OSS scripts to display objects names and attributes
    • SQL/MX utilities: MODIFY, DUP, PURGEDATA, RECOVER
    • Lab 3: Creating and dropping database objects
  • Module 5 - Database Maintenance
    • Reorganizing SQL/MX data
    • Using TACL routines and FUP for managing SQL/MX files
    • Using Guardian utilities for managing SQL/MX
    • The mxtool utilities: VERIFY, FIXUP, GOAWAY
    • Using MXCI and OSS utilities to manage SQL/MX
    • The mxexportddl utility
    • Lab 4: Database maintenance
  • Module 6 - Database Security
    • Review of Guardian and OSS security
    • GRANT/REVOKE security in SQL/MX
    • Using scripts to display object security settings
    • Lab 5: Database security
  • Module 7 - Connectivity Services
    • MXCS architecture
    • ODBC client components and setup
    • Managing MXCS with MXCI
    • Managing SQL server processes
    • Environment variables and MXCS users
    • Using NSM/web to manage MXCS
 
For Web site issues, contact Webmaster .   Copyright 2003-2009 Polaris Learning Solutions   All rights reserved.