• Customer Support Portal
  • +1.800.267.0730
  • info@dkl.com
DataKinetics
  • Home
  • tableBASE
  • Solutions
  • Services
  • News & Events
  • Company
    • Resource Center
    • Careers
  • Contact
Select Page
  • Home
  • tableBASE
  • Solutions
  • Services
  • News & Events
  • Company
    • Resource Center
    • Careers
  • Contact
  • Customer Support Portal
  • +1.800.267.0730
  • info@dkl.com
  • 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
  • Home
  • /
  • Documentation Archive
  • /
  • tableBASE Administration Guide

Best Practices

This chapter contains some information on optimization and organization that should be of benefit to tableBASE administrators.

  • 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)
Last modified December 1, 2023

Doc navigation

< tablesONLINE/CICS Administration tableBASE Diagnostic Information >