This document provides guidance on installing and configuring Oracle Database 10g and related components on Linux for IBM zSeries systems. It discusses best practices for system sizing and resource allocation. Chapters cover installing a single instance Oracle database, using the Automatic Storage Management feature, and deploying the Cluster Ready Services and Real Application Clusters technologies.
The document provides information about implementing Tivoli Data Warehouse 1.2, including its features, architecture, planning considerations, and setup instructions. It covers topics such as hardware and software requirements, physical and logical design choices, database sizing, security, and skills required. The document also provides step-by-step instructions for installing and deploying Tivoli Data Warehouse in both a single machine and distributed environment.
This document provides an introduction and guide to using Copy Services features in IBM System Storage DS Storage Manager, including FlashCopy, VolumeCopy, and Enhanced Remote Mirroring (ERM). It describes how each feature works, prerequisites, best practices, and includes step-by-step instructions for using the graphical user interface (GUI) wizard and command line interface (CLI) to configure and manage copies. The document is intended for storage administrators to help them effectively implement and utilize these data copying and replication capabilities.
Construction ofanoracle10glinuxserver 0.5sopan sonar
This document provides a step-by-step guide to constructing a Linux server and installing Oracle 10g on it. It outlines preparing the server with Linux, configuring basic network and server services like SSH, Samba, and installing Java. It then details installing Oracle 10g, including configuring the kernel, creating an 'oracle' user, and extending data storage. Finally, it discusses setting up an X-Windows client on a Windows PC to host a Linux desktop and connect to the server.
This document provides an introduction and overview of a dissertation project that aims to investigate how data encryption affects data recovery. Specifically, the project will conduct an experiment to recover identical files from both an encrypted and unencrypted hard drive. This will determine if encryption makes some file types unrecoverable. The objectives are to evaluate recovery and encryption software, test different types of data loss, perform the recovery experiment, document results, and determine the effect of encryption on recoverability.
VSAN is a new storage solution from VMware that is fully integrated with vSphere. It automatically aggregates server disks in a cluster to create shared storage that can be rapidly provisioned from VMware vCenter during VM creation.
This document provides tuning guidelines for optimizing Oracle 9i and 10g database performance on Red Hat Enterprise Linux systems. It covers topics such as kernel tuning, memory configuration, I/O optimization, and use of large pages. The guidelines are applicable to Red Hat Enterprise Linux versions 2.1 through 5 for both 32-bit and 64-bit systems.
This document provides an overview and introduction to IBM TotalStorage SAN File System version 2.2.2. It discusses the growth of storage area networks (SANs) and storage networking technology trends. It also covers SAN File System architecture, prerequisites, features like policy-based storage management and FlashCopy, and reliability. The document is intended to help readers understand and plan SAN File System implementations.
This document provides information about multi-booting Solaris and other operating systems like Windows NT and Linux. It discusses boot managers for each OS and how to partition a hard disk to install multiple operating systems. The document also provides step-by-step examples for configuring common multi-boot scenarios with different combinations of Solaris, Windows NT, Linux and Windows 98 on single and dual hard disk configurations.
Red Hat Enterprise Linux 4 System Administration Guide provides documentation on installation, configuration, and administration of Red Hat Enterprise Linux 4 systems. Key topics covered include kickstart installations, Logical Volume Manager (LVM), Software RAID, package management, network configuration, firewall configuration, NFS, Samba, DHCP, Apache, authentication, console access, users/groups, printers, and more. The guide is intended to help system administrators manage and maintain Red Hat Enterprise Linux servers.
Learn about DB2 10 for Linux on System z, Using z/VM v6.2, Single System Image, Clusters and Live Guest Relocation. For more information, visit http://ibm.co/PNo9C
This chapter discusses installing the Bayanihan Linux operating system. It describes downloading the installation ISO image, verifying the image integrity, booting from the installation media, and performing the graphical installation. Advanced installation options like expert mode and rescue mode are also mentioned. The chapter provides guidance on checking the installation media for errors before beginning the installation process.
This document provides step-by-step instructions for disaster recovery solutions for IBM TotalStorage SAN File System. It discusses four scenarios: 1) complete recovery to a different TCP/IP address, 2) complete recovery to the same TCP/IP address, 3) storage recovery using FlashCopy, and 4) replacing a failed MDS. It also covers recovering SAN File System clients and protecting files in the global namespace using backup tools like Tivoli Storage Manager.
This document provides a deployment guide for Tivoli Continuous Data Protection for Files. It discusses the product architecture including main components, capabilities, directories and files, and integration with IBM Tivoli Storage Manager. It covers planning considerations for deployment such as critical files, backup needs, backup locations, and file backup frequencies. The guide also describes installing, configuring, and using Tivoli Continuous Data Protection for Files as well as troubleshooting, use case scenarios, and how it can work with IBM Tivoli Storage Manager.
This document provides an overview of backup and recovery solutions for IBM TotalStorage Network Attached Storage (NAS) appliances. It discusses hardware and software considerations for data availability and describes recovery procedures for the NAS 200 and 300. The document also examines the use of snapshot and replication technologies like Persistent Storage Manager (PSM) and Double-Take. Finally, it reviews several popular backup software solutions and how to implement backups from IBM NAS using them.
The Xen hypervisor allows multiple virtual machines to run simultaneously on a single physical machine. The Domain0 acts as the virtual machine host and controls the other virtual machines (VM Guests). Virtual machines can run in either paravirtual or full virtualization mode, with paravirtualized guests generally having better performance. The hypervisor, Domain0, VM Guests, and management tools together form the virtualization environment.
This document provides an overview of tape backup solutions for Netfinity servers. It discusses various tape technologies like DLT, 8mm, and 4mm tapes. It also covers different system topologies for backups like direct tape connections, single server models, two-tier models, and multi-tier models. The document recommends strategies for backups, including scheduling, compression, and hierarchical storage. It provides details on specific IBM tape drives like 40/80GB DLT, 35/70GB DLT, and 20/40GB 8mm drives. The intended audience is IT professionals implementing backup solutions for Netfinity servers.
VM Explorer® is a simple but powerful software to back up, replicate and restore your VMware ESX, ESXi and Microsoft Hyper-V Virtual Machines (VM).
The following documentation explains the main tasks required for configuration and daily use of VM Explorer®. All services hereinafter are brought to you by HPE.
The HPE services and materials presented for VM Explorer® hereinafter are protected by copyright, trademark, trade dress, unfair competition, and other intellectual property rights. The trademarks, logos and marks of HPE and VM Explorer® displayed on the services and products are the property of HPE or third parties. You are not permitted to use the Marks without the prior consent of HPE or the third party that may own the Marks.
This document provides an overview of Java basics, including:
- Java programs are portable across operating systems due to features like the Java language specification, portable class library, and use of bytecode instead of machine code.
- Java is secure due to lack of pointer arithmetic, garbage collection, bounds checking, and restrictions on applets.
- Java is robust with features that avoid crashes like bounds checking and exceptions.
- Java programs come in the form of standalone applications or applets, with differences in file I/O restrictions and need to handle browser lifecycle methods.
- The Java compiler produces bytecode files that are dynamically loaded and linked at runtime.
This document provides a question bank on the topic of engineering physics for a bachelor's degree program. It includes 70 questions across three sections - short answer, descriptive, and problems. The short answer section contains multiple choice and short response questions testing concepts like band structure of materials, Hall effect, semiconductors, and superconductors. The descriptive section asks students to explain key theories and differentiate between material types. The problems section provides calculations testing conductivity, mobility, drift velocity, and other quantitative applications of the theoretical concepts.
The document provides information about mechanics of solids-I, including:
1) It describes different types of supports like simple supports, roller supports, pin-joint supports, and fixed supports. It also describes different types of loads like concentrated loads, uniformly distributed loads, and uniformly varying loads.
2) It discusses shear force as the unbalanced vertical force on one side of a beam section, and bending moment as the sum of moments about a section.
3) It explains the relationship between loading (w), shear force (F), and bending moment (M) for an element of a beam. The rate of change of shear force is equal to the loading intensity, and the rate of change of bending
This document contains examples of SQL queries being run on database tables to retrieve various data. The queries demonstrate selecting data from tables, filtering on conditions, using aggregation functions like COUNT and AVG, joining tables, and more. The tables being queried include EMP, DEPT, and other tables containing employee and department data.
1. A DC motor converts direct current electrical energy into mechanical energy through electromagnetic induction. It consists of field magnets, an armature, a commutator, and brushes.
2. The motor's working principle is that a current-carrying conductor in a magnetic field experiences a mechanical force based on Fleming's left-hand rule. Back EMF is induced in the armature as it rotates, opposing the applied voltage.
3. A DC motor's speed can be controlled through various methods like adjusting the field flux, armature resistance, or applied voltage. The speed-torque characteristics differ between series, shunt, and compound wound DC motor types.
This document discusses trusses and frames. It begins by defining plane trusses, which are two-dimensional structures like the sides of a bridge, and space trusses, which are three-dimensional structures like TV towers. It then motivates the structure of a plane truss using a simple example of three rods connected in a triangle. The document goes on to analyze the forces in this simple truss and introduces the method of joints and method of sections for analyzing more complex trusses. It concludes by introducing the method of virtual work, which provides an alternative way to determine forces without considering the equilibrium of individual parts of the structure.
Microcontroller based speedo meter cum odometerNexus
it is a small computer on a single integrated circuit containing a processor core, memory, and programmable input/output peripherals. program memory in the form of ferroelectric ram, nor flash or otp romis also often included on chip, as well as a typically small amount of ram. microcontrollers are designed for embedded applications, in contrast to the microprocessors used in personal computers or other general purpose applications.
microcontrollers are used in automatically controlled products and devices, such as automobile engine control systems, implantable medical devices, remote controls, office machines, appliances, power tools, toys and other embedded systems. by reducing the size and cost compared to a design that uses a separate microprocessor, memory, and input/output devices, microcontrollers make it economical to digitally control even more devices and processes. mixed signal microcontrollers are common, integrating analog components needed to control non-digital electronic systems.
This document provides a 3-sentence summary of a training guide for the Oracle Database 10g:
The guide is intended for students learning fundamentals of SQL and the Oracle Database, covering topics such as retrieving and restricting data, functions, aggregated data, joins, and subqueries. It includes objectives, examples, and practice questions for each lesson to help students master SQL and work with Oracle databases. Various SQL statements, clauses, operators, and functions are explained to demonstrate how to communicate with an Oracle database using the SQL language.
This document contains short questions and long questions related to biomedical instrumentation. Some of the topics covered include:
- Definitions of biomedical signals and examples of different types of signals
- In vivo and in vitro measurements
- Components and advantages of intelligent medical instrumentation systems
- Electrocardiography and electroencephalography signals
- Transducers including pressure, temperature, and flow transducers
- Recording systems and analysis techniques
- Patient monitoring systems and techniques for measuring vital signs
- Electrical safety and leakage currents in medical devices
This document provides an overview and introduction to developing PL/SQL program units such as procedures, functions, packages, and triggers in Oracle Database 10g. It discusses modularizing development with PL/SQL blocks and anonymous blocks. It also covers PL/SQL execution environments and development environments like iSQL*Plus and SQL*Plus. The document contains copyright information and disclaimers.
This document contains additional practice problems for the Oracle Database 10g: PL/SQL Fundamentals course. The additional practices provide supplemental exercises in PL/SQL concepts like declaring variables, writing code blocks, SQL statements, control structures, composite data types, cursors and exception handling. The problems use sample database tables like employees, jobs, job_history and departments to demonstrate working with tables.
mpmc (Microprocessor and microcontroller) notesNexus
The document discusses the history and development of artificial intelligence over the past 70 years. It outlines some of the key milestones in AI research including the creation of logic theories, machine learning algorithms, and neural networks. Recent advances in deep learning have helped AI systems match and even surpass human-level performance in certain tasks such as image recognition.
This document provides guidance on answering common interview questions. It begins with general tips, such as being upbeat, rehearsing answers, and tailoring responses to the needs of the employer. It then addresses 64 specific tough interview questions, providing sample answers and strategies. For the first question "Tell me about yourself", it advises determining the employer's needs before speaking and highlighting relevant qualifications and achievements. The document stresses matching one's abilities to the employer's requirements throughout the interview.
This document discusses concepts related to mechanics of solids including:
- It provides an overview of the different classifications of engineering mechanics including mechanics of solids, fluids, rigid bodies, and deformable bodies.
- It describes common idealizations used in mechanics problems such as treating bodies as continua, rigid bodies, and particles.
- It introduces basic concepts in mechanics including space, time, mass, and force which provide the framework for analyzing mechanics problems.
- It defines different systems of forces including collinear, coplanar parallel, coplanar like parallel, and coplanar concurrent forces and provides examples.
Here are the key points about the course agenda:
- The course is divided into lessons that will be covered over multiple days.
- On the first day, the lessons covered are the Introduction lesson (which provides an overview of the course) and two core PL/SQL lessons - an introduction to PL/SQL and declaring variables.
- These initial lessons lay the groundwork by introducing PL/SQL and how to declare and work with variables.
Lessons for subsequent days will build on this foundation by covering additional core PL/SQL concepts like writing executable statements, interacting with the database, writing control structures, and more advanced topics like exceptions and stored procedures/functions.
The pacing and grouping of lessons is designed to progressively introduce
A Tesla coil is an electrical resonant transformer circuit invented by Nikola Tesla around 1891. It is used to produce high-voltage, low-current, high frequency alternating-current electricity. Tesla experimented with a number of different configurations consisting of two, or sometimes three, coupled resonant electric circuits.
Tesla used these coils to conduct innovative experiments in electrical lighting, phosphorescence, X-ray generation, frequency alternating phenomena, electrotherapy, and the transmission of electrical energy without wires. Tesla coil circuits were used commercially in spark gap radio transmitters for wireless telegraphy until the 1920s, and in medical equipment such as electrotherapy and violet ray devices. Today their main use is for entertainment and educational displays, although small coils are still used today as leak detectors for high vacuum systems.
This document provides lecture notes on engineering physics for an engineering course. It covers topics on atomic structure, electronic configurations, electrical conduction, and electron theories of metals. The document begins with an introduction to atomic structure, including the components of atoms and Madelung's and Hund's rules for electron configuration. It then discusses electrical conduction, defining terms like resistivity, conductivity, and classifications of materials. The remainder of the document covers electron theories of metals, including classical free electron theory, quantum free electron theory, and band theory. Key concepts from each theory are summarized.
The document contains 16 sections that describe database management system experiments to be performed. Each section includes instructions to create and manipulate tables, perform queries, and implement concepts like triggers, functions, stored procedures, cursors, and embedded SQL. Students will connect to databases and design systems for payroll, banking, and a library using Visual Basic. Their work will be evaluated based on aim and description, queries, results, output, and records.
The document provides examples of SQL queries and solutions to interview questions related to SQL queries on Oracle databases. It includes queries to find products with continuously increasing sales, products with no sales, products whose sales decreased in 2012 vs 2011, the top product sold each year, and total sales of each product. Tables called PRODUCTS and SALES are created with sample data on products and sales to demonstrate the example queries.
SQL is a language for managing and manipulating databases. It includes languages for data definition (DDL), data manipulation (DML), data retrieval (DRL), transaction control (TCL), and data control (DCL). The document provides detailed syntax examples for creating tables, inserting data, selecting data using conditions, updating and deleting records, and managing transactions using commands like commit, rollback, and savepoints. It also covers altering tables and dropping or renaming database objects.
This document provides a draft summary of an IBM reference architecture for virtualized environments using IBM System Storage N series storage platforms. It includes chapters on architecture, Clustered Data ONTAP 8.2 features, VMware vSphere integration, and Microsoft Hyper-V integration. The document discusses storage configuration, provisioning, cloning, snapshots, and other topics to understand how to design scalable cloud solutions using N series storage and Clustered Data ONTAP.
This document provides an overview and guide for planning and using the IBM TS7500 Virtualization Engine. The TS7500 consolidates backup storage and improves efficiency through data deduplication and compression. It introduces virtual tape support through its software architecture. The guide covers TS7500 components, disk architecture using RAID, and backup architectures like disk-to-disk-to-tape. It aims to help users understand and make the best use of the TS7500's virtualization capabilities.
This document provides information about planning and deploying IBM TotalStorage Productivity Center for Data, including:
- An overview of the product, its features, architecture and supported levels
- Planning considerations for hardware, software, databases, user IDs and security
- Steps for installing the Agent Manager and other components on Windows and Linux
This document provides an overview of the IBM TotalStorage SAN File System. It discusses industry trends in storage networking, the rise of storage virtualization, and issues with SAN data sharing. It also describes IBM's TotalStorage product family including the SAN Volume Controller and SAN File System. The SAN File System architecture is explained covering hardware/software prerequisites, components like engines and filesets, and key features such as the global namespace, policy-based management, clients, and reliability.
This document provides an overview and instructions for integrating IBM DB2 databases with the IBM System Storage N series. It discusses requirements, configuration, creating new databases, and migrating existing databases to the N series storage system. The document is intended to help users optimize DB2 database performance, backup and recovery, high availability, reliability, and storage requirements when using IBM N series storage.
This document provides guidance on integrating IBM DB2 databases with the IBM System Storage N series. It discusses requirements for the integration including DB2, database server, N series storage, and network requirements. It then covers configuring the environment including configuring the N series for various operating systems. Chapters also cover creating a new database on N series storage, migrating an existing DB2 database to N series storage, and performance considerations.
This document provides instructions for integrating IBM Tivoli Workload Scheduler (ITWS) and IBM Content Manager OnDemand to provide centralized job log processing. It describes how to configure ITWS on both distributed and z/OS systems to collect log and report data and store it in OnDemand repositories for easy access and reporting. Implementation steps are provided for collecting log data from distributed ITWS jobs, z/OS JES spool, and end-to-end configurations covering both distributed and z/OS systems. The integration provides a single point of access for logs and reports from all ITWS environments.
This document provides instructions for integrating IBM Tivoli Workload Scheduler (ITWS) and IBM Content Manager OnDemand to provide centralized job log processing. It describes how to configure ITWS on both distributed and z/OS systems to collect log and report data and store it in Content Manager OnDemand for easy access and reporting. Implementation steps are provided for collecting log data from the JES spool, datasets, and ITWS logs on z/OS. Methods for collecting log data from distributed ITWS instances like the push and pull methods are also outlined. The integration provides a single point to access log data for troubleshooting and analysis purposes.
This document provides an overview of Docker containerization and includes tutorials on Docker concepts and commands. Chapter 1 discusses why Docker is useful, the difference between machines, images and containers, and includes tutorials on installing Docker, basic commands like creating machines, images and containers, and using Docker for integration testing with Maven. Subsequent chapters provide tutorials on installing Docker on Ubuntu, Docker kernel requirements, Docker "hello world" examples using basic images and building Java apps, Docker as a service, and the Docker build process.
This document provides an overview and guide for installing and administering IBM AIX Enterprise Edition. It describes the key components of AIX Enterprise Edition including DB2, IBM Tivoli Monitoring, Tivoli Asset and Discovery for Distributed Management, and IBM Tivoli Usage and Accounting Manager. It also provides guidance on planning, sizing, installing, configuring, and operating each component. The document is intended as a reference for system administrators working with AIX Enterprise Edition.
This document provides an overview and comparison of IBM tape library solutions for backing up IBM xSeries servers. It discusses factors to consider when selecting a tape library such as capacity, number of drives, and scalability. It also provides configuration details for backing up to tape libraries using Tivoli Storage Manager, VERITAS Backup Exec, and CA ARCserve. Recovery procedures using the backup software and Tivoli Disaster Recovery Manager are also covered.
This document provides guidance on backing up WebSphere Application Server (WAS) using Tivoli Storage Manager (TSM). It describes the WAS and TSM architectures, important WAS components to backup, and strategies for backing up WAS. The document then focuses on installing and using Tivoli Data Protection for WebSphere (TDP for WAS) to backup WAS V3.5 and V4.0 to TSM. It provides details on configuring TDP for WAS, performing backups and restores, and troubleshooting backup issues. The document aims to help administrators successfully protect WAS environments through regular backups to TSM.
RDB Synchronization, Transcoding and LDAP Directory Services ...Videoguy
This document provides an overview and instructions for synchronizing data between mobile databases and back-end databases using IBM WebSphere Everyplace Access Version 4.1.1. It also covers using transcoding technologies to adapt portlet content for different devices. The key topics covered include:
- Configuring database synchronization between DB2 Everyplace and backend DB2 or Oracle databases
- Using transcoding technologies like XML stylesheets and annotations to customize content for devices
- A sample application demonstrating how to clip content from documents using internal and external annotation
BOOK - IBM Z vse using db2 on linux for system zSatya Harish
The document is a technical guide about using DB2 on Linux for System z. It provides information on planning, setting up, and customizing a DB2 environment where some data is hosted on z/VSE and accessed using DB2 on Linux for System z. The guide covers topics like hardware planning, database considerations, installing and configuring DB2 and related software, and setting up networking and connectivity between the z/VSE and Linux systems.
This document provides instructions for installing and configuring a two-node Oracle RAC cluster using virtual machines on a single laptop or desktop computer. It details the necessary hardware requirements, including a minimum of 8GB RAM and 40GB free disk space. The software components needed are Windows 7 64-bit as the host operating system, along with VirtualBox for virtualization, Putty and VNC Viewer for remote access, and Oracle Grid Infrastructure and database software. The document provides a step-by-step guide to setting up the virtualized environment, installing Linux on the virtual machines, configuring the Grid Infrastructure and database software, and testing the overall cluster configuration.
This document provides a practical guide to installing and configuring Tivoli SANergy. It begins with an introduction to SANergy and its benefits for sharing data on a SAN. It then provides step-by-step instructions for setting up SANergy with both Windows and UNIX management domains controllers (MDCs). Additional chapters cover advanced topics like performance tuning, high availability configurations, and integrating SANergy with other Tivoli applications like Tivoli Storage Manager. The document is intended to help readers successfully implement and use SANergy in their own environments.
This document provides an overview and instructions for installing and configuring IBM Tivoli Web Access for Information Management. It discusses planning the installation, performing the SMP/E installation, customizing the Information Management installation, enabling access for users, and verifying the installation. The document is intended to help users install and set up Web Access to move an existing help desk application to the web. It contains information on installing and configuring necessary software and components, as well as customizing settings. Various sections provide details on tasks involved in the implementation and setup process.
This document provides guidance on setting up IBM tape drives and libraries in multiple UNIX environments. It discusses IBM LTO Ultrium tape drive models, hardware platforms, connectivity options, partitioning of multi-path tape libraries, and SAN considerations for attaching tape libraries. The document is intended to help integrators and administrators implement IBM tape solutions for backup and archiving in UNIX environments.
This document provides an overview of building a highly available clustered environment for IBM Tivoli Storage Manager. It discusses cluster concepts and high availability. It then describes testing a clustered Tivoli Storage Manager environment, including testing the cluster infrastructure and applications. The document focuses on configuring Microsoft Windows clusters with Tivoli Storage Manager for both Windows 2000 and Windows 2003 environments. It covers installing and configuring the Tivoli Storage Manager server and client within a Microsoft Cluster Server. It also includes testing the setup and configurations.
Similar to Experiences with oracle 10g database for linux on z series sg246482 (20)
This document provides the table of contents and introduction for the PostgreSQL 15.1 documentation. It describes that PostgreSQL is an open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The documentation is copyrighted by the PostgreSQL Global Development Group and provides instructions for how to report bugs and get further information.
This document provides the table of contents and introduction for the PostgreSQL 14.6 documentation. It describes that PostgreSQL is an open-source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The documentation is copyrighted by the PostgreSQL Global Development Group and provides instructions for how to report bugs and get further information.
This document provides instructions for a lab exercise on getting started with IBM MobileFirst Platform. It introduces the key concepts of MobileFirst Platform Studio and walks through steps to import a sample banking application project, examine the project structure, add an Android environment, and preview the application in the Mobile Browser Simulator and an Android device. It also demonstrates how to invoke adapters and use the MobileFirst Platform Console and Operational Analytics. The lab aims to familiarize users with the MobileFirst Platform development tools and features.
The IBM MobileFirst Platform provides mobile application development tools and services. It allows developers to integrate backend data, continuously improve apps based on user feedback, and deliver personalized experiences. The platform provides modular services for contextualizing apps, securing data, and gaining insights from usage data. It supports both hybrid and native mobile application development.
IBM MobileFirst Foundation provides tools for developing hybrid, native, and mobile web applications using standards-based technologies. This proof of technology session will demonstrate how to use IBM MobileFirst Foundation to accelerate mobile app development, provide management of deployed apps, and utilize capabilities like in-app notifications, operational analytics, and sentiment analysis. The agenda includes presentations and hands-on labs covering app development, backend integration, app lifecycle management, quality assurance, and the MobileFirst architecture. The session is intended for IT professionals interested in a mobile application platform and will be offered free of charge with breakfast provided.
The document describes adding a mobile coupons ("My Offers") feature to the IBMBank mobile application. It involves using the MobileFirst Platform Service Discovery wizard to generate an adapter for a SOAP web service, adding HTML/JS to display offer data from the service, and implementing local storage of selected offers using the JSON Store database. Key steps include discovering and testing the SOAP service, importing JS files, initializing JSON Store, modifying the app code to retrieve and save offers, and previewing the updated app.
This document provides instructions for a lab exercise on getting started with IBM MobileFirst Platform. It introduces the key concepts of MobileFirst Platform Studio and walks through steps to import a sample banking application project, examine the project structure, add an Android environment, and preview the application in the Mobile Browser Simulator and an Android device. It also demonstrates how to invoke backend services using adapters and view analytics data from the MobileFirst Operations Console. The document contains detailed steps, screenshots and explanations to help users learn fundamental MobileFirst Platform development tasks.
This document describes a lab exercise to demonstrate application management functions in IBM MobileFirst using the MobileFirst Operations Console. The lab will:
1. Deploy an initial version of an IBMBank mobile application to a MobileFirst Server.
2. Publish an updated version of the application to fix a bug, and test the "Direct Update" feature which pushes changes to client devices.
3. Configure application status notifications via the MobileFirst Operations Console and see them displayed on an Android emulator.
This document provides an overview of IBM MobileFirst Platform's operational analytics features. It describes how the analytics platform collects and analyzes data from mobile applications, servers, and devices to provide visibility into performance and usage. The analytics console contains various views and capabilities for searching logs, viewing charts and reports, and diagnosing issues. It summarizes the different data sources, events captured, and the client and server APIs used to log additional analytics data. The document then outlines the steps to access the analytics console and walk through its key pages and functionality.
This document provides instructions for using the MobileFirst Quality Assurance tool on Bluemix to perform sentiment analysis. It first gives a brief overview of MobileFirst Quality Assurance and its capabilities. It then outlines the steps to set up a Mobile Quality Assurance service instance on Bluemix and link it to an iOS app. Finally, it describes how to view the sentiment analysis results in production, including overall sentiment scores, attribute dashboards, comparison to other apps, and attribute trend statistics.
The document describes an exercise using IBM Mobile Quality Assurance (MQA) to test a mobile banking application and report bugs. Students will launch an Android emulator containing the instrumented app. They can test the app functionality and use MQA's in-app notification to report bugs found, such as a misspelled button label. MQA will capture screenshots which students can annotate to describe the issue. All bug reports are uploaded to MQA and viewed by instructors in Bluemix to share with the class. The goal is to introduce MQA's capabilities for mobile app testing and feedback.
This document provides an overview and instructions for installing and configuring the Tivoli Management Environment (TME) platform. It discusses planning the installation, installing TME software on UNIX and PC nodes, configuring the TME management regions and resources, creating administrators and policy regions, and diagnosing common installation issues. It also provides guidance on setting up backups and describes capabilities of the Tivoli/Courier deployment application for managing file packages.
This document provides an overview of firewalls and demilitarized zones (DMZs), and summarizes Tivoli Framework solutions for communicating across firewalls in a secure manner. It describes how Tivoli Framework 3.7.1 introduced single port bulk data transfer and endpoint upcall port consolidation to reduce open ports. The Firewall Solutions Toolbox further improves security with endpoint and gateway proxies, relays to cross multiple DMZs adhering to no direct routing, and supporting unidirectional communications. It also describes the event sink for collecting events from non-Tivoli sources.
This document provides an overview of planning and implementing Tivoli Data Warehouse Version 1.3. It discusses the key components of Tivoli Data Warehouse including the control center server, source databases, central data warehouse, data marts, warehouse agents, and Crystal Enterprise server. It also covers planning considerations such as hardware and software requirements, physical and logical design choices, database sizing, security, network traffic, and skills required. The document is intended as a guide for implementing and managing a Tivoli Data Warehouse.
This document provides an overview and guide for using Business Objects reporting tools with Tivoli Data Warehouse 1.2. It covers Business Objects products and platform, installing Business Objects desktop components, configuring Business Objects for Tivoli Data Warehouse, creating reports, advanced reporting and security features, and deploying reports. The document contains examples and step-by-step instructions for setting up Business Objects and generating simple to advanced reports on Tivoli Data Warehouse data.
The document is a manual for Tivoli Business Systems Manager Version 2.1. It provides an overview of the product, which allows for end-to-end business impact management through integrated systems management. The manual details the product structure, components, functions, database structure, user interface, and planning requirements for implementation. It is intended to help users understand and implement the key capabilities of Tivoli Business Systems Manager.
This document provides an overview of implementing the Tivoli Enterprise Console (TEC). It discusses planning requirements such as the management software, managed devices, event sources, and rule policies. It then covers installing the required relational database management system (RDBMS), either Oracle or Sybase. Finally, it describes setting up the Tivoli Management Framework, installing the TEC software, configuring distributed monitoring and scripts, and deploying event adapters.
This document provides a release guide for IBM Tivoli Storage Productivity Center Version 4.2. It includes information on the new features and functions of Tivoli Storage Productivity Center V4.2, an overview of the product architecture and family, and instructions for installing Tivoli Storage Productivity Center on Windows and Linux systems. The document covers preinstallation steps, installing prerequisite software like DB2, and installing the Tivoli Storage Productivity Center servers, graphical user interface (GUI), and command line interface (CLI).
This document discusses data synchronization features in IBM Tivoli Directory Integrator 6.1, including delta detection, delta tagging, and delta application. Delta detection discovers changes in a data source and retrieves only the modified data. Delta tagging stores change information in the retrieved data using operation codes. Delta application then uses these tags to efficiently propagate only necessary changes to target systems.
This document discusses strategies for migrating and consolidating storage using IBM TotalStorage products. It describes migrating a storage volume from one SAN to another using IBM SAN Volume Controller without interrupting access. It also outlines two methods for migrating data between tape technologies using IBM Tivoli Storage Manager: migrating individual nodes or migrating entire storage pools to a new tape technology.
In this follow-up session on knowledge and prompt engineering, we will explore structured prompting, chain of thought prompting, iterative prompting, prompt optimization, emotional language prompts, and the inclusion of user signals and industry-specific data to enhance LLM performance.
Join EIS Founder & CEO Seth Earley and special guest Nick Usborne, Copywriter, Trainer, and Speaker, as they delve into these methodologies to improve AI-driven knowledge processes for employees and customers alike.
Performance Budgets for the Real World by Tammy EvertsScyllaDB
Performance budgets have been around for more than ten years. Over those years, we’ve learned a lot about what works, what doesn’t, and what we need to improve. In this session, Tammy revisits old assumptions about performance budgets and offers some new best practices. Topics include:
• Understanding performance budgets vs. performance goals
• Aligning budgets with user experience
• Pros and cons of Core Web Vitals
• How to stay on top of your budgets to fight regressions
MYIR Product Brochure - A Global Provider of Embedded SOMs & SolutionsLinda Zhang
This brochure gives introduction of MYIR Electronics company and MYIR's products and services.
MYIR Electronics Limited (MYIR for short), established in 2011, is a global provider of embedded System-On-Modules (SOMs) and
comprehensive solutions based on various architectures such as ARM, FPGA, RISC-V, and AI. We cater to customers' needs for large-scale production, offering customized design, industry-specific application solutions, and one-stop OEM services.
MYIR, recognized as a national high-tech enterprise, is also listed among the "Specialized
and Special new" Enterprises in Shenzhen, China. Our core belief is that "Our success stems from our customers' success" and embraces the philosophy
of "Make Your Idea Real, then My Idea Realizing!"
Video traffic on the Internet is constantly growing; networked multimedia applications consume a predominant share of the available Internet bandwidth. A major technical breakthrough and enabler in multimedia systems research and of industrial networked multimedia services certainly was the HTTP Adaptive Streaming (HAS) technique. This resulted in the standardization of MPEG Dynamic Adaptive Streaming over HTTP (MPEG-DASH) which, together with HTTP Live Streaming (HLS), is widely used for multimedia delivery in today’s networks. Existing challenges in multimedia systems research deal with the trade-off between (i) the ever-increasing content complexity, (ii) various requirements with respect to time (most importantly, latency), and (iii) quality of experience (QoE). Optimizing towards one aspect usually negatively impacts at least one of the other two aspects if not both. This situation sets the stage for our research work in the ATHENA Christian Doppler (CD) Laboratory (Adaptive Streaming over HTTP and Emerging Networked Multimedia Services; https://athena.itec.aau.at/), jointly funded by public sources and industry. In this talk, we will present selected novel approaches and research results of the first year of the ATHENA CD Lab’s operation. We will highlight HAS-related research on (i) multimedia content provisioning (machine learning for video encoding); (ii) multimedia content delivery (support of edge processing and virtualized network functions for video networking); (iii) multimedia content consumption and end-to-end aspects (player-triggered segment retransmissions to improve video playout quality); and (iv) novel QoE investigations (adaptive point cloud streaming). We will also put the work into the context of international multimedia systems research.
Navigating Post-Quantum Blockchain: Resilient Cryptography in Quantum Threatsanupriti
In the rapidly evolving landscape of blockchain technology, the advent of quantum computing poses unprecedented challenges to traditional cryptographic methods. As quantum computing capabilities advance, the vulnerabilities of current cryptographic standards become increasingly apparent.
This presentation, "Navigating Post-Quantum Blockchain: Resilient Cryptography in Quantum Threats," explores the intersection of blockchain technology and quantum computing. It delves into the urgent need for resilient cryptographic solutions that can withstand the computational power of quantum adversaries.
Key topics covered include:
An overview of quantum computing and its implications for blockchain security.
Current cryptographic standards and their vulnerabilities in the face of quantum threats.
Emerging post-quantum cryptographic algorithms and their applicability to blockchain systems.
Case studies and real-world implications of quantum-resistant blockchain implementations.
Strategies for integrating post-quantum cryptography into existing blockchain frameworks.
Join us as we navigate the complexities of securing blockchain networks in a quantum-enabled future. Gain insights into the latest advancements and best practices for safeguarding data integrity and privacy in the era of quantum threats.
INDIAN AIR FORCE FIGHTER PLANES LIST.pdfjackson110191
These fighter aircraft have uses outside of traditional combat situations. They are essential in defending India's territorial integrity, averting dangers, and delivering aid to those in need during natural calamities. Additionally, the IAF improves its interoperability and fortifies international military alliances by working together and conducting joint exercises with other air forces.
What Not to Document and Why_ (North Bay Python 2024)Margaret Fero
We’re hopefully all on board with writing documentation for our projects. However, especially with the rise of supply-chain attacks, there are some aspects of our projects that we really shouldn’t document, and should instead remediate as vulnerabilities. If we do document these aspects of a project, it may help someone compromise the project itself or our users. In this talk, you will learn why some aspects of documentation may help attackers more than users, how to recognize those aspects in your own projects, and what to do when you encounter such an issue.
These are slides as presented at North Bay Python 2024, with one minor modification to add the URL of a tweet screenshotted in the presentation.
Are you interested in dipping your toes in the cloud native observability waters, but as an engineer you are not sure where to get started with tracing problems through your microservices and application landscapes on Kubernetes? Then this is the session for you, where we take you on your first steps in an active open-source project that offers a buffet of languages, challenges, and opportunities for getting started with telemetry data.
The project is called openTelemetry, but before diving into the specifics, we’ll start with de-mystifying key concepts and terms such as observability, telemetry, instrumentation, cardinality, percentile to lay a foundation. After understanding the nuts and bolts of observability and distributed traces, we’ll explore the openTelemetry community; its Special Interest Groups (SIGs), repositories, and how to become not only an end-user, but possibly a contributor.We will wrap up with an overview of the components in this project, such as the Collector, the OpenTelemetry protocol (OTLP), its APIs, and its SDKs.
Attendees will leave with an understanding of key observability concepts, become grounded in distributed tracing terminology, be aware of the components of openTelemetry, and know how to take their first steps to an open-source contribution!
Key Takeaways: Open source, vendor neutral instrumentation is an exciting new reality as the industry standardizes on openTelemetry for observability. OpenTelemetry is on a mission to enable effective observability by making high-quality, portable telemetry ubiquitous. The world of observability and monitoring today has a steep learning curve and in order to achieve ubiquity, the project would benefit from growing our contributor community.
The Rise of Supernetwork Data Intensive ComputingLarry Smarr
Invited Remote Lecture to SC21
The International Conference for High Performance Computing, Networking, Storage, and Analysis
St. Louis, Missouri
November 18, 2021
Scaling Connections in PostgreSQL Postgres Bangalore(PGBLR) Meetup-2 - MydbopsMydbops
This presentation, delivered at the Postgres Bangalore (PGBLR) Meetup-2 on June 29th, 2024, dives deep into connection pooling for PostgreSQL databases. Aakash M, a PostgreSQL Tech Lead at Mydbops, explores the challenges of managing numerous connections and explains how connection pooling optimizes performance and resource utilization.
Key Takeaways:
* Understand why connection pooling is essential for high-traffic applications
* Explore various connection poolers available for PostgreSQL, including pgbouncer
* Learn the configuration options and functionalities of pgbouncer
* Discover best practices for monitoring and troubleshooting connection pooling setups
* Gain insights into real-world use cases and considerations for production environments
This presentation is ideal for:
* Database administrators (DBAs)
* Developers working with PostgreSQL
* DevOps engineers
* Anyone interested in optimizing PostgreSQL performance
Contact info@mydbops.com for PostgreSQL Managed, Consulting and Remote DBA Services
Blockchain and Cyber Defense Strategies in new genre timesanupriti
Explore robust defense strategies at the intersection of blockchain technology and cybersecurity. This presentation delves into proactive measures and innovative approaches to safeguarding blockchain networks against evolving cyber threats. Discover how secure blockchain implementations can enhance resilience, protect data integrity, and ensure trust in digital transactions. Gain insights into cutting-edge security protocols and best practices essential for mitigating risks in the blockchain ecosystem.
Fluttercon 2024: Showing that you care about security - OpenSSF Scorecards fo...Chris Swan
Have you noticed the OpenSSF Scorecard badges on the official Dart and Flutter repos? It's Google's way of showing that they care about security. Practices such as pinning dependencies, branch protection, required reviews, continuous integration tests etc. are measured to provide a score and accompanying badge.
You can do the same for your projects, and this presentation will show you how, with an emphasis on the unique challenges that come up when working with Dart and Flutter.
The session will provide a walkthrough of the steps involved in securing a first repository, and then what it takes to repeat that process across an organization with multiple repos. It will also look at the ongoing maintenance involved once scorecards have been implemented, and how aspects of that maintenance can be better automated to minimize toil.
An invited talk given by Mark Billinghurst on Research Directions for Cross Reality Interfaces. This was given on July 2nd 2024 as part of the 2024 Summer School on Cross Reality in Hagenberg, Austria (July 1st - 7th)
Experiences with oracle 10g database for linux on z series sg246482
1. Front cover
Experiences with
Oracle 10g Database
for Linux on zSeries
Installing a single instance of Oracle
Database 10g
Installing Oracle 10g RAC
Using ASM
Kathryn Arrell
Laurent Dupin
Dennis Dutcavich
Terry Elliott
Bruce Frank
Chris Little
Barton Robinson
Tom Russell
ibm.com/redbooks
3. International Technical Support Organization
Experiences with Oracle 10g Database for Linux on
zSeries
August 2005
SG24-6482-00
16. COPYRIGHT LICENSE:
This information contains sample application programs in source language, which illustrates programming
techniques on various operating platforms. You may copy, modify, and distribute these sample programs in
any form without payment to IBM, for the purposes of developing, using, marketing or distributing application
programs conforming to the application programming interface for the operating platform for which the
sample programs are written. These examples have not been thoroughly tested under all conditions. IBM,
therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. You may copy,
modify, and distribute these sample programs in any form without payment to IBM for the purposes of
developing, using, marketing, or distributing application programs conforming to IBM's application
programming interfaces.
Trademarks
The following terms are trademarks of the International Business Machines Corporation in the United States,
other countries, or both:
AIX® Multiprise® S/390®
ECKD™ MVS™ Tivoli®
ESCON® OS/390® VM/ESA®
Footprint® PR/SM™ z/OS®
FICON® Redbooks™ z/VM®
IBM® Redbooks (logo) ™ zSeries®
ibm.com® RACF®
The following terms are trademarks of other companies:
PDB, Solaris, and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States,
other countries, or both.
Windows, and the Windows logo are trademarks of Microsoft Corporation in the United States, other
countries, or both.
Intel, Intel logo, Intel Inside logo, and Intel Centrino logo are trademarks or registered trademarks of Intel
Corporation or its subsidiaries in the United States, other countries, or both.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Linux is a trademark of Linus Torvalds in the United States, other countries, or both.
Other company, product, and service names may be trademarks or service marks of others.
xiv Experiences with Oracle 10g Database for Linux on zSeries
18. Dennis Dutcavich is a zSeries Oracle Specialist with the American sales
division. Dennis is part of Sales and Distribution in the Americas. He is Technical
Sales Specialist supporting Linux on zSeries opportunities.
Terry Elliott is a zSeries Specialist working in the IBM/Oracle International
Competency Center at IBM San Mateo. He has over 30 years of experience in
information technology. Before joining the IBM Oracle International Competency
Center six months ago, Terry was as an ERP zSeries Performance Specialist.
Bruce Frank is a zSeries Oracle Specialist in the IBM/Oracle International
Competency Center at IBM San Mateo.
Chris Little works at the Department of Human Services as a Unix/Linux/z/VM
Administrator. It was his pressure that got DHS into the Early Adopters Program
for Oracle, and he helped implement one of the first production Oracle databases
on Linux/390.
Barton Robinson is president of Velocity Software, Inc. He started working with
VM in 1975, specializing in performance starting in 1983. His previous
publication experience includes the VM/HPO Tuning Guide published by IBM,
and the VM/ESA® Tuning Guide published by Velocity Software. He is the author
and developer of ESAMAP and ESATCP.
Tom Russell is a zSeries Specialist with IBM Canada. He spent several years
on a special assignment with Oracle in Redwood Shores, California.
Thanks to the following people for their contributions to this project:
Neil Rasmussen
IBM Tivoli Development San Jose
Masayuki Kamitohno
zSeries ATS, IBM Japan
Roy Costa
Mike Ebbers
Julie Czubik
International Technical Support Organization, Poughkeepsie Center
Mark Polivka
Betsie Spann
Mike Morgan
Oracle Corporation
There were many others from the IBM labs in Boeblingen, Germany;
Poughkeepsie, New York; and Endicott, New York; as well as well as the those
from Oracle Corporation, Redwood Shores, California, who contributed to the
xvi Experiences with Oracle 10g Database for Linux on zSeries
19. technical information provided in this book and the technical reviews of the
material. We appreciate all the support we received.
Become a published author
Join us for a two- to six-week residency program! Help write an IBM Redbook
dealing with specific products or solutions, while getting hands-on experience
with leading-edge technologies. You'll team with IBM technical professionals,
Business Partners and/or customers.
Your efforts will help increase product acceptance and customer satisfaction. As
a bonus, you'll develop a network of contacts in IBM development labs, and
increase your productivity and marketability.
Find out more about the residency program, browse the residency index, and
apply online at:
ibm.com/redbooks/residencies.html
Comments welcome
Your comments are important to us!
We want our Redbooks™ to be as helpful as possible. Send us your comments
about this or other Redbooks in one of the following ways:
Use the online Contact us review redbook form found at:
ibm.com/redbooks
Send your comments in an email to:
redbook@us.ibm.com
Mail your comments to:
IBM Corporation, International Technical Support Organization
Dept. HYJ Mail Station P099
2455 South Road
Poughkeepsie, NY 12601-5400
Preface xvii
20. xviii Experiences with Oracle 10g Database for Linux on zSeries
22. 1.1 What is Linux
Linux is a UNIX®-like operating system initially created by Linus Torvalds when
he was a graduate student in 1991. The objective for developing Linux was to
deliver a non-proprietary operating system and application development
environment, completely independent of underlying hardware architectures, that
would offer maximum freedom to move applications from one hardware platform
to another by simply recompiling code, without expensive, labor-intensive porting
efforts.
Linux is a fully networked 32-bit/64-bit architecture, that supports multiple users,
multitasking, and multiprocessors, with a user-friendly Xwindows Graphical User
Interface. Continued development and testing of Linux is governed by the Open
Source community, which uses the Internet as the primary vehicle for technical
exchange. Linux source code can be downloaded free of charge from the
Internet, and programmers are free to modify the code. However, the integrity of
the official kernel source code is managed and maintained by a strict submission
and review process controlled by the Linux Review Board, an international
standards body for Linux.
Linux, like other Open Source software, is distributed under the terms of the
GNU Public License (GPL), and is packaged and distributed by approved
distributors, such as Caldera, Red Hat, SuSE, and Turbo Linux. Distributor
packages include the Linux operating system code that has been precompiled
for specific hardware environments, along with other Open Source applications
and middleware, such as Apache Web Server, SAMBA (file/print serving),
Jabber (instant messaging), and IMAP/POP (mail servers). Distributors also offer
Linux services and support packages, as does IBM Global Services.
1.2 Linux on zSeries
In 1998 IBM announced a commitment to support Linux on all its hardware
platforms, including zSeries. The 31-bit version of the Linux operating is
available from Linux distributors for S/390® G5 and G6 processors, and on 64-bit
zSeries models. The Linux 64-bit support on the zSeries is available on Open
Source and became available from SuSE in April 2001.
The Linux operating system has been running in a zSeries test environment
since early 1999. As of December of 1999, the IBM Web site
(http://www.ibm.com/servers/eserver/zseries/solutions/s390da/linuxisv.html) is
continually updated to show all the Independent Software Vendors (ISVs)
applications or infrastructure available for the zSeries platform.
2 Experiences with Oracle 10g Database for Linux on zSeries
23. Linux on zSeries is an ASCII environment that takes advantage of IBM zSeries
hardware, especially for system availability and I/O performance. Of particular
interest is the ability to run many Linux images under z/VM. This provides an
excellent environment for server consolidation. It will more fully utilize system
resources and facilitate system management.
Linux is not a replacement for other IBM operating systems on zSeries or S/390,
and will coexist with z/OS, OS/390®, and VM/ESA. It supports such UNIX tools
as sed, awk and grep, compilers like C, C++, Fortran, Smalltalk, and Ada.
Network tools like Telnet, ftp, ping, and traceroute are supported as well.
1.3 Why Oracle9i and Oracle 10g for Linux on zSeries
The ability to combine the hardware characteristics of the IBM zSeries with the
openness of Linux provides significant benefits to users.
IBM's zSeries has, over the years, demonstrated its unique ability to run multiple
diverse work loads. This key strength also applies to Linux workloads. zSeries is
particularly well suited to the hosting of multiple lightly to moderately loaded
servers. (Examples of this type of server would be firewall servers, print and file
serving, Domain Name Servers, Internet news servers, or Web serving that is not
processor intensive.) Most IT installations use multiple outboard servers to
perform these functions. Consolidation of these functions onto a single zSeries
can provide the following benefits:
zSeries qualities of service: No other platform offers the qualities of service
available in zSeries and z/VM.
Reduced hardware costs: Processors, storage, memory, etc. are now shared
on a single zSeries.
Reduced software costs: Software licenses spread over several machines
and operating systems in most cases are reduced when consolidated onto
zSeries processors.
Reduced networking costs: Physical networking gear like routers and cabling
are no longer necessary on a single zSeries. Servers communicate through
inter-system facilities on zSeries (hardware or software).
More efficient inter-server communication: Inter-server communication is
faster than physical networking.
Reduced systems management/support costs: Supporting multiple servers
on a single platform requires less effort and fewer people.
Reduced deployment time for new servers: Since new servers are added
virtually instead of physically, the time required to create a new server is
minutes, not weeks.
Chapter 1. Overview of Oracle Database 10g for Linux on zSeries 3
24. Linux on zSeries offers many advantages to customers who rely upon z/OS
systems to run their businesses. While z/OS has key strengths in the areas of
data acquisition through high-volume transaction processing and data
management, its value is enhanced by the addition of Linux on zSeries in
different ways.
Linux on zSeries brings the zSeries user the ability to access host data efficiently
by using high speed, low latency, inter-partition communication. Benefit is
derived from the elimination of outboard servers, routers, and other networking
gear, reduced floor space, and reduced maintenance cost. Linux also has the
well-earned reputation for rapid deployment of applications—giving zSeries
users a key choice in how they choose to deploy an application.
Linux on zSeries takes advantage of the qualities of service in the zSeries
hardware—making it a robust industrial strength Linux, while zSeries native
services are available for applications that require the qualities of service
inherent in z/OS as well as those of the zSeries hardware.
There are several other advantages to running Linux on zSeries. They are
described in the following sections.
1.3.1 Expanded application portfolio
The non-proprietary environment of Linux opens the door for zSeries to perform
as an application development and deployment server. The Linux application
portfolio will greatly increase the number of applications available to zSeries
customers who want to continue to leverage the critical advantages of the
platform to run business applications on a highly available and reliable
architecture. Customers will now have the flexibility to develop new applications
directly for Linux on zSeries and run them on any Linux-supported platform; or to
develop and test Linux on other platforms, such as the desktop, and then run the
applications for Linux on zSeries, with a simple recompile. As applications from
ISVs become generally available, customers will be able to deploy them quickly
on zSeries without any special porting effort.
Note: The MP 3000 and 9672 machines are 31-bit only and support the s390
Linux distributions. Oracle 9i is a 31-bit application and is the only Oracle that
these machines can run. zSeries machines are 64-bit processors and can run
the 31-bit (s390) and the 64-bit (s390x) distributions of Linux. The s390x Linux
distribution can run Oracle 10g, which is a 64-bit application, or Oracle 9i, a
31-bit Oracle database.
4 Experiences with Oracle 10g Database for Linux on zSeries
25. 1.3.2 Cost savings
A new feature designed specifically for the Linux operating environment, the
Integrated Facility for Linux (IFL), is now available on G5, G6, and all zSeries
server models including the Multiprise® 3000. The IFL gives you the ability to
dedicate processors to the Linux operating system on a logically partitioned
machine, transparently to the z/OS operating system. Processors dedicated to
the Linux LPAR under IFL are priced at a lower rate than those for the z/OS
environment. The added capacity, because it is dedicated to Linux workloads,
does not increase the software licensing fees of the zSeries environment.
Software pricing is confined to the capacity of only those processors enabled to
the zSeries LPARs on the system. (This reflects pricing as of the publishing of
this book and may have changed since the publication date. Consult your IBM
server sales representative to obtain the most current pricing structure
information.)
1.3.3 Server consolidation and faster time to market
All of the great flexibility and openness of Linux combined with the outstanding
qualities of service of zSeries results in an industrial-strength Linux environment.
zSeries has several options for partitioning server resources into multiple logical
servers. The PR/SM™ hardware feature provides the ability to partition the
physical machine into many logical servers (15 on a 9672 and 30 on a zSeries),
or LPARs, with dedicated, or shared, CPU and memory. The z/VM operating
system allows you to partition an LPAR horizontally into multiple logical operating
system images. These unique partitioning features provide the capability to
quickly and easily consolidate a large number of Linux servers onto a single
zSeries server. This industry-leading zSeries technology for dynamically sharing
processing resources across multiple logical systems delivers value to the Linux
environment not provided by any other architecture on the market today.
Figure 1-1 on page 6 illustrates the typical Linux or UNIX application deployment
strategy used by most installations deploying applications on non-zSeries
servers today.
Chapter 1. Overview of Oracle Database 10g for Linux on zSeries 5
26. O r a c le 1 0 g O r a c le 9 i O r a c le 1 0 g
f o r L in u x f o r L in u x f o r L in u x
L IN U X L IN U X L IN U X
Figure 1-1 Linux application deployment on server farms
Without the robust operating environment provided by the z/OS operating system
and the industry-leading reliability of the zSeries hardware, most installations
choose to deploy each new application in its own isolated operating system
environment, on its own server, with a dedicated database or database partition.
This leads to large server farms, with applications that cannot be easily
integrated, and require complex systems management.
Contrast the configuration in Figure 1-1 to the flexibility available on the
zSeries-S/390 architecture illustrated in Figure 1-2.
O racle10g O racle10g
LIN U X O racle9 i LIN U X
z /O S L IN U X
zS eries
Figure 1-2 Linux application deployment on zSeries
6 Experiences with Oracle 10g Database for Linux on zSeries
27. The unique capabilities of zSeries for running multiple operating images
simultaneously and sharing processing resources dynamically, supports many
diverse workloads and multiple applications on a single server, with outstanding
interpretability and integration between applications. Database sharing with
integrity and ease of systems management are additional unique benefits that
zSeries brings to the Linux operating environment.
In fact, many customers are blending the data richness of the zSeries
environments with the Web capability of Linux applications to deliver highly
integrated, cost-effective e-business solutions today.
1.4 Oracle Database 10g for Linux on zSeries
Oracle has four main families of products:
Oracle Database Server (9i and 10g)
Oracle9i Application Server and Oracle Application Server 10g
Oracle 11i eBusiness Suite
Oracle Collaboration Suite
See the following Web site for the latest information:
http://www.metalink.oracle.com
1.4.1 Oracle9i Database Server and Oracle Database 10g
Oracle delivered their production level Oracle9i Enterprise Edition Database
Server on September 1, 2002. This release included the Oracle9i Release 2 (9.2)
Enterprise Edition Server. The i in 9i stands for Internet and the g in 10g stands
for grid.
This release includes most of the components of the Enterprise Edition including:
Real application clusters
OLAP
Spatial
Label security
Partitioning
Data mining
Advanced security
Pro*COBOL
The client package is also included, including Oracle Net Services, OCI, and the
Pro*C/C++ precompiler.
Chapter 1. Overview of Oracle Database 10g for Linux on zSeries 7
28. The following functions are not yet provided:
OracleText does not have the INSO filters.
The Oracle Management Server (OMS) function of OEM does not run in
Linux.
No generic connectivity (ODBC and OLE).
Authentication with Verisign, CyberTrust, and Entrust.
This provides a complete Oracle9i database or 10g Database for development,
testing, and production in Linux on zSeries.
1.4.2 Oracle9i Application Server and AS 10g
In many ways, Oracle9i Application Server is well suited to Linux on zSeries.
Linux, at its current state of development, is better suited for horizontally scaled
workloads, such as print serving, Web serving, and simple application serving, or
smaller scale database workloads. In building Oracle9i Application Server,
Oracle uses many advanced elements for supporting Internet computing
requirements like portals, security, commerce, etc. Some of these elements are
not yet available outside the Intel® and more established UNIX environments.
Oracle and IBM are working to ensure that these partner products can be
delivered.
The Oracle 10g Application Server
Also on metalink, support for AS10g for Linux on zSeries is shown as projected.
These are works in progress at the time of writing of this book.
1.4.3 Oracle application solutions for Linux on zSeries
In this section we discuss Oracle application solutions for Linux on zSeries.
The Oracle E-Business Suite
Oracle has delivered is full suite of products, Oracle Database 10g, Application
Server 10g, and the Oracle E-Business Suite on Linux, on Intel hardware. Oracle
EBS requires a 10.1.0.4 level of the database. On metalink, support for the split
tier mode where the database will run on Linux on zSeries is shown as projected.
The Oracle Collaboration Suite
The newest suite of products is the Oracle Collaboration Suite. The product is a
complete collaboration suite, including calendar, e-mail, files, voicemail, and
workflow. It enables the consolidation of messaging and collaboration
8 Experiences with Oracle 10g Database for Linux on zSeries
29. infrastructure to achieve cost efficiency. Oracle Collaboration Suite is supported
in a split tier mode where the database server can be run on Linux on zSeries.
1.5 What distributions of Linux Oracle supports
Oracle9i is a 31-bit product. Oracle9i for Linux on zSeries runs on SLES8 31 bit
and SLES8 64 bit. There are plans to certify Oracle9i on SLES9.
Oracle 10g is a 64-bit product. Oracle 10g runs on SLES8 and SLES9 64 bit.
There are plans to certify Oracle 10g on RedHat 4 U1.
The latest information on supported platforms is found at:
http://www.otn.oracle.com/support/metalink/content.html
1.6 Obtaining a copy of Oracle Database 10g for Linux
on zSeries
The Oracle Database 10g Server can be purchased through the Oracle Store
(https://store.oracle.com/), or CD images can be downloaded from the
Oracle Technical Network (http://otn.oracle.com/).
1.7 Sizing workloads for Oracle10g for Linux on zSeries
The selection of an application to start testing the Oracle10OK, Database Server,
or any application for that matter, is critical to the success of the test. It makes
sense to select an application that has the characteristics of most of the
applications that would be considered for server consolidation. It is very
important to get a sizing of the workload to be moved to Linux on zSeries. It is
also sensible to start with an application that is small or not complicated and use
that as a vehicle for skill building in this area.
It is important to understand that a sizing is an estimate of capacity needs. The
performance team in Poughkeepsie developed a sizing methodology for
equating a workload on a UNIX or Intel platform to its equivalent MIPS on
zSeries. While this process has been generally accurate for several years, it is
not a capacity plan. Capacity plans are based on the past performance of a
system. The changing capacity needs over time provide an accurate way to
predict future needs.
If this is a new application that has never run before, the sizing becomes a bit
more difficult. Predictions can generally be made from testing done during
Chapter 1. Overview of Oracle Database 10g for Linux on zSeries 9
30. development. If this is a vendor’s application, they may be able to provide sizing
assistance for their application in a Linux environment.
There are two significant reasons to start with a sizing. First, it is important to
understand the resources needed to run the application. This includes peak
utilization on this server as well as when others peak. The sum of all peaks
becomes important as more servers are moved to Linux on zSeries. In fact, this
step helps start the process of understanding what the Total Cost of Ownership
(TCO) results will be.
The second important reason for performing a sizing is to set expectations for
testing of the workload that is moved. This will provide a starting point that can be
used for tuning in either Oracle10g, Linux, or z/VM, if necessary.
There is a service called SIZE390 that is available to provide pre-sale processor
sizing estimates to IBM sales representatives and Business Partners for IBM
zSeries and S/390 systems running z/OS or OS/390 and Linux. It is now
available world wide.
SIZE390 provides a questionnaire that requests all the information needed to
size workloads. The questionnaire can be obtained by IBM sales representatives
or Business Partners through TechXpress.
You should be prepared to supply the following:
Machine model and characteristics such as:
– CPU MHz
– Number of CPUs
– Memory
Type of application
– DSS
– OLTP
– DNS
– etc.
Approximate number of users
Utilization profile
– VMSTATS should be provided for a peak period.
This sizing deliverable provides some information about sizing estimates for
Linux. Keep in mind that to get exact sizing estimates you will need to test in
each customer's environment, but this data is useful for measuring other possible
consolidation efforts in the customer location.
10 Experiences with Oracle 10g Database for Linux on zSeries
32. 2.1 Memory sizing and configuration
The sizing and allocation of memory is one of the most critical areas of the
implementing Oracle in Linux under z/VM. This was especially so with 31-bit
Oracle9i and 31-bit Linux distributions. Even though Oracle Database 10g 64-bit
runs in 64-bit Linux, memory sizing still affect performance.
When running under z/VM, there is a need for expanded storage. Even though
z/VM is essentially 64-bit and supports 64-bit virtual machines, expanded
storage must be configured when running Oracle. The need for a expanded
storage still exists even with z/VM. When running under the current versions of
z/VM, we found that you need expanded storage in the configuration. z/VM, even
in a 64-bit environment, requires EStore to use as a paging device. Performance
will not be acceptable unless you configure from 25 percent to 33 percent of the
storage in the z/VM system as EStore.
This hierachy is needed because CP and the control blocks in z/VM must reside
below 2 GB, or what is referred to as host memory, including a guest page being
referenced for CP processing (I/O, IUCV, etc.). With high amounts of I/O (disk
and network as well), this can create contention for storage below the 2 GB level.
In z/VM 4.2.0 and earlier z/VM releases, when we steal a page below the 2 GB
bar due to contention, we do not move it to central storage above the 2 GB; we
page it out. If there is no expanded storage, it gets paged out to DASD. This can
create a thrashing scenario. If you see paging to DASD, but lots of storage
available above 2 GB, then there is probably contention for storage below 2 GB.
As a starting point, at least 25 percent of the amount of memory assigned to the
LPAR that is running z/VM must be allocated to expanded storage. As the
system performance characteristics become known, this number can be
adjusted. Once configured, it is unlikely that the amount of expanded storage
configured would be decreased.
When sizing the Linux virtual machine for Oracle, the virtual machine should be
configured with the minimum amount of memory needed. Linux will set up cache
buffers with all memory allocated to it. It is better to let z/VM handle paging and
manage memory where possible. System performance can be adversely
affected by the amount of memory allocated. This could be caused by the 2 GB
line issued as outlined above.
The method to size a guest for Oracle is to add the Systems Global Area, the
Program Global Area (if needed), and about 128 MB for Linux.
The Systems Global Area is the memory requirement for Oracle. This is
shared memory within Oracle to functions such as caching table data, parsing
SQl, sorting, etc.
12 Experiences with Oracle 10g Database for Linux on zSeries
33. The Program Global Area is memory outside the Oracle instance. This
generally used by users who create connections to the database. Depending
on the application, this can be either a small amount of memory per user or
very large amounts (in excess of 10 MB per user) for applications like the
Oracle E-Business Suite.
This tends to be the complete opposite of assigning memory to Linux in an Intel
environment or even in UNIX. But it must be remembered that in this case, Linux
is running under and being managed by another operating system.
2.2 CPU allocation
CPU (or CP) allocation can be viewed in a few perspectives:
A MIPS requirement for the databases and applications to be run in Linux on
zSeries
Allocation of virtual CPs
Setting shares or running multiple LPARS with CPUs either as shared or
dedicated
2.2.1 Sizing
As part of the consolidation process, workloads should be sized not only to
insure the correct amount of MIPS are determined, but also to aid in determining
if this is a good candidate to move to Linux on zSeries. It can also help determine
if this database should possibly be run in a Linux guest in an LPAR and not under
z/VM with the development, test, etc. databases being run under z/VM. This is a
very important part of the consolidation process, if not the most important part.
Doing the right work here will save problems later after the workload is moved to
Linux on zSeries.
There are several rules of thumb to do a sizing. While they may provide a quick
number, none take into account the characteristics of the workload. These
workload characteristics are extremely important in assessing MIPS
requirements.
IBM can provide sizing estimates, and there is no charge for this. To do an
estimate, IBM will need to following information:
Make and model of the system the database currently runs on
The number of CPs and the MHz rating of the CPs
The peak utilization of each system
Chapter 2. Best practices for installing an Oracle Database 10g on Linux on zSeries 13
34. It is best if these are actual numbers from a system tool such as vmstat.
Approximations can be provided, but the amount of utilization they are in error is
directly proportional to the error in the MIPS estimate.
There are two methods of sizing: The Quick Sizer tool and Size390 team. The
Quick Sizer tool takes your estimated data as input and provides a MIPS
estimate. The Size390 team uses vmstat reports from peak periods to perform a
sizing estimate. The Size390 team can also take vmstat reports taken through
peak periods and perform a sizing estimate from that. If a Quick Sizer is done
and the numbers warrant proceeding, then working with the Size390 team is the
best approach.
2.2.2 CP allocation
The amount of virtual CPs allocated (using the CP define cpu command) to a
Linux machine is important. In general, one virtual CP is a good starting point
unless the sizing points to something much larger.
In a constrained CPU environment (that is, more CPU cycles are needed to
complete the work), you should give the Linux virtual machine all the CPs it
needs to do its work efficiently. However, there should not be more CPs
allocated than the number of physical CPUs that are assigned to this LPAR when
running under z/VM. If this were to happen (more virtual CPs than physical
CPUs), the transaction rates would decrease and the cost to execute these
transactions would increase. This is due to increased scheduling overhead in
z/VM’s control program.
CPU time is limited to the number of CPUs installed. Therefore it would be
prudent to reduce CPU usage where possible. This would be in areas such as:
Eliminate any unnecessary services that might install with the Linux guest.
Eliminate any unnecessary cron tasks.
Reduce unnecessary work.
– Ensure timer patch is turned on and timer pops are disabled. This is the
default with SLES8.
– Eliminate using “r-u-there” pings to determine if the virtual machines are
there and up.
– Do not measure idle guests. Measuring takes cycles.
Network consideration
– Use Guest Lan
– Use Vswitch
14 Experiences with Oracle 10g Database for Linux on zSeries
35. 2.2.3 Setting shares
The workload of Linux virtual machines can be managed or controlled by setting
of the SHARE value of a virtual machine. The first choice of SHARE is to use
ABSOLUTE or RELATIVE. The second choice is the size of the SHARE. The
simplest way to decide which to use for a specific server is to determine whether
as more users log on to this system, should this service machine get more CPU
or less CPU?
A relative share says this server should get a relative share of the processor,
relative to all virtual machines in the dispatch and eligible lists. As more users log
on, the share will drop.
An absolute shares remain fixed up to the point where the sum of the absolute
shares is 100 percent or more, a rather confused state of configuration. Servers
might have a requirement that increases as the level of work increases. These
servers should have ABSOLUTE shares. All other users should use RELATIVE.
Size of share is both a business decision and a performance decision. For
example, if one server is assigned a very high share, which might be as much of
the system as the rest combined, one would expect this server to be absolutely
critical to your business. This server has the capability of taking resources
whenever it needs them, but if this server starts looping, it would easily consume
all the resources allocated. But in general, this is not a likely situation for
production.
A simple way of looking at share values is that if there is a heavy contention for
the processor, what servers would you like to run? The production Oracle
databases are an obvious choice. Required servers should have absolute values
Chapter 2. Best practices for installing an Oracle Database 10g on Linux on zSeries 15
36. Control Priority of Linux guests
SHARE settings determine access priority for
Absolute Relative
CPU, main storage, and paging capacity
% Share
Settings can be changed on the fly by 40 Absolute Relative 800
command or programmed automation guests guests 700
30 600
Resources are allocated to Absolute guests
500
first, remaining resources are allocated to
20 400
Relative guests 300
SHARE settings are not a guarantee for system 10 200
behavior 100
Lin1 Lin2 Lin3 Lin4
0 0
CP
SET SHARE Lin1 ABSOLUTE 20% ABSOLUTE 30% LIMITSOFT Notes:
SET SHARE Lin2 ABSOLUTE 10% ABSOLUTE 15% LIMITHARD = limit can be exceeded if unused
SET SHARE Lin3 RELATIVE 200 RELATIVE 300 LIMITHARD capacity is available (limitsoft)
SET SHARE Lin4 RELATIVE 100 RELATIVE 200 LIMITSOFT = limit will not be exceeded (limithard)
Figure 2-1 Using shares to manage guest priorities
2.3 Paging, swap, and I/O considerations
z/VM uses paging, while Linux primarily uses swapping but performs some
paging as well. The term swap is a carry over from early days of Linux when it did
swap an address space to reclaim memory if needed. However, today Linux
does page and uses its own paging algorithm. This means that double paging
can occur and this is not a new concept in z/VM.
One case may be where z/VM needs to page out and selects a page from the
LRU. Hopefully the system is properly configured and the paging is to expanded
storage. Now a Linux virtual machine needs to page and looks at its LRU to
page. Most likely this could be the page that z/VM just paged out. If we assume
this is the case, a page fault now occurs and the page must be brought back into
central storage. Now Linux will complete its paging by moving the page to its
swap space or paging device. In this case the system paged so that a system
guest can page.
It is best to keep this type of activity to a minimum. The approach to this is to
keep the memory in Linux virtual machines small enough so that z/VM does not
do a lot of paging and large enough so that Linux does not have to do excessive
paging. And all paging at the first level should be to a memory device such as a
VDISK for Linux or expanded storage for z/VM.
16 Experiences with Oracle 10g Database for Linux on zSeries
37. 2.3.1 z/VM paging
One of the common mistakes with new VM customers is to not allocate paging
space (along with not configuring expanded storage). The installation process
configures enough paging space to complete an installation. This paging space
on the sysres pack is small and can handle a small amount of tasks. However,
you should remove the paging space from the sysres pack and add DASD page
space to do real work. The VM Planning and Administration manual has details
on determining how much space is required. Here are a few thoughts:
If the system is not paging, you may not care where you put the page space.
However, it has been our experience that sooner or later the system grows to
a point where it pages and then you will wish you had thought about it.
z/VM paging is most optimal when it has large contiguous available space on
volumes that are dedicated to paging. Therefore, do not mix page space with
other space (user, tdisk, spool, Linux guests, etc.).
Set up VM paging to many disks. The more subchannels z/VM can use the
faster the paging will take place.
A rough starting point for page allocation is to add up the virtual machine
sizes of virtual servers running and multiply by 2. Keep an eye on the
allocation percentage and the block read set size.
2.3.2 Swap space for Linux
Try to avoid swapping in Linux whenever possible. It adds pathlength and
significant hit to response time. However, sometimes swapping is unavoidable. If
you have to swap, these are some of your best choices.
Dedicated volume - If the storage load on your Linux guest is large, the guest
might need a lot of room for swap. One way to accomplish this is simply to
ATTACH or DEDICATE an entire volume to Linux for swapping. If you have
the DASD to spare, this can be a simple and effective approach.
Traditional minidisk - Using a traditional minidisk on physical DASD requires
some setup and formatting the first time and whenever changes in size of
swap space are required. However, the storage burden on z/VM to support
minidisk I/O is small, the controllers are well-cached, and I/O performance is
generally very good. If you use a traditional minidisk, you should disable z/VM
Minidisk Cache (MDC) for that minidisk (use the MINIOPT NOMDC statement
in the user directory).
VM VDISK - A VM virtual disk in storage (VDISK) is transient like a t-disk is.
However, VDISK is backed by a memory address space instead of by real
DASD. While in use, VDISK blocks reside in central storage (which make
them very fast). When not in use, VDISK blocks can be paged out to
Chapter 2. Best practices for installing an Oracle Database 10g on Linux on zSeries 17
38. expanded storage or paging DASD. The use of VDISK for swapping is
sufficiently complex that we have written a separate tips page for it.
Linux assigns priorities to swap extents. So, for example, you could set up a
small VDISK with higher priority (higher numeric value), and it would be selected
for swap as long as there was space on the VDISK to contain the process being
swapped. Swap extents of equal priority are used in round-robin fashion. Equal
prioritization can be used to spread swap I/O across chpids and controllers, but if
you are doing this, be careful not to put all the swap extents on minidisks on the
same physical DASD volume, for if you do, you will not be accomplishing any
spreading. Use swapon -p ... to set swap extent priorities.
Setting up two VDISKS of different priorities or a VIDSK and a minidisk with the
higher priority on the VDISK can provide a tuning toll or method for properly
sizing your memory needs on the Linux virtual machine. Monitor the paging at
peak times. If there is paging to the second paging disk, then you should
consider adding memory to Linux.
2.3.3 I/O considerations
One of the biggest performance issues we ran into during some testing, both on
z/OS and Linux on zSeries, was when we placed the database on a single rank
in the ESS800. This will cause many performance-related issues that mostly
involve cache utilization in the ESS800. The best practice for the ESS system is
to distribute data across as many ranks (arrays) as possible. This made a
dramatic difference in our testing, even though this was a small database.
It is also important to stripe the logical volumes that are created. This enables the
operating system to issue multiple I/Os against the LVM. Striping a logical
volume is not the same as any striping or RAID that is done inside the disk
controller. The guidelines for striping on a IBM Total Storage ESS and DS8000
are as follows;
ESCON® - One stripe per channel
FICON® - One stripe per physical volume
FCP - One stripe per volume or LUN
When the logical volume is created one of the parameters is the stripe size. The
best stripe size is dependent on the workload characteristics. The IBM Web site
recommends 16 K or 32 K stripe sizes. In testing typical OLTP type applications
either 4 K or 8 K worked better. Applications such as Samba that may serve
large files do better with a 64 K stripe. So the message here is that if you do not
already know the optimal stripe size for your application, it may take some testing
to determine what that size might be.
18 Experiences with Oracle 10g Database for Linux on zSeries
39. A final thought on this is that faster and newer is always better. Some
implementations have experienced up to a 50 percent performance improvement
just going from ESCON to FICON.
Parallel Access Volumes can be used with z/VM and Linux. This lets the ESS800
write from parallel processes to the same device. The writes will occur in different
domains within the volume. This feature is only available on the IBM ESS800.
2.3.4 Monitoring the system
z/VM provides extensive virtualization techniques. A virtual machine running
under z/VM acts as if it has all the resources allocated to it in the user direct
profile that was created for the virtual machine. This means that monitoring what
a virtual machine is doing by looking at resource utilization with a tool or monitor
running in that virtual machine may not always be accurate.
Since monitoring a virtual machine from the virtual machine is not always
accurate, it is extremely important to use a tool to monitor the z/VM system and
all the virtual machines from a system perspective. There are two tools that we
have experince with and both provide value:
IBM Performance Toolkit for VM - Licensed through IBM
ESAMON from Velocity Software (http://www.velocity-software.com)
While using one of these tools is absolutely necessary for performance
monitoring and tuning, do not overlook using tools like sar to vmstat monitor
events and resource utilization such as swapping in a Linux virtual machine.
Yet another way to monitor performance, especially during times when problems
are suspected, is the use of CP commands such as cp indicate load. These
are very valid to use for a current point in time but do not provide the ability to go
back to review past performance, as does one of the tools mentioned above.
The purpose of this chapter is to describe the configuration of Linux and z/VM.
However, this is for an Oracle database, and using a tool such as Statspack (or
DB Control for 10g) is still an important way to monitor and tune the Oracle
database server.
2.4 Summary
The following is a summary of the key points needed to get the best performance
from Oracle.
Memory - This is likely the most critical area of tuning Linux virtual machines.
The mindset here is the exact opposite of Linux on Intel. The less memory the
Chapter 2. Best practices for installing an Oracle Database 10g on Linux on zSeries 19
40. better. Memory assigned to Linux should be enough to cover the needs of the
Oracle database (SGA + PGA) and about 128 MBs more for Linux.
Monitor resources - The more virtual machines installed under z/VM the more
you will need to use a system monitor such as the z/VM Toolkit. Trying to
understand performance problems and determine capacity needs without this
type of monitor is impossible.
Paging and swap space - Paging at the z/VM level and Linux level (swapping)
is most practically unavoidable. You must allow for this. Expanded storage is
an absolute must, as is swap space (paging device) on Linux. The best
paging device for Linux is a VDISK.
Avoid I/O bottlenecks - Use a best practice for configuring and using disk.
Data must be distributed as well as possible across different ranks. The
logical volumes should be striped, with the number of stripes being
dependent on the technology used.
20 Experiences with Oracle 10g Database for Linux on zSeries