Toad® IBM® DB2® z/OS® Components
© 2022 Quest Software Inc.
ALL RIGHTS RESERVED.
This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software Inc.
The information in this document is provided in connection with Quest Software products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest Software products. EXCEPT AS SET FORTH IN THE TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST SOFTWARE ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST SOFTWARE BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST SOFTWARE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest Software makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest Software does not make any commitment to update the information contained in this document.
If you have any questions regarding your potential use of this material, contact:
Quest Software Inc.
Attn: LEGAL Dept
4 Polaris Way
Aliso Viejo, CA 92656
Refer to our web site (www.quest.com) for regional and international office information.
Quest Software is proud of our advanced technology. Patents and pending patents may apply to this product. For the most current information about applicable patents for this product, please visit our website at www.quest.com/legal.
This product includes patent pending technology. For the most current information about applicable patents for this product, please visit our website at www.quest.com/legal.
Quest, Quest Software,
|Prepare to Install Toad IBM DB2 z/OS Components|
|Install Toad IBM DB2 z/OS Components|
|Manual Transfer of the z/OS Component Installation Files|
|Appendix A: Objects Created by the Installation|
|Appendix B: Edit QCIVP|
You must install the Toad IBM DB2 z/OS Components on each IBM DB2 for z/OS subsystem that you want to manage using Toad for IBM DB2. The z/OS components enables you to use Toad to perform the following functions on the IBM DB2 subsystem:
After you install Toad for IBM DB2 on the client machine, install the Toad IBM DB2 z/OS Components on each IBM DB2 subsystem that you want Toad to manage. Review this section to ensure that the proper user privileges and system requirements are in place for each IBM DB2 subsystem.
Before installing Toad IBM DB2 z/OS Components, ensure that your mainframe meets the following minimum hardware and software requirements:
|Database Server||IBM DB2 for z/OS version 9 or later|
|WLM application environments||
Two WLM application environments are required. The environments must be defined using ISPF Application IWMARINO. z/OS VIR6.0 MVS Planning Workload Management (SA22-7602-06) provides instructions for using the WLM ISPF panels.
Note: The z/OS components must have these two WLM environments for its exclusive use. Do not attempt to use pre-existing WLM environments used for other applications.
|Resource Recovery Services||
Resource Recovery Services (RRS) subsystem installed and active for your DB2 WLM application environment. z/OS VIR6.0 MVS Programming Resource Recovery (SA22-7616-04) and z/OS VIR4.0 MVS System Commands (SA22-7627-11) provide instructions for setting up and starting RRS on your system.
For WLM usage, verify that the load module
SORT is in the Link Pack Area (LPA) or is marked as reentrant. Due to limitations of the WLM address space starting in Program Status Word (PSW) key 8, a non-reentrant
SORT load module causes an
ABEND SOC4 when
SORT during utility processing.
Note: When running
SYNCSORT in the WLM environment, users might receive
ABEND SOC4 errors when
SYNCSORT. You can contact
SYNCSORT to obtain a fix tape that contains support for IBM DB2 stored procedures. This fix applies ZAPs to the current
SORT modules, and then creates a new
SORT stub and aliases to a new reentrant module
SYNCFNI. The documentation accompanying the tape provides instructions for applying the fix.
Generally, any user can run the Toad IBM DB2 z/OS Components Installation wizard. However, one phase in the installation is to transfer installation files from the Toad client to the mainframe. If you want the wizard to automatically perform this transfer, the user ID running the wizard must have permissions to FTP the files.
After the wizard finishes its part of the installation process, the user must perform additional tasks on the mainframe to complete the z/OS components installation. The user who performs these post-wizard tasks must have the following privileges and authorities:
Generally, a systems programmer performs the post-wizard tasks.
The permhlq.JCLLIB(GRANTS) member predefines the privileges required to run the z/OS components. One of the post-wizard installation tasks is to edit and execute this member to grant these permissions to the authorization IDs you specify in the member.
To catalog IBM DB2 subsystem