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 / Preface VTS Manager References The following manuals describe the VTS Manager product: VTS Manager Concepts and Facilities Guide VTS Manager Administration Guide Doc navigation < Additional tableBASE references Customer Support >