• Notices
• Preface
  • Audience for this Guide
  • What is Covered in this Guide
  • What’s new in Version 7
  • Features from Version 6
  • Naming protocol
  • What You Should Know to Use this Guide
  • Glossary
  • Conventions used in this guide
  • What This Guide Contains
  • Additional tableBASE references
  • VTS Manager 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
• VTS Gate (VTS with Enhanced Security)
  • Overview
  • VTS management
    • Valid combinations of VTS Gate 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
• 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 run-time 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) or 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
  • TBEXEC error messages
• PC Server implementation in a CICS environment
  • Implementation and Restart/Recovery Considerations
  • Steps to Implement the PC Server
  • RESTART/RECOVERY Considerations
  • NOTES and CAUTIONS