Training for NonStop Systems

NonStop Platform Introduction

Platform introduction, architecture and history.  Covers Himalaya and Integrity (Itanium), terminology and basic concepts.

SQL/MX DBA Training

Database Administration and Maintenance of SQL/MX objects. Design and Create Tables, Indexes, Constraints, Triggers and Views. Learn HASH and RANGE partitioning concepts, updating statistics, grant/revoke, best practices and more.

SQL/MP Administration

Database Administration and Maintenance for SQL/MP tables, indexes, and views. Design and Create Tables/Indexes/Views, Partitioning Concepts and First Key Values,  Sizing and Extent Calculations, Statistics, Dup vs. Load, NonStop Features, etc.

SQL/MP Query Design

SQL DML language details…  SELECT, INSERT, UPDATE, DELETE.  Sorting, Grouping, MDAM, CASE, MIN/MAX/AVG, Function calls, Concatenation, Locks, and performance concepts.

SQL/MX Differences

Understanding new and changed features in SQL/MX vs. SQL/MP.  MXCI Conversional Interface, ODBC/MX, Publish/Subscribe, Aliases, Histogram Stats, Orthogonality, etc.

Performance Analysis

Tandem NSK Performance Concepts, Collecting and Analyzing Measure Data, Queuing Theory, Using GPA, Disk Cache, Peek, TMF Trans Rates, TPDC, SPAM, Prognosis, etc.

SMF Concepts

System Management Foundation overview, usage, configuration, SCF commands.  Introduction of the Automated Storage Management product (ASM), setup, configuration, and operation.

TMF Administration

Transaction Monitoring Facility (NonStop TM/MP) overview, setup, configuration.  Focusing on configuration and recoverability concepts and strategies, including Audit Trails, Audit Dumps, Online Dumps, and Disk and File recovery.

TACL Programming

Learn how to program in this powerful scripting language. Covers Macro/Routine/Alias differences, variables, built-ins, and programming design concepts and strategies.

TACL Advanced Programming

For those already familiar with TACL programming basic concepts.  Learn advanced techniques such as filtering, messaging, inter-process communication, argument processing and more.

Operations for K&S Series

Combined K& S-Series operations management course.  Covers Tandem architecture, Monitoring applications, System Maintenance, Tools/Utilities, and Common problem resolution.

Pathway Administration

Learn to configure, monitor, and balance pathway systems.  This includes PATHMON, Server classes, TCPs, Screen Programs, Server Links, Linkmon, Logs, and more.

Spooler Administration

Tandem spooler setup, configuration, and monitoring details.  Covers SPOOLCOM, Peruse, Print processes, Printer setup and configuration, and managing print jobs.

SQL Report Writer

Detailed course specifically on the Report Writer features of NonStop SQL/MP, including LAYOUT options, DETAIL command, page breaks, data grouping, sizing/spacing manipulation, totaling values, headings and more.

COBOL85 Tandem Programming

COBOL85 Programming concepts specific to the Tandem NonStop environment.  Includes $RECEIVE concept and strategies, context free server programming, and embedded SQL.

COBOL85 Advanced Tandem Programming

COBOL85 course for those already familiar with Tandem COBOL.  In depth training on calling guardian procedures, functions, date/time processing, sorting, and creating nonstop processes.

Security for Tandem Systems

Learn Tandem security commands, concepts, and strategies.  Includes guardian security, FUP, Safeguard, and 3^rd party products.