The Star in Tandem© NonStop Training & Professional Services since 1986
Polaris Learning Solutions Home PagePolaris Learning Solutions Home PageOn-Site CoursesProfessional ServicesPricing and Payment TermsContact UsAbout UsOur Clients
PLBP403 - NSK File Infrastructure
This advanced course teaches the student what the best (and worst) practices in NonStop Database (both ENSCRIBE and NonStop SQL/MP) utilizations are. Many experienced people generalize database characteristics across platforms. Tandem's databases have unique and powerful implementations that make fully understanding them paramount in optimizing their performance.

A relative file on IBM works the same way as on Tandem...doesn't it? What about space reclamation? Just what are Key sequenced files on Tandem like? Are they like VSAM? If the wrong decision can cripple performance, the right decision can make it sparkle!

This course is designed for senior Programmers, Analysts, Application Designers, DBAs, System Managers, and those who need to fully understand how each of Tandem's file types compare with the rest of the industry, and what is special and most useful about each one. It will cover all three of Tandem's file structures, plus unstructured files, and their respective strong (and weak) points. This is a critical course to optimizing database performance and fully understanding the impacts of your choices.


Online: Self-Paced, includes Instructor Support
On-Site: 1 day


Those senior Programmers, Application Designers, Analysts, DBAs and System Managers and others who need to learn about each of Tandem's strucutred file characteristics, and other aspects of Tandem databases.


  • DP2 Review
  • Overview of General NSK File Strucutres
  • In-depth coverage of the three Tandem Strucutred file types, how and when to use them optimally
  • In-depth coverage of how Tandem file types compare to others in the industry, their relative strengths and weaknesses


  • Minimum of 2 years experience on Tandem NonStop systems.
  • Minimum 2 years hands-on experience with NonStop Databases (ENSCRIBE and/or NonStop SQL/MP).

Web site:



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

1892 FM 2481
Bluff Dale, TX  76433

  • NSK File Infrastructure
    • General NSK File Structures
      • General File Systems, and the NSK File System
      • NSK Structured and Unstructured Files
      • Why different file types
      • Indexing and Partitioning
      • File Extents
      • Big Files (Format2 files)
      • OSS Files (Veritas)
    • DP2 Review
      • Disk Access Manager
      • The DP2 Process
      • Disk Cache
      • Sequential Block Buffering (Real and Virtual)
      • File Extents
      • Big Files (Format2 files)
    • NSK File-blocking strategy, including discussion of audited files and the impact of auditing (TMF) on I/O performance.
    • Detailed analysis and comparison of Relative, Entry-Sequenced and Key-Sequenced files with similar file structures in the rest of the Industry
      • Entry Sequenced Files - Compare and contrast to entry-sequenced formats on other platforms. Discuss inserts, reads, updates, and alternate indexes.
      • Relative files - Compare and contrast to other Relative file formats on other platforms. We will also discuss space allocation and space reclamation (and why NonStop excels at this), alternate keys, and use of three different types of record insertion and the impact on key structure, including using logical keys. Also discuss random vs. sequential reads - direct or with alternate indexes.
      • Key Sequenced file. Compare and contrast this popular format with other Key-Sequenced files on other platforms. We will discuss its major areas of strength on the NonStop platform, and optimal utilization. Discussion also includes space allocation, reloading strategies, and index structures as used in various platforms, including "fat index/ skinny data" designs, DB2 and NonStop. We will discuss indexed nonsequential strucutres along with indexed sequential ones.
    • Detailed design and structures of NSK Relative, Entry-Sequenced and Key-Sequenced files,
      • Entry-Sequenced Files - Discussion of NSK-Specific record alignment within blocks, free space, record insertion, updates and deletes. We will discuss the Syskey for ES files, absence of block splits, and optimal usage conditions.
      • Relative Files - Discuss block allocation, record insertion and nature of the Syskey. We will also discuss optimal usage conditions.
      • Key Sequenced Files - Discuss specifics of block splits, record insertions, and deletions. We will also discuss B-Tree index structure, impact of multiple index levels, when a Syskey is or is not generated, caching strategies, and use of the Tandem Reload Analyzer (TRA).
    For Web site issues, contact Webmaster .   Copyright © 2003-2009 Polaris Learning Solutions   All rights reserved.