• Notices
• Preface
  • Audience for this Guide
  • What is Covered in this Guide
  • Naming protocol
  • What You Should Know to Use this Guide
  • Glossary
  • Conventions used in this guide
  • What This Guide Contains
  • Additional tableBASE references
  • Customer Support
  • Training and Professional Services
  • About DataKinetics
• Installation Modifications
• tableSPACE Reporting
  • Generating the tableSPACE report for batch, IMS and VTS Agent
  • Generating the tableSPACE report for CICS
  • tableSPACE report samples and description
• tableBASE User Exits
  • User Exits
  • Working with User Exits
    • Step 1—Programming User Exits
    • Step 2—Defining Exits using DK1TX072
    • Step 3—JCL Requirements for Exit Processing
    • Step 4—TBOPT Parameter Requirement
  • DK1EXDFN Macro Parameters
    • Defining a Header (TYPE=INITIAL)
    • Defining the Entries (TYPE=ENTRY)
  • Parameter Data Passed to Exits
    • Parameter 1: Communication Area
    • Parameter 2: Global Work Area
    • Parameter 3: Shared Thread Related Work Area
    • Parameter 4: Private Thread Related Work Area
  • Exit Related Messages
  • Sample User Exits
• Program Call Server
  • Initialization of the Program Call Server
  • Server Messages
    • Licensing Messages
  • Re-initialization of the Program Call Server
    • Restarting the tableBASE Program Call Server
  • Shutting down the Program Call Server
• DB2 Stored Procedures
  • Using DB2 stored procedures
• IMS
  • JCL
  • Pre-loading tableBASE modules
  • Application/transaction initialization
    • Transaction abends
    • VTS-TSR access
• CICS
  • JCL
  • Definitions
    • Journal
    • Programs
    • Transactions
  • CICS initialization and shutdown
  • Transaction TBST
    • Restrictions
  • Transaction TBDR
  • The TBOPT dataset
• VTS (Virtual Table Share)
  • Overview
  • New Features in Version 7
  • Changes from Version 6
    • Update commands in a VTS-TSR
    • Transaction affinities
    • TBPOSTV
    • TBOPTV
    • SWITCHES parameter
  • VTS Agent operations
    • Startup
    • Initialization of a VTS-TSR
    • TBOPT parameters
    • VTS-TSR table loading sample JCL
    • VTS-TSR refresh process
    • VTS Agent shutdown
    • VTS Agent recovery
  • VTS commands
  • VTS operational considerations
    • Reducing virtual storage when moving tables into VTS
    • Linked tables in VTS
    • 7/24 VTS
    • Capacity
    • Loading a VTS-TSR
  • VTS messages
    • Internal logic errors
    • VTS user messages
• VTSGate (VTS with Enhanced Security)
  • Overview
  • VTS management
    • Valid combinations of VTSGate security features
    • tableBASE commands by TSR access type
    • TBOPT parameters
    • VTSDATA
    • Access control setup for SAF protected VTS
    • Startup and shutdown
    • Table loading and updating for read-only VTS
    • Strobe reporting
    • Licensing Messages
• VTSManager
  • VTSManager Features
    • Pre-loaded VTS-TSRs
    • Read-only VTS
    • Refresh-only VTS
    • Update Tables in the Background
    • Switching VTS-TSRs
    • Alias Names for VTS-TSRs
  • Installing VTSManager
    • Details of VTSManager Installation
      • Install the Necessary Modules into an APF-authorized Library
      • Activate the VTSManager License
  • Administration of VTSManager
    • VTSManager Administrative Tasks
    • VTS-TSR Access Modes
    • Pre-loading VTS-TSR
    • Sample JCL to bring up VTS-TSR in RF Mode
  • DK1MEXEC Utility
    • VTSManager Command Summary
    • DK1MEXEC
      • Sample JCL to run DK1MEXEC
      • Command Structure and Syntax
      • VTSManager Commands
        • LICENSE Command
        • RESET Command
        • SET Command
        • SHOW Command
        • SWITCH Command
        • Command Sequence Examples
      • TBMSG Report
      • Example of TBMSG Report for DK1MEXEC
    • Things to consider while performing VTS Manager SWITCH
      • Batch
      • CICS
      • IMS
  • JCL Examples Delivered with VTSManager
• tablesONLINE/CICS Architecture
  • Overview
  • Library architecture
    • System library
    • Application Control Table library
    • Application-Driving Tables library
    • Data Dictionary library
  • Levels of privilege
  • Types of data
    • Common corporate data
    • Application-specific user data
    • Application-driving data
• tablesONLINE/CICS Security
  • The signon security exit
    • The Cross Authorization table
    • The User/Application Relationship table
    • The Application Control table
    • Invoking signon security
• tablesONLINE/CICS Administration
  • Set up new users
    • Application Control table
    • Modifying an existing Application Control table entry
  • Editing the User/Application Relationship table
  • Cross-Authorization table
  • tablesONLINE/CICS and VTS
  • Creating new applications
    • Copying applications
    • Developing applications
  • Removing a User-developed application
  • Customizing your environment
    • User Profile
    • Editing system help
    • Editing system tutorials
    • System constants
    • Editing MRO transaction IDs
  • Monitoring your system
    • Session control
    • Session suspension and restoration
    • Terminating a session
    • Terminating the administrator session
    • Transferring to user applications
  • Use of temp tables and TS queues
  • Converting from Release 4.2.x
• Best Practices
  • Protecting tableBASE libraries
    • Concurrent multiple updates
    • Read-Only libraries
  • Protecting tableBASE tables
    • Table read and write passwords
    • TSR LOCK-LATCH
    • Time out while waiting for a lock
    • tablesONLINE temporary tables
  • Performance
    • Shared tables: Virtual Table Share (VTS)
    • Linking tableBASE
    • Using the TB-PARM Communication Area
    • WLM priority level consideration
    • Application performance with TBASEV or TBCALLV
    • Batch/IMS Performance Degradation with Dynamic Calls to tableBASE
    • Table access optimization
    • Multitasking
  • tableBASE library definition considerations
    • Library Blocksize
    • tableBASE library space usage
    • BDAM/QSAM tableBASE libraries
    • VSAM tableBASE libraries
    • VSAM tableBASE libraries and LSR pools
  • Enhanced Data Integrity option
  • Library directory caching
  • TSR Space Allocation
  • tableBASE modules that can reside in the Link Pack Area (LPA)
• tableBASE Diagnostic Information
  • tableBASE use of MVS Enqueues
  • tableBASE Library Diagnostics
• tableBASE Runtime Options
  • ALLOW_TB_LIB_IO—Allow tableBASE Library I/O
  • CICSJRNL—CICS Journal File ID
  • DATERTNX—Date-Sensitive Processing Found Code
  • FGDELIM—Fetch Generic Delimiter
  • HASH_HI_DEN_LIM—High Density Limit for Hash Indexes
  • HASH_LOW_DEN_LIM—Low Density Limit for Hash Indexes
  • LDS—Linear Data Set Use
  • LIBnn, ML—tableBASE Library List
  • LISTOPTIONS—List Parameter Options
  • LOCKTIMERC—Lock Timer Wait Value
  • LOCKTIMEWTO—Lock Timer Message Wait Value
  • MAXNMTAB—Maximum Number of Tables
  • MTRETAIN—Retain Rows and Index Areas
  • MULTITASKING—Multitasking
  • MULTOPNX—Multiple Alternate Index
  • OVRRIDES—Allow Changes to Status Switches
  • RACF_LIBACCESS—Perform Checks on Protected Libraries
  • RACF_VTS—Perform Checks on SAF Interface Protected VTS-TSRs
  • STROBE—Strobe Interval
  • STROBEMETHOD—Strobe Method
  • SUPPRESS_DUMPS—Suppress tableBASE Messages and Dumps
  • SWITCHES—Status Switches
  • TABLEWAITRC—Table Open Enqueue Wait Time
  • TABLEWAITWTO—Table Open Enqueue Report Time
  • TPVM—VTS Group Manager Use
  • TSR_ALGORITHM—Optimize TSR Usage
  • TSR_KEY_PROTECT—Hardware Key Protection for VTS-TSRs
  • TSR_WARNING_FREQ—Frequency of TSR Allocation Warnings
  • TSR_WARNING_PCT—Percentage of TSR Allocation for Warning Activation
  • TSRACCESS—Read Only (RO), Refreshable (RF), and Read Write (RW) TSR Access
  • TSRSIZE—tableSPACE Region Size
  • USEREXITS—User Exits
  • VTSFIRST, VTSLAST—VTS Search Sequence
  • VTSNAME—Specifying the Name of a VTS-TSR
  • VTSPREFIX—VTS Prefix Definition
  • ZEROROWS—Zero Data Table Rows on De-allocation
• Setting up an organization
  • Defining authorities
  • Defining the environment
  • Defining users and applications
• tableBASE messages
  • tableBASE return codes
  • tableBASE messages
  • tablesONLINE/CICS error messages
  • tablesONLINE/ISPF error messages
  • DK1TEXEC error messages
  • VTSManager Error messages
    • Command Interpretation Errors
    • Command Processing Errors
    • Licensing Warnings and Errors
• PC Server implementation in a CICS environment
  • Implementation and Restart/Recovery Considerations
  • Steps to Implement the PC Server
  • RESTART/RECOVERY Considerations
  • NOTES and CAUTIONS
• VTS Gate and VTSManager Compatibility
  • Scope
  • VTSManager with RACF protection from VTS Gate
    • Description of the VV Command
    • Compatibility Consideration: VV and TSRACCESS=RF
  • VTS Configurations with LDS Backing and VTS Manager Alias Switching
    • TSRACCESS=RF
    • TSRACCESS=RO
    • TSRACCESS=RW
  • VTS Configurations without LDS Backing and VTS Manager Alias Switching
    • Important Context
    • Read-Refresh Access (TSRACCESS=RF)
    • Read-Only Access (TSRACCESS=RO)
    • Read-Write Access (TSRACCESS=RW)