TitlePage

Copyright

© 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.

Patents

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.

Trademarks

Quest, Quest Software, Benchmark Factory,Spotlight, LiteSpeed, SQL Navigator, vWorkspace, Toad, and the Quest logo are trademarks of Quest Software Inc. in the U.S.A. and other countries. For a complete list of Quest Software trademarks, please visit our website at www.quest.com/legal. Microsoft, Windows, Windows Server, Windows Vista, Visual Studio, SQL Server, SharePoint, Access and Excel are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Oracle is a trademark or registered trademark of Oracle and/or its affiliates in the United States and other countries. Citrix® and XenApp™ are trademarks of Citrix Systems, Inc. and/or one or more of its subsidiaries, and may be registered in the United States Patent and Trademark Office and in other countries. SAP is the registered trademark of SAP AG in Germany and in several other countries. IBM and DB2 are registered trademarks of International Business Machines Corporation. MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries. Google and Google Analytics are registered trademarks of Google Inc. PostgreSQL is a registered trademark of the PostgreSQL Community Association of Canada. Subversion is a trademark of the Apache Software Foundation. All other trademarks, servicemarks, registered trademarks, and registered servicemarks are property of their respective owners.

Toad IBM DB2 z/OS Components 7.4
Installation Guide
Tuesday, April 19, 2022

Table of Contents

Prepare to Install Toad IBM DB2 z/OS Components

Why Install Toad IBM DB2 z/OS Components

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:

• Bind and rebind packages and plans
• Invoke utilities and commands within scripts that Toad for IBM DB2 advanced alters and migrations generate
• Run stand-alone IBM DB2 utilities in Toad
• Run IBM DB2 for z/OS commands from the Editor
• Remotely execute IBM DB2 for z/OS scripts
• Create, alter, or drop dataset templates
• Run DISPLAY, START and STOP commands on databases, tablespaces and indexes
• Access accurate bufferpool information
• View volumes available for defining storage
• Access information about the current threads connected to the IBM DB2 subsystem
• Assign a RACF group to a Toad Security role

Prepare to Install Toad IBM DB2 z/OS Components

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.

Mainframe Requirements

Before installing Toad IBM DB2 z/OS Components, ensure that your mainframe meets the following minimum hardware and software requirements:

Other WLM Environment Requirements

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 DSNUTILB calls SORT during utility processing.

Note: When running SYNCSORT in the WLM environment, users might receive ABEND SOC4 errors when DSNUTILB calls 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.

Privileges Required

For Installing the z/OS Component

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:

• SYSADM privileges in order to run SPUFI scripts and to create objects
• EXECUTE authority on all packages in the DSNAOCLI collection

Generally, a systems programmer performs the post-wizard tasks.

For Running the z/OS Component

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.

IBM DB2 Subsystem Performance Requirement

To improve overall z/OS components performance on the IBM DB2 subsystem, define an index on the OWNER column in SYSIBM.SYSPLAN in the subsystem.

Catalog IBM DB2 Subsystem Before Installation

Before installing Toad IBM DB2 z/OS Components, make sure that the IBM DB2 for z/OS subsystem on which you are installing the z/OS components is cataloged on your Toad DB2 client.

To catalog IBM DB2 subsystem

1. In Toad for IBM DB2, click in the Toad toolbar.
2. Click in the Connections window to launch the Client Configuration wizard.
3. For instructions on how to catalog the DB2 subsystem, press F1.