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) Home / Documentation Archive / V 7.0.3 tableBASE Administration Guide / VTSManager / Installing VTSManager Details of VTSManager Installation To install and begin using VTSManager requires two steps. Install the necessary modules into an APF-authorized library. Activate the VTSManager license. Install the Necessary Modules into an APF-authorized Library Activate the VTSManager License