U2 Extensible Administration Tool - Rocket Software

Transcription

U2 Extensible AdministrationToolVersion JAN2015January 2015DBT-JAN2015-XA-AM-02

NoticesEditionPublication date: January 2015Book number: DBT-JAN2015-XA-AM-02Product version: Version JAN2015Copyright Rocket Software, Inc. or its affiliates 2005-2015. All Rights Reserved.TrademarksRocket is a registered trademark of Rocket Software, Inc. For a list of Rocket registered trademarks goto: www.rocketsoftware.com/about/legal. All other products or services mentioned in this documentmay be covered by the trademarks, service marks, or product names of their respective owners.ExamplesThis information might contain examples of data and reports. The examples include the names ofindividuals, companies, brands, and products. All of these names are fictitious and any similarity tothe names and addresses used by an actual business enterprise is entirely coincidental.License agreementThis software and the associated documentation are proprietary and confidential to Rocket Software,Inc. or its affiliates, are furnished under license, and may be used and copied only in accordance withthe terms of such license.Note: This product may contain encryption technology. Many countries prohibit or restrict theuse, import, or export of encryption technologies, and current use, import, and export regulationsshould be followed when exporting this product.2

Corporate informationRocket Software, Inc. develops enterprise infrastructure products in four key areas: storage, networks,and compliance; database servers and tools; business information and analytics; and applicationdevelopment, integration, and modernization.Website: www.rocketsoftware.comRocket Global Headquarters77 4th Avenue, Suite 100Waltham, MA 02451-1468USATo contact Rocket Software by telephone for any reason, including obtaining pre-sales informationand technical support, use one of the following telephone numbers.CountryToll-free telephone numberUnited 295Japan0800-170-5464Netherlands0-800-022-2961New Zealand0800-003210South Africa0-800-980-818United Kingdom0800-520-0439Contacting Technical SupportThe Rocket Customer Portal is the primary method of obtaining support. If you have currentsupport and maintenance agreements with Rocket Software, you can access the Rocket CustomerPortal and report a problem, download an update, or find answers to in the U2 Knowledgebase.To log in to the Rocket Customer Portal or to request a Rocket Customer Portal account, go towww.rocketsoftware.com/support.In addition to using the Rocket Customer Portal to obtain support, you can send an email tou2support@rocketsoftware.com or use one of the following telephone numbers.CountryTelephone numberNorth America 1 800 729 3553United Kingdom/France 44 (0) 800 773 771 or 44 (0) 20 8867 3691Europe/Africa 44 (0) 20 8867 3692Australia 1 800 707 703 or 61 (0) 29412 5450New Zealand 0800 505 5153

ContentsNotices. 2Corporate information. 3Chapter 1: Getting started. 6Welcome to XAdmin help.6Installing and updating the DBTools using the Eclipse Update Manager.6XTOOLSUB. 6Installing XTOOLSUB for UniData on Windows. 7Installing XTOOLSUB for UniVerse on Windows. 8Installing XTOOLSUB for UNIX/Linux for UniData. 9Installing XTOOLSUB for UNIX/Linux on UniVerse. 9Installing XTOOLSUB on Windows. 10Chapter 2: XAdmin overview.12Starting XAdmin. 12XAdmin workspace. 12Establishing server connections. 13U2 server definitions. 13Creating U2 server definitions. 13Viewing or editing advanced settings of a U2 server definition. 14Specifying a command to run on connection. 15Editing U2 server definitions.15Connecting to U2 servers.15Disconnecting from U2 servers.16Deleting U2 server definitions. 16Chapter 3: Administering U2 accounts. 17U2 accounts overview. 17Initiating Accounts tasks. 17Adding or viewing U2 accounts. 17Creating a U2 account.17Chapter 4: Managing disk space.19Disk space usage. 19Initiating disk space tasks.19Viewing disk space usage.19Chapter 5: Managing Secure Sockets Layer (SSL).21Secure Sockets Layer (SSL) technology.21Initiating SSL tasks. 21Setting up and managing SSL. 21Generating certificate signing requests. 22Starting the Generate Certificate Signing Request wizard. 22Specifying a file and algorithm for the CSR.22Defining properties of the CSR. 22Selecting a key pair option. 23Supplying key pair parameters. 23Entering a password for the private key file. 24Verifying the status of generating the certificate. 24Generating SSL certificates.25Starting the Generate SSL Certificate wizard. 25Specifying a certificate file name. 25Setting the validity period for a new certificate.26Selecting a certificate type. 264

ContentsOptional: Defining certificate extensions.26Selecting required files to generate a certificate. 27Selecting the private key file of the CSR.27Selecting the signing certificate file and private key file. 27Entering the password for the private key file. 28Creating security context records. 28Starting the Security Context Record wizard. 29Specifying the record ID and protocol. 29Selecting server or client usage. 29Setting authentication properties. 30Setting server authentication properties.30Setting client authentication properties.31Adding trusted peer names. 32Selecting the certificate path rule.32Associating certificates to the security context.33Associating server/client certificates to a security context. 33Associating a server certificate to a security context.33Optional: Associating a client certificate to a security context. 34Selecting the private key file for the server or client certificate.34Optional: Associating CA certificates to a security context record.35Selecting or generating a random file. 35Optional: Generating a random file. 36Adding seed source files. 36Optional: Specifying ciphers. 36Optional: Specifying a certificate revocation list. 37Setting a password for the SCR.37Verifying the status of generating the SCR. 37Configuring SSL for U2 servers. 38Chapter 6: Managing data encryption. 39Automatic data encryption (ADE) operations.39Initiating data encryption tasks. 39Administering data encryption. 39Managing encryption keys. 40Opening the Keys tool.40Creating encryption keys. 40Viewing encryption key details.40Deleting encryption keys.415

Chapter 1: Getting startedWelcome to XAdmin helpThe help provides conceptual, task-based, and reference information about XAdmin.You can search for a word or phrase in these help topics by selecting the Search tab and entering yoursearch topic. To narrow the search results to an exact phrase, enclose the phrase within quotationmarks, for example, “dictionary files.”Additional resourcesFor additional information about U2 products, training, and technical resources go to alling and updating the DBTools using the EclipseUpdate ManagerYou can update and install any of the U2 DBTools using the Update Manager in Eclipse.Find the latest information about updates for U2 DBTools at 3.4.5.6.Launch any U2 DBTools or base Eclipse installations (beginning with Galileo) on your computer.From the Eclipse Help menu, select Help Install New Software.Click Add, enter a name for the site, such as U2 Update Site, and in the Work with field enterhttp://updates.rocketsoftware.com/u2. Click OK.Allow the repository to load and then expand the tree for U2 DBTools. Select the updates that youwant to apply. You can also choose to install any other U2 DBTools into your existing workspace.Click Next and follow the installation wizard to complete the installation of updates.Updates will take effect the next time an updated tool is launched.Note: Only tools that are installed through separate InstallShield installations will appear onthe Start menu. Tools installed using the Eclipse Update Manager are installed as individualperspectives in a single Eclipse instance. You can access the different perspectives by selectingWindow Open Perspective and then selecting the appropriate tool.Note: You can check for updates to the DBTools by selecting Help Check for Updates. To usethis option, you must have previously defined the http://updates.rocketsoftware.com/u2 locationin the Install New Software dialog, as described in step 3.XTOOLSUBThis topic describes the XTOOLSUB program and how to upgrade to the latest version of XTOOLSUBon various operating systems.6

Installing XTOOLSUB for UniData on WindowsUpdating the XTOOLSUB ProgramThe XTOOLSUB program is a U2 database server-side BASIC program used by various U2 Client Tools.This includes U2 DataVu, U2 Web DE, Basic Developer's Toolkit (BDT), Extensible Administration Tool(XAdmin), Web Services Developer, and more. It also includes any tool that uses the U2 Resource View.XTOOLSUB updates itself automatically. However, if something happens to the XTOOLSUB programyou can download the latest version from the public Tech Note site 410028.aspThe XTOOLSUB program contains several zip and tar files, and includes three or four files, dependingon the environment. The XTOOLSUB program is used by all the tools, but the other files included areonly used for the Basic Developer's Toolkit (BDT).The XTOOLSUB EXECPRE/XTOOLSUB XPRE programs are for pre-execution functionality andXTOOLSUB EXECPOST/XTOOLSUB XPST are for post-execution functionality. These programs arediscussed further in the related public Tech Note, BDT Extensibility Details. If you have added your owncode to the pre- and post-functionality, copy those modified programs to the older database versionsrather than the pre- and post- files located here.The files included for UniData are: XTOOLSUBXTOOLSUB EXECPREXTOOLSUB EXECPOSTEDAMAPSUB (UniData 6.1 and lower)The files included for UniVerse are: XTOOLSUBXTOOLSUB XPREXTOOLSUB XPSTEDAMAPSUB (UniVerse 10.3 and lower)Do not catalog the EDAMAPSUB subroutine when using UDT 7.1 or UV 11.1 and higher. This programalready exists on those versions.There is a difference between the databases because UniVerse's catalog environment is a type 1 fileand has a 14–character file name limit.Only extract the file that is needed for the database server/version and OS type you are using.The .UX.tar (Unix) files come from AIX. You will need to run fnuxi/convcode if you use other UNIX/Linux operating systems. Files are not included for all operating systems in order t

To contact Rocket Software by telephone for any reason, including obtaining pre-sales information and technical support, use one of the following telephone numbers. Country Toll-free telephone number United States 1-855-577-4323 Australia 1-800-823-405 Belgium 0800-266-65 Canada 1-855-577-43