IBM Cognos PowerHouse 4GL Getting Started
IBM Cognos Application Development ToolsIBM Cognos PowerHouse 4GLVersion 8.40G for OpenVMSGetting StartedGetting Started15-07-2009PowerHouse8.40GType the text for the HTML TOC entryCognos ReportNet(TM) ReadmeIBM Cognos PowerHouse 4GL Getting Started
Product InformationThis document applies to IBM Cognos PowerHouse 4GL 8.40G for OpenVMS and may also apply to subsequent releases. To check for newerversions of this document, visit the IBM Cognos Information Centers r0m0/index.jsp).CopyrightLicensed Materials - Property of IBM Copyright IBM Corp. 1982, 2010.US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.IBM, the IBM logo, ibm.com, Cognos, Axiant, and Powerhouse are trademarks or registered trademarks of International Business MachinesCorp., in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list ofIBM trademarks is available on the Web at www.ibm.com/legal/copytrade.shtml.Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, orboth.Intel, Intel logo, Intel Inside, Intel Inside logo, Intel Centrino, Intel Centrino logo, Celeron, Intel Xeon, Intel SpeedStep, Itanium, andPentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.
Table of ContentsAbout this Document 5Conventions Used in this Document 5Getting Help 5For More Information 5Chapter 1: Installing IBM Cognos PowerHouse 4GL 7Before You Begin 7Important Note Regarding Licensing and Software Enable Keys 7Installation Package 7Download Instructions 7OpenVMS Supported Versions 8Installation Requirements 8Installation Overview 8Before Running the Installation Procedure 8Using Oracle 10g Release 2 9Installing PowerGrid 9Installing PowerHouse 4GL 11The IBM Cognos PowerHouse 4GL Books 16PowerHouse 4GL Books Installation 16Uninstalling the PowerHouse 4GL Books 17Considerations When Using Oracle 17Shared Images 17PowerHouse 4GL and PowerHouse Web Share Oracle Logicals 18Changing the Version of Oracle 18PowerHouse 4GL Configuration 19Directory Structure 19PowerHouse 4GL Command Files 20PowerHouse 4GL Logical Names 22Modifying the Time-out Period for Idle Connections 24Screen Tuning 24Relational Databases Services Log 25SQL 92 Compatibility 25Temporary Sort File Location 25System Resources and Parameters 25User Resources and Parameters 26Account Resources 26Modifying the Time-out Period for Idle Connection 27Allowing Access to PowerHouse 4GL 27Modifying the Startup File 27Modifying System Login Command Files 27System Resources in a Cluster 27Chapter 2: Client Network Support (PowerGrid) 29What is PowerGrid? 29Operating PowerGrid 29Starting the Network Daemon for HP TCP/IP 29Verifying that PowerGrid is Running 29Testing a Network Daemon Connection 29Debug Parameters 30Running Multiple Network Daemons 30Licensed Materials - Property of IBM Copyright IBM Corp. 1999, 20103
Terminating the Network Daemon 30A PowerGrid Example 31If the Network Daemon Process Terminates Automatically 31PowerGrid Configuration 31PowerGrid Directory Structure 31PowerGrid Command Files 32PowerGrid Logical Name 32PowerGrid Privilege Requirements 32Removing PowerGrid 334 IBM Cognos PowerHouse 4GL Version 8.40G for OpenVMS
About this Document This document describes how to install IBM Cognos PowerHouse 4GL version 8.40G forOpenVMS. It is intended for system managers familiar with the OpenVMS environment.Chapter 1, "Installing IBM Cognos PowerHouse 4GL ", provides information about installingPowerHouse 4GL and setting the environment.Chapter 2, "Client Network Support (PowerGrid)", provides information about running andconfiguring PowerGrid.Conventions Used in this DocumentIn this document, the term install directory refers to the directory in which you installed thecomponents.When this document uses the term "enter", type the information and then press the Enter orReturn key.Getting HelpFor more information about using this product or for technical assistance, go tohttp://www.ibm.com/support. Under Choose support type, select Information management, thenunder Choose a product, select Cognos Application Development Tools. Under CognosApplication Development Tools support, click Documentation.For More InformationFor information on the supported environments for your specific platform and any last-minuteproduct information or corrections to the documentation, please refer to the IBM CognosPowerHouse 4GL Release Notes.Licensed Materials - Property of IBM Copyright IBM Corp. 1999, 20105
About this Document6 IBM Cognos PowerHouse 4GL Version 8.40G for OpenVMS
Chapter 1: Installing IBM Cognos PowerHouse4GLThis chapter describes how to install IBM Cognos PowerHouse 4GL.Before You BeginBefore you begin the installation, read this document and the IBM Cognos PowerHouse 4GLRelease Notes in their entirety.Important Note Regarding Licensing and Software Enable KeysAs of version 8.40F, PowerHouse 4GL no longer requires software enable keys, the PowerHouseLicensing software, license files, or the license daemon. For more information, see the IBMCognos PowerHouse 4GL Release Notes.The use of this software program ("Program") is subject to the terms of the license agreementpreviously entered into between you and Cognos, or between you and IBM, as applicable.Regardless of the fact that all Program features and data access are enabled, your use of thisProgram continues to be restricted by the number of users and by the entitlements described inyour order and license agreement. It is your responsibility to ensure that users are restricted fromusing any other Program functionality. If you have any questions, contact your salesrepresentative.Installation PackageThere are two IBM Cognos PowerHouse 4GL 8.40G packages, one each for OpenVMS AlphaServer and OpenVMS Integrity (Itanium ). Each package consists of an IBM CognosPowerHouse 4GL Installation CD and the IBM Cognos PowerHouse 4GL Books CD. If you havedownloaded the files, the contents of the downloaded files are identical to the contents of the CDs.Download InstructionsIf you are downloading the installation package, follow these steps to download the files.Steps 1. Download the files to your Microsoft Windows system but do not unzip or open them.When the "File Download" dialog appears, select "Save". Do not attempt to open thedownload directly from the download page.2. Transfer the PowerHouse 4GL OpenVMS AlphaServer or OpenVMS Integrity zip file to yourOpenVMS system as binary.3. Unzip the PowerHouse 4GL OpenVMS AlphaServer or OpenVMS Integrity zip file to atemporary location using the correct HP OpenVMS Systems UNZIP eware.html4. Change the file attributes by typing:SET FILE/ATTRIBUTE (RFM:FIX,RAT:NONE,LRL:32256) powerhouse084.%SET FILE/ATTRIBUTE (RFM:FIX,RAT:NONE,LRL:32256) powergrid074.%5. Extract the IBM Cognos PowerHouse 4GL Books zip file to a temporary folder on yourWindows system and ensure that the option "Use folder names" is checked.Licensed Materials - Property of IBM Copyright IBM Corp. 1999, 20107
Chapter 1: Installing IBM Cognos PowerHouse 4GLOpenVMS Supported VersionsRefer to the IBM Cognos PowerHouse 4GL Release Notes for a list of supported softwareversions in the OpenVMS environment. PowerHouse 4GL will not install on a version ofOpenVMS less than 8.2 on HP AlphaServer and 8.2-1 on HP Integrity.Installation RequirementsRefer to the IBM Cognos PowerHouse 4GL Release Notes for the installation requirements foryour OpenVMS environment.Installation OverviewThe restoration and installation procedures have a conversational structure, with default answersenclosed in square brackets for most questions. To select the default answer, press Enter orReturn. To obtain more information at any prompt, enter a question mark (?).PowerHouse 4GL and PowerGrid are installed using VMSINSTAL, the standard OpenVMS toolfor installing software. For more information about VMSINSTAL, see the OpenVMS SystemManager's Manual.To install PowerHouse 4GL and Client Network Support (PowerGrid), follow these steps.Steps1. Install Client Network Support (PowerGrid) if you are connecting to Axiant 4GL.If you require PowerGrid, it must be installed before PowerHouse 4GL.2. Install PowerHouse 4GL.3. Set up Client Network Support if you installed PowerGrid in step 1.Details on completing steps 1 and 2 are covered in this chapter. For more information aboutClient Network Support, see Chapter 2,"Client Network Support (PowerGrid)".Before Running the Installation ProcedureBefore running the installation, verify that there is sufficient space on the target disk. If you try toinstall with insufficient disk space, the install procedure issues an error message and asks you ifyou want to continue or not.The install attempts to determine the amount of system resources currently in use and verify thatthere are sufficient free resources. It can be difficult to determine how much of the availableresources are in use. For example, in a new installation, the LOCKIDTBL value may need to beincreased. The LOCKIDTBL value may appear sufficient, when in fact another application isusing that resource heavily. For more information about resources, see the OpenVMS SystemManagement Utilities Reference manual.The procedure recommended by HP for adjusting these parameters is to mark the changes inSYS SYSTEM:MODPARAMS.DAT and use the AUTOGEN procedure (as described in theOpenVMS Cluster Systems manual). By using MODPARAMS.DAT, you can ensure that thechanges necessary for PowerHouse 4GL are not lost when you adjust other system parameters orwhen you upgrade OpenVMS.You should use the ADD option with GBLPAGES and GBLSECTIONS, and the MIN optionwith LOCKIDTBL and RESHASHTBL.Oracle Rdb and PowerHouse 4GL use many of the same system resources (in particular,LOCKIDTBL, RESHASHTBL, and GBLPAGES). If Oracle Rdb is installed on your system, ensurethat there are sufficient resources to run PowerHouse 4GL and Oracle Rdb together.If you are using a shared PHD format dictionary, you will need the following system resources: GBLSECTIONS - one section per dictionary that is to be shared. GBLPAGES - one page per file block and 2 for each dictionary to be shared. For example, ifthe dictionary size is 1500 blocks, you will need 1502 GBLPAGES.8 IBM Cognos PowerHouse 4GL Version 8.40G for OpenVMS
Chapter 1: Installing IBM Cognos PowerHouse 4GLUsing Oracle 10g Release 2If you are using Oracle 10g Release 2 (10.2.0), you must re-link the Oracle executable for properversion resolution. The process uses LINK. You will be prompted for the path to your Oraclesetup location. Typically, you will find ORAUSER.COM in the Oracle setup location.If you select Oracle 10.2.0 during the PowerHouse 4GL installation, the procedure prompts youto enter the path to your Oracle setup location. If you do not provide the correct path, you areprompted to continue the installation. If you stop the installation, obtain the correct path andstart the installation again. If you continue the installation, you must relink the Oracle 10.2.0executable after the installation is complete.Steps1. To set up the Oracle logicals required by the re-linking script, run the Oracle 10.2.0 setupscript provided by Oracle (ORAUSER.COM).2. From PH LOCATION (by default PATH POWERHOUSE:[840G.PH COMMON]), re-linkthe Oracle executable by running@SETPOWERHOUSE 840GSET DEFAULT PATH POWERHOUSE:[840G.PH COMMON]@ORDBA1020 @SETUP ORDBA10203. From PH INSTALL LOCATION (by default PATH POWERHOUSE:[840G.INSTALL]),de-install and re-install the PowerHouse 4GL images by running@PWRDEINSTALL 840G@PWRINSTALL 840G "" "" 1020Installing PowerGridPowerGrid provides network communication services for thin-client applications using Axiant4GL. The main function of the PowerGrid network daemon is starting the servers needed by clientapplications. To respond to requests from client and server applications, the PowerGrid networkdaemon (NETD) must be started before trying to connect to the server from a client PC. Thenetwork daemon must be left running as a background process on each host.You do not need PowerGrid unless you are building and deploying Axiant 4GL thin-clientapplications.If you need PowerGrid, PowerHouse 4GL 8.40G requires PowerGrid version 7.4.You must install PowerGrid before you install PowerHouse 4GL.Steps1. Log on to an account with system privileges.2. If a PowerGrid network daemon is running, terminate the daemon, which will have theprocess name NETD UCX MAIN. For more information about terminating the daemon, see"Terminating the Network Daemon" (p. 30).3. Initiate the installation by entering the command: @SYS UPDATE:VMSINSTAL POWERGRID074 devicename POWERGRID074 is the name of the software and devicename is either the name of adevice or the directory specification where the PowerHouse 4GL savesets are found. Forexample, DQAO:.VMSINSTAL may issue warning messages concerning, for example, other users on thesystem. These messages may be ignored.The following message may appear:Do you want to continue anyway [NO]?If you want to continue, enter YES.You may also be asked about your backup status:Are you satisfied with the backup of your system disk [YES]?If you want to continue, enter YES or press Return.4. You must agree to the license agreement in order for the installation to continue.Getting Started 9
Chapter 1: Installing IBM Cognos PowerHouse 4GL5. You are prompted to designate the target disk on which to restore the files:* Enter the target disk [SYS SYSDEVICE]:If IBM Cognos products are already installed on your system, DISK COGNOS is the default;otherwise SYS SYSDEVICE is the default. The device you specify must be a disk name andcannot be a concealed device (such as SYS SYSROOT:). The colon on the device name isoptional.6. Designate the target root directory in which to restore the files in response to the prompt:* Enter the target root directory [COGNOS]:If IBM Cognos products are already installed on your system, the translation ofROOT COGNOS in the system logical name table is used as the default. Otherwise, the rootdirectory is created at the top level of the directory tree and is named COGNOS.The root directory must be located at either the top or the second level of the directory tree. Ifyou want the root at the second level, the top level directory must already exist. Respond tothe prompt as follows: top level directory .COGNOSwhere top level directory is the name of the top level directory and .COGNOS is optionalbecause it is assumed.7. The following prompts appear if the COGNOS account does not exist. For trials anddemonstrations, the COGNOS account is recommended but not required. The first prompt is:* Would you like the COGNOS account created? [N]:If you choose NO, skip to the next step. If you choose YES, the following prompts appear:Enter the UIC group number (1 to 37776 in octal) [200]:Specify a particular group of users. Choose an octal number in the range of 1 to 37776. Thedefault is 200.Enter the UIC member number (0 to 17776 in octal) [504]:Specify a particular member of a group. Choose an octal number in the range of 0 to 17776.The default is 504.The account is created as follows: the password is POWERHOUSE the default device is set to the target device entered earlier the default directory is set to the root directory entered earlier8. You are prompted to designate an owner of the files:* Which user name will own the PowerGrid files? [COGNOS]:Enter a valid user name or resource identifier. The ownership of the PowerGrid files restoredfrom the distribution medium is set to this user. If a COGNOS account exists, the default isCOGNOS, otherwise the default is SYSTEM ([1,4]).9. Enter the PowerGrid file protection:Enter the file protection [S:RWED,O:RWED,G:RE,W:RE]:The default grants the group and world categories read (R) and execute (E) access to thePowerGrid files, and grants the owner full access to the files, including delete (D). TheSYSTEM protection code should be set to read (R), write (W), execute (E), delete (D) toensure proper installation.If the install creates the COGNOS directory, the protection for the COGNOS directory andall files in the COGNOS directory tree are set to this protection. Otherwise, the protection isonly set for the version directory and all the files in the version directory tree. The install alsoensures that none of the directory files have delete access granted to them.10. If you already have an existing PowerGrid daemon on your system, the existing and targetversions are listed with a message that the existing daemon will be replaced with a NEWER,OLDER, or the SAME version. You are then prompted for authorization to proceed:Do you wish to continue [YES]?Enter YES if you want to replace your current daemon with the target version. Enter NO ifyou want to keep your current daemon.11. If you responded YES in the previous step, the PowerGrid installation begins with themessage:10 IBM Cognos PowerHouse 4GL Version 8.40G for OpenVMS
Chapter 1: Installing IBM Cognos PowerHouse 4GLInstalling PowerGrid for HP TCP/IP Services for OpenVMSIf you do not have TCP/IP Services for OpenVMS installed on your system, PowerGrid issuesan error message similar to the following:HP TCP/IP Services for OpenVMS (formerly UCX) is not installed.You may finish installing PowerGrid, but do not attempt to execute the version-specificPGBOOT command procedure until the appropriate network has been installed. PowerGridrequires HP TCP/IP Services for OpenVMS.12. Specify the PowerGrid port number in response to:* Specify the PowerGrid Port Number [1526]Enter 0 or a number from 1024 to 65535. The default port number is 1526. IBM Cognosclient applications use this port number when initializing a communications session withPowerGrid. If a value other than 1526 is specified, be sure to alert IBM Cognos clientapplication users, as they must configure their applications to use the same number.A value of 0 has a special meaning; it indicates that the PowerGrid communications portnumber will be maintained in the network product Services file.13. The install verifies that there is sufficient disk space (2,500 blocks) to install PowerGrid. Ifthere is insufficient disk space, a warning message appears, and you must specify if you wishto continue, YES or NO.14. The install verifies that the specified user name receiving ownership of the PowerGrid files hassufficient disk quota to accept them. If disk quotas are enabled and the disk quota for the useris too low, a warning message indicating that the disk quota will be increased in the finalphase appears.15. The install verifies that the system parameters are sufficient. For each system parameter, theinstall displays the amount required for PowerGrid, the current setting, the amount in use,and the amount available. For each insufficient resource, an error message appears, and thefollowing question is asked:* Do you wish to continue? [N]To proceed, answer YES, otherwise VMSINSTAL will exit with a warning message that theinstallation has failed. To restart VMSINSTAL, re-issue the VMSINSTAL command.16. When resource checking is complete, the install takes the following actions: Creates the COGNOS directory if it does not already exist. Creates the COGNOS account if you requested this. It also changes the disk quota ifnecessary. Restores the PowerGrid files from the distribution medium and sets the protection andownership accordingly. If a HP TCP/IP Services network type has been selected, the install creates thesystem-specific version of the PowerGrid start-up command file PGBOOT.COM and thenetwork-specific version of the PowerGrid daemon start-up command fileNETD START.CO
OpenVMS Supported Versions Refer to the IBM Cognos PowerHouse 4GL Release Notes for a list of supported software versions in the OpenVMS environment. PowerHouse 4GL will not install on a version of OpenVMS less than 8.2 on HP AlphaServer and 8.2-1 on HP Integrity. Installation Requirements
2 IBM Cognos Business Intelligence Version 10.1.1: Using IBM Cognos Series 7 and IBM Cognos Business Intelligence in the Same Environment. Chapter 2. Set up Interoperability Between IBM Cognos Series 7 and IBM Cognos BI Set up interoperability before and during migration to provide continuity to your
IBM Cognos ReportNet Model Upgrade 367 Verifying the Model in IBM Cognos ReportNet 367 Opening and Upgrading the Model 368 Verifying and Repairing the Upgraded IBM Cognos ReportNet Model 370 IBM Cognos 8.1 or 8.2 Model Upgrade 374 Verifying the Model in IBM Cognos 8.1 or 8.2 374 Opening and Upgrading the IBM Cognos 8.1 or 8.2 Model 375
Sybase names are case-sensitive. PowerHouse 4GL upshifts all components of table and column names by default. Unless this information is in uppercase in your database, you should use the . PowerHouse 4GL allows access to system tables, a ssuming you have database access privileges to them. However, SHOW statements do not show information on .
IBM Cognos Analysis for Microsoft Excel 10.2.0 has feature enhancements in several key areas: v IBM Cognos Analysis for Microsoft Excel is now integrated with IBM Cognos TM1 data sources. Use IBM Cognos Analysis for Microsoft Excel with IBM Cognos TM1 data sources to enter and write back values to TM1 cubes. For more information, see
With the release of IBM Cognos Business Intelligence V10.1, the IBM Cognos Platform delivered a new 64-bit, in-memory query processing . mode with dynamic query capabilities. IBM Cognos Business Intelligence Dynamic Query is an optional mode included with the Cognos Business Intelligence query service, which can be implemented
Componentes de Cognos Mobile instalados en un sistema . . 33 Componentes de Cognos Mobile instalados en distintos sistemas . . 34 IBM Cognos Analytics con otr os pr oductos de IBM Cognos . . 34 Pr oductos de IBM Cognos que inter operan con IBM Cognos Analytics . . 34 Capítulo 3.
found in the Cognos Connection User Guide, a link to which can be found on the Resources tab in the IIT Cognos portal. 2. About the Cognos Portal The IIT Cognos Portal (aka "Cognos Connection") allows users to access Cognos reports and launch the various Cognos tools for authoring reports and queries based on data stored
Araling Panlipunan – Ikalawang Baitang Alternative Delivery Mode Unang Markahan – Modyul 3: Komunidad Ko, Pahahalagahan Ko Unang Edisyon, 2020 Isinasaad sa Batas Republika 8293, Seksiyon 176 na: Hindi maaaring magkaroon ng karapatang-sipi sa anomang akda ang Pamahalaan ng Pilipinas. Gayonpaman, kailangan muna ang pahintulot ng ahensiya o tanggapan ng pamahalaan na naghanda ng akda kung ito .
